Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 1 H&S desserts supplies its ice cream shops with three flavors of ice cream: chocolate, vanilla, and banana. In addition to the specific flavors,
QUESTION 1 H&S desserts supplies its ice cream shops with three flavors of ice cream: chocolate, vanilla, and banana. In addition to the specific flavors, the main ingredients in the ice creams are milk, sugar, and cream. Due to extreme hot weather and a high demand for its products, the company has run short of its supply of ingredients and will not be able to fill all the orders received from the ice cream stores. The chocolate, vanilla, and banana flavors generate AED 20, 18, and 16 of profit for each gallon sold, respectively. Below is a screenshot of the spreadsheet model that was used to determine how many gallons of ice cream should the company produce of each flavor in order to maximize the total profit, along with its corresponding sensitivity report. Chocolate Vanilla Banana Unit Proft (AED) 20 18 16 Requirements / Gallon of Ice Cream Used Available Milk 0.45 0.5 0.4 187.5 200 Sugar 0.5 0.4 0.4 150 =100 b) The new constraint may be algebraically represented as 0.2 C + 0.2 V + 0.2 B
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