Solve this LP by Excel Solver. Attach your Excel worksheet as an Excel file $($not just a screenshot$)$ including the sensitivity report of the LP$.$

Using the sensitivity report, answer the following questions. Note: You are not allowed to re$-$solve the LP for these questions; please explain how you use the report in your answer.

What is the marginal value of a pound of pine bark? Over what range of pine bark quantity is this marginal value appropriate?

Suppose the manager is able to rent more machines and obtain more machine time, i$.$e$.,$ over $600$ minutes currently available. Do you think that obtaining additional machine time will be valuable? Why?

If profits on chips increased to $$8$ per bag, would the optimal quantities change? Would the value of the total profit at the optimal solution change? If so$,$ how large is the new profit?

What should the minimum price of mini$-$nuggets be so th