Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Guido's Pizzeria Guido's Pizzeria produces 750 pies per day. To accomplish this, it needs three employees, one driver, and a small dining room. It also

image text in transcribed
Guido's Pizzeria Guido's Pizzeria produces 750 pies per day. To accomplish this, it needs three employees, one driver, and a small dining room. It also uses 250 pounds of wheat, 120 pounds of cheese, 145 pounds of tomato sauce, and 30 pounds of pepperoni. The daily energy and water consumption is 65 KWH and 210 gallons, respectively. Average fully allocated labor cost is $14.2 per hour. Assume 8 paid hours per work day. About half the pizzas produced are delivered by third-party drivers at a fee of 45 cents per pizza. The cost per pound of wheat is $2.20. Cheese costs $1.30 per pound, tomato sauce is $0.95 and pepperoni is $3.60. Electricity is charged at $1.99 per kWH and water costs 7 cents per gallon Equipment amortization is estimated at $450 per month and property rental is $2,500 per month. Guido's operates 360 days per year. As a consultant to Mr. Guido, your job is build the framework of a model in Excel to calculate multifactor productivity. Upload your Excel file. Guido's Pizzeria Guido's Pizzeria produces 750 pies per day. To accomplish this, it needs three employees, one driver, and a small dining room. It also uses 250 pounds of wheat, 120 pounds of cheese, 145 pounds of tomato sauce, and 30 pounds of pepperoni. The daily energy and water consumption is 65 KWH and 210 gallons, respectively. Average fully allocated labor cost is $14.2 per hour. Assume 8 paid hours per work day. About half the pizzas produced are delivered by third-party drivers at a fee of 45 cents per pizza. The cost per pound of wheat is $2.20. Cheese costs $1.30 per pound, tomato sauce is $0.95 and pepperoni is $3.60. Electricity is charged at $1.99 per kWH and water costs 7 cents per gallon Equipment amortization is estimated at $450 per month and property rental is $2,500 per month. Guido's operates 360 days per year. As a consultant to Mr. Guido, your job is build the framework of a model in Excel to calculate multifactor productivity. Upload your Excel file

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Governmental and Nonprofit Entities

Authors: Earl R. Wilson, Jacqueline L Reck, Susan C Kattelus

16th Edition

78110939, 978-0078110931

More Books

Students also viewed these Accounting questions

Question

What are the typical benefits of ERP?

Answered: 1 week ago