Question: 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
Get step-by-step solutions from verified subject matter experts
