Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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
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
icon
Related questions
Question

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. They make three kinds of edible bricks (based on their shapes): square, rectangular, and circular. Square bricks sell for a profit of $5 per brick, rectangular bricks sell for the profit of $4 per brick, while circular bricks sell for a profit of $2 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 Flour Sugar Butter 4 2 0.3 1 Rectangular brick 3 1 0.2 Circular brick 1 4 0.1 Leego has a total of 50 cups of flour, 120 cups of sugar, and 4 cups of butter to use. To maximize their profit, the senior Operations Manager at Leego has entered the following LP into Excel. maximize 5x₁ +4x2+2x3 subject to 4x1 + 3x2 + 1x3 ≤ 50 2x1 + 1x2 + 4x3 ≤ 120 0.3x1 +0.2x2 + 0.1x3 ≤ 4 X1, 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 include a screenshot of the Excel 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 of bricks they produce? square c. Suppose now that Leego is given an offer to buy an additional quarter cup (0.25 cups) of butter at a price of $2. Should they accept this offer? Why or why not?
Transcribed Image Text: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 $5 per brick, rectangular bricks sell for the profit of $4 per brick, while circular bricks sell for a profit of $2 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 Flour Sugar Butter 4 2 0.3 1 Rectangular brick 3 1 0.2 Circular brick 1 4 0.1 Leego has a total of 50 cups of flour, 120 cups of sugar, and 4 cups of butter to use. To maximize their profit, the senior Operations Manager at Leego has entered the following LP into Excel. maximize 5x₁ +4x2+2x3 subject to 4x1 + 3x2 + 1x3 ≤ 50 2x1 + 1x2 + 4x3 ≤ 120 0.3x1 +0.2x2 + 0.1x3 ≤ 4 X1, 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 include a screenshot of the Excel 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 of bricks they produce? square c. Suppose now that Leego is given an offer to buy an additional quarter cup (0.25 cups) of butter at a price of $2. Should they accept this offer? Why or why not?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 10 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS