(1) Start on the left with the given inputs in the orange colored D-column cells. Write them down on paper as reference. Fixed costs do not change, Now, vary the annual forecasted sales volume from 0 to 10,000 for each item, one at a time, keeping the other two items constant. (2) Complete (manually) the DATA table on the right by bringing your result in cell 0 - 13 into the table, varying item 1 annual sales volume by 1000 units each time, keeping items 2 and 3 constant. (3) Repeat this entire process for item 2 and then item 3. (4) Drawa scattergram plot (see "Charts" option under "insert" on this fxcel sheet) tor each of the three items, using the completed column for each item in the data table. Connects the data points with a line. (5) Answer the sensitivity analysis question at the bottom of the spreadsheet. Chart Title point ( $5) lumn A 76/64.71 (-fixed cost/total weighted contribution) Chart Title X-axis=Numberofsandwichunitsforecastedoriginallyconstant)(keepingtheotheritems,drinkandpotato,as Home insert Pagelayout formulas Data Revies Vien Help x-asis=Numberofsandwichunits(keepingtheotheritems,drinkandpotato,asoriginallyconstant) Drink Chart Title Y-axis = breakeven point (\$) values (from column x ) X-axis * Number of drink (all other units for sandwich and potato kept as units forecasted originally constant) Potato Chart Title Y-axis = breakeven point (5). values (from column I) (1) Start on the left with the given inputs in the orange colored D-column cells. Write them down on paper as reference. Fixed costs do not change, Now, vary the annual forecasted sales volume from 0 to 10,000 for each item, one at a time, keeping the other two items constant. (2) Complete (manually) the DATA table on the right by bringing your result in cell 0 - 13 into the table, varying item 1 annual sales volume by 1000 units each time, keeping items 2 and 3 constant. (3) Repeat this entire process for item 2 and then item 3. (4) Drawa scattergram plot (see "Charts" option under "insert" on this fxcel sheet) tor each of the three items, using the completed column for each item in the data table. Connects the data points with a line. (5) Answer the sensitivity analysis question at the bottom of the spreadsheet. Chart Title point ( $5) lumn A 76/64.71 (-fixed cost/total weighted contribution) Chart Title X-axis=Numberofsandwichunitsforecastedoriginallyconstant)(keepingtheotheritems,drinkandpotato,as Home insert Pagelayout formulas Data Revies Vien Help x-asis=Numberofsandwichunits(keepingtheotheritems,drinkandpotato,asoriginallyconstant) Drink Chart Title Y-axis = breakeven point (\$) values (from column x ) X-axis * Number of drink (all other units for sandwich and potato kept as units forecasted originally constant) Potato Chart Title Y-axis = breakeven point (5). values (from column I)
