Answered step by step
Verified Expert Solution
Question
1 Approved Answer
McKinney's Sweet Shop specializes in homemade candies and ice cream. McKinney's produces its ice cream in house, in batches of 50 pounds. The first stage
McKinney's Sweet Shop specializes in homemade candies 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-specified requirements on the percentages of certain constituents of the mix. The desired composition is as follows: Required Percentage Constituent (%) 1. Fat 16.00 2. Serum 10.00 Solids 3. Sugar 14.00 Solids 4. Egg Solids 0.35 5. Stabilizer 0.25 6. Emulsifier 0.15 7. Water 59.25 The mix can be composed of ingredients from the following list: Ingredient Cost ($/lb) 1. 40% Cream 1.17 2. 23% Cream 0.70 3. Butter 2.34 4. Plastic Cream 2.30 5. Butter Oil 2.89 6.4% Milk 0.25 7. Skim Condensed Milk 0.34 8. Skim Milk Powder 0.65 9. Liquid Sugar 0.29 10. Sugared Frozen Fresh Egg Yolk 1.75 11. Powdered Egg Yolk 4.39 12. Stabilizer 2.45 13. Emulsifier 1.66 14. Water 0.00 The number of pounds of a constituent found in a pound of an ingredient is shown below (the rows correspond to constituents 1 through 7 and the columns correspond to ingredients 1 through 14). Note that a pound of stabilizer contributes only to the stabilizer requirement (one pound), one pound of emulsifier contributes only to the emulsifier requirement (one pound), and that water contributes only to the water requirement (one pound). Ingredient Constituent 1 2 3 4 5 6 7 8 9 7 8 9 10 11 12 13 14 1 0.4 0.2 0.8 0.8 0.9 0.1 0.5 0.6 2 0.1 0.1 0.1 0.3 1 0.7 0.1 3 4 0.4 0.4 5 1 6 1 0.3 7 0.5 0.8 0.2 0.1 0.1 0.8 0.7 Click on the datafile logo to reference the data. 2 Ingredient Constituent 1 2 3 4 5 6 7 8 9 2 4 5 6 10 11 12 13 14 1 0.4 0.2 0.8 0.8 0.9 0.1 0.5 0.6 0.1 0.1 0.1 0.3 1 3 0.7 0.1 4 0.4 0.4 5 1 6 1 7 0.5 0.8 0.2 0.1 0.1 0.8 0.7 0.3 Click on the datafile logo to reference the data DATA file 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 Skim 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 Emulsifier and 25.24 pounds of water. The scale at McKinney's is only accurate to 100ths of a pound.) (a) Jack feels that perhaps it is possible 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 specified above. How does the optimal cost compare to the cost of Papa Jack's recipe? Do not round intermediate calculations. Round your answer to the nearest cent. The optimized recipe saves $ $ per 50 pounds. (b) Jack is also curious about the cost effect of being a little more flexible in the requirements. He wants to know the cheapest mix if the composition meets the following tolerances: 1. Pat 15.00-17.00% 2. Serum 9.00-11.00% Solids 3. Sugar 13.50-14.50% Solids 4. Egg Solids 0.30-0.40% 5. Stabilizer 0.20-0.30% 6. Emulsifier 0.10-0.20% 7. Water 58.00-59.50% How much cost benefit is there to being more flexible? Do not round Intermediate calculations. Round your answer to the nearest cent. The flexible recipe saves $ per 50 pounds in comparison with the optimal cost found in part (a). McKinney's Sweet Shop specializes in homemade candies 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-specified requirements on the percentages of certain constituents of the mix. The desired composition is as follows: Required Percentage Constituent (%) 1. Fat 16.00 2. Serum 10.00 Solids 3. Sugar 14.00 Solids 4. Egg Solids 0.35 5. Stabilizer 0.25 6. Emulsifier 0.15 7. Water 59.25 The mix can be composed of ingredients from the following list: Ingredient Cost ($/lb) 1. 40% Cream 1.17 2. 23% Cream 0.70 3. Butter 2.34 4. Plastic Cream 2.30 5. Butter Oil 2.89 6.4% Milk 0.25 7. Skim Condensed Milk 0.34 8. Skim Milk Powder 0.65 9. Liquid Sugar 0.29 10. Sugared Frozen Fresh Egg Yolk 1.75 11. Powdered Egg Yolk 4.39 12. Stabilizer 2.45 13. Emulsifier 1.66 14. Water 0.00 The number of pounds of a constituent found in a pound of an ingredient is shown below (the rows correspond to constituents 1 through 7 and the columns correspond to ingredients 1 through 14). Note that a pound of stabilizer contributes only to the stabilizer requirement (one pound), one pound of emulsifier contributes only to the emulsifier requirement (one pound), and that water contributes only to the water requirement (one pound). Ingredient Constituent 1 2 3 4 5 6 7 8 9 7 8 9 10 11 12 13 14 1 0.4 0.2 0.8 0.8 0.9 0.1 0.5 0.6 2 0.1 0.1 0.1 0.3 1 0.7 0.1 3 4 0.4 0.4 5 1 6 1 0.3 7 0.5 0.8 0.2 0.1 0.1 0.8 0.7 Click on the datafile logo to reference the data. 2 Ingredient Constituent 1 2 3 4 5 6 7 8 9 2 4 5 6 10 11 12 13 14 1 0.4 0.2 0.8 0.8 0.9 0.1 0.5 0.6 0.1 0.1 0.1 0.3 1 3 0.7 0.1 4 0.4 0.4 5 1 6 1 7 0.5 0.8 0.2 0.1 0.1 0.8 0.7 0.3 Click on the datafile logo to reference the data DATA file 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 Skim 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 Emulsifier and 25.24 pounds of water. The scale at McKinney's is only accurate to 100ths of a pound.) (a) Jack feels that perhaps it is possible 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 specified above. How does the optimal cost compare to the cost of Papa Jack's recipe? Do not round intermediate calculations. Round your answer to the nearest cent. The optimized recipe saves $ $ per 50 pounds. (b) Jack is also curious about the cost effect of being a little more flexible in the requirements. He wants to know the cheapest mix if the composition meets the following tolerances: 1. Pat 15.00-17.00% 2. Serum 9.00-11.00% Solids 3. Sugar 13.50-14.50% Solids 4. Egg Solids 0.30-0.40% 5. Stabilizer 0.20-0.30% 6. Emulsifier 0.10-0.20% 7. Water 58.00-59.50% How much cost benefit is there to being more flexible? Do not round Intermediate calculations. Round your answer to the nearest cent. The flexible recipe saves $ per 50 pounds in comparison with the optimal cost found in part (a)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started