Solution:
Ham Inc. | |||||
Cost of goods sold budget | |||||
For the year ended Dec 31, 2018 | |||||
First Qtr. | Second Qtr. | Third Qtr. | Fourth Qtr. | Total | |
Budgeted sales units | 720 | 480 | 640 | 640 | 2480 |
Cost per unit | $191.00 | $191.00 | $191.00 | $191.00 | $191.00 |
Budgeted cost of goods sold | $137,520.00 | $91,680.00 | $122,240.00 | $122,240.00 | $473,680.00 |
Ham Inc. | |||||
Production Budget | |||||
For the year ended Dec 31, 2018 | |||||
First Qtr. | Second Qtr. | Third Qtr. | Fourth Qtr. | Total | |
Budgeted sales units | 720 | 480 | 640 | 640 | 2480 |
Add: Desired ending inventory | 240 | 320 | 320 | 480 | 480 |
Total requirement | 960 | 800 | 960 | 1120 | 2960 |
Less: Beginning inventory | 360 | 240 | 320 | 320 | 360 |
Budgeted Production units | 600 | 560 | 640 | 800 | 2600 |
Ham Inc. | |||||
Direct labor budget | |||||
For the year ended Dec 31, 2018 | |||||
First Qtr. | Second Qtr. | Third Qtr. | Fourth Qtr. | Total | |
Budgeted production units | 600 | 560 | 640 | 800 | 2600 |
Direct labor hour per unit | 3 | 3 | 3 | 3 | 3 |
Total direct labor hours needed | 1800 | 1680 | 1920 | 2400 | 7800 |
Direct labor rate per hour | $20.00 | $20.00 | $20.00 | $20.00 | $20.00 |
Total budgeted direct labor costs (dollar) | $36,000.00 | $33,600.00 | $38,400.00 | $48,000.00 | $156,000.00 |
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...
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...
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...
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...
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...
Mauti 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 1,800 units. Expected sales (in units) for the current year are: 1,620 (Quarter 1), 1,080 (Quarter 2), 1,440 (Quarter 3), and 1,440 (Quarter 4) Sales for the first quarter of the following year total 2,160 units. The selling price is $510 per unit in the first three quarters of the...