Problems 8-5, 8-13, 8-19, and 8-23 Assignment Outcomes Discover how simplex methods are effective for management control. Discuss why modeling is an effective method 8-5 The Kleenglass Corporation...

1 answer below »
4 problems with subset


Problems 8-5, 8-13, 8-19, and 8-23 Assignment Outcomes Discover how simplex methods are effective for management control. Discuss why modeling is an effective method 8-5 The Kleenglass Corporation makes a dishwasher that has excellent cleaning power. This dishwasher uses less water than most competitors, and it is extremely quiet. Orders have been received from several retails stores for delivery at the end of each of the next 3 months, as shown below: Month Number of Units June 195 July 215 August 205 Due to limited capacity, only 200 of these can be made each month on regular time, and the cost is $300 each. However, an extra 15 units per month can be produced if overtime is used, but the cost goes up to $325 each. Also, if there are any dishwashers produced in a month that are not sold in that month, there is a $20 cost to carry this item to the next month. Use linear programming to determine how many units to produce in each month on regular time and on overtime to minimize the total cost while meeting the demands 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 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 drive130 45 Hard disk drive430 170 Memory expansion260 60 board 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? Data for Problem 8-13 InternalModem ExternalModem CircuitBoard CD Drives HardDrives MemoryBoards Test device 1 7 3 126 18 17 Test device 225 3 2 15 17 Test device 3 51 32 9 2
Answered Same DayApr 10, 2021

Answer To: Problems 8-5, 8-13, 8-19, and 8-23 Assignment Outcomes Discover how simplex methods are effective...

Pooja answered on Apr 12 2021
137 Votes
8.5
    Variables
            X1 = Amount Produced in June
            X2 = Amount produced in June from overtime
            X3 = Amount placed into end of June Inventory (start of July)
            X4 = Amount Produced in July
            X5 = Amount prod
uced in July from overtime
            X6 = Amount placed into end of July Inventory (start of August)
            X7 = Amount Produced in August
            X8 = Amount produced in August from overtime
            X9 = Amount placed into end of August Inventory (start of September)
    Decision Variables
            X1    X2    X3    X4    X5    X6    X7    X8    X9
            200    0    5    200    10    0    200    5    0
    Objective Function
            X1    X2    X3    X4    X5    X6    X7    X8    X9    Min Cost
            $ 300.00    $ 325.00    $ 20.00    $ 300.00    $ 325.00    $ 20.00    $ 300.00    $ 325.00    $ 20.00    $ 184,975.00
    Limitations
            X1    X2    X3    X4    X5    X6    X7    X8    X9    Cell Reference    Sign    Constraint
        Max June Regular Production    1                                    200    <=    200
        Max June Overtime production        1                                0    <=    15
        Max July Regular Production                1                        200    <=    200
        Max July Overtime Production                    1                    10    <=    15
        Max August Regular Production                            1            200    <=    200
        Max August Overtime Production                                1        5    <=    15
        Demand June    1    1    -1                            195    >=    195
        Demand July            1    1    1    -1                215    >=    215
        Demand August                        1    1    1    -1    205    >=    205
Answer Report 1
    Microsoft Excel 15.0 Answer Report
    Worksheet: [38735.xlsx]8.13
    Report Created: 12-04-2019 3.35.25 PM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
        Engine: Simplex LP
        Solution Time: 0.047 Seconds.
        Iterations: 2 Subproblems: 0
    Solver Options
        Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
        Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
    Objective Cell (Max)
        Cell    Name    Original Value    Final Value
        $B$2    max profit    0    195504.827586207
    Variable Cells
        Cell    Name    Original Value    Final Value    Integer
        $B$5    I    0    496.5517241379    Contin
        $B$6    E    0    1241.3793103448    Contin
        $B$7    G    0    0    Contin
        $B$8    C    0    0    Contin
        $B$9    H    0    0    Contin
        $B$10    M    0    0    Contin
    Constraints
        Cell    Name    Cell Value    Formula    Status    Slack
        $B$13    Condition...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here