Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Glencoe Accounting Concepts Procedures Applicatons

Authors: McGraw-Hill Education

3rd Edition

0028036174, 978-0028036175

More Books

Students also viewed these Accounting questions