# Maintaining Optimal Level of Stock Problem

Question

Problem

CPG Bagels starts the day with a large production run of bagels. Throughout the morning, additional bagels are produced as needed. The last bake is completed at 3:00 pm and the store closes at 8:00 pm. It costs approximately \$0.20 in materials and labor to make a bagel. The price of a fresh bagel is \$0.60. Bagels not sold by the end of the day are sold next day as “day old” bagels in bags of six, for \$0.99 a bag. About two-thirds of the day-old bagels are sold; the remainders are just thrown away. There are many bagel flavors, but for simplicity, concentrate on plain bagels. The store manager predicts that demand for plain bagels from 3:00 pm until closing are normally distributed with mean of 54 and standard deviation of 21.

a. How many bagels should the store have at 3:00 pm to maximize the store’s expected profit from sales between 3:00 pm until closing? Assume day-old bagels are sold for \$0.99/6=\$0.165 each, i.e., do not worry about the fact that day old bagels are sold in bags of six.

b. Suppose the manager would like to ensure at least 99% service level on demand that occurs after 3:00 pm. How many bagels should the store have at 3:00 pm?

c. Suppose that the store manager is concerned that stock-outs might cause a loss of future business. To explore this idea, the store manager feels that it is appropriate to assign

d. Stock-out cost of \$5.00 per bagel that is demanded but not filled. Given this additional cost, how many bagels should the store have at 3:00 pm to maximize the expected profit?

Summary

The question belongs to Supply Chain Management and it is about CPG Bagels which produces and sells bagels. Every day there is a significant amount of bagels are thrown away as old stock. The company wants to reduce this wastage. For this company wants to study how many average bagels are sold and thus make bagels accordingly. The solution for this problem is given in the Excel sheet.

Total Word Count NA

• Rasha

this is a very good website

• maani

I have 50 questions for the same test your page is showing only 28

• joeanne

• joeanne

hi can anyone help or guide me to my assignments. thanks

• Monik

• Cristina

This solution is perfect ...thanks

• Janete

Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes

• Sandeep

Perfect bank of solution.

• Oxana

great !

• Paul Brandon-Fritzius

thanks for the quick response. the solution looks good. :)

• tina Johnson

thnx for the answer. it was perfect. just the way i wanted it.

• Giuseppe

works fine.