Question: Caramba - Caramel Formula Design Spreadsheet begin { tabular } { | c | c | c | c | c | c |

Caramba - Caramel Formula Design Spreadsheet \begin{tabular}{|c|c|c|c|c|c|c|c|}\hline & A & B & \(=\mathrm{A}\times \mathrm{B}\) & & & & \\\hline Process Stage \& Ingredient & Wet Wt per 100 out & \% Solids & Dry Weight & Protein & Fat & Carb & Ash \\\hline \multicolumn{8}{|l|}{Premix}\\\hline Water & 15.07 & 0.0\% & \(\cdot \) & - & - & \(\cdot \) & -\\\hline Sugar, granulated & 25.12 & 99.9\% & 25.10 & - & - & 25.10 & 0.01\\\hline Corn syrup, 42DE & 34.26 & 80.1\% & 27.44 & - & - & 27.41 & 0.03\\\hline Sweetened condensed milk & 23.60 & 73.0\% & 17.23 & 2.12 & 2.01 & 12.79 & 0.31\\\hline Vegetable fat, trans FA-free & 14.01 & 100.0\% & 14.01 & - & 14.01 & - & -\\\hline Salt & 1.07 & 100.0\% & 1.07 & - & - & - & 1.07\\\hline Veglecithin & 0.19 & 100.0\% & 0.19 & - & 0.19 & \(\cdot \) & -\\\hline Total Premix & 113.32 & 75.0\% & 85.04 & 2.12 & 16.20 & 65.30 & 1.41\\\hline \multicolumn{8}{|l|}{Evaporation}\\\hline Premix, dissolved, emulsified & 113.32 & 75.0\% & 85.04 & 2.12 & 16.20 & 65.30 & 1.41\\\hline Water evaporated & (13.32) & 0.0\% & - & - & - & - & \(\cdots \)\\\hline Caramel, cooled & 100.00 & 85.0\% & 85.04 & 2.12 & 16.20 & 65.30 & 1.41\\\hline \multicolumn{2}{|l|}{\multirow[t]{2}{*}{*Wt unit per design recipe (g, kg, or lb per bat or per hour)}} & \multicolumn{2}{|l|}{ch \% of Dry Solids} & 2.5\% & 19.1\% & 76.8\% & 1.7\%\\\hline & & \multicolumn{2}{|l|}{\% of Wet Out} & 2.1\% & 16.2\% & 65.3\% & 1.4\%\\\hline \end{tabular} Add additional columns for further compositional break out as needed Formula Modification
- Modify Caramba Caramel Formulation to achieve a \(25\%\) reduction in sugars.
- Optional ingredients to choose from: sucralose, acesulfame-K, monk fruit extract, polydextrose, inulin, maltodextrose
Caramba - Caramel Formula Design Spreadsheet \

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!