Question 4 A firm that assembles computers and computer equipment is about to start production of two types of microcomputers. Each type will require assembly time, inspection time and storage Space The amounts of each of these resources that can be devoted to the production of the microcomputers is limited The manager of the firm would like to determine the quantity of each microcomputer to produce in order to maximize the profit generated by sales of these microcomputers In order to develop a suitable model of the problem, the manager has met with design and production personnel As a result of those meetings, the manager has obtained the following information Type 1 Type 2 GHS 60 GHS 50 Profit per unit 4 hours 10 hours Assembly time per unit 1 hour Inspection time per unit 2 hours 3 cubic fect 3 cubic feet Storage spoce per unit The manager also has acquired information on the availability of company resources. These (daily) amounts are as follows: Resource Amount Available 100 hours Assembly time 22 hours Inspection time 10 cubic feet Storage space a) As a student of AIT who has studied OR, how can you help the manager to formulate the LP model for the above problem (write the mathematical model) b) Use the excel solver on the simplex method to solve the problem (show the answer report, sensitivity report and limit report) c) If the profit on Type I computers increased from GHS 60 per unit to GHS 65 per unit what will be the elect on the optimal solution