Question: Consider the following scenario and develop a MS Excel model of the profit for this business. Tony opened a pizza restaurant in a food court.
Consider the following scenario and develop a MS Excel model of the profit for this business. Tony opened a pizza restaurant in a food court. Last month he sold 3000 pizzas at an average price of $10 each. He bought his pizza dough shells from a local bakery at $2 each and spent $2000 on various kind of toppings and other raw materials last month. He has two employees and each one of them worked 160 hours last month at a rate of $10 per hour. In addition, he paid $800 rent to the mall and $200 for the energy and utilities costs. How much profit, before taxes, did Tony earned last month? Build the model for Tonys monthly profit on an Excel spreadsheet. You must not manually input the answer into Excel; use the formulae in Excel to calculate profit. Copy your completed Excel model and paste it to slide 1 and title the slide as Question 1. Dont forget to save your assignment presentation after each question.
Please explain each step as much as possible
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
