# Question

The following information has been gathered by Miller Company to determine its economic order quantity.

Annual demand ...................................................................... 2,000,000

Cost to place an order ............................................................ $ 9.50

Cost to carry a unit in inventory ............................................ 2.75

Required

Use a computer spreadsheet to answer the following questions. Treat each situation independently. Do not round your answers to the nearest whole unit.

A. What is the economic order quantity?

B. If demand increases by 25 percent, what is the economic order quantity?

C. If the cost to place an order increases by $ 2.00, what is the economic order quantity?

D. If the cost to carry a unit in inventory increases by $ 0.50, what is the economic order quantity?

E. If Miller decides to maintain a safety stock of 200 units, what is the economic order quantity?

Annual demand ...................................................................... 2,000,000

Cost to place an order ............................................................ $ 9.50

Cost to carry a unit in inventory ............................................ 2.75

Required

Use a computer spreadsheet to answer the following questions. Treat each situation independently. Do not round your answers to the nearest whole unit.

A. What is the economic order quantity?

B. If demand increases by 25 percent, what is the economic order quantity?

C. If the cost to place an order increases by $ 2.00, what is the economic order quantity?

D. If the cost to carry a unit in inventory increases by $ 0.50, what is the economic order quantity?

E. If Miller decides to maintain a safety stock of 200 units, what is the economic order quantity?

## Answer to relevant Questions

Refer to CA5.1. Prepare a spreadsheet that proves using the economic order quantity minimizes total inventory ordering costs plus inventory carrying costs. Use Exhibit 5.3 as a guide. Do not round your answers to the nearest ...What are the budgets/ schedules that result from revenue process planning? Niedringhaus Corporation’s sales revenue follows: Niedringhaus’s management estimates that 65 percent of credit sales will be collected in the month of sale with a 2% discount taken, and that 34 percent will be collected ...Accounting Receivable Codner, Inc., plans to purchase $ 800,000 and $ 850,000 of direct materials in Months One and Two, respectively. The accounts payable balance at the beginning of Month One is $ 50,000. Codner pays for 75 percent of its ...Post your question

0