Please solve the following problems using Excel functions:

You may use the following template for this assignment

S: 8-13 (High-tech production problem) Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems graphics circuit boards, CD drives, hard disk drives, 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 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 Data for Problem 8-13 INTERNAL MODEM EXTERNAL MODEM CIRCUIT BOARD CD DRIVES HARD DRIVES MEMORY BOARDS Test device 1 7 3 12 6 18 17 Test device 2 2 5 3 2 15 17 Test device 3 5 1 3 2 9 2. 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 product 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 hour for test device 1, $12 per hour for test device 2, and $18 per hour for test device 3. Quitmeyer Electronics wants to maximize its profits. a. Formulate this problem as an LP model. b. Solve the problem by computer. What is the best product mix? c. What is the value of an additional minute of time per week on test device 1? Test device 2? Test device 3? Should Quitmeyer Electronics add more test device time? If so, on which equipment? RIGHT Newspaper TV Solutions 1 LEFT Objective 925 2000 Constrains 0.04 0.051 >>= 0.03 0.03 0.4 0.6 > RIGHT SIDE Internal Modem Solutions 1 Revenue Material Costa Test device Test device 2 Test device 3 Total Profit External Circuit CD Hard Memory LEFT Modem Board Drivers Driver Boards SIDE 1 1 1 1 1 200 120 180 130 430 260 35 25 40 45 170 60 7 3 12 6 18 17 2 51 3 2 15 17 2 9 CE 120 120 100