Develop a spreadsheet model that maximizes the total profit and conduct a sensitivity analysis to find if the daily operating hours increased to 12 hours, how would that affect the optimal production plan and total profit?

If the profit margin for product 1 were to increase or decrease, how would the optimal production plan and total profit be affected? Similarly, what if the profit margin for product 2 changed?

A company that operates 10 hours a day manufactures two products on three sequential processes. The following table summarizes the data of the