Attachment 1: VL Shipyard LP Spreadsheet Model. Then, run Excelun Excel Solver and you will find that the results are excellent.Try adding 2 more Jacket Contracts and see what happens. On the other hand, add one Repair Contract, run Excel Solver, and you will find that the results are terrible. Make sure that you set your model back to its original numbers before you try any of these Sensitivity experiments. Now lets see what happens when you ask the Purchasing Manager to find another Steel vendor to add extra tons of Steel Capacity. Again, the results are excellent when you run Excel Solver. The question is how many more tons of Steel should you add? Hint try 336 Tons and then try 337 Tons. See what happens when you run Excel Solver. The Case tells us that we will be unable to add additional Anti-Corrosion or Dock Days, and the labor market is not good. So, just add Tons of Steel. Remember that you need $30M to cover all fixed costs and loan payments. Solver LP and create Attachment 2: VL Shipyard LP Optimized Spreadsheet Model R Please insert the attachment spreadsheet thank you

	A	B	C	D	E	F	G
1
2		Repair	Conversion	Newbuilding	Jacket	Total (Formula)	Capacity Constraint
3	Contracts	1	1	1	1
4
5	Contribution	520171	5014710	1600150	3098844	=SUMPRODUCT(B3:E3,B5:E5)
6
7	Demand	40	4	2	2
8	Steel	?	?	?	?	=SUMPRODUCT($B$3:$E$3,B8:E8)	5500
9	Anti-Corrosion	?	?	?	?	=SUMPRODUCT($B$3:$E$3,B9:E9)	500000
10	Dock Days	?	?	?	?	=SUMPRODUCT($B$3:$E$3,B10:E10)	700
11	Man-Hours	?	?	?	?	=SUMPRODUCT($B$3:$E$3,B11:E11)	4000000
12