Question: need help on replace the function General Appliance Corporation Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between



need help on replace the function
General Appliance Corporation Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the accompanying data, which shows the solution to an optimization model that finds the minimum cost and amounts shipped from two plants to four distribution centers. Your table should be set up as follows, and the formulas for the Amount Shipped column should reference the names in the From and To columns E:8. Click the icon to view the data and model. spreadsheet below. Replace the functions with the amounts shipped between each pair of cities. Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the accompanying data which shows the sofition io an optimization model that finds the minimum cost and amounts shipped from two plants to four distribution centers Your tabie should be set up as foliows, and the formulas for the Amount Shipped column should reference the names in the From and fo columins Click the icon to view the data and model Replace the funchons with the amounts shipped between each pair of cifies
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
