This is a linear programming question.

Please, solve in excel and show excel functions or steps on how to apply the functions (solver).

1. Problem One: Prats Design is a small design company that produces two lines of electronic devices, model A, and model B. After preliminary research, the marketing department expects the demand for model A to be at least 84 units per day. In contrast, the demand for model B is expected to be at least 54 units per day. In addition, due to limitations in the assembly line, the company cannot exceed 235 units for model A, and 130 for model B respectively. Because of an upcoming technology event, the company has a contractual obligation to send at least 315 units every day. If the sale of each model A yields a $77 profit, and the sale of each model B results in a $88 profit, how many units of each model should the company produce to maximize daily profits