The Sun food co. produces three canned fruit products. The mail ingredients in each product are...

The Sun food co. produces three canned fruit products. The mail ingredients in each product
are pears and peaches. Each product is produced in lots and must go through three processes -
mixing, canning, and packaging. The resource requirements for each product and each process
are shown in the following LP formulation.

Maximize Z = 10 x1 + 6 x2 + 8 x3 (profit, $)
subject to
	20 x1 + 10 x2 + 16 x3 <= 320 (pears, lbs)
	10 x1 + 20 x2 + 16 x3 <= 400 (peaches, lbs)
	x1 + 2 x2 + 2 x3 <= 43 (mixing, hr)
	x1 + x2 + x3 <= 60 (canning, hr)
	2 x1 + x2 + x3 <= 40 (packaging, hr)
	x1, x2, x3 >= 0 (non-negativity conditions)

A)	What is the maximum price the company would be willing to pay for additional pears?
	How much could be purchased at that price?
B)	What is the marginal value of peaches? Over what range is this price valid?
C)	The company can purchase a new mixing machine that would increase the available
	mixing time from 40 to 60 hours. Would this affect the optimal solution?
D)	The company can also purchase a new packaging machine that would increase the available
	packaging time from 40 to 50 hours. Would you recommend this? Explain.
E)	If the manager were to attempt to secure additional units of only one of the resources,
	which should it be and why?

Solutions

Expert Solution

Solution using Solver is as follows

Formula:

E2 =SUMPRODUCT(B2:D2,$B$9:$D$9) copy to E2:E7

Sensitivity report is as under

A) Refer sensitivity report, Shadow price of pear constraint is 0.467. Therefore, Maximum price the company would be willing to pay for additional pears is 0.467

Allowable increase is 80 . So a maximum of 80 should be purchased at that price.

B) Marginal value of peaches is 0.067 (shadow price of peaches constraint)

It is valid over range of 400-240 = 160 to 400+30 = 430 (refer allowable increase and decrease in sensitivity report)

D) No, There is already unutilized capacity availableon mixing machine. Therefore, it is not beneficial to purchase new machine.

Also refer sensitivity report, shadow price of mixing is 0, which means it will not increase the profit.

D) No, There is already unutilized capacity available on packaging machine. Therefore, it is not beneficial to purchase new packaging machine.

Also refer sensitivity report, shadow price of packaging is 0, which means it will not increase the profit.

keosha answered 1 week ago

Next > < Previous

Related Solutions

A manufacturer produces lots of a canned food product. Let p denote the proportion of the...

A manufacturer produces lots of a canned food product. Let p denote the proportion of the lots that do not meet the product quality specifications. An n = 29, c = 0 acceptance sampling plan will be used. (a) Compute points on the operating characteristic curve when p = 0.01, 0.03, 0.10, and 0.20. (Round your answers to four decimal places.) c p = 0.01 p = 0.03 p = 0.10 p = 0.20 0 (c) What is the probability...

A manufacturer produces lots of a canned food product. Let p denote the proportion of the...

A manufacturer produces lots of a canned food product. Let p denote the proportion of the lots that do not meet the product quality specifications. An n = 25, c = 0 acceptance sampling plan will be used. (a) Compute points on the operating characteristic curve when p = 0.01, 0.03, 0.10, and 0.20. (Round your answers to four decimal places.) c p = 0.01 p = 0.03 p = 0.10 p = 0.20 0 What is the probability that...

Lafayette Co. produces three products out of a common process; Product L, Product M, and Product...

Lafayette Co. produces three products out of a common process; Product L, Product M, and Product N. The company currently uses the physical measures method to allocate joint costs to these products. The following additional information is available: Product LinePhysical VolumeUnit Selling Price Product L10,000 units$79.20 Product M12,000 units$36.00 Product N18,000 units$20.00 Joint costs to produce the products are $950,000. The manager of the Product N product line is particularly disgruntled. He believes that his product line is allocated a...

MC Qu. 45 Garrison Co. produces three products ... Garrison Co. produces three products — X,...

MC Qu. 45 Garrison Co. produces three products ... Garrison Co. produces three products — X, Y, and Z — from a joint process. Each product may be sold at the split-off point or processed further. Additional processing requires no special facilities, and production costs of further processing are entirely variable and traceable to the products involved. Last year all three products were processed beyond split-off. Joint production costs for the year were $120,000. Sales values and costs needed to...

FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables....

FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.34 per pound) 50 pounds 90 pounds Corrugating medium ($0.17 per pound) 40 pounds 50 pounds Direct labor required per 100 boxes ($14.00 per hour) 0.35 hour 0.70 hour The following production-overhead...

FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables.

FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.28 per pound) 50 pounds 90 pounds Corrugating medium ($0.14 per pound) 40...

Dalton Inc. produces and sells three products. Unit data concerning each product is shown below. Product...

Dalton Inc. produces and sells three products. Unit data concerning each product is shown below. Product D E F Selling price $181.00 $283.20 $233.00 Direct labor costs 28.60 83.60 34.10 Other variable costs 90.00 78.00 140.00 The company has 1,900 hours of labor available to build inventory in anticipation of the company’s peak season. Management is trying to decide which product should be produced. The direct labor hourly rate is $11. Product Direct Labor Cost Per unit Direct Labor Hours...

Dalton Inc. produces and sells three products. Unit data concerning each product is shown below. Product...

Dalton Inc. produces and sells three products. Unit data concerning each product is shown below. Product D E F Selling price $ 190.6 $ 297.5 $ 246.4 Direct labor costs 28.6 84.7 34.1 Other variable costs 97 78 141 The company has 2,200 hours of labor available to build inventory in anticipation of the company’s peak season. Management is trying to decide which product should be produced. The direct labor hourly rate is $ 11 . A) Number of direct...

Required information FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit,...

Required information FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.28 per pound) 25 pounds 65 pounds Corrugating medium ($0.14 per pound) 15 pounds 25 pounds Direct labor required per 100 boxes ($15.00 per hour) 0.40 hour 0.80 hour The...

Glavine & Co. produces a single product, each unit of which requires three direct labor hours...

Glavine & Co. produces a single product, each unit of which requires three direct labor hours (DLHs). Practical capacity (for setting the factory overhead application rate) is 60,000 DLHs, on an annual basis. The information below pertains to the most recent year: Standard direct labor hours (DLHs) per unit produced 3.00 Practical capacity, in DLHs (per year) 60,000 Variable overhead efficiency variance $ 20,000 unfavorable (U) Actual production for the year 17,000 units Budgeted fixed manufacturing overhead $ 1,200,000 Standard...

Subjects