Leego needs to decide how many and what types of edible bricks to make for this...
Fantastic news! We've Found the answer you've been seeking!
Question:
![Leego needs to decide how many and what types of edible bricks to make for this week. They make three kinds](https://dsd5zvtm8ll6.cloudfront.net/questions/2023/12/6582e8e6abc2c_1703078016667.jpg)
![Leego has a total of 80 cups of flour, 120 cups of sugar, and 6 cups of butter to use. Also, they would like](https://dsd5zvtm8ll6.cloudfront.net/questions/2023/12/6582e8fa98940_1703078036963.jpg)
Transcribed Image Text:
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 <80 < 120 ≤ 6 > 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? 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 <80 < 120 ≤ 6 > 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?
Expert Answer:
Answer rating: 100% (QA)
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... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Coronado's CVP income statement included sales of 6000 units, unit selling price of $100, unit variable cost of $60, and fixed expenses of $160000. Contribution margin is
-
Assume the books and media division of Brekke Company is operated as an investment center. Actual results were as follows: Sales: $477,000 Variable costs: $198,000 Controllable Fixed costs: $93,000...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
An impure sample (0.70 g) of potassium carbonate (K2CO3) is dissolved in enough water to make 200.0 mL of solution A. A 20.00 mL aliquot of solution A is taken and put into an Erlenmeyer flask. To...
-
Because preferred stock dividends in arrears must be paid before common stock dividends, should they be considered a liability and appear on the right- hand side of the balance sheet?
-
2 Suponga que usted es el gerente de publicidad de una nueva lnea de fragancias para nios. Qu tipo de medios usara para este nuevo producto?
-
Describe the components of a retail strategy.
-
Following are descriptions of transactions and other financial events for the City of Tetris for the year ending December 2010. Not all transactions have been included here. Only the General Fund...
-
step by step please npt in Progress Rogen Corporation manufactures a single product. The standard cost per unit of product is shown below. $7.00 16.65 Direct materials-1 pound plastic at $7.00 per...
-
On January 1, 2021, the general ledger of Grand Finale Fireworks includes the following account balances: During January 2021, the following transactions occur: January 2 Issue an additional 2,000...
-
please so this question fast On December 31, 2014, Oppong Corporation showed the following (All of the shares had been issued early in 2013): Oppong Corporation Equity Section of Balance Sheet...
-
Provide the firm name and web page. Does this firm provide highly specialized skills or generic skills? What client need does this firm specialize in? Which phase in the change lifecycle does the...
-
Provide a specific prompting strategies for each number (trainer action) it may be pictorial, written, gestural, modeling, material, verbal or manual explain briefly using the hierarchy or prompting...
-
When Loreen was planning a Caribbean cruise, she decides to purchase all her souvenirs in the Bahamas because the exchange rate would be to her benefit. This means Multiple Choice the currency in the...
-
Here is a list of phobias. Match each of the phobias to one of the 15 statements following the list. Type the letter attached to each phobia you choose next to each statement. The list below contains...
-
A B C D E 1 2 3 4 5 6 7 8 9 10 Kevin, a calendar-year taxpayer, utilizes the cash method of accounting for his small business, which provides various consulting expertise to the railroad industry. At...
-
Credit risk measures using the reduced form model: assume a company has the following values for its debt issue. Face value of the firms debt: K = $1,000 Time to maturity of the debt (tenor): T t = 1...
-
What are three disadvantages of using the direct write-off method?
-
The bargaining power of both sides is affected by a number of factors. Identify the factors that affect managements and the unions bargaining power.
-
Why are newer forms of organizational structure a challenge to traditional union-employer relationships?
-
Identify common themes among the writers who discuss the origin of unions. Are these themes still applicable to unions being formed in the 21st century?
-
How does the accounting for capital leases utilized for fund-based financial statements differ from the procedures used in producing government-wide financial statements?
-
E19.6. Credit Scoring for a Firm with a Ratings Downgrade: Maytag Corporation (Medium) Maytag Corporation is the established manufacturer of washing machines, dryers, dish- washers, and other home...
-
E19.4. Z-Scoring (Easy) Below are ratios for some of the firms that have appeared in this book, for their 1998 fiscal year. Working Retained Capital Earnings Earnings before Interest and Taxes Market...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App