Question: 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!

Please help! This spreadsheet directly links into this following one... TASK #1.1:

This spreadsheet directly links into this following one...

BE POINT gh-End Lifts, Inc. Contribution Margin Income Statement For the six-months

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f