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 Tony’s monthly profit on an Excel spreadsheet.