The question is in the screenshot

Excel Data is:

From	To	Ship	Unit Cost					Supply/Demand
Source 1	Destination 1		$6					40
Source 1	Destination 2		$7					60
Source 1	Destination 3		$4					-30
Source 2	Destination 1		$5					-40
Source 2	Destination 2		$8					-30
Source 2	Destination 3		$6

Consider the transportation problem having the unit shipping costs shown in the following table. Click here for the Excel Data File Formulate and solve a spreadsheet model for this problem. a. Determine the shipping costs. Note: Leave no cells blank. Enter " 0 " wherever required. Answer is complete but not entirely correct. b. Determine the total cost. Answer is complete but not entirely correct