what is the range of optimality for the company
QUESTION 3 PI3KUM Corporation is offering a new position to work at marketing department. They have a choice of selecting from us-trained, serni-trained and highly-trained candidates. Consider the following sensitivity report generated by Excel Solver for PISKUM Corporation. Answer Report by Excel Objective Cell (Min) Cell Name $A$15 Max Total Profit Untrained Original Value Final Value 8225 8225 Name Variable Cells Cel $B$13 No. of employees Untrained SC$13 No. of employees Semi-trained SO$13 No. of employees Trained Original Value 18.33333333 0 Final Value Integer 18.33333133 Contin O Contin 6.666666667 Contin 6.666666667 Constraints Cell Name $B$18. Minimum employees Hours Used (LHS) SBS19 Painting training hours Hours Used (LHS) S8520 Packing training hours Hours Used (LHS) Cell Value Formula Status Slack 25 $B$1$F$18 Binding 0 613.3333333 $B$19$F$19 Not Binding 86.66666667 775 $B$20-$F520 Binding Sensitivity. Analysis Report by Excel: Variable Cells Cell Name 58$13 No. of employees Untrained SCS13 No. of employees Sentrained SD$13 No. of employees Trained Final Reduced Objective Allowable Value Cost Coefficient Increase 18.33333333 315 525 0 118 450.5 15:30 6.666666667 0 367.5 354 Allowable Decrease 1E+30 118 52.5 Constraints Final Cell Name Valve $B$18 Minimum employees Hours Used LHS) 25 $B$19 Painting training hours Hours Used LHS 613.3333333 S8520 Packing training hours Hours Used (LHS) 775 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 437.5 25 13.75 2.857142857 0 700 1E430 86.66666667 775 100 275 What is the total training cost equation for P13KUM Corporation? Tips: Objective fanction equation What is the optimal recruitment plan for the company? What is their expected total training cost by adopting the recruitment plan? What is the range of optimality for number of trained employees to be recruited by the company? Tii. iv. V. What is the range of feasibility for packing training hours for the company? Are there excess hours available for painting training? Why? What is the maximum training cost per additional hour for conducting training for packing? vi. What would be the acceptable training cost per semi-trained employee so that the company should start recruiting semi-trained employees? [3+2+2+2+2+2+2 = 15 marks) QUESTION 4 QUESTION 3 PI3KUM Corporation is offering a new position to work at marketing department. They have a choice of selecting from us-trained, serni-trained and highly-trained candidates. Consider the following sensitivity report generated by Excel Solver for PISKUM Corporation. Answer Report by Excel Objective Cell (Min) Cell Name $A$15 Max Total Profit Untrained Original Value Final Value 8225 8225 Name Variable Cells Cel $B$13 No. of employees Untrained SC$13 No. of employees Semi-trained SO$13 No. of employees Trained Original Value 18.33333333 0 Final Value Integer 18.33333133 Contin O Contin 6.666666667 Contin 6.666666667 Constraints Cell Name $B$18. Minimum employees Hours Used (LHS) SBS19 Painting training hours Hours Used (LHS) S8520 Packing training hours Hours Used (LHS) Cell Value Formula Status Slack 25 $B$1$F$18 Binding 0 613.3333333 $B$19$F$19 Not Binding 86.66666667 775 $B$20-$F520 Binding Sensitivity. Analysis Report by Excel: Variable Cells Cell Name 58$13 No. of employees Untrained SCS13 No. of employees Sentrained SD$13 No. of employees Trained Final Reduced Objective Allowable Value Cost Coefficient Increase 18.33333333 315 525 0 118 450.5 15:30 6.666666667 0 367.5 354 Allowable Decrease 1E+30 118 52.5 Constraints Final Cell Name Valve $B$18 Minimum employees Hours Used LHS) 25 $B$19 Painting training hours Hours Used LHS 613.3333333 S8520 Packing training hours Hours Used (LHS) 775 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 437.5 25 13.75 2.857142857 0 700 1E430 86.66666667 775 100 275 What is the total training cost equation for P13KUM Corporation? Tips: Objective fanction equation What is the optimal recruitment plan for the company? What is their expected total training cost by adopting the recruitment plan? What is the range of optimality for number of trained employees to be recruited by the company? Tii. iv. V. What is the range of feasibility for packing training hours for the company? Are there excess hours available for painting training? Why? What is the maximum training cost per additional hour for conducting training for packing? vi. What would be the acceptable training cost per semi-trained employee so that the company should start recruiting semi-trained employees? [3+2+2+2+2+2+2 = 15 marks) QUESTION 4
