A restaurant that is open 7 days per week experiences level demand throughout the year. The average annual demand for disposable napkins, which costs $0.20 apiece,is 45000per year. The annual holding cost rate 10% and the ordering cost is estimated to be $25per order. The forecast CV is of 15%and the lead time from order to receipt is 2days. A cycle service level of 98% is targeted.
Calculate the optimal order quantity and the reorder point (ROP).
****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****
From the given data, we have,
Annual Demand = D = 45000 units / year
Holding Rate = h = 10 % / unit / year
Ordering Cost = K = 25 $ / order
Purchase price = c = 0.2 $ / unit
CV = 15 %
Lead TIme = LT = 2 days
The economic order quantity is calculated using the formula EOQ = SQRT [2*K*D / (h*c)]
EOQ = SQRT [2 * 25 * 45000 / (0.1 * 0.2)]
= 10606.6 units
Standard Deviation of Demand = σD = C.V * Mean Demand
= 0.15 * (45000 / 365)
= 18.5 units
Standard Deviation of Demand during lead time chase = σDL = σ * Sqrt (2)
= 18.5 * Sqrt (2)
= 26.16 units.
For a 98% probability of remaining in stock, corresponding z value for 0.9800 probability = 2.05.
Safety Stock = z * σDL
= 2.05 * 26.16
= 53.73 = 54 units.
Demand During lead time = μDLT = (μD * μLT )
= 123.3 * 2
= 246.57 = 247 units
Reorder point = μDLT + Safety Stock
=247 + 54
= 301 units
A restaurant that is open 7 days per week experiences level demand throughout the year. The...
Compute the safety stock (S.S.) and reorder point (ROP) for the following situation: Annual Demand = 6570 units Unit Price = $11 and no quantity discounts Ordering Cost = $25/order Holding Cost = $1.50/unit Lead Time = 5 days Desired Customer Service Level = 97.5% Assume 365 days/year and that demand and lead time are constant. Safety Stock = 10; ROP = 90 Safety Stock = 0; ROP = 90 Safety Stock = 5; ROP = 150 Safety Stock =...
Your factory manufactures tricycles. You need to purchase front wheels from the supplier. The expected annual demand (D) is 1300 units; the setup or ordering cost (S) is $8 per order, and the holding cost per unit per year (H) is $0.50. Determine optimal number of wheels to order Determine the reorder point (ROP) (without safety stock) assuming that the lead time (L) is 4 days and your factory works 250 days a year. Based on your answer in (b),...
A local store sells toilet paper to people in the surrounding communities. The demand for the toilet paper has been increasing and management needs to ensure that enough rolls are available to meet the increasing demand. The daily demand for the toilet paper is 400 rolls. The store operates 250 days per year. The following information is also available about the product. The cost of each roll……………………….…..$2. Ordering costs………………………………..……$100 per order Annual holding costs per unit…………… 10% of the costs...
Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $10.75 per bag. The following information is available about these bags. Demand = 95 bags/week Order cost = $58/order Annual holding cost = 25 percent of cost Desired cycle@service level = 90 percent Lead time = 4 weeks (28 working days) Standard deviation of weekly demand = 16 bags Current on-hand inventory is 315 bags, with...
Petty House operates 52 weeks per year, 6 days per week, and uses a continuous review inventory system (i.e. Q system). It purchases kitty litter for $ 10 per bag. The following information is available about these bags. Demand = 102 bags/ week Order cost = $ 49/ order Annual holding cost = 25 percent of cogs Desired cycle service level = 80 percent Lead time = 3 weeks Standard deviation of weekly demand = 15 bags Current on-hand inventory...
Sam's Cat Hotel operates 52 weeks per year, 7 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.25 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. Demand 96 bags/week Order cost- $58/order >Annual holding cost 26 percent of cost > Desired cycle-service level 90 percent > Lead time 1 week(s) (7 working days) > Standard deviation of weekly demand 13 bags >Current on-hand...
b) As a contractor to Petronas, East Technology uses 4000 valves for repairing one of Petronas plant every year. These valves are purchased from a supplier 200 km away. The following information is known about the valves Table Q3b: Forecast demand for plastic product Annual demand 4000 Holding cost /valve/vear Order cost/ year RM 9 RM 25 s days Lead time Working days per year 250 Given the above information, calculate i) The economic order quantity (EOQ)? ii) The annual...
A gourmet coffee shop in downtown San Francisco is open 200 days a year and sells an average of 75 pounds of Kona coffee beans a day. (Demand can be assumed to be distributed normally, with a standard deviation of 15 pounds per day.) After ordering (Fixed cost=$16 per order), beans are always shipped from Hawaii within exactly four days. Per-pound annual holding costs for the beans are $3. a) What is the EOQ for Kona Coffee Beans? b) What...
Can you help with letter b? For letter a I got 93 bottles idk if thats correct but not sure how to do b? And I know S= R(l+T) where l is lead time which is the 3 days The manager of store Z asks you to help in determining the optimal ordering policy for Truck Stop Honey. The demand for this beer is 35 bottles per day. The store pays a unit cost of $3.50 per bottle and a...
Deep Six Seafood, a restaurant that’s open 360 days a year, specializes in fresh Maine lobsters at a cost of $12.50 each. Air freight charges have increased significantly and it now costs Deep Six $50 to place an order. Because the lobsters are shipped live in a saltwater tub, the ordering cost is not affected by order sizes. The cost to keep a lobster alive until needed runs about $0.02 per day. The demand for lobsters during the 1-day lead...