statistic assignment
whiterose2015
skis_problem.xlsxAnswer Report 1
| Microsoft Excel 14.4 Answer Report | ||||||
| Worksheet: [Workbook2]Sheet1 | ||||||
| Report Created: 2/25/2015 9:41:13 PM | ||||||
| Result: Solver found a solution. All constraints and optimality conditions are satisfied. | ||||||
| Solver Engine | ||||||
| Engine: Simplex LP | ||||||
| Solution Time: 0.880546 Seconds. | ||||||
| Iterations: 2 Subproblems: 0 | ||||||
| Solver Options | ||||||
| Max Time Unlimited , Iterations Unlimited , Precision 1e-06, 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$24 | Profit Jordanelle | 0 | 945 | |||
| Variable Cells | ||||||
| Cell | Name | Original Value | Final Value | Integer | ||
| $B$18 | Quantity Produced Jordanelle | 0 | 5.25 | Contin | ||
| $C$18 | Quantity Produced Deercrest | 0 | 10.5 | Contin | ||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $F$19 | C1 (Fabrication) Hour Used | 60.375 | $F$19<=$G$19 | Not Binding | 23.625 | |
| $F$20 | C2 (Finishing) Hour Used | 21 | $F$20<=$G$20 | Binding | 0 | |
| $F$21 | C3 Hour Used | 0 | $F$21>=$G$21 | Binding | 0 |
Sensitivity Report 1
| Microsoft Excel 14.4 Sensitivity Report | |||||||
| Worksheet: [Workbook2]Sheet1 | |||||||
| Report Created: 2/25/2015 9:41:14 PM | |||||||
| Variable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$18 | Quantity Produced Jordanelle | 5.25 | 0 | 50 | 1E+30 | 6.6666666667 | |
| $C$18 | Quantity Produced Deercrest | 10.5 | 0 | 65 | 10 | 90 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $F$19 | C1 (Fabrication) Hour Used | 60.375 | 0 | 84 | 1E+30 | 23.625 | |
| $F$20 | C2 (Finishing) Hour Used | 21 | 45 | 21 | 8.2173913043 | 21 | |
| $F$21 | C3 Hour Used | 0 | -2.5 | 0 | 14 | 42 |
Limits Report 1
| Microsoft Excel 14.4 Limits Report | |||||||||
| Worksheet: [Workbook2]Sheet1 | |||||||||
| Report Created: 2/25/2015 9:41:20 PM | |||||||||
| Objective | |||||||||
| Cell | Name | Value | |||||||
| $B$24 | Profit Jordanelle | 945 | |||||||
| Variable | Lower | Objective | Upper | Objective | |||||
| Cell | Name | Value | Limit | Result | Limit | Result | |||
| $B$18 | Quantity Produced Jordanelle | 5.25 | 0 | 682.5 | 5.25 | 945 | |||
| $C$18 | Quantity Produced Deercrest | 10.5 | 10.5 | 945 | 10.5 | 945 |
Sheet1
| Sklenka Skis | ||||||
| Data | ||||||
| Product | ||||||
| Department | Jordanelle | Deercrest | ||||
| Fabrication | 3.5 | 4 | ||||
| Finishing | 1 | 1.5 | ||||
| Profit | 50 | 65 | ||||
| Model | ||||||
| Jordanelle | Deercrest | Constrains LHS Fomula | RHS Constant | |||
| Quantity Produced | 5.25 | 10.5 | Hour Used | Limiation | ||
| Fabrication | 18.375 | 42 | C1 (Fabrication) | 60.375 | 84 | |
| Finishing | 5.25 | 15.75 | C2 (Finishing) | 21 | 21 | |
| C3 | 0 | 0 | ||||
| Objective | ||||||
| Profit | 945 |
