Question

1) Greg Fletcher, the materials manager at Easy Furniture Inc., is responsible for managing the inventory...

1) Greg Fletcher, the materials manager at Easy Furniture Inc., is responsible for managing the inventory of writing desks. Greg isn't talkative about his inventory, but you have managed to extract the following information from him: It costs $35 to place an order. Each writing desk costs $31.33. Annual per unit holding cost is 30%of item value. Average daily demand is 100 writing desks. Standard deviation of demand during lead time is 51.96. Lead time to receive a writing desk from a supplier is 3 days. Target service level is 94%. Easy furniture Inc. is open 5 days a week, 52 weeks a year. The company follows a continuous review policy.

a) Please help Greg out by determining the order quantity, reorder point and the safety stock for writing desks.

Order Quantity=

Reorder Point=

Safety Stock=

Homework Answers

Answer #1

Daily demand d= 100

Annual demand D = =100*5*52 = 26000

Ordering cost S= 35

Cost = 31.33

Holding cost H =30% = 0.3*31.33 = 9.399

Standard deviation = 51.96

Lead time = 3 days

Service level = 94%

Z = 1.55

Order quantity Q

Q = 440

Reorder point = Demand during lead time + Safety stock

Demand during lead time = dL = 100*3 = 300

Safety stock SS

Safety stock SS = 139.50

Reorder point = 300 + 139.50 = 439.5

Safety stock SS = 139.50

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't...
Bob Sean, manager at Ikea is responsible for managing the inventory of computer desks. Bob isn't talkative about his inventory, but you have managed to extract the following information from him: It costs $35 to place an order. Each computer desk costs $31.33. Annual per unit holding cost is 30% of item value. Average daily demand is 100 writing desks. Standard deviation of demand during lead time is 51.96. Lead time to receive a computer desk from a supplier is...
Question 11.6 The materials manager of an ambulatory surgery center is looking to determine the appropriate...
Question 11.6 The materials manager of an ambulatory surgery center is looking to determine the appropriate order quantity and reorder points for customized surgical kits. A custom surgical kit costs $50 to order, and the annual carrying cost is 10 percent of the product cost. Annual demand for surgical kist is 3,600 and the purchase price is $200. Lead time for delivery is two weeks. a. What is the economic order qualtity for surgical kits? b. What is the length...
Procurement manager Ikbal is working on preparing a 10-day inventory management and order schedule for Dragon...
Procurement manager Ikbal is working on preparing a 10-day inventory management and order schedule for Dragon Ball Inc. The company has the following cost structure and demand structure: solve in excel and show the formula used in step by step format : Setup(order) cost is $30, unit product cost is $20 and planned holding fraction (h) is 10%. Orders take 3 days to arrive to facility and they typically hold a 10% of lead time demand as safety stock. Daily...
Hershey Company uses quantitative models for inventory control. For canned syrup, the annual demand is 8,000...
Hershey Company uses quantitative models for inventory control. For canned syrup, the annual demand is 8,000 cases. The supplier is 500 miles away, and it usually takes three days to get an order filled. The average order costs $16 to process and the carrying cost per case is $40 per year. The store is open 300 days a year. A. Determine the economic order quantity. B. Determine the reorder point if a safety stock of 24 cases is desired.
MNO has an average annual demand for red, medium polo shirts of 100,000 units. The cost...
MNO has an average annual demand for red, medium polo shirts of 100,000 units. The cost of placing an order is $500 and the cost of carrying one unit in inventory for one year is $20. Required: a. Use the economic-order-quantity model to determine the optimal order size. b. Determine the reorder point assuming a lead time of 12 days and the store is open 250 days in the year. c. Determine the safety stock required to prevent stockouts assuming...
The following questions about els based on the information provided. The PC Inc. decides to make...
The following questions about els based on the information provided. The PC Inc. decides to make circuits boards for its computer assembly. The following information is available. Annual Demand, units/year: 10000 Set up Cost Per Production Run: 100 Annual Carrying Costs, as of Unit Cost: 0.20 Unit Costs, manufacturing: 54 Daily Production (in units): 50 Lead Time (days): 1 Safety Stock: 0 Days of a Calendar Year: 250 a. the annual inventory carrying costs are not (in units): 1,039 b....
You manage inventory for your company and use a continuous review inventory system to control reordering...
You manage inventory for your company and use a continuous review inventory system to control reordering items for stock. Your company is open for business 300 days per year. One of your most important items experiences demand of 20 units per day, normally distributed with a standard deviation of 3 units per day. You experience a lead time on orders from your supplier of six days with a standard deviation of two days. The unit price, regardless of order size,...
Daily demand for neckties at a MegaMart store is normally distributed with a mean of 20...
Daily demand for neckties at a MegaMart store is normally distributed with a mean of 20 units and a standard deviation of 7. The supplier, Suits Galore, takes on average about 9 days to supply a MegaMart order. The standard deviation of lead time is 3 days. MegaMart is targeting a customer service level of 95 percent (z = 1.65) and monitors its inventory continuously. How much safety inventory of neckties should MegaMart carry? What should their reorder point (ROP)...
Problem 3 (Variation & Safety Stock) Period Demand 1 1200 2 1000 3 800 4 900...
Problem 3 (Variation & Safety Stock) Period Demand 1 1200 2 1000 3 800 4 900 5 1400 6 1100 7 1100 8 700 9 1000 10 800 By using excel Average=1000 STDEV=211 Assume the lead time is one period and that the hospital wants a 99.90% service level. Please calculate the following questions: a) Average demand during lead time b) Appropriate safety stock c) The reorder point (stock quantity in inventory that would trigger the order)
The purchasing manager for Alpa Enterprises requested the following data from the accounting department: Annual demand...
The purchasing manager for Alpa Enterprises requested the following data from the accounting department: Annual demand = 15,500; Cost of placing an order = £180; Annual inventory holding costs = 20 percent; Unit cost = £753 Assume Alpha’s demand for an item during the lead time is normally distributed with a mean of 5,000 and a standard deviation of 50. What reorder point should be used in order to average no more than one stock out every 20 re-order cycles?...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT