1. Business
  2. Operations Management
  3. a manufacturing company is planning to build a new facility...

Question: a manufacturing company is planning to build a new facility...

Question details

A manufacturing company is planning to build a new facility in one of four states within the United States. Review the table below and develop a weighted project selection model with a minimum of 6 criteria (two criteria have been provided to get you started) to aid in the selection of the correct project. The company can only invest in one facility. Assign fictional scores to each criterion for each of the 4 states, provide a legend, and total the score. Make a recommendation based upon the score. Complete the assignment using Microsoft Excel. Please attach Excel file if possible. Thanks!
State Cost to Operate Skilled Worker Availability Medium Michigan Ohio Texas Idaho Mediumm Low Low High Medium Low Low

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution