(a) | ||
CULVER COMPANY | ||
Production Budget | ||
For the month ending February 31, 2017 | ||
January | February | |
Expected unit sales | 10500 | 12900 |
Add : Desired ending finished goods inventory ( 20% * next month's expected unit sales ) | 2580 | 2760 |
Total required units | 13080 | 15660 |
Less : Beginning finished goods inventory | 2100 | 2580 |
Required production in units | 10980 | 13080 |
Note : Beginning finished goods inventory for January = Ending finished goods inventory of December = 20% * January expected unit sales = 20% * 10500 | 2100 |
(b) | |
CULVER COMPANY | |
Production Budget | |
For the month ending February 31, 2017 | |
January | |
Required production in units | 10980 |
Materials requirements per unit (lbs.) | 4 |
Materials needed for production (lbs.) | 43920 |
Add : Budgeted ending inventory (lbs.) [ 40% of next month's materials requirement = 40% * ( 13080 * 4 ) ] | 20928 |
Total materials requirement (lbs.) | 64848 |
Less : Budgeted beginning inventory (lbs.) | 17568 |
Materials to be purchased | 47280 |
Direct material cost per lb. | $ 5 |
Total budgeted direct materials | $ 236,400 |
Note : Beginning raw materials inventory for January = Ending raw materials inventory of December = 40% * Production requirement of January = 40% * 43920 | 17568 |
per Cute Company dereits ending materials inventory tagal 40% of the next month's Culver Company's sales...
Culver Company has 2,284 pounds of raw materials in its December 31, 2016, ending inventory. Required production for January and February of 2017 are 4,230 and 5,740 units, respectively. 2 pounds of raw materials are needed for each unit, and the estimated cost per pound is $9. Management desires an ending inventory equal to 27% of next month’s materials requirements. Prepare the direct materials budget for January. (Round intermediate calculations and final answer to 0 decimal places, e.g. 5,275.) CULVER...
Pina Company's sales budget projects unit sales of part 1987 of 10,700 units in January, 12,200 units in February, and 13,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $4 per pound. Pina Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December 31, 2016....
Culver Company produces and sells automobile batteries, the
heavy-duty HD-240. The 2017 sales forecast is as follows.
Quarter
HD-240
1
5,400
2
7,430
3
8,450
4
10,230
The January 1, 2017, inventory of HD-240 is 2,160 units. Management
desires an ending inventory each quarter equal to 40% of the next
quarter’s sales. Sales in the first quarter of 2018 are expected to
be 25% higher than sales in the same quarter in 2017.
Prepare quarterly production budgets for each quarter...
Exercise 23-8 Fuqua Company's sales budget projects unit sales of part 1987 of 11,000 units in January, 12,600 units in February, and 14,000 units in March. Each unit of part 1982 requires 3 pounds of materials, which cost $3 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December...
Fuqua Company's sales budget projects unit sales of part 198Z of 10,400 units in January, 13,000 units in February, and 13,400 units in March. Each unit of part 198.Z requires 4 pounds of materials, which cost $3 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December 31, 2016...
*Exercise 9-8 Fuqua Company's sales budget projects unit sales of part 198z of 10,700 units in January, 12,400 units in February, and 13,500 units in March. Each unit of part 198Z requires 2 pounds of materials, which cost $5 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December...
Fuqua Company’s sales budget projects unit sales of part 198Z of 11,000 units in January, 12,600 units in February, and 14,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $3 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month’s production requirements, and its ending finished goods inventory to equal 20% of the next month’s expected unit sales. These goals were met at December 31, 2016....
Fuqua Company's sales budget projects unit sales of part 1987 of 10,300 units in January, 12,600 units in February, and units in March. Each unit of part 1987 requires 3 pounds of materials, which cost $4 per pound. Fuqua Company desires its ending raw materials inventory to 10% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December 31, 2019. Prepare a...
Exercise 9-8 Fuqua Company's sales budget projects unit sales of part 198Z of 11,000 units in January, 12,600 units in February, and 14,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $3 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month's production requirements, and its ending finished goods inventory to equal 20% of the next month's expected unit sales. These goals were met at December...
Monty Company’s sales budget projects unit sales of part 198Z of 10,400 units in January, 13,000 units in February, and 13,400 units in March. Each unit of part 198Z requires 4 pounds of materials, which cost $3 per pound. Monty Company desires its ending raw materials inventory to equal 40% of the next month’s production requirements, and its ending finished goods inventory to equal 20% of the next month’s expected unit sales. These goals were met at December 31, 2016....