Question: please use excel and all excel functions PROBLEM #3 (Prepare an Excel spreadsheet to solve the problem) Joe's Coffee Shop has fresh muffins delivered each

please use excel and all excel functions

PROBLEM #3 (Prepare an Excel spreadsheet to solve the problem) Joe's Coffee Shop has fresh muffins delivered each moming. Daily demand for muffins is approximately normal with a mean of 2000 and a standard deviation of 350 . Joe pays $0.40 per muffin and sells each muffin for $1.25. Joe and the staff eat any leftovers they can and throw the rest, instead of feeding homeless. What a shame! a) Find the optimal order quantity for Joe that minimizes his cost. Does the number make any sense? Why or why not? b) Using simulation, create 1000 random demand numbers and find the expected profit from the muffins if Joe orders the optimal order quantity. Try two other order quantities to illustrate the change in the expected profit. Provide a short discussion on the relevance of the optimal order quantity and the mean demand

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!

PROBLEM \#3 (Prepare an Excel spreadsheet to solve the problem). Joe's Coffee Shop has fresh muffins delivered each morning. Daily demand for muffins is approximately normal with a mean of 2000 and a...

Please use excel and show any formulas you used in your response, thank you. PROBLEM \#3 (Prepare an Excel spreadsheet to solve the problem) Joe's Coffee Shop has fresh muffins delivered each...

Hi! I need help calculating some revenue gained and grossprofit gained. Must show show work in excel! Answers need to be in cell K60, K61, U60, U61, AE 60, A61. You might find additional help in case...

S w 9B10D015 O PY SUNSET GRILL AT BLUE Jason Melhuish wrote this case under the supervision of Professors Dina Ribbink and John Haywood-Farmer solely to provide material for class discussion. The...

MGT489 Point of View Analyses (2 of them for this summer's class) Guidelines: No more than four pages, single spaced, no smaller than 11 point type. Your name, date, title of the case and what number...

This is business writing: clear and to the point. Literary and dramatic embellishments are unwelcome. Use terminology, grammar and punctuation correctly. Treat this as if you are working for the...

MGT 489 Beanz Coffee: Point of View Analysis 1 The analysis is meant to be an exercise to be performed by you on the case at hand. You identify a problem and work it through with the information you...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

SYS FISH HOUSE ACCOUNTING INFORMATION SYSTEM NEEDS 1. Identify the business processes you see at Sys 2. For each process, write a detailed description of the steps in the process or feel free to flow...

Drug usage at work can cause damaging affects to businesses. There are both pros and cons for the employer and the employee. This paper will better explain those pros and cons via researching the...

On January 2, 2006, Bradley Company acquired 20% of the 100,000 shares of outstanding common stock of Caldecott Corp. for $20 per share. The purchase price was equal to Caldecotts underlying book...

Which item relates to whether the applicant can generate enough cash to pay personal living expenses and other obligations as they become due?

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...