INSTRUCTIONS:

Use Solver to determine the optimal method for packing bags of different types of coffee into a box for shipment. You should only ship whole bags of coffee. Your solution should maximize profit, subject to the constraints listed in Excel.

A B C D E F G H - Name Box 1 BRAZIL BEANS 1 Number of Bags Brand (bean type) Weight (oz) Cost Sale Price Profit per Bag Total Profit Total Weight 2 per Box 14 13.5 3 Gold Ground 4 French Vanilla 5 Dark Roast 6 Peaberry Organic Espresso Roast 8 Total 13 12.5 12 $8.00 $13.00 $7.00 $11.00 $6.00 $ 10.00 $7.50 $12.00 $ 7.50 $ 12.50 7 9 10