Question

In: Finance

A vegetable canning company uses 730 shipping crates a month, which it purchases at a cost...

A vegetable canning company uses 730 shipping crates a month, which it purchases at a cost of $10 each. The manager has assigned an annual carrying cost of 35 percent of the purchase price per crate. Ordering costs are $28. Currently the manager orders once a month. (Round intermediate calculations and final answer to 2 decimal places. )

a. What is the EOQ? EOQ = ____ crates

b. How much could the firm save annually in ordering and carrying costs by using the EOQ? (Round intermediate calculations and final answer to 2 decimal places. Omit the "$" sign in your response.)

Solutions

Expert Solution

Answer a.

Annual usage = 12 * Monthly usage
Annual usage = 12 * 730
Annual usage = 8,760

Carrying cost per crate = 35% * Purchase price per crate
Carrying cost per crate = 35% * $10
Carrying cost per crate = $3.50

Ordering cost = $28

EOQ = (2 * Annual usage * Ordering cost / Carrying cost per crate)^(1/2)
EOQ = (2 * 8,760 * $28 / $3.50)^(1/2)
EOQ = 140,160^(1/2)
EOQ = 374.38 crate

Answer b.

If order size is 730 crates:

Ordering cost = (Annual usage / Order size) * Ordering cost
Ordering cost = (8,760 / 730) * $28
Ordering cost = $336

Carrying cost = (Order size / 2) * Carrying cost per crate
Carrying cost = (730 / 2) * $3.50
Carrying cost = $1,277.50

Total cost = Ordering cost + Carrying cost
Total cost = $336 + $1,277.50
Total cost = $1,613.50

If order size is 374.38 crates:

Ordering cost = (Annual usage / Order size) * Ordering cost
Ordering cost = (8,760 / 374.38) * $28
Ordering cost = $655.16

Carrying cost = (Order size / 2) * Carrying cost per crate
Carrying cost = (374.38 / 2) * $3.50
Carrying cost = $655.17

Total cost = Ordering cost + Carrying cost
Total cost = $655.16 + $655.17
Total cost = $1,310.33

Cost saved = $1,613.50 - $1,310.33
Cost saved = $303.17


Related Solutions

A produce distributor uses 787 packing crates a month, which it purchases at a cost of...
A produce distributor uses 787 packing crates a month, which it purchases at a cost of $10 each. The manager has assigned an annual carrying cost of 36 percent of the purchase price per crate. Ordering costs are $28. Currently, the manager orders once a month. How much could the firm save annually in ordering and carrying costs by using the EOQ? (Round intermediate calculations and final answer to 2 decimal places. Omit the "$" sign in your response.) Savings...
1. A fresh produce distributor uses 770 non-returnable packing crates a month, which it purchases at...
1. A fresh produce distributor uses 770 non-returnable packing crates a month, which it purchases at a cost of $6 each. The manager has assigned an annual holding cost of 28 percent of the purchase price per crate. Ordering cost is $32 per order. Currently the manager orders 770 crates at a time. How much could the firm save annually in ordering and holding costs by using the EOQ? (Round the final answer to 2 decimal places.)   Annual savings A...
Maple Mount Fishery is a canning company in Astoria. The company uses a normal costing system...
Maple Mount Fishery is a canning company in Astoria. The company uses a normal costing system in which factory overhead is applied on the basis of direct labor costs. Budgeted factory overhead for the year was $680,000, and management budgeted $322,000 of direct labor costs. During the year, the company incurred the following actual costs. Direct materials used $389,000 Direct labor 318,000 Factory overhead 653,400 The January 1 balances of inventory accounts are shown below. Materials — all direct $62,800...
Ridgecrest Company manufactures plastic storage crates and has the following information available for the month of...
Ridgecrest Company manufactures plastic storage crates and has the following information available for the month of April: Work in process, April 1 (100% complete for materials, 44% for conversion) 26,600 units Direct materials $ 20,000 Conversion cost $ 27,000 Number of units started 54,400 units April costs Direct materials $ 60,800 Conversion cost $ 102,800 Work in process, April 30 (100% complete for materials, 22% for conversion) 23,000 units Required: Using the weighted-average method of process costing, complete each of...
Ridgecrest Company manufactures plastic storage crates and has the following information available for the month of...
Ridgecrest Company manufactures plastic storage crates and has the following information available for the month of April: Work in process, April 1 (100% complete for materials, 47% for conversion) 23,600 units Direct materials $ 20,000 Conversion cost $ 23,000 Number of units started 49,400 units April costs Direct materials $ 61,800 Conversion cost $ 98,800 Work in process, April 30 (100% complete for materials, 22% for conversion) 17,000 units Required: Using the weighted-average method of process costing, complete each of...
Which item would a shipping department cost pool use as a cost driver?
Which item would a shipping department cost pool use as a cost driver? Number of sales orders Number of containers Number of units Number of machine hours
Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales:...
Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales: Units April 1 (beg. balance) 600 $6.00 April 3 500 4 1,500 $6.08 9 1,400 8 800 $6.40 11 600 13 1,200 $6.50 23 1,200 21 700 $6.60 27 900 29 500 $6.79 Instructions: 1) Assume Randal Company uses periodic inventory records. Determine the value of ending inventory using: a) FIFO b) LIFO c) Average-cost 2) Assume Randa lComapny uses perpetual inventory records. Determine...
Brian Canning Co., which sells canned corn, uses an operation costing system. Cans of corn are...
Brian Canning Co., which sells canned corn, uses an operation costing system. Cans of corn are classified as either sweet or regular, depending on the type of corn used. Both types of corn go through the separating and cleaning operations, but only regular corn goes through the creaming operation. During January, two batches of corn were canned from start to finish. Batch X consisted of 1,800 pounds of sweet corn, and Batch Y consisted of 1,700 pounds of regular corn....
UPSA Ltd is a company that produces fruit juice which is bottled and sold in crates....
UPSA Ltd is a company that produces fruit juice which is bottled and sold in crates. The normal annual level of production on which the fixed production overhead absorption is based is 120,000 crates. Production 145,000 crates Sales 112,000 crates Selling price GHS2,000 per crate Costs: Direct material GHS600 per unit Direct labour GHS520 per unit Variable overhead GHS250 per unit Fixed production overhead GHS1,820,000 Variable selling and distribution cost 10% of sales revenue Fixed selling and distribution cost GHS234,000...
A shipping company believes that the variation in the cost of a customer’s shipment can be...
A shipping company believes that the variation in the cost of a customer’s shipment can be explained by differences in the weight of the package being shipped. To investigate whether this relationship is useful, a random sample of 20 customer shipments was selected, and the weight (in lb.) and the cost (in dollars, rounded) for each shipment were recorded. The following results were obtained: Weight (lbs.) Cost (Dollars) 8 11 6 8 5 11 7 11 12 17 9 11...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT