Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Small Business Management Launching & Growing Entrepreneurial Ventures

Authors: Justin Longenecker, William Petty, Leslie Palich, Frank Hoy

17th edition

9781285972565, 1133947751, 1285972562, 978-1133947752

More Books

Students also viewed these General Management questions

Question

Compare and Contrast file Systems with database systems?

Answered: 1 week ago

Question

Define Data Abstraction and dinsuun levels of Abstraction?

Answered: 1 week ago