1. LINEAR PROGRAMMING

Mrs. Bear has a home business in which she makes and sells stuffed animals from her home. She primarily makes two products dolphins and manatees. Each dolphin requires 2 square feet of material, 4 ounces of stuffing and 3 hours of labor, while each manatee requires 4 feet of material, 8 ounces of stuffing and 1 hour of labor. Mrs. Bear purchases 80 feet of material and 120 ounces of stuffing each week and allots 60 hours for her business. If she earns a profit of $5 for each dolphin and $7 for each manatee, how many of each should she make in order to maximize her profit and what is that profit?

Set up the linear programming problem in Excel and be prepared to answer questions from the output.