Michael Chan operates a small desert shop (with 125 ft2 useable floor area) and plans to expand the current product line by selling doughnuts. His estimation of the annual demand is 5,000 doughnuts. He has contacted a local wholesaler who can supply frozen doughnuts at $5 each. The delivery lead time is 2 working days. For Dave, the holding cost of each doughnut per year is 10% of the wholesale unit price, and the ordering cost is $50 per order. There are 250 working days per year. The assumptions of Economic Order Quantity (EOQ) model are satisfied. Show the units and steps of calculation when you answer the following questions. Round the number to ONE decimal place.
1. What is the EOQ if Michael wants to purchase doughnuts from the wholesaler?
2. Based on the EOQ in (1), what is the total annual inventory cost (including the annual purchase cost of the doughnuts)?
3. Based on the EOQ in (1), what is the reorder point (ROP)?
4. Based on the EOQ in (1), what is the time between orders?
Economic Order Quantity is the number of unit that is added to the inventory which minimize the total inventory cost. It maintain a balance between ordering costs and carrying costs.


Michael Chan operates a small desert shop (with 125 ft2 useable floor area) and plans to...
2. Joe Henry’s machine shop uses 10,000 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 10,000 Holding cost per bracket per year $1.75 Order cost per order $22.00 Lead time 4 days Working days per year 250 a. Given the above information, what would be the economic order quantity (EOQ)? b. Given the EOQ, what would be the average inventory? What...
Joe Henry's machine shop uses 2,520 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand 2,520 Holding cost per bracket per year $1.25 Order cost per order $18.50 Lead time 22 days Working days per year 250 a) What is the EOQ? ____units (round your response to two decimal places). b) What is the average inventory if the EOQ is used? _____units...
Joe Henry's machine shop uses 2,490 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The following information is known about the brackets: Annual demand Holding cost per bracket per year Order cost per order Lead time Working days per year 2,490 $1.30 $20.00 2 days 250 a)What is the EO0? 276.79 units (round your response to two decimal places). b)What is the average inventory if the EOQ is used? 138.4 units...
Ross White’s machine shop uses 2,500 brackets dur- ing the course of a year, and this usage is relatively constant throughout the year. These brackets are purchased from a supplier 100 miles away for $15 each, and the lead time is 2 days. The holding cost per bracket per year is $1.50 (or 10% of the unit cost) and the ordering cost per order is $18.75. There are 250 working days per year. (a) What is the EOQ? (b) Given...
Teck is a Canadian metal mining and processing company with new investments in coal and oil. The company has several warehouses in Western Canada that store thousands of parts and supplies for the machines and equipment used in its mines and operations. The stocks in the warehouses are controlled using computers in the Vancouver head office. For spare parts, the EOQ/ROP model is used. The following data is the usage of specific spare part during a nine-month period: Jan Feb...
Excel Online Structured Activity: EOQ Calculation The Las Vegas Corporation purchases a critical component from one of its key suppliers. The operations manager wants to determine the economic order quantity, along with when to reorder, to ensure the annual inventory cost is minimized. The information obtained from historical data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers...
Please answer the following 4 questions based on the same problem: A small shop implemented a continuous review policy in managing its inventory with the given parameters for one item: Annual demand: 15,000 units Holding costs: 40% of purchase price per year. Landed purchase cost: $10 Setup cost: $75 per order Number of working days per calendar year: 250 Lead time: 3 days Required service level: 95% 1. Determine the reorder point, assuming no safety stock. Round your answer to...
A gourmet coffee shop in downtown SF is open 200 days a year and sells an average of 73 pounds of Kona Coffee beans a day. (Demand can be assumed to be distributed normally with a standard deviation of 16 pounds/day.) After ordering (fixed cost = $13 per order), beans are always shipped from Hawaii within exactly 4 days. Per-pound annual holding costs for the beans are $3. a) What is the economic order quantity (EOQ) for Kona coffee beans?...
The Las Vegas Corporation purchases a critical component from
one of its key suppliers. The operations manager wants to determine
the economic order quantity, along with when to reorder, to ensure
the annual inventory cost is minimized. The information obtained
from historical data has been collected in the Microsoft Excel
Online file below. Open the spreadsheet and perform the required
analysis to answer the questions below. Do not round intermediate
calculations. Round your answers according to the input
instructions for...
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...