Excel Expert Requested
lnealjr
cookin.xlsxDocumentation
| 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 |
