please provide the right solution with all the excel formulas.

4. A manufacturing company makes two products. Each product can be made on either of two machines. The time in hours) required to make each product on each machine is listed in the file P10_04.xlsx. Each month, 500 hours of time are available on each machine. Each month, customers are willing to buy up to the quantities of each product at the prices also given in the same file. The company's goal is to maximize the revenue obtained from selling units during the next two months. a) Determine how the company can meet this goal. Assume that it will not produce any units in a month that it cannot sell in that month. b) Use SolverTable to see what happens if customer demands for each product in each month simultaneously change by as much as plus or minus 30%, in increments of 10%, from their current values. Revise the model so that you can use SolverTable to investigate the effect of these changes on total revenue. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does? Times (hours) needed to product each product on each machine Machine 1 Machine 2 Product 1 0.4 0.3 Product 2 0.7 0.4 Demands and prices Demands Month 1 Month 2 Product 1 1000 1900 Product 2 1400 1300 Prices Month 1 Month 2 $55 $12 $65 $32 4. A manufacturing company makes two products. Each product can be made on either of two machines. The time in hours) required to make each product on each machine is listed in the file P10_04.xlsx. Each month, 500 hours of time are available on each machine. Each month, customers are willing to buy up to the quantities of each product at the prices also given in the same file. The company's goal is to maximize the revenue obtained from selling units during the next two months. a) Determine how the company can meet this goal. Assume that it will not produce any units in a month that it cannot sell in that month. b) Use SolverTable to see what happens if customer demands for each product in each month simultaneously change by as much as plus or minus 30%, in increments of 10%, from their current values. Revise the model so that you can use SolverTable to investigate the effect of these changes on total revenue. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does? Times (hours) needed to product each product on each machine Machine 1 Machine 2 Product 1 0.4 0.3 Product 2 0.7 0.4 Demands and prices Demands Month 1 Month 2 Product 1 1000 1900 Product 2 1400 1300 Prices Month 1 Month 2 $55 $12 $65 $32