Question: QUESTION 25 (10 points) - Fixed-Period Inventory Systems (FPS) Average demand Lead time Order cost Unit Cost Annual inventory holding cost Standard deviation of weekly

QUESTION 25 (10 points) - Fixed-Period Inventory

QUESTION 25 (10 points) - Fixed-Period Inventory Systems (FPS) Average demand Lead time Order cost Unit Cost Annual inventory holding cost Standard deviation of weekly demand Desired service level with safety stock Current on-hand inventory Current scheduled receipts Current backorders 32 jugs per week 3 days $15 per order $1.6 for a jug 900% for a year 7 jugs per week 85% 25 jugs O jugs O jugs A corner store carries milk jugs with current and average information presented in the table above. The store follows a fixed-period inventory system (FPS) to manage its carriage of milk jugs. The corner store is open 52 weeks per year and 7 days per week. Because milk is perishable, holding a jug for a month costs 75% of the item cost, or 900% per year. You would need to show equations, steps, and the final results with units for full credits. Time intervals and goods quantities are rounded up to whole numbers. You should work with a time unit of days, find average daily demand and standard deviation of daily demand, and scale up those daily measures to find necessary values. (a)[2] Find the Economic Order Quantity (EOQ). (Rounded up to a whole number) (b)[1] Based on part (a), find the time interval between reviews T in days. (Rounded up) (c)[1] Find the current inventory position (IP). (d)[3] Given that no safety stock is considered, find the replenishment level M(AD). Explain how this inventory system would operate. If today is the review day, what is the order quantity? Loosely sketch how the system would operate over time (movement of IP over time). (e)[3] Given that the corner store carries safety stock and aims for the desired service level, find the replenishment level M(ST). Explain how this inventory system would operate. If today is the review day, what is the order quantity? Loosely sketch how the system would operate over time (movement of IP over time). Hint: Use the following table to find the z-value corresponding to the desired service level 0.80 0.85 0.90 0.95 0.99 Z=NORM.S.INV(av) 0.84162 1.03643 1.28155 1.64485 2.32635

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!