Profitability and Popularity Charts

Menu Product Mix Spreadsheet $-$ Complete the data for both worksheets.

Fill in all blanks using the appropriate formulas. Answer the questions below.

$\backslash$table$[[$Item$,\backslash$table$[[$Number$],[$Sold$]],\backslash$table$[[$Cost$],[$Per$],[$Item$]],\backslash$table$[[$Selling$],[$Price$],[$Per$],[$Item$]],\backslash$table$[[$Food Cost$],[$Percentage$],[($FCS $/],[$SPS$)]],\backslash$table$[[$Menu Mix$],[$Percentage$],[($#sold $/$ #total$],[$sold$)]],\backslash$table$[[$Individual$],[$Contribution$],[$Margin$],[($SPSS$-$FCS$)]],\backslash$table$[[$Total Cost$],[($# sold x$],[$FCS$)]],\backslash$table$[[$Total Sales$],[($#sold x$],[$SP$$)]]],[\backslash$table$[[$Meatloaf$],[$Sandwich$]],218,1\mathrm{.}56,6\mathrm{.}50,,,4\mathrm{.}94,,],[\backslash$table$[[$Pork Chop$],[$Sandwich$]],305,2\mathrm{.}99,6\mathrm{.}95,,,3\mathrm{.}96,,],[\backslash$table$[[$Turkey$],[$Sandwich$]],346,1\mathrm{.}56,6\mathrm{.}95,,,5\mathrm{.}39,,],[$Hamburger$,659,1\mathrm{.}88,4\mathrm{.}50,,,2\mathrm{.}62,,],[$Cheeseburger$,1376,2\mathrm{.}19,5\mathrm{.}50,,,3\mathrm{.}31,,],[$Total$,,,,,,\backslash$table$[[$Total the next$],[$two columns$]],*,*]]$

Data needed to answer the questions below: