Create a file: Pizza_by_First_Last.xlsm . Create sheet Sales and put reasonable numbers for prices (your choice), add create formulas. Put the % for sales tax in H1 (it is 8% in NY). After that, you need to put formulas in place, add a row for totals, calculate tax and it will be the base for the customer billing = grand total. Assume at all payments are cash only.
|
Item #
|
Description
|
Price
|
Number Ordered
|
Line Total
|
|
1
|
Individual Pizza
|
|
|
|
|
2
|
Small Pizza
|
|
|
|
|
3
|
Medium Pizza
|
|
|
|
|
4
|
Large Pizza
|
|
|
|
|
5
|
Extra topping (any)
|
|
|
|
|
6
|
Salad (boxed)
|
|
|
|
|
7
|
Soda (fountain)
|
|
|
|
|
8
|
Cookies (any)
|
|
|
|
2. One customer ordered 2 medinum pizzas, one salad and two sodas. Check your formulas.
3. Thinking about using this model in practice, which problems you can see? The next customer arrives...Describe the possible problems in a textbox in that sheet (in 20 to 30 words)!
4. After serving one customer, salesperson should be able to save the money information to be ready for the next customer. If he/she will copy and paste in manually, it could be a lot of mistakes and even purposely made mistakes. Create a new sheet named Manager. Create a macro instruction! It could be recorded (or by using VBA). We will use VBA code in this project. For the header use the idea below (you may add more columns if needed). Test your macro.
4. Create ("make-them-up") sales for 20 customers.
5. Create a sheet: Menu. Make a button type menu to go to all sheets and from them back to Menu (please use recordable macros when making a menu).