Question

In: Operations Management

An electronics store uses a fixed order quantity inventory control system. Characteristics of one of its...

An electronics store uses a fixed order quantity inventory control system. Characteristics of one of its items is as follows: weekly demand is 2,000 units, ordering cost is $35 per order, holding cost per week is $0.04, replenishment lead-time is 3 weeks and the standard deviation of weekly demand is 400 units. Assuming the store operates 50 weeks per year, what is the EOQ for this item? Calculate the reorder point with safety stock if the store wishes to provide a 90 percent cycle-service level.

Solutions

Expert Solution

Following data have been provided :

Annual demand = D = 2000 / week x 52 weeks = 104000 units

Ordering cost = Co = $35 / order

Annual unit holding cost = Ch = $0.04 / week x 52 weeks = $2.08

EOQ for this item

= Square root ( 2 x Co x D / Ch )

= Square root ( 2 x 35 x 104000 /2.08 )

= 1870.82 ( 1871 rounded to nearest whole number )

EOQ = 1871 units

Standard deviation of weekly demand = 400 weeks

Lead time = 3 weeks

Therefore , Standard deviation of demand during lead time = 400 x Square root ( Lead time ) = 400 x Square root ( 3 )= 400 x 1.732 = 692.80

Z Value for 90 percent service level = NORMSINV ( 0.90 ) = 1.2815

Therefore , safety stock = Z value x Standard deviation of demand during lead time= 1.2815 x 692.80 = 887.82 ( 888 units rounded to nearest whole number )

Reorder point = Weekly demand x Lead time ( weeks ) + safety stock = 2000 x 3 + 888 = 6000 + 888 = 6888 units

REORDER POINT = 6888 UNITS

SAFETY STOCK = 888 UNITS


Related Solutions

For fixed order quantity inventory system, which of the following costs is increased when order size...
For fixed order quantity inventory system, which of the following costs is increased when order size (Q) is increased? a) Setup cost b) Ordering cost c) Start-up quality cost d) Insurance cost e) Receiving inspection cost      
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items....
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items. The review interval is 12 ​weeks, and the lead time for receiving the materials ordered from its wholesaler is 4 weeks. Weekly demand is normally​ distributed, with a mean of 125 units and a standard deviation of 25 units. Refer to the standard normal table LOADING... for​ z-values. a. What is the average and the standard deviation of demand during the protection​ interval? The...
One requirement of a fixed order interval system is that the inventory must be constantly monitored...
One requirement of a fixed order interval system is that the inventory must be constantly monitored Select one: True False
2. Periodic Review System (P-System) or Periodic Order Quantity (POQ) or Fixed Interval Reorder System or...
2. Periodic Review System (P-System) or Periodic Order Quantity (POQ) or Fixed Interval Reorder System or Periodic Reorder System. (10 Points) Wood County Hospital consumes 1,000 boxes of bandages per week and the hospital operates 52 weeks per year. The price of bandages (v) is $ 35 per box and the cost of holding one box for a year is 15 percent of the value of the material (r). The cost of processing an order is $ 15. Demand is...
San Lorenzo General Store uses a periodic inventory system and the retail inventory method to estimate...
San Lorenzo General Store uses a periodic inventory system and the retail inventory method to estimate ending inventory and cost of goods sold. The following data are available for the month of October 2018: Cost Retail Beginning inventory $ 47,000 $ 62,000 Net purchases 10,480 32,800 Net markups 2,400 Net markdowns 1,400 Net sales 44,000 Required: Complete the table below to estimate the average cost of ending inventory and cost of goods sold for October.
Northfield Inc., an upscale electronics wholesaler, uses a periodic inventory system to account for the goods...
Northfield Inc., an upscale electronics wholesaler, uses a periodic inventory system to account for the goods available for sale. Northfield’s CFO, Bob Garey, feels that the periodic inventory system that the company uses is too inefficient. The company often runs out of the company’s best - selling merchandise and is unable to fulfill orders. In addition, Northfield shuts down operations twice a year to perform a physical inventory. Bob is considering purchasing a perpetual inventory system module for his accounting...
In inventory management, economic order quantity (EOQ) is the order quantity that minimizes the total holding...
In inventory management, economic order quantity (EOQ) is the order quantity that minimizes the total holding costs and ordering costs. It is one of the oldest classical production scheduling models. Requirements: Discuss the EOQ Model using an quantitative example computation with interpretation of the solution. 2. The B. N. Thayer and D. N. Thaht Computer Company sells a desktop computer that is popular among gaming enthusiasts. In the past few months, demand has been relatively consistent, although it does fluctuate...
Problem 2 Cindy’s Appliance Store uses a perpetual inventory system, and ending inventory at April 30...
Problem 2 Cindy’s Appliance Store uses a perpetual inventory system, and ending inventory at April 30 was $25,000. Following is a listing of transactions for Cindy’s for the month of May. Cindy’s purchased refrigerators from GE on account at a total cost of $500,000 with terms 2/10, n/30. Cindy’s also paid freight of $800 on the refrigerators purchased from GE. Several of the refrigerators had to be returned to GE, and GE issued a credit to Cindy’s for 10 refrigerators...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for...
Fortune Stores uses the periodic inventory system for its merchandise inventory. The April 1 inventory for one of the items in the merchandise inventory consisted of 120 units with a unit cost of $375. Transactions for this item during April were as follows: April 9 Purchased 40 units @ $395 per unit 14 Sold 80 units @ $600 per unit 23 Purchased 20 units @ $400 per unit 29 Sold 40 units Required a. Calculate the cost of goods sold...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial...
LeMay Department Store uses the retail inventory method to estimate ending inventory for its monthly financial statements. The following data pertain to one of its largest departments for the month of March 2021: Cost Retail Beginning inventory $ 52,000 $ 72,000 Purchases 219,000 412,000 Freight-in 19,470 Purchase returns 5,500 8,000 Net markups 7,000 Net markdowns 4,700 Normal breakage 8,000 Net sales 292,000 Employee discounts 3,000 Sales are recorded net of employee discounts. Required: 1. Compute estimated ending inventory and cost...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT