Question: Please help, the DATAFILE screenshot is given as well. Thank you SO much in advance! Please DO NOT COPY & PASTE ANSWER -- if you
Please help, the DATAFILE screenshot is given as well. Thank you SO much in advance!
Please DO NOT COPY & PASTE ANSWER -- if you do I will downvote your answer.



McKInney's Sweet Shop speciallzes in homemade candles and ice cream. McKinney's produces its ice cream in house, in batches of 50 pounds. The first stage in ice cream making is the blending of ingredients to obtain a mix, which meets pre-spedfled requirements on the percentages of certain constituents of the mix. The desired composition is as follows: The mix can be composed of ingredients from the following llst: The number of pounds of a constituent found in a pound of an ingredlent is shown below (the rows correspond to constituents 1 through 7 and the columns correspond to ingredlents 1 through 14). Note that a pound of stabilizer contributes only to the stabilizer requirement (one pound), one pound of emulsifler contributes only to the emulsifler requirement (one pound), and that water contributes only to the water requirement (one pound). CII Jack MckInney Jr. has recently acquired the shop from his father (Papa Jack). Jack's father has in the past used the following mixture: 9.73 pounds of Plastic Cream, 3.03 pounds of Sklm Milk Powder, 11.37 pounds of Liquid Sugar, 0.44 pounds of Sugared Frozen Fresh Egg Yolk, 0.12 pounds of Stabilizer, 0.07 pounds of Emulsifler and 25.24 pounds of water. (The scale at McKInney's is only accurate to 100 ths of a pound.) (a) Jack feels that perhaps it is posslble to produce the ice cream in a more cost-effective manner. He would like to find the cheapest mix for producing a batch of ice cream, which meets the requirements specifled above. How does the optimal cost compare to the cost of Papa Jack's reclpe? Do not round intermedlate calculations. Round your answer to the nearest cent. The optimized reclpe saves I per 50 pounds. (b) Jack is also curlous about the cost effect of being a llttle more flexlble in the requirements. He wants to know the cheapest mlx if the composition meets the following tolerances: How much cost benefit is there to being more flexible? Do not round intermedlate calculations. Round your answer to the nearest cent. The flexible recipe saves 4 per 50 pounds in comparison with the optimal cost found in part (a)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
