Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Table 1: Planned Income Statement Table 2 Flexible Income Statement Table 3: Actual Income Statement for Previous Fiscal Year Revenues - Advanced (Projected Sales =
Table 1: Planned Income Statement | Table 2 Flexible Income Statement | Table 3: Actual Income Statement for Previous Fiscal Year | |||||
Revenues - Advanced (Projected Sales = 310,000 units) | $53,940,000 | Revenues - Advanced (Projected Sales = 360,000 units) | $62,640,000 | Revenues - Advanced (Actual Sales = 360,000 units) | $60,840,000 | ||
COGS - Advanced | COGS - Advanced | COGS - Advanced | |||||
Direct Materials | $18,104,000 | Direct Materials | $21,024,000 | Direct Materialsa | $21,978,000 | ||
Direct Labor | $17,670,000 | Direct Labor | $20,520,000 | Direct Laborb | $20,880,000 | ||
Budgeted MOH | $12,845,625 | Budgeted MOH | $14,917,500 | Actual MOHc | $17,100,000 | ||
Gross Margin - Advanced | $5,320,375 | Gross Margin - Advanced | $6,178,500 | Gross Margin - Advanced | $882,000 | ||
Revenues - Basic (Actual Sales = 210,000 units) | $30,240,000 | ||||||
Revenues - Basic (Projected Sales = 360,000 units) | $48,240,000 | Revenues - Basic (Projected Sales = 210,000 units) | $28,140,000 | COGS - Basic | |||
COGS - Basic | COGS - Basic | Direct Materialsa | $7,654,500 | ||||
Direct Materials | $12,132,000 | Direct Materials | $7,077,000 | Direct Laborb | $12,240,900 | ||
Direct Labor | $20,520,000 | Direct Labor | $11,970,000 | Actual MOHc | $6,300,000 | ||
Budgeted MOH | $8,775,000 | Budgeted MOH | $8,701,875 | Gross Margin - Basic | $4,044,600 | ||
Gross Margin - Basic | $6,813,000 | Gross Margin - Basic | $391,125 | ||||
Total Gross Margin | $4,926,600 | ||||||
Total Gross Margin | $12,133,375 | Total Gross Margin | $6,569,625 | ||||
Selling Costs | |||||||
Commissions (2 percent of revenues) | $1,821,600 | ||||||
Selling Costs | Selling Costs | Salesperson Salaries | $430,000 | ||||
Commissions (2 percent of revenues) | $2,043,600 | Commissions (2 percent of revenues) | $1,815,600 | Fixed Administrative Costs | $1,655,000 | ||
Salaries | $460,000 | Salaries | $460,000 | Interest | $650,000 | ||
Fixed Administrative Costs | $1,800,000 | Fixed Administrative Costs | $1,800,000 | ||||
Interest | $550,000 | Interest | $550,000 | Pre-Tax Income (Loss) | $370,000 | ||
Pre-Tax Income | $7,279,775 | Pre-Tax Income | $1,944,025 |
Calculate the variance using the information provided above.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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