Question: use excel solver to solve please 1) An ice cream shop sells single scoop ice cream cones that come in three flavors: chocolate only, vanilla


use excel solver to solve please
1) An ice cream shop sells single scoop ice cream cones that come in three flavors: chocolate only, vanilla only, and chocolate-vanilla twist. The cones are prepackaged and sold to a supermarket daily. The ingredients used along with the minimum demand of each flavor are shown as follows: Ice Cream Flavor Vanilla Chocolate-Vanilla Chocolate Ingredient: Chocolate Vanilla 0 oz. 3 oz. 4 oz. O oz. 4 oz. 2 oz. Min daily demand: 20 scoops 15 scoops 10 scoops Each day, 40 pounds of chocolate and 38 pounds of vanilla are supplied to the ice cream shop from an outside vendor. The chocolate, vanilla, and chocolate-vanilla twist each yield a profit of $2.00, $2.50, `and $3.00 per cone, respectively. How many chocolate, vanilla, and chocolate- vanilla twist cones must prepackage daily to maximize daily profits? 1) An ice cream shop sells single scoop ice cream cones that come in three flavors: chocolate only, vanilla only, and chocolate-vanilla twist. The cones are prepackaged and sold to a supermarket daily. The ingredients used along with the minimum demand of each flavor are shown as follows: Ice Cream Flavor Vanilla Chocolate-Vanilla Chocolate Ingredient: Chocolate Vanilla 0 oz. 3 oz. 4 oz. O oz. 4 oz. 2 oz. Min daily demand: 20 scoops 15 scoops 10 scoops Each day, 40 pounds of chocolate and 38 pounds of vanilla are supplied to the ice cream shop from an outside vendor. The chocolate, vanilla, and chocolate-vanilla twist each yield a profit of $2.00, $2.50, `and $3.00 per cone, respectively. How many chocolate, vanilla, and chocolate- vanilla twist cones must prepackage daily to maximize daily profitsStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
