Production Budget as follows:
Ham Inc. | |||||
Production Budget | |||||
For the year ended December 31, 2018 | |||||
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |
Next Quarter Budgeted Sales (Units) (A) | 480 | 640 | 640 | 960 | |
Ratio of Inventory to Future Sales (B) | 50% | 50% | 50% | 50% | |
Budgeted Ending Inventory (Units) (A × B)= C | 240 | 320 | 320 | 480 | 480 |
Budgeted Sales (Units) (D) | 720 | 480 | 640 | 640 | 2480 |
Required Units available production (E= C+D) | 960 | 800 | 960 | 1120 | 2960 |
Budgeted beginning inventory (F = C, But the first quarter is given i.e. 360) | 360 | 240 | 320 | 320 | 360 |
Units to be produced (G = E-F) | 600 | 560 | 640 | 800 | 2600 |
____________________________________________________________________________________
Direct material budget as follows:
Ham Inc. | |||||
Direct materials Budget | |||||
For the year ended December 31, 2018 | |||||
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |
Units to be produced (G) | 600 | 560 | 640 | 800 | |
Material per unit (pounds) (H) | 8 | 8 | 8 | 8 | |
Materials needed for production (pounds) (I = G×H) | 4800 | 4480 | 5120 | 6400 | |
Add: Desired ending inventory (J = 50%(4480/5120/6400/3840 given) | 2240 | 2560 | 3200 | 3840 | |
Total material requirements (pounds) (K = I+J) | 7040 | 7040 | 8320 | 10240 | |
Less: Beginning Balance (L) | 2400 | 2240 | 2560 | 3200 | |
Materials to be purchased (pounds) (M= K-L) | 4640 | 4800 | 5760 | 7040 | |
Material Price-per pound (N) | $14 | $14 | $14 | $14 | |
Total cost of direct materials purchases (O = M×N) | $64,960 | $67,200 | $80,640 | $98,560 | $311,360 |
DUE SOON, PLEASE HELP!!!! Sales for the final quarter of the prior year total 800 units....
DUE SOON, PLEASE HELP!!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...
DUE SOON, PLEASE HELP!!! Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...
DUE SOON, PLEASE HELP Sales for the final quarter of the prior year total 800 units. Expected sales in units) for the current year are: 720 (Quarter 1), 480 (Quarter 2), 640 (Quarter 3), and 640 (Quarter 4). Sales for the first quarter of the following year total 960 units. The selling price is $660 per unit in the first three quarters of the year, and $690 per unit in the final quarter. Company policy calls for a given quarter's...
need help thank you Collins Inc. has gathered the following budgeting information for next year and has asked you to prepar their master budget. Sales for the final quarter of the prior year total 1,400 units. Expected sales (in units) for the current year are: 1,260 (Quarter 1), 840 (Quarter 2), 1,120 (Quarter 3), and 1120 (Quarter 4). Sales for the first quarter of the following year total 1,680 units. The selling price is $470 per unit in the first...
Thomas Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. a. Sales for the final quarter of the prior year total 900 units. Expected sales in units) for the current year are: 810 (Quarter 1), 540 (Quarter 2), 720 (Quarter 3), and 720 (Quarter 4). Sales for the first quarter of the following year total 1,080 units. The selling price is $670 per unit in the first three quarters of...
Mitchell Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. a. Sales for the final quarter of the prior year total 300 units. Expected sales in units) for the current year are: 270 (Quarter 1), 180 (Quarter 2), 240 (Quarter 3), and 240 (Quarter 4). Sales for the first quarter of the following year total 360 units. The selling price is $610 per unit in the first three quarters of...
Mitchell Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. Sales for the final quarter of the prior year total 300 units. Expected sales (in units) for the current year are: 270 (Quarter 1), 180 (Quarter 2), 240 (Quarter 3), and 240 (Quarter 4). Sales for the first quarter of the following year total 360 units. The selling price is $610 per unit in the first three quarters of the...
Mitchell Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. Sales for the final quarter of the prior year total 300 units. Expected sales (in units) for the current year are: 270 (Quarter 1), 180 (Quarter 2), 240 (Quarter 3), and 240 (Quarter 4). Sales for the first quarter of the following year total 360 units. The selling price is $610 per unit in the first three quarters of the...
Mitchell Inc. has gathered the following budgeting information for next year and has asked you to prepare their master budget. a. Sales for the final quarter of the prior year total 300 units. Expected sales in units) for the current year are: 270 (Quarter 1), 180 (Quarter 2), 240 (Quarter 3), and 240 (Quarter 4). Sales for the first quarter of the following year total 360 units. The selling price is $610 per unit in the first three quarters of...
White Corporation's budget calls for the following sales for next year: Quarter i Quarter 2 108,500 units 90,000 units Quarter 3 Quarter 4 73,300 units 105,200 units Each unit of the product requires 3 pounds of direct materials. The company's policy is to begin each quarter with an inventory of product equal to 5% of that quarter's estimated sales requirements and an inventory of direct materials equal to 20% of that quarter's estimated direct materials requirements for production. Required: 1....