$25 520 Question 3 (35 points AppleSmash crushes three (3) types of apples to make applesauce that is "never too bitter, yet tart and sweet as can be Operations processes 1000 or more barrels of apples each month by crushing and blending three (3) types of apples Cortland, Macs, and Jazz The Operating and Apple costs plus Flavor Content for each type of apple per barrel are shown in the table below: Flavor Content (unes barrel) Apole Type Operating Cast (barrel) Cost of Apples (S/barrel Bremness Tartness Sweetness Cortland $25 20 10 15 Macs $20 25 15 20 Jazz $25 $15 15 20 25 Marketing limits the Flavor Content of processed barrels to less than 24,000 for Bitterness, at least 15,000 for Tartness, and at least 20,000 for Sweetness Manufacturing must have only 200 barrels of Jazz apples available at the start of each month. The following LP Blending formulation was used to determine the mix of apple types to process in order to optimize Total Cost B D E F G Cortland Macs Jazz 2 Apples (Barrels 900 100 3 Operating Cost (Barrel) $25 $20 1525 4 Cost of Apples (S/Bartel) 525 520 S15 5 Total Cost = Operating plus Apple Cost 550 540 540 540.000 6 7 Constraints LHS RHS 8 Maximum Jazz (barrels) 0 D 1 100 200 9. Maximum Butterness Flavor 20 25 15 24,000 24 000 10 Minimum Tartness Flavor 10 15 20 15 500 15,000 11. Minimum swango Flav 15 20 25 20.500 20,000 12 Minimum Annies (barrels 1 1 1 1000 1.000 a. What Excel formula is in cell B5 to do a Fill Right to D5 to calculate the Total Cost for each type? BS = b. What inequalities (le, soc') were typed into cells F8 through F127 F8 59 F10 FIL F12: What Excel formula was put into cell ES the Total Cost to optimize? ES d How should the following Solver window be filled out: di Solver Parameters" Window Set Objective To: By Changing Variable Cells 0.2 "Subject to the Constraints (wiite Excel command(s) below) e How many barrels of Jazz apples are left over at the end of each month? (Show all work)