Excel Expert Requested
lnealjrcookin.xlsx
Documentation
Cookin Good | |
Created By: | |
Date Created: | |
Purpose: | To record sales information for Cookin Good products. |
Sales Form
Enter New Sales Information Below | Product Information | |||||
Region | Product ID | Product Name | Product Price | |||
Product ID | HPP | Homeware Pizza Pan | 19.95 | |||
Product Name | SPP | Stone Pizza Pan | 29.95 | |||
Product Price | HCD | Homeware Casserole Dish | 19.95 | |||
Units Sold | HCP | Homeware Cookie Pan | 9.95 | |||
Total Sale | CW | China Wok | 19.95 | |||
HEW | Homeware Electric Wok | 29.95 | ||||
WCM | Wilson Coffee Machine | 29.95 | ||||
HBM | Homeware Bread Machine | 49.95 | ||||
HBMD | Homeware Bread Machine -Deluxe | 89.95 | ||||
HR | Homeware Rotisserie | 119.95 | ||||
OGG | Olson Gas Grill | 159.95 | ||||
OEG | Olson Electric Grill | 159.95 |
Sales Record
Region | Product ID | Product Name | Product Price | Units Sold | Total Sale |
3 | HEW | Homeware Electric Wok | 29.95 | 3 | 89.85 |
1 | SPP | Olson Electric Grill | 159.95 | 1 | 159.95 |
1 | SPP | Stone Pizza Pan | 29.95 | 5 | 149.75 |
4 | HCD | Homeware Casserole Dish | 19.95 | 3 | 59.85 |
1 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 10 | 899.50 |
5 | HEW | Homeware Electric Wok | 29.95 | 6 | 179.70 |
1 | HEW | Homeware Electric Wok | 29.95 | 9 | 269.55 |
5 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 6 | 539.70 |
4 | HEW | Homeware Electric Wok | 29.95 | 3 | 89.85 |
4 | OGG | Olson Gas Grill | 159.95 | 2 | 319.90 |
1 | HCD | Homeware Casserole Dish | 19.95 | 3 | 59.85 |
4 | HEW | Homeware Electric Wok | 29.95 | 6 | 179.70 |
4 | CW | China Wok | 19.95 | 5 | 99.75 |
4 | SPP | Stone Pizza Pan | 29.95 | 2 | 59.90 |
4 | HBM | Homeware Bread Machine | 49.95 | 4 | 199.80 |
2 | OEG | Olson Electric Grill | 159.95 | 3 | 479.85 |
2 | SPP | Stone Pizza Pan | 29.95 | 6 | 179.70 |
4 | HBM | Homeware Bread Machine | 49.95 | 10 | 499.50 |
5 | CW | China Wok | 19.95 | 8 | 159.60 |
3 | OGG | Olson Gas Grill | 159.95 | 3 | 479.85 |
5 | HPP | Homeware Pizza Pan | 19.95 | 10 | 199.50 |
2 | HEW | Homeware Electric Wok | 29.95 | 8 | 239.60 |
3 | SPP | Stone Pizza Pan | 29.95 | 4 | 119.80 |
4 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 5 | 449.75 |
5 | OGG | Olson Gas Grill | 159.95 | 8 | 1279.60 |
3 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 6 | 539.70 |
2 | HEW | Homeware Electric Wok | 29.95 | 9 | 269.55 |
2 | OGG | Olson Gas Grill | 159.95 | 7 | 1119.65 |
5 | OEG | Olson Electric Grill | 159.95 | 1 | 159.95 |
4 | HCP | Homeware Cookie Pan | 9.95 | 4 | 39.80 |
3 | WCM | Wilson Coffee Machine | 29.95 | 1 | 29.95 |
4 | OGG | Olson Gas Grill | 159.95 | 4 | 639.80 |
5 | OGG | Olson Gas Grill | 159.95 | 10 | 1599.50 |
4 | WCM | Wilson Coffee Machine | 29.95 | 1 | 29.95 |
2 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 9 | 809.55 |
1 | CW | China Wok | 19.95 | 1 | 19.95 |
4 | WCM | Wilson Coffee Machine | 29.95 | 9 | 269.55 |
4 | HCP | Homeware Cookie Pan | 9.95 | 2 | 19.90 |
2 | HCD | Homeware Casserole Dish | 19.95 | 9 | 179.55 |
3 | SPP | Stone Pizza Pan | 29.95 | 2 | 59.90 |
1 | CW | China Wok | 19.95 | 2 | 39.90 |
4 | HCD | Homeware Casserole Dish | 19.95 | 9 | 179.55 |
1 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 1 | 89.95 |
2 | CW | China Wok | 19.95 | 9 | 179.55 |
4 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 8 | 719.60 |
1 | HR | Homeware Rotisserie | 119.95 | 7 | 839.65 |
4 | HBM | Homeware Bread Machine | 49.95 | 9 | 449.55 |
1 | HR | Homeware Rotisserie | 119.95 | 3 | 359.85 |
4 | WCM | Wilson Coffee Machine | 29.95 | 4 | 119.80 |
2 | HR | Homeware Rotisserie | 119.95 | 1 | 119.95 |
5 | WCM | Wilson Coffee Machine | 29.95 | 7 | 209.65 |
2 | HBM | Homeware Bread Machine | 49.95 | 1 | 49.95 |
5 | HPP | Homeware Pizza Pan | 19.95 | 3 | 59.85 |
5 | HCP | Homeware Cookie Pan | 9.95 | 1 | 9.95 |
3 | OEG | Olson Electric Grill | 159.95 | 4 | 639.80 |
3 | HEW | Homeware Electric Wok | 29.95 | 6 | 179.70 |
3 | OGG | Olson Gas Grill | 159.95 | 9 | 1439.55 |
1 | HBM | Homeware Bread Machine | 49.95 | 10 | 499.50 |
3 | HR | Homeware Rotisserie | 119.95 | 3 | 359.85 |
5 | HBMD | Homeware Bread Machine -Deluxe | 89.95 | 6 | 539.70 |
2 | HCP | Homeware Cookie Pan | 9.95 | 4 | 39.80 |
2 | HCD | Homeware Casserole Dish | 19.95 | 2 | 39.90 |
4 | HEW | Homeware Electric Wok | 29.95 | 3 | 89.85 |
5 | WCM | Wilson Coffee Machine | 29.95 | 6 | 179.70 |
1 | OEG | Olson Electric Grill | 159.95 | 2 | 319.90 |
3 | WCM | Wilson Coffee Machine | 29.95 | 7 | 209.65 |
5 | HR | Homeware Rotisserie | 119.95 | 1 | 119.95 |
1 | OGG | Olson Gas Grill | 159.95 | 6 | 959.70 |
Sales Table
Total Sales | Region | ||||||
Product ID | 1 | 2 | 3 | 4 | 5 | Grand Total | |
CW | $ 59.85 | $ 179.55 | $ 99.75 | $ 159.60 | $ 498.75 | ||
HBM | $ 499.50 | $ 49.95 | $ 1,148.85 | $ 1,698.30 | |||
HBMD | $ 989.45 | $ 809.55 | $ 539.70 | $ 1,169.35 | $ 1,079.40 | $ 4,587.45 | |
HCD | $ 59.85 | $ 219.45 | $ 239.40 | $ 518.70 | |||
HCP | $ 39.80 | $ 59.70 | $ 9.95 | $ 109.45 | |||
HEW | $ 269.55 | $ 509.15 | $ 269.55 | $ 359.40 | $ 179.70 | $ 1,587.35 | |
HPP | $ 259.35 | $ 259.35 | |||||
HR | $ 1,199.50 | $ 119.95 | $ 359.85 | $ 119.95 | $ 1,799.25 | ||
OEG | $ 319.90 | $ 479.85 | $ 639.80 | $ 159.95 | $ 1,599.50 | ||
OGG | $ 959.70 | $ 1,119.65 | $ 1,919.40 | $ 959.70 | $ 2,879.10 | $ 7,837.55 | |
SPP | $ 309.70 | $ 179.70 | $ 179.70 | $ 59.90 | $ 729.00 | ||
WCM | $ 239.60 | $ 419.30 | $ 389.35 | $ 1,048.25 | |||
Grand Total | $ 4,667.00 | $ 3,706.60 | $ 4,147.60 | $ 4,515.35 | $ 5,236.35 | $ 22,272.90 |