In: Operations Management
The Italian eatery at the Student Union orders pre-made, frozen calzones from a gourmet food distributor. They cost $2.50 apiece. Ordering costs are $10 per order, and orders always take 4 days to arrive. The demand over a term (for which the eatery is open 100 days) averages 80 calzones a day, with a standard deviation of 20 calzones per day. Holding costs are 10% of the Eatery’s purchase price.
a) What is the economic order quantity for calzones?
b) if the management has specified that the risk of a stock out during a cycle is 15.87%? What is the Reorder point?
c) What is the annual holding costs and annual ordering costs if we use the EOQ?
d) The Eatery has decided to make calzones themselves. These are made periodically in large batches, and everything not used that day is frozen. The daily production rate, p, is 160 calzones. Assume that the holding cost, H, is now $.40/calzone per term and S, the setup cost, is $16 per run. All other parameters remain unchanged. What is the EPQ, and how often do we start a production cycle? How many days do we run production? Please provide written work with formulas (not excel)
Please post written work on how you got the answer not just excel.
ANNUAL DEMAND = 8000
ORDERING COST = 10
HOLDING COST = 0.25
COST PER UNIT = 2.5
LEAD TIME = 4
EOQ = SQRT(2 * D * S / H), WHERE D = DEMAND, S = ORDERING COST AND H = HOLDING COST = SQRT(2 * 8000 * 10 / 0.25) = 800
2. SERVICE LEVEL = 1 - STOCKOUT RISK = 1 - 15.87/100 = 0.8413
DEMAND = 80
STANDARD DEVIATION OF DEMAND = 20
SERVICE LEVEL = 84.13, WHICH GIVES A Z VALUE OF 1
REORDER POINT = DEMAND * LEAD TIME + SAFETY STOCK
SAFETY STOCK = Z * STANDARD DEVIATION OF DEMAND * SQRT(LEAD TIME)
SAFETY STOCK = 1 * 20 * SQRT(4) = 40
REORDER POINT = (80 * 4) + 40 = 360
3. ANNUAL HOLDING COST = AVERAGE INVENTORY * PER UNIT HOLDING COST = (800 / 2) * 0.25 = 100
ANNUAL ORDERING COST = NUMBER OF ORDERS * ORDERING COST = (8000 / 800) * 10 = 100
COST OF MANAGING = ANNUAL HOLDING COST + ANNUAL ORDERING COST = 100 + 100 = 200
4. ANNUAL DEMAND = 8000
SETUP COST = 16
HOLDING COST = 0.4
DAILY PRODUCTION = 160
DAILY USAGE = 80
PRODUCTION EOQ = SQRT(2 * DEMAND * ORDERING COST / HOLDING COST * (1 - (DAILY USAGE / DAILY PRODUCTION))) = SQRT(2 * 8000 * 16 / (0.4 * (1 - (80 / 160))) = 1131
NUMBER OF PRODUCTION RUNS = ANNUAL DEMAND / EPQ = 8000 / 1131 = 7.07
RUN TIME = EPQ / DAILY PRODUCTION = 1131 / 160 = 7.07
** Leaving a thumbs-up would really help me out. Let me know if you face any problems.