A sales budget is given below for one of the products manufactured by the Rhys Hoskins Co.:

	Sales Budget in Units
January	27,000
February	42,000
March	67,000
April	47,000
May	37,000
June	32,000

The inventory of finished goods at the end of each month must equal 23% of the next months sales. On December 31, the finished goods inventory totaled 6,210 units.

Each unit of product requires four specialized electrical switches. Since the production of these specialized switches by Rhys Hoskins suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to 35% of the next months production needs. This requirement had been met on January 1 of the current year.

Required:

Prepare a production budget for January, February, March and April. (Input all amounts as positive values.)

	January	February	March	April
(Click to select) Budgeted sales Add: Desired ending inventory Deduct: Beginning inventory Deduct: Desired ending inventory Add: Beginning inventory
(Click to select) Budgeted sales Add: Desired ending inventory Deduct: Beginning inventory Add: Beginning inventory Deduct: Desired ending inventory
Total needs
(Click to select) Budgeted sales Add: Desired ending inventory Deduct: Desired ending inventory Deduct: Beginning inventory Add: Beginning inventory
Units to be produced

Calculate the quantity of switches to be purchased each month for January, February, March and in total for the quarter. (Input all amounts as positive values.)

	January	February	March	Quarter
(Click to select) Production needs Add: Desired ending inventory Deduct: Beginning inventory Add: Beginning inventory Deduct: Desired ending inventory
(Click to select) Production needs Add: Desired ending inventory Deduct: Desired ending inventory Deduct: Beginning inventory Add: Beginning inventory
Total needs
(Click to select) Production needs Add: Desired ending inventory Deduct: Desired ending inventory Deduct: Beginning inventory Add: Beginning inventory
Required purchases