please use excel.
Date Assigned: Tuesday, June 30, 2020 Date Due: Wednesday, July 01, 2020 before class. No late homework will be accepted. Homework 19 Please notice that all work must be shown in a professional way with attention to detail No credit will be given for incomplete or disorderly work Please use a cover sheet stating your name, course number, date due, and homework number Unstapled homework will not be collected as this is part of the assignment All work must be individual with emphasis on numerical accuracy This is an Excel based assignment that must be submitted following the stated guidelines Please notice that late homework (after collected by the instructor) will incur into a 25% late fee 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? 2. Problem Two: Fiterman Furniture is a small company that produces two lines of smart desks, model A, and model B. After preliminary research, the marketing department expects the demand for model A to be at least 100 units per day. In contrast, the demand for model B is expected to be at least 39 units per day. In addition, due to limitations in the assembly line, the company cannot exceed 415 units for model A, and 295 for model B respectively. Because of an upcoming technology event, the company has a contractual obligation to send at least 350 units every day. If the sale of each model A yields a $254 profit, and the sale of each model Bresults in a $425 profit, how many units of each model should the company produce to maximize daily profits