Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Leego needs to decide how many and what types of edible bricks to make for this week. They make three kinds of edible bricks
2. 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. 1 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. maximize3x1+5x2+6x3subjectto3x1+3x2+2x3804x1+3x2+4x31200.1x1+0.2x2+0.3x36x12x1,x2,x30 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 number 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
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