Question 3 Consider Question 2 again. Suppose that we are given the following excel answer report. State the optimal objective value and the optimal production by analyzing the answer report. Objective Cell (Max) Cell Name $B$8 objective: profit Variable Cells Cell Name $B$6 x1: corn profit $B$7 x2: tobacco profit Original Value 0 Name Original Value 0 0 Final Value 142800 Constraints Cell $F$10 farm size $F$11 budget $F$12 govenrment restriction Optimal objective: 142800, x1: 320, x2: 90 Final Value Cell Value Integer 320 Contin 90 Contin Formula Status 410$F$10

Question 3 Consider Question 2 again. Suppose that we are given the following excel answer report: State the optimal objective value and the optimal production by analyzing the answer report The Bradley family owns 410 acres of farmland in North Carolina on which they grow corn and tobacco. Each acre of corn costs $105 to plant, cultivate, and harvest; each acre of tobacco costs $210. The Bradleys have a budget of $52,500 for next year. The government limits the number of acres of tobacco that can be planted to 100 . The profit fiom each acre of corn is $300; the profit from each acre of tobacco is $520. The Bradleys want to know how many acies of each crop to plant in order to maximize their profit