help me with parts A,B,C 2. Leego needs to decide how many and what types of edible bricks to make for this week. Theymake three kinds of edible bricks (based on their shapes): square, rectangular, and circular. Squarebricks sell for a profit of $5 per brick, rectangular bricks sell for the profit of $4 per brick, whilecircular bricks sell for a profit of $2 per brick.There are three main items required to make these edible bricks: flour, sugar, and butter. Thenumber of cups of each ingredient needed to make each kind of bricks are given in the chart below.Ingredient Square brickFlourSugarButter420.31Rectangular brick310.2Circular brick140.1Leego has a total of 50 cups of flour, 120 cups of sugar, and 4 cups of butter to use. To maximizetheir profit, the senior Operations Manager at Leego has entered the following LP into Excel.maximize 5x₁ +4x2+2x3subject to4x1 + 3x2 + 1x3 ≤ 502x1 + 1x2 + 4x3 ≤ 1200.3x1 +0.2x2 + 0.1x3 ≤ 4X1, X2, X30Solve 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 include a screenshot of theExcel sheet with the formulation, as well as the sensitivity report.b. Suppose that the profit per square brick rises to $6. Should Leego change the number ofbricks they produce?squarec. Suppose now that Leego is given an offer to buy an additional quarter cup (0.25 cups) of butterat a price of $2. Should they accept this offer? Why or why not?

Answered: Image /qna-images/answer/6cc307a0-d11e-48e2-aa77-036a2006bbaa.jpg

Leego needs to decide how many and what types of edible bricks to make for this week. They ake three kinds of edible bricks (based on their shapes): square, rectangular, and circular. Square icks sell for a profit of $5 per brick, rectangular bricks sell for the profit of $4 per brick, while cular bricks sell for a profit of $2 per brick. here are three main items required to make these edible bricks: flour, sugar, and butter. The mber of cups of each ingredient needed to make each kind of bricks are given in the chart below.

Leego needs to decide how many and what types of edible bricks to make for this week. They ake three kinds of edible bricks (based on their shapes): square, rectangular, and circular. Square icks sell for a profit of $5 per brick, rectangular bricks sell for the profit of $4 per brick, while cular bricks sell for a profit of $2 per brick. here are three main items required to make these edible bricks: flour, sugar, and butter. The mber of cups of each ingredient needed to make each kind of bricks are given in the chart below.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Which of the following is a term for physical goods that are bought and sold?
Assume you are conducting a study to determine the importance of brand names and features of mobile phone handsets. What types of questions would you use—open-ended, closed-ended, scaled?—and why? Suggest six to eight questions you would ask and in what sequence you would ask them.
How is a submittal considered part of the quality control process?
What is the objective of tracer study What is the objective of job readiness skill What is the objective of blended learning
discuss approaches the ad hoc inspection and acceptance committees may use to overcome challenges faced in fulfilling their mandate
Multiple customer service representatives come to you to relay information about a recurring customer complain regarding a product defect. What actions do you take and why?
True of false Wherever a company does must always consider that they have products that compete with its products and services
A f t e r w a t c h i n g t h e m o v i e , c a t c h m e i f y o u c a n . W h a t a r e y o u r t h o u g h t s , l e a r n i n g s , o b s e r v a t i o n s , a n d o p i n i o n s ? P l e a s e w r i t e i t i n e s s a y f o r m . A n d s u m m a r i z e s t h e s t o r y o f i t .
Write a confirmation memo to: You’ve an owner of carpentry workshop and recently you had a conversation with a potential Customer to make his living room chairs and sofas. During his visit to your workshop, you both reached an agreement about the price, types, and style and delivery date. Write a memo and send it to the customer to clarify a few of these points and to create a written record of the discussion.
legitimacy ensures cost of effectiveness. True or False
Write a proper standard regarding cutting a lime up by a bartender. You must indicate in your standard which of the parts of your standard matches each of the five parts of a proper standard: Specific, Actionable, Measurable, Accountable and Detailed. etc.
Discuss four reasons why some organizations fail to conduct needs accessment as thoroughly as they need to before the development and delivery of a training program