URGENT PLEASE HELP I KEEP GETTING THE WRONG ANSWER ON MY HOMEWORK!!! WILL LIKE!!!

a. What is the optimal solution?

b. which constraints are binding at the optimal?

c. what will be the impact on costs if the capacity of gas needed is increased by 10.

d. what is the allowable range for the capacity constraint.

e. the company that provides trucks for bringing in coal has offered to increase its capacity from 720 to 920 mons/year for an additional

cost of $90,000 per year. Should Stephanie Coggins accept this offer? Why

or why not?

The SS model is on the next tab "Problem 355 Model" By solving the model, Stephine obtained the following Answer and Sensitivity Reports. Answer Questions on worksheet tab "Problem 3 Questions" Answer Report Constraints \begin{tabular}{|c|c|c|c|c|c|} \hline Name & \begin{tabular}{l} Final \\ Value \end{tabular} & \begin{tabular}{c} Shadow \\ Price \end{tabular} & \begin{tabular}{l} Constraint \\ R.H. Side \end{tabular} & \begin{tabular}{l} Allowable \\ Increase \end{tabular} & \begin{tabular}{l} Allowable \\ Decrease \end{tabular} \\ \hline \$B\$21 Capacity (mtons/year) LHS & 1225 & 64 & 1225 & 145 & 205 \\ \hline \$B\$22 Non-union/Non-Union LHS & 815 & 0 & 0 & 815 & 1E+30 \\ \hline \$B\$23 Truck LHS & 720 & -0.5 & 720 & 205 & 120 \\ \hline \$B\$24 Rail LHS & 505 & 0 & 650 & 1E+30 & 145 \\ \hline \$B\$25 Ashley LHS & 300 & -14.5 & 300 & 205 & 300 \\ \hline \$B\$26 Bedford LHS & 600 & -13.5 & 600 & 120 & 535 \\ \hline \$B\$27 Consol LHS & 205 & 0 & 510 & 1E+30 & 305 \\ \hline \$B\$28 Dunby LHS & 120 & 0 & 655 & 1E+30 & 535 \\ \hline \$B\$29 Earlam LHS & 0 & 0 & 575 & 1E+30 & 575 \\ \hline \$B\$30 Florence LHS & 0 & 0 & 680 & 1E+30 & 680 \\ \hline \$B\$31 Gaston LHS & 0 & 0 & 450 & 1E+30 & 450 \\ \hline \$B\$32 Hopt LHS & 0 & 0 & 490 & 1E+30 & 490 \\ \hline \end{tabular} New Bedford Steel (NBS) is a small steel manufacturing company. Their Planning Manager for next year's production, Stephanie Coggins, has received bids from 8 suppliers for next year (see table below) for supply of gas that NBS needs for manufacturing. The manager needs to accept bids for a total of 1,225 mtons ( 1 mton =1,000 tons) of coking coal for the coming year. NBS needs to procure at least 50% of its coking coal from union mines. The capacity for bringing in coal by rail is limited to 650 mtons per year and capacity for bringing in coal by truck is limited to 720 Constraints \begin{tabular}{|c|c|c|c|} \hline Name & Cell Value & Status & Slack \\ \hline \$B\$21 Capacity (mtons/year) LHS & 1225$B$21>=$D$21 & Binding & 0 \\ \hline \$B\$22 Non-union/Non-Union LHS & 815$B$22>=$D$22 & Not Binding & 815 \\ \hline \$B\$23 Truck LHS & 720$B$23= & 1225 \\ Non-union/Non-Union & 815 & >= & 0 \\ Truck & 720 & =$D$21 & Binding & 0 \\ \hline \$B\$22 Non-union/Non-Union LHS & 815$B$22>=$D$22 & Not Binding & 815 \\ \hline \$B\$23 Truck LHS & 720$B$23= & 1225 \\ Non-union/Non-Union & 815 & >= & 0 \\ Truck & 720 &