Question

In: Finance

2. PC Calculators sell calculators that it purchases for $15 each. It costs PC $60 each...

2. PC Calculators sell calculators that it purchases for $15 each. It costs PC $60 each time calculators are ordered, and carrying costs are 20% of the calculator's purchase price. Annual demand is 100,000 calculators. (a) Compute the EOQ. (b) Compute the inventory costs if PC orders are at (i) the EOQ amount, (ii) 1000 calculators, (iii) 2500 calculators.

Solutions

Expert Solution

Given: Purchase price = $15, Ordering cost = $60 , Carrying cost = 20 % * $15 = $3

(a) The formula for calculating the EOQ (economic order quantity) is :

EOQ = (2 * Annual demand * cost of placing the order / carrying cost )1/2

Now, putting the given values in the above equation, we get,

EOQ = (2* $100000 * $60 / $3)1/2

EOQ = ($12000000 / $3)1/2

EOQ = ($4000000)1/2

EOQ = 2000 calculators

(b) Inventory cost = Cost of purchase + Cost of order + Carrying cost

(i) Inventory cost at EOQ units of 2000 is:

Cost of purchase = 2000 * purchase price = $2000 * $15 = $30000

Cost of order = Annual demand / Ordering quantity * cost of placing the order = 100000 / 2000 * 60 = $3000

Carrying cost = 20% of purchase price = 20% * $30000 = $6000

Total cost = $30000 + $3000 + $6000 = $39000

(ii) Inventory cost at 1000 calculators is:

Cost of purchase = 1000 * purchase price = $1000 * $15 = $15000

Cost of order = Annual demand / Ordering quantity * cost of placing the order = 100000 / 1000 * 60 = $6000

Carrying cost = 20% of purchase price = 20% * $15000 = $3000

Total cost = $15000 + $6000 + $3000 = $24000

(iii) Inventory cost at 2500 calculators is:

Cost of purchase = 2500 * purchase price = $2500 * $15 = $37500

Cost of order = Annual demand / Ordering quantity * cost of placing the order = 100000 / 2500 * 60 = $2400

Carrying cost = 20% of purchase price = 20% * $37500 = $7500

Total cost = $37500 + $2400 + $7500 = $47400


Related Solutions

Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, you will...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, how much...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, you will...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, how much...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, how much...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, you will...
The PC Supply manufactures memory cards that sell to wholesalers for $2.00 each. Variable and fixed...
The PC Supply manufactures memory cards that sell to wholesalers for $2.00 each. Variable and fixed costs are as follows: Variable Costs per card Fixed Costs per Month Manufacturing Direct materials $0.30 Direct labor 0.25 Factory overhead 0.25 0.80 Factory overhead $4,000 Selling and admin. 0.15 Selling and admin. 3,000 Total $0.95 Total $7,000 PC Supply produced and sold 10,000 cards during October 2010. There were no beginning or ending inventories. a. Prepare a contribution income statement for the month...
Great-Garments Company plans to sell 9,000 T-shirts at $15 each in the coming year. Product costs...
Great-Garments Company plans to sell 9,000 T-shirts at $15 each in the coming year. Product costs include: Direct materials per T-shirt $5.00 Direct labour per T—shirt $1.00 Variable overhead per T-shirt $0.65 Total fixed factory overhead $44,000 Variable selling expense is the redemption of a coupon, which averages $0.85 per T-shirt; fixed selling and administrative expenses total $19,000. Required: ( for the following questions, please write the formula as well) a. Total variable cost per unit b. Contribution margin per...
Great-Garments Company plans to sell 9,000 T-shirts at $15 each in the coming year. Product costs...
Great-Garments Company plans to sell 9,000 T-shirts at $15 each in the coming year. Product costs include: Direct materials per T-shirt $5.00 Direct labour per T—shirt $1.00 Variable overhead per T-shirt $0.65 Total fixed factory overhead $44,000 Variable selling expense is the redemption of a coupon, which averages $0.85 per T-shirt; fixed selling and administrative expenses total $19,000. Required: ( for the following questions, please write the formula as well) a. Total variable cost per unit b. Contribution margin per...
A project currently generates sales of $15 million, variable costs equal 60% of sales, and fixed...
A project currently generates sales of $15 million, variable costs equal 60% of sales, and fixed costs are $3.0 million. The firm’s tax rate is 30%. Assume all sales and expenses are cash items. a. What are the effects on cash flow, if sales increase from $15 million to $16.5 million? (Input the amount as positive value. Enter your answer in dollars not in millions.) Cash flow: increases or decreses by __________? b. What are the effects on cash flow,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT