Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show formulas, thank you in advance! I need help with the contribution margin income statement. The pictured above is the information needed go solve
Please show formulas, thank you in advance!
I need help with the contribution margin income statement. The pictured above is the information needed go solve the contribution margin income statement. Please solve the contribution margin income statement. Please provide the required formulas. Thank you!
TASK #2.2: COST BEHAVIOR Accounts Classification Sales Revenue - WA All Units Revenue High-Low (HL) Method Variable Fixed 73,623.26 $ Linear Regression (LR) Method Variable Fixed 73,623.26 0 $ - $ | $ $ $ $ 33,130 7,362 3,681 1,192 33,130 7,362 3,681 91,500 10,000 COGS - All Units Advertising Expense Sales Commissions Salaries & Wages Expense Depreciation Expense Insurance Expense Rent Expense Utilities Expense Mixed Mixed Variable Mixed Fixed Step-Fixed Fixed Mixed 91,500 10,000 - 110,510 8,240 5,757 12,000 2,000 - 544 504 128,232 8,240 5,900 12,000 2.000 74 74 TOTALS $ $ 45,943 PER WA UNIT 240,007 PER MONTH $ 45,592 PER WA UNIT 257,872 PER MONTH TASK #3: CONTRIBUTION MARGIN INCOME STATEMENT High-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended, 4th year Per Unit Total % Cell D7 = Task #1 tab cell G61 Weighted Average Volume, All Units - 6 months 199.70 $ 73,623.26 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin #DIV/0! #DIV/0! #DIV/0! Cell C9 = Task #2.2, F6 Cell C10 = Task #2.2, F17 Check: Cell C11 = $5,597,613 6 months D13 (hint: make sure you calculate 6 months of fixed costs) Fixed Costs Predicted Operating Income (EBIT) #DIV/0! #DIV/0! ! Check D14 = $4,050,381 Operating Income (EBIT) on Task #3.1 IS - Cell C21 4,050,380 27.5% Check D19 = 0.00003% error Difference % Error % Error is insignificant; highly predictive equatic TASK #2.2: COST BEHAVIOR Accounts Classification Sales Revenue - WA All Units Revenue High-Low (HL) Method Variable Fixed 73,623.26 $ Linear Regression (LR) Method Variable Fixed 73,623.26 0 $ - $ | $ $ $ $ 33,130 7,362 3,681 1,192 33,130 7,362 3,681 91,500 10,000 COGS - All Units Advertising Expense Sales Commissions Salaries & Wages Expense Depreciation Expense Insurance Expense Rent Expense Utilities Expense Mixed Mixed Variable Mixed Fixed Step-Fixed Fixed Mixed 91,500 10,000 - 110,510 8,240 5,757 12,000 2,000 - 544 504 128,232 8,240 5,900 12,000 2.000 74 74 TOTALS $ $ 45,943 PER WA UNIT 240,007 PER MONTH $ 45,592 PER WA UNIT 257,872 PER MONTH TASK #3: CONTRIBUTION MARGIN INCOME STATEMENT High-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended, 4th year Per Unit Total % Cell D7 = Task #1 tab cell G61 Weighted Average Volume, All Units - 6 months 199.70 $ 73,623.26 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin #DIV/0! #DIV/0! #DIV/0! Cell C9 = Task #2.2, F6 Cell C10 = Task #2.2, F17 Check: Cell C11 = $5,597,613 6 months D13 (hint: make sure you calculate 6 months of fixed costs) Fixed Costs Predicted Operating Income (EBIT) #DIV/0! #DIV/0! ! Check D14 = $4,050,381 Operating Income (EBIT) on Task #3.1 IS - Cell C21 4,050,380 27.5% Check D19 = 0.00003% error Difference % Error % Error is insignificant; highly predictive equatic 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