Answered step by step
Verified Expert Solution
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!
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, 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
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