A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations. What quantity should the shop order with each order?How many times per year will the shop order on average?How many operating days will elapse on average between two consecutive orders?What is the store’s minimum total annual cost of placing orders & carrying inventory (cycle stock)?

This question is related to the topic -Inventory management and this topic fall under the operations…

Answered: A small coffee shop consumes on average…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations.
1. What quantity should the shop order with each order?
2. How many times per year will the shop order on average?
3. How many operating days will elapse on average between two consecutive orders?
4. What is the store’s minimum total annual cost of placing orders & carrying inventory (cycle stock)?

Features Features Normal distribution is characterized by two parameters, mean (µ) and standard deviation (σ). When graphed, the mean represents the center of the bell curve and the graph is perfectly symmetric about the center. The mean, median, and mode are all equal for a normal distribution. The standard deviation measures the data's spread from the center. The higher the standard deviation, the more the data is spread out and the flatter the bell curve looks. Variance is another commonly used measure of the spread of the distribution and is equal to the square of the standard deviation.

Expert Solution