Question: please complete everything in excel with your step by step. thank you! McBurger, Inc., wants to redesign its kitchens to improve productivity and quality. Three

please complete everything in excel with your step by step. thank you!
please complete everything in excel with your
McBurger, Inc., wants to redesign its kitchens to improve productivity and quality. Three designs, called designs K1, K2, and K3, are under consideration. No matter which design is used, the daily production of sandwiches at I typical McBurger restaurant is for 500 sandwiches. A sandwich costs $1.30 to produce. Non-defective sandwiches sell, on the average, for $2.50 per sandwich. Defective sandwiches cannot be sold and are scrapped. The goal is to choose a design that maximizes the expected profit at a typical restaurant over a 300-day period. Designs K1, K2, and K3 cost $100,000, $150,000, and $180,000, respectively. Under design K1, there is a 75 chance that 90 out of each 100 sandwiches are non-defective and a 25 chance that 70 out of each 100 sandwiches are non-defective. Under design K2, there is a 85 chance that 90 out of each 100 sandwiches are non-defective and a .15 chance that 75 out of each 100 sandwiches are non-defective. Under design K3, there is a 90 chance that 95 out of each 100 sandwiches are non-defective and a 10 chance that 80 out of each 100 sandwiches are non-defective. What is the expected profit level of the design that achieves the maximum expected 300-day profit level

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!