c) Thought question: How do you assess the overall risk in the rise in prices of ingredients to Alpine Cupcakes future? As in question 2, assume all sales of cupcakes remained the same, and the sales price ($2.40 per cupcake) remains the same. Use the number of cupcakes sold in 2022.

A good place to start is to look back at your answer to the cost per cupcake. Are there any ingredients that appear frequently, that have a high price?

Transcribed Image Text:

Analyze the risk associated with the cost of ingredients Using the data provided, determine the cost of each type of cupcake Presentation matters when showing the results of data analytics, because you are trying to take many numbers and present them in a way that someone unfamiliar with your computations can quickly understand your results. An example of one type of presentation for the cost of cupcakes is shown below. You can use this example as a template, or come up with a better way to present your work. If you click on the yellow cells below, you can see the formulas used in this particular visualization. It can also serve as a check to ensure that you are arriving at the correct cost when you create your cost analysis. Hint: There are many ways to set up a visualization, pick a way that makes sense for you. You can copy and paste the recipes or make reference in the cells below to the original numbers on the data pages. Vanilla Vanilla Cupcakes Ingredient Unit measured as Amount of unit used per 36 cupcakes price/unit Ingredient cost per /36 cupcakes Cost/cupcake eggs sugar salt dozen pounds pounds 0.7500 0.9923 0.0049 $1.50 $0.50 $0.20 $1.12500 $0.49613 $0.00098 baking vanilla flour powder quart pounds pounds 0.0150 1.2375 0.0195 $40.00 $0.30 $3.00 $0.60000 $0.37125 $0.05850 salt milk Butter Cream Frosting confec. shortening Sugar pounds pounds pounds gallons 0.6780 3.9600 0.0049 0.0473 0.55 $0.56 $0.20 $3.00 $0.37290 $2.21760 $0.00098 $0.14175 $9.78508 $0.270 Total butter vanilla butter pounds quart pounds 1.0000 0.0225 0.7500 $2.00 $40.00 $2.00 $2.00000 $0.90000 $1.50000 Analyze the risk associated with the cost of ingredients Using the data provided, determine the cost of each type of cupcake Presentation matters when showing the results of data analytics, because you are trying to take many numbers and present them in a way that someone unfamiliar with your computations can quickly understand your results. An example of one type of presentation for the cost of cupcakes is shown below. You can use this example as a template, or come up with a better way to present your work. If you click on the yellow cells below, you can see the formulas used in this particular visualization. It can also serve as a check to ensure that you are arriving at the correct cost when you create your cost analysis. Hint: There are many ways to set up a visualization, pick a way that makes sense for you. You can copy and paste the recipes or make reference in the cells below to the original numbers on the data pages. Vanilla Vanilla Cupcakes Ingredient Unit measured as Amount of unit used per 36 cupcakes price/unit Ingredient cost per /36 cupcakes Cost/cupcake eggs sugar salt dozen pounds pounds 0.7500 0.9923 0.0049 $1.50 $0.50 $0.20 $1.12500 $0.49613 $0.00098 baking vanilla flour powder quart pounds pounds 0.0150 1.2375 0.0195 $40.00 $0.30 $3.00 $0.60000 $0.37125 $0.05850 salt milk Butter Cream Frosting confec. shortening Sugar pounds pounds pounds gallons 0.6780 3.9600 0.0049 0.0473 0.55 $0.56 $0.20 $3.00 $0.37290 $2.21760 $0.00098 $0.14175 $9.78508 $0.270 Total butter vanilla butter pounds quart pounds 1.0000 0.0225 0.7500 $2.00 $40.00 $2.00 $2.00000 $0.90000 $1.50000

Answer rating: 100% (QA)

answer Determination of cost of each type of Cupcake per unit Particulars Source ... View the full answer