Question: Please help me out with these questions. will thumbs up if answers seem correct. Clearly separate each question neatly I would appreciate it! thanks so


Please help me out with these questions. will thumbs up if answers seem correct. Clearly separate each question neatly I would appreciate it! thanks so much
Objective Cell (Max) Name Acres Total Profit Final Value $456,600 NOT ALL INFORMATION IS RELEVANT AND SOME INFORMATION IS MISSING Variable Cells Name Acres Raspberries Acres Strawberries Final Reduced Objective Value Cost Coefficient 31 0 6800 24 0 7200 10 0 7300 Allowable Increase 233 3000 140 Allowable Decrease 2000 87.5 1E+30 Acres Tomatoes THIS CONTENT IS COPYRIGHTED Constraints Name land Resource Used Water Resource Used Fertilizer Resource Used Storage Raspberries Resource Used Storage Strawberries Resource Used Min Tomatoes requirement Resource Used Final Shadow Constraint Allowable Value Price R.H. Side Increase 65 6000 65 6.33 417 0 500 1E+30 850 80 850 130 31 50 24 50 10 -140 10 15 Allowable Decrease 10.33 83 95 10 THIS CONTENT IS COPYRIGHTED If the profit contribution per acre of tomatoes changed from $7300 to $7397, what would be the effect of this change on total contribution? That is, by how much would the optimal objective function change? if there is an increase, write the value; if there is no change, write 0; if there is a decrease write a negative value; In either case there is no need to for $ sign or decimal points. Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED The farmer is offered additional bags of fertilizer at the prices of $30 per bag. If the farmer purchases the additional 18 bags of fertilizer, what effect will this have on total profit contribution? if there is an increase, write the value; if there is no change, write 0; if there is a decrease use the minus sign to write a negative value; In either case there is No need to for $ sign or decimal points. QUESTION 3 7.5 points Save Answer Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED How much should the farmer be willing to pay for one additional unit of shipping storage for strawberries? No need to for $ sign or decimal points Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED Assume that the requirement to plant at least 10 acres of tomatoes is changed to a requirement to plant at least 21 acres of tomatoes. What effect would this change have on the total profit contribution if there is an increase, write the value; if there is no change, write 0; if there is a decrease use a minus sign to write a negative value; In either case there is No need to for $ sign or decimal points. QUESTION 5 7.5 points Save Answer Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED The farmer has an opportunity to grow and sell Red Peppers. One acre of peppers requires 5 acre-ft of water, 20 bags of fertilizer and of course 1 acre of land. What should be the minimum profit contribution per acre of peppers in order to be attractive (i.e., what is the breakeven point from 1 acre of peppers)? NO need to for $ sign or decimal points Objective Cell (Max) Name Acres Total Profit Final Value $456,600 NOT ALL INFORMATION IS RELEVANT AND SOME INFORMATION IS MISSING Variable Cells Name Acres Raspberries Acres Strawberries Final Reduced Objective Value Cost Coefficient 31 0 6800 24 0 7200 10 0 7300 Allowable Increase 233 3000 140 Allowable Decrease 2000 87.5 1E+30 Acres Tomatoes THIS CONTENT IS COPYRIGHTED Constraints Name land Resource Used Water Resource Used Fertilizer Resource Used Storage Raspberries Resource Used Storage Strawberries Resource Used Min Tomatoes requirement Resource Used Final Shadow Constraint Allowable Value Price R.H. Side Increase 65 6000 65 6.33 417 0 500 1E+30 850 80 850 130 31 50 24 50 10 -140 10 15 Allowable Decrease 10.33 83 95 10 THIS CONTENT IS COPYRIGHTED If the profit contribution per acre of tomatoes changed from $7300 to $7397, what would be the effect of this change on total contribution? That is, by how much would the optimal objective function change? if there is an increase, write the value; if there is no change, write 0; if there is a decrease write a negative value; In either case there is no need to for $ sign or decimal points. Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED The farmer is offered additional bags of fertilizer at the prices of $30 per bag. If the farmer purchases the additional 18 bags of fertilizer, what effect will this have on total profit contribution? if there is an increase, write the value; if there is no change, write 0; if there is a decrease use the minus sign to write a negative value; In either case there is No need to for $ sign or decimal points. QUESTION 3 7.5 points Save Answer Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED How much should the farmer be willing to pay for one additional unit of shipping storage for strawberries? No need to for $ sign or decimal points Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED Assume that the requirement to plant at least 10 acres of tomatoes is changed to a requirement to plant at least 21 acres of tomatoes. What effect would this change have on the total profit contribution if there is an increase, write the value; if there is no change, write 0; if there is a decrease use a minus sign to write a negative value; In either case there is No need to for $ sign or decimal points. QUESTION 5 7.5 points Save Answer Continue with the Red Farm problem (see sensitivity report in description of question 1). THIS CONTENT IS COPYRIGHTED The farmer has an opportunity to grow and sell Red Peppers. One acre of peppers requires 5 acre-ft of water, 20 bags of fertilizer and of course 1 acre of land. What should be the minimum profit contribution per acre of peppers in order to be attractive (i.e., what is the breakeven point from 1 acre of peppers)? NO need to for $ sign or decimal points