Answered You can hire a professional tutor to get the answer.
A meat packing plant produces 480 hams, 400 pork bellies, and 230 picnic hams every day; each of these products can be sold either fresh or smoked.
A meat packing plant produces 480 hams, 400 pork bellies, and 230 picnic hams every day; each of these products can be sold either fresh or smoked. The total number of hams, bellies, and picnics that can be smoked during a normal working day is 420; in addition, up to 200 products can be smoked on overtime at a higher cost. The net profits are as follows: Fresh Smoked on regular time Smoked on overtime Hams $8 $14 $11 Bellies $4 $12 $7 Picnics $4 $13 $9 For example, the following schedule yields a total net profit of $9,965: Fresh Smoked (regular time) Smoked (overtime) Hams 165 280 35 Bellies 295 70 35 Picnics 55 70 105 The objective is to find the schedule that maximizes the total net profit.
Use Excel Solver to solve this problem
