Question

In: Operations Management

Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand =...

Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information:

Average demand = 35 units per day

Average lead time = 49 days

Item unit cost = $69 for orders of less than 390 units

Item unit cost = $65 for orders of 390 units or more

Ordering cost = $44

Inventory carrying cost = 20%

The business year is 250 days

Assume there is no uncertainty at all about the demand or the lead time.

a. Calculate EOQ if unit cost is $69 and $65. (Note: These EOQs do not need to be feasible in their price range.) (Round up your answers to the next whole number.)

b. Calculate annual ordering costs for each alternative? (Round your answers to 2 decimal places.)

c. Calculate annual inventory carrying costs for each alternative? (Round your answers to 2 decimal places.)

d. Calculate annual product costs for each alternative?

e. What will be the total costs for each alternative? (Round your answers to 2 decimal places.)

f. Based on your analysis, how many chairs should they order at a time? (Round your answers to 2 decimal places.)

   

g. How much the firm can save annually by using the order quantity in Part f. instead of the first EOQ shown in Part a? (Round your answer to 2 decimal places.)

Solutions

Expert Solution

Average demand d = 35 units per day

Annual demand D = 35*250 days = 8750

Average lead time L = 49 days

Item unit cost C = $69 for orders of less than 390 units

= $65 for orders of 390 units or more

Ordering cost S = $44

Inventory carrying cost = 20%

H = 0.2*69 = 13.8 for orders of less than 390 units

H = 0.2*65 = 13 for orders of 390 units or more

The business year is 250 days

a)

Unit cost is $69

EOQ = 236 units (Feasible)

Unit cost is $65

EOQ = 243 units (Not Feasible)

b)

We calculate the costs at Q = 236 and 390

Q = 236

Annual ordering costs = (D/Q)S = (8750/236)*44 = 1631.36

Q = 390

Annual ordering costs = (D/Q)S = (8750/390)*44 = 987.18

c)

Q = 236

Annual inventory carrying costs = (Q/2)H = (236/2)*13.8 = 1628.4

Q = 390

Annual inventory carrying costs = (Q/2)H = (390/2)*13 = 2535

d)

Q = 236

Annual production costs = DC = 8750*69 = 603750

Q = 390

Annual production costs = DC = 8750*65 = 568750

e)

Total cost = Annual production costs + Annual ordering costs +  Annual inventory carrying costs

Q = 236

Total cost = 603750 + 1628.4 + 1631.36 = 607009.76

Q = 390

Total cost = 568750 + 2535+987.18 = 572272.18

f)

They should order 390 chairs as the total cost is less when compare with EOQ = 236

g) Savings= 607009.76 - 572272.18 = 34738.58

keosha answered 1 year ago
Next > < Previous

Related Solutions

Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand =...
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 30 units per day Average lead time = 44 days Item unit cost = $64 for orders of less than 340 units Item unit cost = $62 for orders of 340 units or more Ordering cost = $39 Inventory carrying cost = 25% The business year is 250 days Assume there is no uncertainty at all about the demand or the lead time. a....
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand =...
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 20 units per day Average lead time = 30 days Item unit cost = $50 for orders of less than 200 units Item unit cost = $48 for orders of 200 units or more Ordering cost = $25 Inventory carrying cost = 25% The business year is 250 days Assume there is no uncertainty at all about the demand or the lead time. a....
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand =...
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 30 units per day Average lead time = 37 days Item unit cost = $57 for orders of less than 270 units Item unit cost = $56 for orders of 270 units or more Ordering cost = $32 Inventory carrying cost = 20% The business year is 250 days Assume there is no uncertainty at all about the demand or the lead time. a....
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand =...
Ergonomics Inc. sells ergonomically designed office chairs. The company has the following information: Average demand = 29 units per day Average lead time = 30 days Item unit cost = $56 for orders of less than 260 units Item unit cost = $54 for orders of 260 units or more Ordering cost = $31 Inventory carrying cost = 25% The business year is 250 days. Assume there is no uncertainty at all about the demand or the lead time. a....
Ergonomics, Inc. sells ergonomically designed office chairs. The company provided the following information: Average Demand =...
Ergonomics, Inc. sells ergonomically designed office chairs. The company provided the following information: Average Demand = 15 units per day Average lead time = 20 days Item unit cost = $60 for orders of less than 200 units Item unit cost = $58 for orders of more 200 units or more Ordering costs = $30 Inventory carrying costs = 25% The business year is 250 days Based on the above information: How many chairs should the firm order each time?...
Office Furniture Inc. sells modular desk units and office chairs in the ratio of 3:2. That...
Office Furniture Inc. sells modular desk units and office chairs in the ratio of 3:2. That is 3 desk units for every 2 chairs sold. The selling prices are $1,280 per desk unit and $540 per chair. The variable costs are $760 per desk unit and $270 per chair. Shared fixed costs total $160,000. a) Prepare a schedule to compute the selling price and variable cost per composite unit. b) Compute the break-even point in composite units. c) Compute the...
Office Furniture Systems, Inc. sells chairs for $150. The unit variable cost per unit is $65....
Office Furniture Systems, Inc. sells chairs for $150. The unit variable cost per unit is $65. Fixed costs total $18,700. Required: a.   What is the contribution margin per unit? b.   What is the breakeven point in units? c.   How many units must be sold to earn a pretax income of $45,000? d.   What is the margin of safety, assuming 700 units are sold?
ABC Company sells 2,976 chairs a year at an average price per chair of $161. The...
ABC Company sells 2,976 chairs a year at an average price per chair of $161. The carrying cost per unit is $15.22. The company orders 500 chairs at a time and has a fixed order cost of $101 per order. The chairs are sold out before they are restocked. What is the economic order quantity? Your friend from Netherlands is planning to visit you in the United States. You estimate the cost of her trip at $5,410. What is the...
Munoz Chairs, Inc. makes two types of chairs. Model Diamond is a high-end product designed for...
Munoz Chairs, Inc. makes two types of chairs. Model Diamond is a high-end product designed for professional offices. Model Gold is an economical product designed for family use. Jane Silva, the president, is worried about cut-throat price competition in the chairs market. Her company suffered a loss last quarter, an unprecedented event in its history. The company’s accountant prepared the following cost data for Ms. Silva: Direct Cost per Unit Model Diamond (D) Model Gold (G) Direct materials $ 19.60...
Benson Chairs, Inc. makes two types of chairs. Model Diamond is a high-end product designed for...
Benson Chairs, Inc. makes two types of chairs. Model Diamond is a high-end product designed for professional offices. Model Gold is an economical product designed for family use. Jane Silva, the president, is worried about cut-throat price competition in the chairs market. Her company suffered a loss last quarter, an unprecedented event in its history. The company’s accountant prepared the following cost data for Ms. Silva: Direct Cost per Unit Model Diamond (D) Model Gold (G) Direct materials $ 20.30...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT