(Solved): .. 54% Zain JO x 4G* 8:38 AM Logs_324_First_Assignment PDF - 351 KB T ing • • One excel Workboo ...

.. 54% Zain JO x 4G* 8:38 AM Logs_324_First_Assignment PDF - 351 KB T ing • • One excel Workbook file is required from each student containing t he one for each question as listed in this assignment document) Your file size should not exceed 500 KG . Your excel sheet should not include coloring • Delays will not be copied. Due date as shown on the leaming page These products have the following resource requirements: Resource Requirements Cow Unit Labor Hour Unit Check Requirements: The manufacturer has a daily production budget of $2.000 and a maximum of 660 hours of labor Maximum daily customer demand is for 200 dlocks 300 radios, and 150 toasters. Clocks sell for $15. radios for $20, and toasters for $12. The company wants to know the optimal product mix that will maximize profit Formate this problemas a linear programming model and solve it by using the Microsoft Excel Solver. 7.5 marks) Notes: (this is an individual assignment which requires one submission per student) • Keep al formulas saved to the assigned cells as appropriate • Use the same workbook (one sheet for each question to solve both questions • Keep all model decision variables, objective function and constraints documented using solver . Use the following format to save the excel file: First Name Last Name ID number Almedabadi 2020005 • Your model must be capable to run after closing the file when it is reopened . Tum in hand in the assignment through the Ms Teams application using the assignment section • One excel Workbook file is required from each wudent containing two shots one for each question as listed in this assignment document) Your file size should not exceed 500 KB • Your excel sheet should not include coloring • Delays will not be accepted. Due date as shown on the e-leaming page