Reference no: EM13899504
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).
|
Describe the three phases of the life history curve
: Describe the three phases of the life history curve. Reliability programs have been used to prolong the lives of tornado sirens that signal the approach of bad weather. Describe a tornado siren in terms of the definition of reliability
|
|
Write a complete java method called sumnums
: 1. Write a complete Java method called sumNums that takes no parameters and returns an integer. The method uses a do-while loop to ask the user to enter a series of positive integer values and keeps a running total. Use a sentinel (-1) to allow the u..
|
|
Calculate the amount of dividends firm a and firm b paid
: Calculate the amount of dividends Firm A and Firm B paid using the information given. Prepare a statement of cash flows for each firm using the indirect method.
|
|
What is the probability that a blue chip will be drawn
: The probability of drawing a pink chip from a bowl of different colored chips is 0.35, the probability of drawing a blue chip is 0.46, the probability of drawing a green chip is 0.15, and the probability of drawing a purple chip is 0.04. What is ..
|
|
Create sheet sales and put reasonable numbers
: 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 total..
|
|
Analyze common ethernet standards found in a switched lan
: Analyze common Ethernet standards found in a switched LAN fabric. ? Summarize the nature of Ethernet frames that are processed in LAN switching.
|
|
Cases that compare specification limits to control limits
: What do control limits represent? What do specification limits represent? Describe the three cases that compare specification limits to control limits
|
|
Enter the last names of five candidates
: Write a program that allows users to enter the last names of five candidates in a local election and the number of votes received by each candidate. The program should then output each candidate's name, the number of votes received, and the percentag..
|
|
Prepare a statement of cash flows using the indirect method
: The following comparative balance sheets and income statement are available for Little Bit Inc. Prepare a statement of cash flows for 2012 using the indirect method and analyze the statement.
|