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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!