Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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 »
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 dishwashe
that has excellent cleaning power. This dishwashe
uses less water than most competitors, and it is extremely
quiet. Orders have been received from several
etails stores for delivery at the end of each of
the next 3 months, as shown below:
Month XXXXXXXXXXNumber of
XXXXXXXXXXUnits
June XXXXXXXXXX
July XXXXXXXXXX
August XXXXXXXXXX
Due to limited capacity, only 200 of these can
e 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 ca
y this item to the
next month. Use linear programming to determine
how many units to produce in each month on regula
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
oards. 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 compute
components is vast, and Quitmeyer Electronics
elieves 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 XXXXXXXXXXRevenue Per Unit Sold($)        Material Cost
XXXXXXXXXXPer Unit ($)
Internal modem         200              XXXXXXXXXX
External modem         120             XXXXXXXXXX
Graphics circuit board     180              XXXXXXXXXX
CD drive            130             XXXXXXXXXX
Hard disk drive        430             XXXXXXXXXX
Memory expansion    260             XXXXXXXXXX
oard
In addition, variable labor costs are $15 pe
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 XXXXXXXXXXExternalModem XXXXXXXXXXCircuitBoard CD Drives HardDrives MemoryBoards
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
Answered Same Day Apr 10, 2021

Solution

Pooja answered on Apr 12 2021
144 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 produced 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    Intege
        $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