ABC Company produces water pumps. The unit sales for the first four months of the year for this product are as follows:
Unit Sales:
January 144,000
February 176,000
March 160,000
April 192,000
Company maintains ending inventory for each month at 25% of next month's sales. However, at the beginning of January, due to greater sales in December than anticipated, the beginning inventory for January is 16,800
Required:
a) Compute the total number of units that should be produced for the months of January, February and March. Find the Total units to be produced for the 1st quarter
b) ABC Company makes wallets and the planned production (4 Marks) in units for the first three months of the following year are:
January 21,900
February 20,500
March 25,100
Additional information is as follows:
Average wage per hour $21.60
Direct labor hour for each wallet 0.45
| Requirement 1 | |||||||
| Production Budget: | Jan | Feb | Mar | Q1 | April | ||
| Unit Sales for the Month | 144000 | 176000 | 160000 | 480000 | 192000 | ||
| Add: Desired Closing Units | 44000 | 40000 | 48000 | 48000 | (25% of Next Month Sales) | ||
| Total Units Needed | 188000 | 216000 | 208000 | 528000 | |||
| Less: Opening Units | 16800 | 44000 | 40000 | 16800 | |||
| Production to be done | 171200 | 172000 | 168000 | 511200 | |||
| Requirement 2 is not clear please share details | |||||||
ABC Company produces water pumps. The unit sales for the first four months of the year...
ABC Company produces water pumps. The unit sales for the first four months of the year for this product are as follows: Unit Sales: January 162,000 February 198,000 March 180,000 April 216,000 Company maintains ending inventory for each month at 25% of next month's sales. However, at the beginning of January, due to greater sales in December than anticipated, the beginning inventory for January is 18,900 Required: a) Compute the total number of units that should be produced for the...
Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 180,000 May 220,000 June 200,000 July 240,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000. Required: Prepare a production budget for the second quarter of...
Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 180,000 May 220,000 June 200,000 July 240,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pump is only 21,000. Required: Prepare a production budget for the second quarter of...
The controller of Harrington Company estimates sales and production for the first four months of 2016 as follows: January February March April Sales $32,300 $41,900 $53,200 $27,700 Production in units 1,050 1,640 2,110 2,600 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct material to produce a finished unit, and...
The controller of Harrington Company estimates sales and production for the first four months of 2020 as follows: Sales Production in units January February $32,700 $41,000 1,100 1,400 March $53,400 2,000 April $27,300 2,700 Sales are 40% cash and 60% on account, and 60% of credit sales are collected in the month of the sale. In the month after the sale, 40% of credit sales are collected. It takes 4 kg of direct materials to produce a finished unit, and...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 23,000 April 25,000 May 22,500 June 21,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 28,000 April 30,000 May 27,500 June 26,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...
Wright Lighting Fixtures forecasts its sales in units for the
next four months as follows:
March
27,000
April
29,000
May
26,500
June
25,000
Wright maintains an ending inventory for each month in the
amount of one times the expected sales in the following month. The
ending inventory for February (March’s beginning inventory)
reflects this policy. Materials cost $4 per unit and are paid for
in the month after production. Labor cost is $8 per unit and is
paid for in...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March April May June 31,000 33,000 30,500 29,000 Wright maintains an ending Inventory for each month in the amount of three times the expected sales in the following month. The ending Inventory for February (March's beginning inventory) reflects this policy. Materials cost $8 per unit and are paid for in the month after production. Labor cost is $12 per unit and is paid for in...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March April May June 29,000 31,000 28,500 27,000 Wright maintains an ending inventory for each month in the amount of two times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $6 per unit and are paid for in the month after production. Labor cost is $10 per unit and is paid for in...