June Stats HW Assistance
typingohio26
stat_june_hw.xlsxGrade
| Grade = | 100 | |
| Question | Points Available | Points Lost |
| 1 | 30 | 0 |
| 2 | 20 | 0 |
| 3 | 40 | 0 |
| 4 | 10 | 0 |
| Total | 100 | 0 |
Hickory 1
| Question1 | ||||||||
| Part a | Grader | |||||||
| Max Profit | ||||||||
| X1 Sofa | X2 Table | X3 Chair | Grader | |||||
| Dec Vars | Solver Solution | |||||||
| Part b | X1 Sofa | X2 Table | X3 Chair | Grader | ||||
| Profit Coefficients | ||||||||
| Part c | Part d | Part e | Part f | Part g | Part h | |||
| Constraint Coefficients | X1 Sofa | X2 Table | X3 Chair | Constraint Value | Amount Used | Slack or Surplus | Type Inequality | Slack or Surplus |
| Wood | ||||||||
| Upholstery | ||||||||
| Labor | ||||||||
| Warehouse Capacity | ||||||||
| Grader | Grader | Grader | Grader | Grader | Grader | |||
Hickory 2
| Question 2 | |||||||||||||
| Adjustable Cells | Grader | ||||||||||||
| Final | Reduced | Objective | Allowable | Allowable | Part | ||||||||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | a | ||||||
| $B$6 | Dec Vars X1 Sofa | 10.9999999996 | 0 | 300 | 7.14 | 30 | b | ||||||
| $C$6 | Dec Vars X2 Table | 0 | -25 | 275 | 25 | 1E+30 | c | ||||||
| $D$6 | Dec Vars X2 Chair | 67 | 0 | 225 | 25 | 4.17 | d | ||||||
| Constraints | |||||||||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||||||||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | Part | f | Grader | ||||
| $F$12 | Wood Amount Used | 345 | 0 | 2250 | 1E+30 | 1905 | e | ||||||
| $F$13 | Upholstery Amount Used | 601 | 8 | 601 | 201 | 39.6 | g | ||||||
| $F$14 | Labor Amount Used | 401 | 33 | 401 | 28.29 | 100.5 | h | ||||||
| $F$15 | Warehouse Capacity Amount Used | 78 | 0 | 650 | 1E+30 | 572 | I | ||||||
Investment 1
| Question 3 | |||||||||
| Part a | Grader | ||||||||
| Max Return | |||||||||
| X1 RE | X2 CD | X3 MF | X4 Bonds | Grader | |||||
| Dec Vars | |||||||||
| Part b | X1 RE | X2 CD | X3 MF | X4 Bonds | Grader | ||||
| Return Coefficients | |||||||||
| Part c | Part d | Part e | Part f | Part g | Part h | ||||
| Constraint Coefficients | X1 RE | X2 CD | X3 MF | X4 Bonds | Constraint Value | Amount Used | Slack or Surplus | Type Inequality | Slack or Surplus |
| RE to CD Ratio | |||||||||
| MF + Bonds Combined | |||||||||
| Bonds <=$2000 | |||||||||
| RE Alone | |||||||||
| CD Alone | |||||||||
| MF Alone | |||||||||
| B Alone | |||||||||
| All Funds Invested | |||||||||
| Grader | Grader | Grader | Grader | Grader | Grader | ||||
Investment 2
| Question 4 | ||||||||||
| Adjustable Cells | ||||||||||
| Final | Reduced | Objective | Allowable | Allowable | ||||||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | Part | Grader | ||
| $B$6 | Dec Vars X1 RE | 4750 | 0 | 0.0800000002 | 1E+30 | 0.0200000004 | a | |||
| $C$6 | Dec Vars X2 CD | 250 | 0 | 0.0399999998 | 0.0400000005 | 1E+30 | b | |||
| $D$6 | Dec Vars X3 MF | 3000.0000000006 | 0 | 0.06 | 0.01 | 1E+30 | c | |||
| $E$6 | Dec Vars X4 Bonds | 1999.9999999996 | 0 | 0.07 | 1E+30 | 0.01 | d | |||
| Constraints | ||||||||||
| Final | Shadow | Constraint | Allowable | Allowable | ||||||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | ||||
| $G$12 | RE to CD Ratio Amount Used | 4,250 | 0 | 0 | 4250 | 1E+30 | ||||
| $G$13 | MF + Bonds Combined Amount Used | 5,000 | -0 | 5000 | 4250 | 2750 | ||||
| $G$15 | RE Alone Amount Used | 4,750 | 0 | 250 | 4500 | 1E+30 | ||||
| $G$16 | CD Alone Amount Used | 250 | -0 | 250 | 1416.6666666667 | 250 | ||||
| $G$17 | MF Alone Amount Used | 3,000 | 0 | 250 | 2750 | 1E+30 | ||||
| $G$18 | B Alone Amount Used | 2,000 | 0 | 250 | 1750 | 1E+30 | ||||
| $G$14 | Bonds <=$2000 Amount Used | 2,000 | 0 | 2000 | 2750 | 1750 | Part | Grader | ||
| $G$19 | All Funds Invested Amount Used | 10,000 | 0 | 10000 | 1E+30 | 4250 | e |
