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

What is the purpose of the SCOR Model and what are the five basic functions of the SCOR Model?
How Tyler should plan on ordering the flour for his bakery. Based on the attached: How much should Tyler plan on ordering the flour for his bakery? When should Tyler order the flour for his bakery
If Martha were to add recycling containers inside her store for her customers, this would Multiple Choice probably end up costing her more money and time but could result in less satisfied customers and harm her profitability. probably end up costing her more money and time but could result in more satisfied customers and future profitability. infuriate customers and investors. probably cost less money, but result in more satisfied customers. probably be a waste of time and money since her responsibility is not to become a recycling center.
LPM Corp. produces and sells two types of frozen burgers, Turkey Burgers and Veggie Burgers. In the most recent month, the firm sold 12,000 Turkey Burgers and 8,000 Veggie Burgers. Turkey Burgers sold for $14.00 per box and variable costs were $7.40 per box. The Veggie Burgers sold for $16.00 per box and variable costs were $8.25 per box. The fixed expenses of the entire company were $41,160. If the sales mix were to shift toward the Turkey Burgers product line with total sales volume remaining constant at 20,000, the overall break-even point for the entire company:
You're moving to California! There are just no jobs in Nebraska, and it just makes sense that you move to California where jobs are plentiful. You have an old car, 2 suitcases, and just enough money to pay for gas for the 4 day trip. You have room for yourself, 5 additional passengers and 5 more suitcases in the car. Choose your passengers from the list given, but make sure you can justify your decisions based on human wants, needs, values, interests, and values.
Efua Babyson (not a real name) completed Fashion Design Programme at a Technical University in Takoradi. Efua decided to join a dress-making group to gain experience for her career. In the course of her internship, Efua has observed that there are always a lot of beautiful pieces of leftover clothes that go waste thereby requiring the shop to spend money to dispose them. She is then thinking of designing fashioned carrier bags with the leftover clothes. Efua needs ideas on what factors to consider in decide to go or not go for the development of the conceived business idea. (a) Discuss four key things to consider in deciding to pursue or not the conceived business idea?
Can you help me with these three review questions A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
Our Kapeng Barako is well-known in Batangas. This product's packaging is made of glass, aluminum,and other plastics. Make a list of the advantages and disadvantages of employing each of these threematerial types for the production of these packaging materials for Kapeng Barako, including cost,recyclability, energy consumption, fuel consumption, and forming processes.
A dietitian has been asked by the athletic director to develop a snack that athletes can use in their training programs. The dietitian intends to mix two seperate products to make the snack. The following information (on the table below): Product A costs Php20 per ounce, while Product B costs Php10 per ounce. Determine the optimal quantities of each product that will give the minimized cost.
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
Radiant wants to hire Cargo planes for transporting their goods. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes. In addition, they provided the following cost related information about the two types Cargo planes- WT88 and BH54: Personnel Cost Fuel Cost Maintenance Cost WT88 2000 1000 2000 BH54 2500 1500 1000 Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming: What is the maximum amount Radiant can carry given their budget constraint? Can you solve using solver ? (I did this but I got a wrong answer) Data Personnel Cost Fuel Cost Maintenance Cost Tons WT88 2000 1000 2000 55…
Bimala is interested in buying a new house and has found a house she likes in Surry Hills. Bimala comes to you for advice about which of the following items would pass to her automatically if she buys the house: • A plastic bird bath which rest on the ground in the back garden; • A concrete swimming pool in the back garden; • A tapestry attached by small tapestry nails to the wall of the living room; and • A barbecue on wheels on the back deck. Advise Bimala. In your advice, please ensure that you refer to relevant case law. *NOTE: This is business law question. can you write more details about the question and answer.