Question

In: Operations Management

A mail-order house uses 15,725 boxes a year. Carrying costs are 49 cents per box a...

A mail-order house uses 15,725 boxes a year. Carrying costs are 49 cents per box a year, and ordering costs are $91. The following price schedule applies.

Number of Boxes Price per Box
1,000 to 1,999 $1.35
2,000 to 4,999 1.25
5,000 to 9,999 1.15
10,000 or more 1.10


a.
Determine the optimal order quantity. (Round your answer to the nearest whole number.)
  

Optimal order quantity             boxes

b. Determine the number of orders per year. (Round your answer to 2 decimal places.)
  

Number of order             per year

Solutions

Expert Solution

a) Optimal order quantity 5000 boxes

The standard EOQ equation is given as below

where D is the annual demand, K is the ordering cost and h is the carrying cost.

Hence without the price discount, we have the EOQ as below

To determine the optimal order quantity, we need to compare the total cost of ordering 2417 with total cost of ordering 5000 and 10000. Total cost is the sum of ordering cost, carrying cost and purchase cost.

Total Ordering cost = (Annual Demand)/(Order Quantity)*(Ordering Cost)

Total Carrying cost = (Order Quantity)/2*(Carrying cost)

Total Purchase cost = (Annual Price)*(Purchase Cost)

For quantity = 2417

Total Ordering cost = (15725)/(2417)*(91) = 592.05

Total Carrying cost = (2417)/2*(0.49) = 592.17

Total Purchase cost = (15725)*(1.25) = 19656.25

Total cost = 592.05+592.17+19656.25 = 20840.47

For quantity = 5000

Total Ordering cost = (15725)/(5000)*(91) = 286.20

Total Carrying cost = (5000)/2*(0.49) = 1225

Total Purchase cost = (15725)*(1.15) = 18083.75

Total cost = 286.20+1225+18083.75 = 19594.95

For quantity = 10000

Total Ordering cost = (15725)/(10000)*(91) = 143.1

Total Carrying cost = (10000)/2*(0.49) = 2450

Total Purchase cost = (15725)*(1.1) = 17297.5

Total cost = 143.1+2450+17297.5 = 19890.6

We can see that the option with ordering 5000 quantity has the lowest cost. Hence optimal order quantity is 5000.

b) Number of order 3.15 per year

Number of orders is calculated by dividing the annual demand by the order quantity. In this case the annual demand is 15725 and the order quantity is 5000. Hence the number of orders per year are 15725/5000 = 3.15


Related Solutions

A mail-order house uses 15,950 boxes a year. Carrying costs are 69 cents per box a...
A mail-order house uses 15,950 boxes a year. Carrying costs are 69 cents per box a year, and ordering costs are $100. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.40 2,000 to 4,999 1.30 5,000 to 9,999 1.20 10,000 or more 1.15 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.)    b. Determine the number of orders per year. (Round your answer to 2 decimal places.)   
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a...
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, and ordering cost are $96. the folling price schedule applies. Number of boxes Price per box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 A. What is the maximum level of inventory the company would have to plan for? B. what is the average level of inventory the company would have to plan for? C....
A mail-order house uses 15,890 boxes a year. Carrying costs are 60 cents per box a...
A mail-order house uses 15,890 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of Boxes Price per Box 1,000 to 1,999 $1.25 2,000 to 4,999 1.20 5,000 to 9,999 1.15 10,000 or more 1.10 a. Determine the optimal order quantity. (Round your answer to the nearest whole number.)    Optimal order quantity              boxes b. Determine the number of orders per year. (Round your answer...
A mail-order house uses 15,750 boxes a year
A mail-order house uses 15,750 boxes a year. Carrying costs are 60 cents per box a year and ordering costs are $96. The following price schedule applies.Number of BoxesPrice per Box1,000 to 1,999$1.252.000 to 4,9991.205,000 to 9,9991.1510.000 or more1.10a. Determine the optimal order quantity (Round your answer to the nearest whole number) Optimal order quantity  = _______  boxes b. Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order _______  per yearA jewelry firm buys semiprecious...
Stanley’s Secretarial Services uses an average of 1,215 boxes of envelopes each year. Carrying costs per...
Stanley’s Secretarial Services uses an average of 1,215 boxes of envelopes each year. Carrying costs per box are $75 per year, and it costs $10 to place and receive an order. a. What is the optimal order quantity for boxes of envelopes, to the nearest whole number?   Economic order quantity boxes b. What is the average number of boxes of envelopes in inventory, to the nearest whole number?   Average number of boxes    c. How times will Stanley order envelopes...
A local manufacturer uses 2,000 electronic switches boxes a year. Carrying costs are 23% of the...
A local manufacturer uses 2,000 electronic switches boxes a year. Carrying costs are 23% of the cost of the switch per year, and ordering costs are $15 per order. The following price schedule applies. What is the optimal order quantity? Show all total costs calculations and explain your answer. Number of Switches               Price per Switch 0 - 99                                          $17.50 100 - 999                                     $17.00 1000 or more    $16.50
If EOQ = 360 units, order costs are $5 per order, and carrying costs are $0.20...
If EOQ = 360 units, order costs are $5 per order, and carrying costs are $0.20 per unit, what is the usage in units? How many orders will be placed in a year if there are 250 working days per year and lead time is 5 days?
Mac-in-the-Box sells computer equipment by mail and telephone order. Mac sells 2,400 flat-bed scanners per year....
Mac-in-the-Box sells computer equipment by mail and telephone order. Mac sells 2,400 flat-bed scanners per year. Ordering cost is $300 and the annual holding cost is 25 percent of the item’s price. There are 300 working days in the year and the lead time is 3 days. The scanner manufacturer offers the following price structure to Mac-in-the Box: Order Quantity Price per Unit 1 to 199 $520.00 200 to 499 $515.00 500 or more $512.00 Given the above information and...
Annual demand 144495 units Carrying costs $3.36 per unit Fixed Costs per order $7.8 Number of...
Annual demand 144495 units Carrying costs $3.36 per unit Fixed Costs per order $7.8 Number of orders 38 What are the total costs?
House A costs $100,000 with annual energy costs of $1,800 per year. House B costs $110,000...
House A costs $100,000 with annual energy costs of $1,800 per year. House B costs $110,000 with annual energy costs of $600 per year. You must borrow the money to purchase the houses at an interest rate of 7% per year for a 30-year mortgage, and that energy costs will escalate 1% per year. a) What would be the simple payback of investing in House B compared to House A? Is this a good investment? b) What are the annualized...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT