Assignment:
The Athens Vegan's Farm owns a greenhouse, which produces strawberries and squash to sell at the local Farmers market. The greenhouse can grow any combination of the two. They sell the strawberries in batches of 12 quart boxes, and the squash in 10 lbs. bushels. They have 10,000 square feet available for planting this year. Each bunch box of strawberries take about 4 square feet and each bushel of squash about 5 square feet.
Special fertilizer is required for fruit and vegetables: strawberries need 5 pounds and squash 2 pounds. The availability of the fertilizer is limited to 5000 pounds. Sales commitments require the company to grow at least 500 boxes of strawberries. Profit contributions are $6 per box and $8 per bushel of squash. If the Manage's objective is to Maximize profit, formulate the production plan as a Linear Program and solve on Excel Solver. What are the profit maximizing quantities and the optimal amount of profit?