Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Leego needs to decide how many and what types of edible bricks to make for this week. They make three kinds of edible bricks
Leego needs to decide how many and what types of edible bricks to make for this week. They make three kinds of edible bricks (based on their shapes): square, rectangular, and circular. Square bricks sell for a profit of $3 per brick, rectangular bricks sell for the profit of $5 per brick, while circular bricks sell for a profit of $6 per brick. There are three main items required to make these edible bricks: flour, sugar, and butter. The number of cups of each ingredient needed to make each kind of bricks are given in the chart below. Ingredient Square brick Rectangular brick Circular brick Flour Sugar Butter 3 4 0.1 3 3 0.2 2 4 0.3 Leego has a total of 80 cups of flour, 120 cups of sugar, and 6 cups of butter to use. Also, they would like to make at least 2 square bricks. In order to maximize their profit, the senior Operations Manager at Leego has entered the following LP into Excel. 3r1 + 5x2 +6x3 maximize subject to 3r1 + 3x2+2rg 4x1 + 3x2 + 4x3 0.11 +0.22 +0.3r3 21 X1, X2, X3 2 20 Solve the above LP using Excel and answer the following questions. a. What is the optimal number of each kind of edible bricks (fractions are allowed if necessary)? What is the maximum possible profit that Leego can obtain? Please, print a copy of the Excel output. b. Suppose that the profit per square brick rises to $4. Will this change the optimal num- ber of square bricks to make? c. How much would the price of rectangular bricks have to decrease before Leego decides to reduce the number of this kind of bricks to make? d. Suppose now that Leego is given an offer to buy 1 additional cup of butter at a price of $5. Should they accept this offer? Why or why not? If the answer is yes, then what will be the new optimal amounts of the three kinds of bricks?
Step by Step Solution
★★★★★
3.41 Rating (167 Votes )
There are 3 Steps involved in it
Step: 1
Im sorry but as an AI I am not able to directly run programs or use external software like Excel However I can guide you through how to solve this Lin...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