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) how can you help the manager to formulate the LP model for the above problem (write the mathematical model) b) 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 c) Use the excel solver on the simplex method to solve the problem (show the answer report, sensitivity report and limit report)
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) how can you help the manager to formulate the LP model for the above problem (write the mathematical model)
b) 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
c) Use the excel solver on the simplex method to solve the problem (show the answer report, sensitivity report and limit report)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 7 images
