3.31 Analysis of Cost Structure: Foxx Company vs. Beyonce, Inc. Contribution Margin Fixed Cost Variable Cust Contribution Marge Fad Cost Net Operating Income Foxx Company Beyonce h Sales 0.25 08 100.000 S 400 000 600,000 Foxx Company Beyonce c Create an Easel worksheet to calculate the breakeven analysis for Foss and Begonce. Be sure to link the yellow output fields to the grees data (input fields) with cell referenceslas After eating you worksheet insert a spinner to allow incremental changes in sales from 10 to $3,000,000 in increments of $100,000 Create a data table calculating Not for both companies for sales of 100,000 Create YouTube Vides Creating a Data Table NOIS 100,000 200.000 300,000 400,000 500,000 000 000 700,000 800.000 1000 1.000.000 1,100 000 1.200.000 1300.000 300,000 1500000 1600 000 700.000 1805 000 1,900,000 2.000.000 YouTube Video-nserting a Spener YouTube Video-Creating a CVP Chan CVP Analysis USE THE VALUES BELOW IN SOLVING THE PROBL V S C Mage Ameda T heat YouTube Video ung Eros Goal Se The Changing Cafe 78 dwing ther fomes and that they 000 Multi product Breakeven Analysis YouTube Video http://youtu.be/M963 Build a worksheet to calculate the level of sales needed to earn a target profit assuming the sales mix remains Sales in units Product A 000 Product 13,000 Price: 150 200 Variable 100 Total fixed cost $400,000 TargetProfi ,000 12 Sales Mix 21 Variat Cost Contribution Margin Sales Variate Cost Cribution Maign Cat at income Caluation of unit sales NARKEGAAR " Donded try price per un Tot Produs A Product Total CM Ratio Target Prot CM Ratio Product A Product Number of units are prof Target Prut CM incume Statements Variat Cost Contribution Margin Fixed Cast Net income (TARGET PROF Total Step 4: The proof