Discuss the below:
Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, CD drives, hard disk drivers, and memory expansion boards. Each of these technical products requires time, in minutes, on three types of electronic testing equipment, as shown in the table shown below.
The first two test devices are available 120 hours per week. The third (device 3) requires more preventive maintenance and may be used only 100 hours each week. The market for all six computer components is vast, and Quitmeyer Electronics believes that it can sell as many units of each products as it can manufacture. The table that follows summarizes the revenues and material costs for each product:
Device Revenue per unit sold($) Material Cost per unit($)
Internal Modem 200 35
External Modem 120 25
Graphics Circuit Board 180 40
CD drive 130 45
Hard disk drive 430 170
Memory expansion board 260 60
In addition, variable labor costs are $15 per hr for test device 1, $12 per hour for test device 2 and $18 per hour for test device 3. Refer to the High Tech Excel spreadsheet . What is the objective function value for the external modem (EM) in the maximization formula?
A. $120
B. $200
C. $92.95
D. This information is not available
How many total minutes are used in the ultimate solution for test device three? Note: Hours available were converted to minutes to agree with the minutes necessary for each unit.
A. 22
B. 3724.138
C. 6000
D. 7200
How much would profit be reduced if High Tech produced one graphics circuit boardo?
A. 0
B. $21.41
C. $135.50
D. $138.64
Attachment:- Adjustable Cells.rar