*only 1200 to spend. Use Solver.

A C D I E F G H I Formula Bar A farmer plans to plant wheat and rye. However, TIC TAS IZJO to spend. Each acre of wheat costs $200 to plant and each acre of rye costs $100 to plant. Moreover, the farmer has to get the planting done in 12 days before it's too late. It takes one day to plant an acre of wheat and 2 days to plant an acre of rye. 3 If the profit is $500 per acre of wheat and $300 per acre of rye. How many acres of each should be planted to maximize profits? 8 9 10 11 12 Answer in English what is the objective? Answer in English what are the decision variables? Answer in English what are the constraints? Problem setup using Excel formulas (objective function, decision variables, and constraints). Solve for the optimal planting plan. 13 14 15 16 17 Objective: 18 Decision variables: 19 Constraints: maximize the profit Acres of rye to plant and acres of wheat to plant The financial constraint of $1200, and the time constraint 20 21 22 23 Wheat Rye Total 500 300 24 Objective function 25 26 Financial constraint 27 Time constraint 200 1 100 2 28 29 30