PLease answer using this format as quickly as possible. Thank you

Carton construction is supplying building materials for a new mall construction project in Kansas. Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period. Carlton's supply depot has access to three modes of transportation: a trucking fleet, railway delivery, and air cargo transport. Their contract calls for exactly 120,000 tons delivered by the end of week one, exactly 80% of the total delivered by the end of week two, and the entire amount delivered by the end of week three. Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking, at least 40% of the total delivered be delivered by railway, and up to 1 5% of the total delivered by air cargo. Unfortunately, competing demands limit the availability of each mode of transportation each of the three weeks to the following levels (all in thousands of tons)L Week Air Cargo Limits Trucking Limits Railway Limits 15 60 45 2 50 10 45 Costs ($per 1000 tons) $200 $140 $500 The following is the LP model for this logistics problem. Let Xij amount shipped by mode i in week j where i- 1 truck), 2(rail),3(Air) and j-1,2,3 Let WLij weekly limit of mode i in week j(as provided in the above table) Let WLij- weekly limit of mode i in week j(as provided in the above table) MIN: 2000X11+X12+x13)+140X21 +X22 +X23)+500x31+X32 +X33) Subject to: XiWLij for all i and j (weekly limits by mode X11 +X12 +X13+ X21 +x22+ X23+x31+X32+X33 250 [total at end of three weeks) X11 +X21+x31 +X12 +X22 +X32-200 total at end of two weeks X11 X21+X31 120 (total at end of first week X11+X12+ X13 >-45 250 (truck mix requirement X21 + X22 + X23 >= .4 * 250 (all mix requirement) X31 +X32 +X33 .15 250 fair mix requirement O for all iandj Inon-negativty) Use the following spreadsheet to implement the problem into Solver. Use the following spreadsheet to implement the problem into Solver $140 Costs $500 $200 byuk by Rayo by Truckby Ra by AirTotals Required Week 1 120 4 Week 2 22 Week 3 Shipped By Percentage 250 15% 45% 40% Total Limit 8 112.5 100 37.5 Total Cost 10 Total Cost 10 Air Rail Truck 12 15 60 13 Week 1 14 Week 2 15 Week 3 45 10 50 45 Your decision variables should be in cells B3:D5, your formulas for your constraints should be in cells E3:E5, and B6D6, and your objective function should be in cell F10. Make sure that your cels alow for 1 decimal place. Implement the above spreadsheet and LP into Excel and Solver, and answer the following questions: What is the value in cell D3? Answer What is the value in cell C4? Answer What is the value in cell E4? Answer What is the value in cell C3? Answer What is the value in cell E5? Answer What is the value in cell B4? Answer What is the value in cell B3? Answer What is the value in cell C6? Answer What is the value in cell D4? Answer What is the value in cell D5? Answer What is the value in cell D6? Answer What is the value in cell B5? Answer: What is the value in cell F10? Answer What is the value in cell ES? Answer What is the value in cell C5? Answer Carton construction is supplying building materials for a new mall construction project in Kansas. Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period. Carlton's supply depot has access to three modes of transportation: a trucking fleet, railway delivery, and air cargo transport. Their contract calls for exactly 120,000 tons delivered by the end of week one, exactly 80% of the total delivered by the end of week two, and the entire amount delivered by the end of week three. Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking, at least 40% of the total delivered be delivered by railway, and up to 1 5% of the total delivered by air cargo. Unfortunately, competing demands limit the availability of each mode of transportation each of the three weeks to the following levels (all in thousands of tons)L Week Air Cargo Limits Trucking Limits Railway Limits 15 60 45 2 50 10 45 Costs ($per 1000 tons) $200 $140 $500 The following is the LP model for this logistics problem. Let Xij amount shipped by mode i in week j where i- 1 truck), 2(rail),3(Air) and j-1,2,3 Let WLij weekly limit of mode i in week j(as provided in the above table) Let WLij- weekly limit of mode i in week j(as provided in the above table) MIN: 2000X11+X12+x13)+140X21 +X22 +X23)+500x31+X32 +X33) Subject to: XiWLij for all i and j (weekly limits by mode X11 +X12 +X13+ X21 +x22+ X23+x31+X32+X33 250 [total at end of three weeks) X11 +X21+x31 +X12 +X22 +X32-200 total at end of two weeks X11 X21+X31 120 (total at end of first week X11+X12+ X13 >-45 250 (truck mix requirement X21 + X22 + X23 >= .4 * 250 (all mix requirement) X31 +X32 +X33 .15 250 fair mix requirement O for all iandj Inon-negativty) Use the following spreadsheet to implement the problem into Solver. Use the following spreadsheet to implement the problem into Solver $140 Costs $500 $200 byuk by Rayo by Truckby Ra by AirTotals Required Week 1 120 4 Week 2 22 Week 3 Shipped By Percentage 250 15% 45% 40% Total Limit 8 112.5 100 37.5 Total Cost 10 Total Cost 10 Air Rail Truck 12 15 60 13 Week 1 14 Week 2 15 Week 3 45 10 50 45 Your decision variables should be in cells B3:D5, your formulas for your constraints should be in cells E3:E5, and B6D6, and your objective function should be in cell F10. Make sure that your cels alow for 1 decimal place. Implement the above spreadsheet and LP into Excel and Solver, and answer the following questions: What is the value in cell D3? Answer What is the value in cell C4? Answer What is the value in cell E4? Answer What is the value in cell C3? Answer What is the value in cell E5? Answer What is the value in cell B4? Answer What is the value in cell B3? Answer What is the value in cell C6? Answer What is the value in cell D4? Answer What is the value in cell D5? Answer What is the value in cell D6? Answer What is the value in cell B5? Answer: What is the value in cell F10? Answer What is the value in cell ES? Answer What is the value in cell C5