Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help! This spreadsheet directly links into this following one... TASK #1.1: BE POINT gh-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended,

Please help!

image text in transcribed

This spreadsheet directly links into this following one...

image text in transcribed

TASK #1.1: BE POINT gh-End Lifts, Inc. Contribution Margin Income Statement For the six-months ended, 4th year Per Unit Total Weighted Average Volume, All Units-6 months 199.70 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin 73,623.26 $ 45,592.55 28,030.71 14,702,250 9,104,637 5,597,613 100.0% 61.9% 38.1% The #s in rows 7-14 came from the CM Income statement derived in Challenge 4, Task #3. Fixed Costs ($257,872 per month) Predicted Operating Income (EBIT) 6 months 1,547,232 4,050,381 10.5% 275% Break-even point in Weighted-Average Units -FC/CM per unit Check: D16-55.2 weighted-average units Break-even point in Sales S: = FC / CM Ratio TASK #1.2 PROOF gh-End Lifts, Inc. Contribution Margin Income Statement at Break-even Point For the six-months ended, 4th year Per Unit Total Cell D7 Task #1.1 cell D16 Break-even weighted-average # of units Check D11 $1,547,232 Predicted Sales Revenue Predicted Variable Cost Predicted Contribution Margin 73,623.26 45,592.55 28,030.71 #DIV/0! #DIV/0! #DIV/0 ! Check D14 $0 Fixed Costs Predicted Operating Income (EBIT) #DIV/0! #DIV/0! 6 months

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

Students also viewed these Accounting questions