Question

The Yucatan Co. in Mexico has a division that manufactures bicycles. Its budgeted sales for Model XG in 2021 are 95,000 units. Yucatan​'s target ending inventory is 7,000 ​units, and its beginning inventory is 11,000 units. The​ company's budgeted selling price to its distributors and dealers is 3,500 pesos per bicycle. Yucatan buys all its wheels from an outside supplier. No defective wheels are accepted. A separate division of the company orders the extra wheels Yucatan needs for replacement parts. The​ company's target ending inventory is 14,000 ​wheels, and its beginning inventory is 16,000 wheels. The budgeted purchase price is 400 pesos per wheel.
Required:
1. Compute the budgeted revenues in pesos.
2. Compute the number of bicycles that Yucatan should produce.
3. Compute the budgeted purchases of wheels in units and in pesos.
4. What actions can Yucatan's managers take to reduce budgeted purchasing costs of wheels assuming the same budgeted sales for Model XG?

Answer 1

Explanation:

1. Revenue in pesos

M*G

= 95000 x 3500

= 332,500,000 pesos

2. Number of bicycle to produce

Budgeted sales for period = s = 95000

Budgeted production = BP

Ending inventory = ev

Begining inventory = bv

BP = s + ex - bv

= 95000+7000-11000

= 91000

Yucatan should produce 91000 bicycles

3. 2 wheels are used

MR = 2x91000 = 182000

Ending inventory ev = 14000

Begining inventory bv = 16000

P = MR-bv+ev

P = 182000-16000+14000

P = 180000 units of wheels to be purchased

Price = 180000x400pesos

= 72000000 pesos

4. To reduce budgeted purchase cost, the manager should only purchase the right quantity of what is needed for the production process to reduce purchased inventory and to also reduce ending inventory