Analysis of Cost Structure: Foxx Company vs. Beyonce, Inc. Create an Excel worksheet to calculate the breakeven analysis for Foxx and Beyonce, Be sure to link the yellow output fields to the green data (input fields) with cell references/formulas. After creating your worksheet insert a spinner to allow incremental changes in sales from $0 to $3,000,000 in increments of $100,000. Create a data table calculating NoI for both companies for sales of $100,000 to $2,000,000. Create a CVP Analysis chart depicting the breakeven crossover point. Be sure to label your chart. YouTube Video - Creating a Data Table: http:// youtu.be/caWMWYuo-MA YouTube Video - Inserting a Spinner http:// routu.be/flwwichiRkl YouTube Video - Creating a CVP Chart htto/lvoutu be/43LP5OHtcXa CVP Analysis USE THE VALUES BELOW IN SOLVING THE PROBLEM Alameda Tie sells products to many people remodeling their homes and thinks that they coulal \begin{tabular}{lrr|} \hline & \multicolumn{2}{c|}{ Alameda Tile } \\ \cline { 2 - 3 } Tulbon & $00 \\ per student \\ Variable Cost & 480 per student \\ Fixed Cost & & 160,000 per year \end{tabular} profitably offier courses on tile installation, which might also increase the demand for their products. The bagic installation course hes the following (tentative) price and cost charecteristics: Recusired a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $80,000 tor the year? c. Agsume that the projected enrollment for the year ls 800 studentg for each of the following (considered independently): 1. What will be the oparating profit (for 900 students)? Your scenario summary should look like this! time Scenario Summary Report was created. Changing cells for each scenario are highliphted in pray. Multi-product Breakeven Analysis: Analysis of Cost Structure: Foxx Company vs. Beyonce, Inc. Create an Excel worksheet to calculate the breakeven analysis for Foxx and Beyonce, Be sure to link the yellow output fields to the green data (input fields) with cell references/formulas. After creating your worksheet insert a spinner to allow incremental changes in sales from $0 to $3,000,000 in increments of $100,000. Create a data table calculating NoI for both companies for sales of $100,000 to $2,000,000. Create a CVP Analysis chart depicting the breakeven crossover point. Be sure to label your chart. YouTube Video - Creating a Data Table: http:// youtu.be/caWMWYuo-MA YouTube Video - Inserting a Spinner http:// routu.be/flwwichiRkl YouTube Video - Creating a CVP Chart htto/lvoutu be/43LP5OHtcXa CVP Analysis USE THE VALUES BELOW IN SOLVING THE PROBLEM Alameda Tie sells products to many people remodeling their homes and thinks that they coulal \begin{tabular}{lrr|} \hline & \multicolumn{2}{c|}{ Alameda Tile } \\ \cline { 2 - 3 } Tulbon & $00 \\ per student \\ Variable Cost & 480 per student \\ Fixed Cost & & 160,000 per year \end{tabular} profitably offier courses on tile installation, which might also increase the demand for their products. The bagic installation course hes the following (tentative) price and cost charecteristics: Recusired a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $80,000 tor the year? c. Agsume that the projected enrollment for the year ls 800 studentg for each of the following (considered independently): 1. What will be the oparating profit (for 900 students)? Your scenario summary should look like this! time Scenario Summary Report was created. Changing cells for each scenario are highliphted in pray. Multi-product Breakeven Analysis
