Total labor cost 238 by OX93Mu

VIEWS: 1 PAGES: 4

									                                                    Sheet1


ABCD Product Mix Example (Part I Data Sheet)

Producton Plan and Gross Profit
                      Product A         Product B         Product C       Product D
Selling price/unit                  5                 4               5               5
Material cost/unit                  2                 2               1               1
Gross profit/unit
Products to produce                 1                 2               3               4
Gross profit

Machine Hours Needed for Each Product
                     Product A      Product B             Product C       Product D
Machine 1                        12                   7               8               10
Machine 2                         8                   9               4                0
Machine 3                         5                  10               7                3

Machine Hours Used and Capacity
                     Time used(min)Time used (hr) <Time avai (hr) Labor cost/hr
Machine 1                                                     20                4
Machine 2                                                     40                4
Machine 3                                                     10                3

Machine Cost and Net Profit
Machine cost
Net profit




                                                    Page 1
                                              Sheet1 (2)


ABCD Product Mix Example (Part I Optimal Solution)

Producton Plan and Gross Profit
                      Product A     Product B         Product C       Product D
Selling price/unit                5               4              5               5
Material cost/unit                2               2              1               1
Gross profit/unit                 3               2              4               4
Products to produce               0               0    52.17391294      78.2608698
Gross profit             521.739131

Machine Hours Needed for Each Product
                     Product A      Product B         Product C       Product D
Machine 1                        12               7               8               10
Machine 2                         8               9               4                0
Machine 3                         5              10               7                3

Machine Hours Used and Capacity
                     Time used(min)Time used (hr) <Time avai (hr) Labor cost/hr
Machine 1              1200.000002 20.00000003                20                4
Machine 2              208.6956518 3.478260863                40                4
Machine 3                       600           10              10                3

Machine Cost and Net Profit
Machine cost            123.9130436
Net profit              397.8260874




                                                Page 2
                                               Sheet1 (3)


ABCD Product Mix Example (Part 2 Data Sheet)

Producton Plan for Products <= 20
                       Product A     Product B         Product C        Product D
Selling price/unit                 5               4               5                5
Material cost/unit                 2               2               1                1
Gross profit/unit
Products to produce                1               2                3                4
Upper Limits                      20              20               20               20
Gross Profit

Production Plan for Products >= 20
                       Product A     Product B         Product C        Product D
Selling price/unit                 4               3               4                4
Material cost/unit                 2               2               1                1
Gross profit/unit
Products to produce                1               2               3                4
Gross Profit

Machine Hours Needed for Each Product
                     Product A      Product B          Product C        Product D
Machine 1                        12                7               8                10
Machine 2                         8                9               4                 0
Machine 3                         5               10               7                 3

Machine Hours Used
                       Min used (<20) Min used (>20) Total min used Total hr used
Machine 1
Machine 2
Machine 3

Regular Time and Overtime Available and Cost
                       Reg. time avai Reg time used Over time used Over time avai
Machine 1                          20                                          10
Machine 2                          40                                          10
Machine 3                          10                                          10

Labor Cost and Net Profit
                                      R labor cost/hr O labor cost/hr
Machine 1                                           4               5
Machine 2                                           4               5
Machine 3                                           3               4

Labor cost
Total labor cost
Net profit




                                                 Page 3
                                                   Sheet1 (4)


ABCD Product Mix Example (Part 2 Optimal Solution)

Producton Plan for Products <= 20
                       Product A      Product B            Product C        Product D
Selling price/unit                  5                  4                5                5
Material cost/unit                  2                  2                1                1
Gross profit/unit                   3                  2                4                4
Products to produce                 0                  0               20               20
Upper Limits                       20                 20               20               20
Gross Profit                      160

Production Plan for Products >= 20
                       Product A     Product B             Product C        Product D
Selling price/unit                 4                   3              4                4
Material cost/unit                 2                   2              1                1
Gross profit/unit                  2                   1              3                3
Products to produce                0                   0    123.4782609      45.21739127
Gross Profit             506.0869565

Machine Hours Needed for Each Product
                     Product A      Product B              Product C        Product D
Machine 1                        12                    7               8                10
Machine 2                         8                    9               4                 0
Machine 3                         5                   10               7                 3

Machine Hours Used
                       Min used (<20) Min used (>20) Total min used Total hr used
Machine 1                         360          1440            1800             30
Machine 2                          80 493.9130436 573.9130436 9.565217393
Machine 3                         200          1000            1200             20

Regular Time and Overtime Available and Cost
                       Reg. time avai Reg time used Over time used Over time avai
Machine 1                          20            20 9.999999998                10
Machine 2                          40 9.565217393                0             10
Machine 3                          10            10             10             10

Labor Cost and Net Profit
                                          R labor cost/hr O labor cost/hr
Machine 1                                               4               5
Machine 2                                               4               5
Machine 3                                               3               4

Labor cost                                 148.2608696      89.99999999
Total labor cost            238.2608696
Net profit                  427.8260869




                                                     Page 4

								
To top