Please help in solving the linear problom. please make it clear Problem 6:A coffee manufacturer blends four component coffee beans into three final blends ofcoffee. The table below summarises the very precise recipes for the final coffee blends,the cost and availability information for the four components, and the wholesale priceper pound of the final blends. The percentages in the body of the table indicate thepercentage of each component to be used in each blend.Component1234Wholesaleprice perpoundFinal Blend (%)212040152535152030310354015OR1.25 OR1.5 OR1.4Cost perpound (OR)0.600.800.550.70Maximumavailability eachweek (pounds)40000250002000045000wishes toWeekly capacity for the processor's plant is 100000 pounds, and the companyoperate at full capacity. There is no problem in selling the final blends, although there isa requirement that minimum production levels of 10000, 25000, and 30000 pounds,respectively, be met for blends 1, 2, and 3. Determine the number of pounds of eachcomponent, which should be used in each blend so as to maximise total weekly profit.

Answered: Image /qna-images/answer/bfe77e9c-78cb-44ae-ac9a-88a5e20a79af.jpg

A coffee manufacturer blends four component coffee beans into three final blends of coffee. The table below summarises the very precise recipes for the final coffee blends, the cost and availability information for the four components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend.

A coffee manufacturer blends four component coffee beans into three final blends of coffee. The table below summarises the very precise recipes for the final coffee blends, the cost and availability information for the four components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend.

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

Problem 3 Carrington Oil produces gas 1 and gas 2 from two types of crude oil: crude 1 and crude 2. Gas 1 is allowed to contain up to 4% impurities, and gas 2 is allowed to contain up to 3% impurities. Gas 1 sells for $72 per barrel, whereas gas 2 sells for $84 per barrel. Up to 4200 barrels of gas 1 and up to 4300 barrels of gas 2 can be sold. The cost per barrel of each crude, their availability, and the level of impurities in each crude are listed in the file. Before blending the crude oil into gas, any amount of each crude can be "purified" for a cost of $3.50 per barrel. Purification eliminates half of the impurities in the crude oil. Determine how to maximize profit. Use SolverTable to determine how an increase in the availability of crude 1 affects the optimal profit. Use SolverTable to determine how an increase in the availability of crude 2 affects the optimal profit. Use SolverTable to determine how a change in the price of gas 2 changes the optimal profit and the types of…
Problem 2 Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 100,000 pounds of grade 9 oranges and 120,000 pounds of grade 6 oranges on hand. The average quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $1.50 and incurs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.05. Each pound of oranges sold in bags yields a revenue of $1.50 and incurs a variable cost of $0.70. Determine how Sunblessed can maximize its profit. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution. Use SolverTable to determine how a change in the amount of grade 9 oranges available affects the optimal solution. Use SolverTable to determine…
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWS), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). Distribution Costs City Los Angeles Tulsa Seattle Demand (MWs) Seattle $345.25 $582.75 $48.38 939.00 Portland $338.25 $575.75 $160.13 813.25 San Francisco $162.13 $459.00 $280.88 2359.00 Boise $344.25 $463.00 $284.88 581.75 Reno $247.50 $485.00 $366.25 960.00 Bozeman $398.63 $398.63 $279.88 576.75 Laramie $374.25 $433.63 $374.25 1205.50 Park City $363.25 $363.25 $482.00 719.50 Flagstaff $187.13 $484.00 $602.75 1196.50 Durango $366.25 $306.88 $603.75 1553.75
Asap ppz Three electricity generating firms are competing in the market with the inverse demand given by P[Q) = 21-Q. All firms have constant marginal costs. Firm 1's marginal cost is MC=5; it has a capacity constraint of K1= 5 units. Firm 2's marginal cost is MC 8; it has a capacity constraint of K2 = 3 units. Firm 3's marginal cost is MC = 10; it has a capacity constraint of K3= 3 units.A. The three firms compete in the style of Cournot. Please compute the Nash equilibrium quantities. Also compute the price in the Nash equilibrium.B. Which of these firms would have produced a larger quantity if it had a larger capacity? Please explain.
A real estate company, Peterson & Johnson, discusses five potential development projects.The following table shows the estimated long-term earnings (net present value) that each project would generate and the investment required to undertake it, in millions of dollars.Company owners Dave Peterson and Ron Johnson raised $20 million in investment capital for these projects. They want to choose the mix of projects that maximizesthe total estimated long-term profit (net present value) without investing more than $20 million. a) Formulate a PEB model for this problem. b) Show the model in an Excel spreadsheet.
Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $12 $15 2 $11 $10 $12 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 575 950 800 If the Edwards production plan for the next period includes 1050 units of component 1 and 775 units of component 2, what purchases do you recommend? That is, how many units of each component should be…
Problem 10-07 (Algorithmic) Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its main power generation plants are located in Los Angeles, Tulsa, and Seattle. The following table shows Aggie Power Generation's major residential markets, the annual demand in each market (in megawatts or MWs), and the cost to supply electricity to each market from each power generation plant (prices are in $/MW). Distribution Costs City Los Angeles Tulsa Seattle Demand (MWs) Seattle $356.25 $593.75 $59.38 950.00 Portland $356.25 $593.75 $178.13 831.25 San Francisco $178.13 $475.00 $296.88 2375.00 Boise $356.25 $475.00 $296.88 593.75 Reno $237.50 $475.00 $356.25 950.00 Bozeman $415.63 $415.63 $296.88 593.75 Laramie $356.25 $415.63 $356.25 1187.50 Park City $356.25 $356.25 $475.00 712.50 Flagstaff $178.13 $475.00 $593.75 1187.50 Durango $356.25 $296.88 $593.75 1543.75 If there are no restrictions on the amount of power that…
2. Optimal solutionA company wants to hire 4 vendors for the sale of 4 products, they could only sell one type of product. The following table (image) indicates what each seller charges for selling each of the products. The company wants to assign each seller a product, find all possible optimal assignments by pinpointing their optimal cost. Indicate which is the optimal solution and the optimal value: a) Seller 1 is assigned product 2, seller 2 is assigned product 4, seller 3 is assigned product 3, and seller 4 is assigned product 1. For an optimal cost of 15 b) Seller 2 is assigned product 1, Seller 4 is assigned product 2, Seller 3 is assigned product 3, and Seller 1 is assigned product 4. For an optimal cost of 15 c) Seller 1 is assigned product 2, seller 2 is assigned product 4, seller 3 is assigned product 3, and seller 4 is assigned product 1. For an optimal cost of 14 d) None of the above
Eastern Chemicals produces two types of lubricating fluids used in industrial manufacturing. Both products cost Eastern Chemicals $1 per gallon to produce. Based on an analysis of current inventory levels and outstanding orders for the next month, Eastern Chemicals’ management specified that at least 30 gallons of product 1 and at least 20 gallons of product 2 must be produced during the next two weeks. Management also stated that an existing inventory of highly perishable raw material required in the production of both fluids must be used within the next two weeks. The current inventory of the perishable raw material is 80 pounds. Although more of this raw material can be ordered if necessary, any of the current inventory that is not used within the next two weeks will spoil—hence, the management requirement that at least 80 pounds be used in the next two weeks. Furthermore, it is known that product 1 requires 1 pound of this perishable raw material per gallon and product 2 requires 2…
Eastern Chemicals produces two types of lubricating fluids used in industrial manufacturing. Both products cost Eastern Chemicals $1 per gallon to produce. Based on an analysis of current inventory levels and outstanding orders for the next month, Eastern Chemicals’ management specified that at least 30 gallons of product 1 and at least 20 gallons of product 2 must be produced during the next two weeks. Management also stated that an existing inventory of highly perishable raw material required in the production of both fluids must be used within the next two weeks. The current inventory of the perishable raw material is 80 pounds. Although more of this raw material can be ordered if necessary, any of the current inventory that is not used within the next two weeks will spoil—hence, the management requirement that at least 80 pounds be used in the next two weeks. Furthermore, it is known that product 1 requires 1 pound of this perishable raw material per gallon and product 2 requires 2…
Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $13 $14 $15 2 $11 $12 $11 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 400 800 600 If the Edwards production plan for the next period includes 800 units of component 1 and 600 units of component 2, what purchases do you recommend? That is, how many units of each component should be…
Problem. A garment factory manufactures men's shirts and women's blouses. The production process includes cutting, sewing, and packaging. The factory employs 25 workers in the cutting department, 35 workers in the sewing department, and 5 workers in the packaging department. Each employee works an 8-hour shift per day for 5 days a week. The following table gives the time requirements and profit per unit for the two garments: Garment Shirts Cutting 20 Minutes per unit Sewing 70 Packaging 12 Profit/unit 60 Php 80.00 Php 120.00 Blouses 60 14 Determine the optimal weekly production schedule for the garment factory.