Analyze the risk associated with the cost of ingredients
a)  Create a visualization to show how a 25% and 50% increase  in the cost of sugar would affect the price of each cupcake.  
Hint:  Often when doing analysis in excel, you need to set up a visualization where you can change a number in a "key" to see an effect elsewhere on a sheet.  This exercise gives you an opportunity to practice this skill by referencing numbers in a different cell. 

 

Transcribed Image Text:

Vanilla Cupcakes Butter Cream Frosting Total Orig. Difference Price change Key Vanilla w/price Price change shortening confec. Sugar Ingredient eggs sugar salt vanilla flour butter butter milk Price baking powder New Price vanilla salt Item change (50% increase = .5) Unit measured as dozen pounds pounds quart pounds pounds pounds pounds pounds pounds pounds gallons sugar quart S0.50 0.25 S0.75 0.0049 0.0195 Amount of unit used per 36 cupcakes 1.2375 0.0049 0.0473 sugar 0.7500 0.9923 0.0150 1.0000 0.0225 0.7500 0.6780 3.9600 $0.50 0.5 $1.00 price/unit 0,55 SO.81 Confect. S0.56 $0.81 S1.50 S0.75 S0.20 $40.00 $0.30 $3.00 S2.00 S40.00 s0.20 $2.00 $3.00 0.25 Sugar Ingredient cost per /36 cupcakes $1.13 S0.37 S1.50 $0.37 $11.02 S0.74 S0.00 S0.60 S0.06 $2.00 S0.90 S0.00 S3.21 $0.14 S0.56 0.5 $1.06 Cost /cupcake S0.31 S0.27 $0.04 Vanilla Cupcakes Butter Cream Frosting Total Orig. Difference Price change Key Vanilla w/price Price change shortening confec. Sugar Ingredient eggs sugar salt vanilla flour butter butter milk Price baking powder New Price vanilla salt Item change (50% increase = .5) Unit measured as dozen pounds pounds quart pounds pounds pounds pounds pounds pounds pounds gallons sugar quart S0.50 0.25 S0.75 0.0049 0.0195 Amount of unit used per 36 cupcakes 1.2375 0.0049 0.0473 sugar 0.7500 0.9923 0.0150 1.0000 0.0225 0.7500 0.6780 3.9600 $0.50 0.5 $1.00 price/unit 0,55 SO.81 Confect. S0.56 $0.81 S1.50 S0.75 S0.20 $40.00 $0.30 $3.00 S2.00 S40.00 s0.20 $2.00 $3.00 0.25 Sugar Ingredient cost per /36 cupcakes $1.13 S0.37 S1.50 $0.37 $11.02 S0.74 S0.00 S0.60 S0.06 $2.00 S0.90 S0.00 S3.21 $0.14 S0.56 0.5 $1.06 Cost /cupcake S0.31 S0.27 $0.04