please answer all clearly

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 Profit per unit GHS 60 GHS 50 Assembly time per unit 4 hours 10 hours Inspection time per unit 2 hours 1 hour Storage space per unit 3 cubic feet 3 cubic feet The manager also has acquired information on the availability of company resources. These (daily) amounts are as follows: Resource Amount Available Assembly time 100 hours Inspection time 22 hours Storage space 39 cubic feet 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 1 computers increased from GHS 60 per unit to GHS 65 per unit what will be the effect on the optimal solution