|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
... The apparent cause of this overall loss is the change in the product mix as California Products produced 40,000units more of product K, 50,000units less of product I, and 40,000units less of product J in 1993. ... 008 1840 2000
Products I produced 400000 Machine B 0. ... 006 2000 2000
Products J produced 160000 Machine C 0. ... 01 1280 2000
Products K produced 0 Total 5120
Objective Function Market Demand
Product I Revenue 2040000 Product I 400000
Product J Revenue 1056000 Product J 200000
Product K Revenue 0 Product K 80000
Product I Material Cost -1040000
Product J Material Cost -512000
Product K Material Cost 0
Throuput Value 1544000
Operating Expenses -1472000
Profit 72000
Microsoft Excel 10.0 Answer Report
Target Cell (Max)
Cell Name Original Value Final Value
$B$21 Profit 72000 72000
Adjustable Cells
Cell Name Original Value Final Value
$B$8 Products I produced 400000 400000
$B$9 Products J produced 160000 160000
$B$10 Products K produced 0 0
Constraints
Cell Name Cell Value Formula Status Slack
$I$7 Machine A Hours 1840 $I$7<=$J$7 Not Binding 160
$I$8 Machine B Hours 2000 $I$8<=$J$8 Binding 0
$I$9 Machine C Hours 1280 $I$9<=$J$9 Not Binding 720
$B$8 Products I produced 400000 $B$8<=$F$13 Binding 0
$B$9 Products J produced 160000 $B$9<=$F$14 Not Binding 40000
$B$10 Products K produced 0 $B$10<=$F$15 Not Binding 80000
$B$8 Products I produced 400000 $B$8>=0 Not Binding 400000
$B$9 Products J produced 160000 $B$9>=0 Not Binding 160000
$B$10 Products K produced 0 $B$10>=0 Binding 0
Microsoft Excel 10.
Approximate Word count = 822
Approximate Pages = 3.3
(250 words per page double spaced)
|
|
|
|
|
|