Question
Sales Budget July August September Total Units to be sold 20,000 35,000 25,000 80,000 Sales price $180 $180 $180 $180 Total sales dollars $3,600,000 $6,300,000
Sales Budget | ||||
| July | August | September | Total |
Units to be sold | 20,000 | 35,000 | 25,000 | 80,000 |
Sales price | $180 | $180 | $180 | $180 |
Total sales dollars | $3,600,000 | $6,300,000 | $4,500,000 | $14,400,000 |
Production Budget | ||||
| July | August | September | Total |
Sales | 20,000 | 35,000 | 25,000 | 80,000 |
Add: Desired ending inventory | 7,000 | 5,000 | 6,000 | 6,000 |
Total needs | 27,000 | 40,000 | 31,000 | 86,000 |
Less: Beginning inventory | (4,000) | (7,000) | (5,000) | (4,000) |
Units to be produced | 23,000 | 33,000 | 26,000 | 82,000 |
Direct Materials Budget | ||||
| July | August | September | Total |
Units to be produced | 23,000 | 33,000 | 26,000 | 82,000 |
lbs per unit | 3 | 3 | 3 | 3 |
Pounds needed | 69,000 | 99,000 | 78,000 | 246,000 |
Desired ending inventory | 29,700 | 23,400 | 25,200 | 25,200 |
Total needs | 98,700 | 122,400 | 103,200 | 271,200 |
Less beginning inventory | (20,700) | (29,700) | (23,400) | (20,700) |
Purchases needed | 78,000 | 92,700 | 79,800 | 250,500 |
$20.00/lb | $20 | $20 | $20 | $20 |
Total purchase cost | $1,560,000 | $1,854,000 | $1,596,000 | $5,010,000 |
Direct Labor Budget | ||||
| July | August | September | Total |
Units to be produced | 23,000 | 33,000 | 26,000 | 82,000 |
0.60 of direct labor hours per unit | 0.60 | 0.60 | 0.60 | 0.60 |
Direct labor hours needed | 13,800 | 19,800 | 15,600 | 49,200 |
$16.00 per hour | $16.00 | $16.00 | $16.00 | $16.00 |
Total direct labor cost | $220,800 | $316,800 | $249,600 | $787,200 |
Overhead Budget | ||||
| July | August | September | Total |
Labor hours | 13,800 | 19,800 | 15,600 | 49,200 |
variable rate per hour | $3.50 | $3.50 | $3.50 | $3.50 |
Total variable OH | $48,300 | $69,300 | $54,600 | $172,200 |
Fixed overhead | $22,000 | $22,000 | $22,000 | $ 66,000 |
Total overhead | $70,300 | $91,300 | $76,600 | $238,200 |
|
| |||
Selling and Administrative Budget | ||||
| July | August | September | Total |
Variable selling expense | $108,000 | $189,000 | $135,000 | $432,000 |
Fixed expenses: |
|
|
|
|
Rent | 6,000 | 6,000 | 6,000 | 18,000 |
Utilities | 1,200 | 1,200 | 1,200 | 3,600 |
Advertising | 400 | 400 | 400 | 1,200 |
Office salaries | 35,000 | 35,000 | 35,000 | 105,000 |
Total | $150,600 | $231,600 | $177,600 | $559,800 |
Calculate the Cost of Goods that would appear on the Income Statement for the month of July?
Please round all your calculations to two decimals.
Do not include "$" or commas in your answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started