FACILITY LOCATION HOMEWORK REPORT!!! for facility layout class.

- What is your recommendation for the BEST location of the plant.

- The overall best solution

- THIS PROBLEM NEEDS TO BE SOLVED IN "WHAT'S BEST" EXCEL!!! (that is the requierement)

PLEASE TRY TO GO STEP BY STEP SO I CAN UNDERSTAND THE PRODECUDERE AND KNOW THE PROCEDURE AND THE REASON OF THE STEPS NOT JUST THE ANSWER.

- THIS IS ALL THE INFORMATION GIVEN IN ORDER TO BE ABLE TO SOLVE THIS PROBLEM

Thanks!!!

The Fly by Night Corporation (FBNC) makes frozen meat products and has two existing plants in Little Rock and Denver, and it is looking to set up two or more new plants. The alternatives for the new plants are in San Antonio, Savanah, Indianapolis, and Los Angeles. These plants are to serve FBNC's proposed warehouse activities in Corpus Christi, Lincoln, New York, Minneapolis, Phoenix, Sioux City, Detroit, San Diego, and Salt Lake City. The capacity at the existing plants is 320 truckloads of Tortillas per year. It is estimated that the demand of the planned warehousing activities will far exceed the current capacity, and it is estimated that the total demand will be divided equally among all the warehouses at the tune of 350 truckloads per warehouse per year. The capacity of the new plants is to make up the difference between the existing plant capacity and the estimated demand. If two plants are to be considered, the difference is to be divided equally among the plant location alternatives. It is estimated that the cost of setting up a new plant will be S100 per truckload per year of capacity in the West coast and S150 per package per year of capacity in the Mid-west, and S125 per package per year of capacity in the East Coast. The transportation cost per mile for each truckload is $1 per mile. Find the best alternative for the location of plants such that the setup and transportation cost is minimized, and identify the distribution network for your solution. Find the overall best solution together with the best solutions for configurations of one plant, two plants, three plants, up to four plants. Assuming that budgets for opening plants might be tight, provides ranges of costs of opening plants and the corresponding solution under that various levels of budget. 1. The Fly by Night Corporation (FBNC) makes frozen meat products and has two existing plants in Little Rock and Denver, and it is looking to set up two or more new plants. The alternatives for the new plants are in San Antonio, Savanah, Indianapolis, and Los Angeles. These plants are to serve FBNC's proposed warehouse activities in Corpus Christi, Lincoln, New York, Minneapolis, Phoenix, Sioux City, Detroit, San Diego, and Salt Lake City. The capacity at the existing plants is 320 truckloads of Tortillas per year. It is estimated that the demand of the planned warehousing activities will far exceed the current capacity, and it is estimated that the total demand will be divided equally among all the warehouses at the tune of 350 truckloads per warehouse per year. The capacity of the new plants is to make up the difference between the existing plant capacity and the estimated demand. If two plants are to be considered, the difference is to be divided equally among the plant location alternatives. It is estimated that the cost of setting up a new plant will be S100 per truckload per year of capacity in the West coast and S150 per package per year of capacity in the Mid-west, and S125 per package per year of capacity in the East Coast. The transportation cost per mile for each truckload is $1 per mile. Find the best alternative for the location of plants such that the setup and transportation cost is minimized, and identify the distribution network for your solution. Find the overall best solution together with the best solutions for configurations of one plant, two plants, three plants, up to four plants. Assuming that budgets for opening plants might be tight, provides ranges of costs of opening plants and the corresponding solution under that various levels of budget. 1