First sheet is provided to answer the second sheet
Objective Cell (Max) Cell Name Original Value Final Value SF$7 Contribution 93.467 93 467 Variable Cells cell Name Original Value Final Value Ince ger SC$6 Allocation of Units Basic 91580 9 580 Contin SDS6 Allocation of Units Deluxe 420 420 Contin SES6 Allocation of Units Surpreme 536 536 Comdin Constraints Cell Name Cell Value Formula SFS10 Direct Materials 5.726.90 SFS106-SHS10 Not Binding SF$11 Direct Labour Hours 10 000.00 SESIN-SHS11 Binding SFS12 Machine Hours 10,000.00 SF5120-58512 Biris SF$13 Special Part 955.75 5F513C-SP513 Not B SF$14 Special Paint 535,75 565142-58514 Not B 54 35 SFS15 Basic units already sold 9 580.00 SES15-SHSTS Not B 8 830.00 SF$16 Deluxe units already sold 420.00 SFS16-SH516 Bind SF$17 Supreme units already sold 535 75 SF$17)-SH517 Not Binding 335.75 Variable Cells Final Reduced Objective Cell Name Value Cost Increase Debre SC56 Allocation of Units Basic 9 580 8 NIE+30 0 58 SDS6 Allocation of Uriits Delune 420 12 0.68 IF-30 SESS Allocation of Units Surpreme 536 12 20.67 3.18 Constraints Final Shadow Constraint Cell Name Value Price R.FL. Side SF$10 Direct Materials 5,727 50,000 1E+30 SF$11 Direct Labour Hours 10,000 6 10,000 5,857 1.343 SFS12 Machine Hours 10,000 10,000 1 791 7.809 SF$13 Special Part 956 5.500 JE+30 SF514 Special Paint 536 2.000 LE+30 1454.25 SF$15 Basic units already sold 9.580 750 8 830 LE-30 SF$16 Deluxe units already sold 420 (1) 420 1.580 420 SF$17 Supreme units already sold 536 200 336 HE + 30Normal No Spac.. Heading 1 Heading 2 Title Dictate Select Font Paragraph Fy Styles Editing Voice Linear Programming AC10037 Linear Programming AC10037 Objective Cell (Max) Required: Cell Name Original Value Final Value SF$7 Contribution 93,467 93.467 1) What is this the objective of the linear program? Variable Cells Cell N am Original Value Final Value Integer 2) How many products are under consideration? SC$6 Allocation of Units Basic 9,580 9,580 Contin SD56 Allocation of Units Deluxe 420 420 Contin SES6 Allocation of Units Sur preme 536 536 Contin 3) How much profit do we make on each Deluxe product? Constraints Cell Name Cell Value Formula Status Stack SF$10 Direct Materials 5,726.90 SF$10 SH$15 Not Binding 8,830.00 SF$16 Deluxe units already sold 420.00 SF$16>SHS16 Binding SFS17 Supreme units already sold 535.75 SF$17>SH$17 Not Binding 335.75 6) How many constraints are there? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$6 Allocation of Units Basic 9.580 1E+30 0.68 7) How many constraints are limiting the recommendation? SDS6 Allocation of Units Deluxe 420 12 0.68 1E+30 SES6 Allocation of Units Sur preme 536 22 20.67 3.18 Constraints 8) If we could get 10 units of each constraint listed, for free, how much would the Objective change by? Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Direct materials SPS10 Direct Materials 5,727 50,000 1E+30 44273.1 SF511 Direct Labour Hours 10,000 10,000 5.857 1,343 Direct labour SF$12 Machine Hours 10,000 10,000 1,791 7,809 SPS13 Special Part 956 5,500 1E+30 4544.25 Machine hours SFS14 Special Paint 536 2,000 1E+30 1464.25 SF$15 Basic units already sold 9,580 750 8, 830 1E+30 9) What is the most you'd be willing to pay to get an extra 200 DLHS? SF$16 Deluxe units already sold 420 (1) 420 1,580 420 SP$17 Supreme units already sold 536 200 336 1E+30
