Perform the calculations and respond to all of the questions on the three problems. Access the three questions from the three tabs on the linked spreadsheet. Be sure to show all of your work to allow for the possibility of partial credit in the event of an incorrect answer. Use Word to present your problem results and the Excel spreadsheet to support and show your work. Submit both documents to complete this assignment.

1. The Bell Helicopters has collected information on fixed and variable costs for four potential plant l Annual Fixed Cost Unit Variable Cost A $250,000 $55 B $350,000 $35 C $400,000 $25 D $550,000 $20 Location a. Plot the total cost curves for the four plant locations on a single graph. b. Compute the range of demand for which each location has a cost advantage. c. Which plant location is best if demand is 35,000 units? for four potential plant locations for tail rotor blades ost advantage. 2. Using the Center of Gravity Heuristic, find the best plant location for the following 4 warehouse Warehouses Load Xi Li Yi Distance from plant Warehouse 1 6 14 16 Warehouse 2 12 5 8 Warehouse 3 4 7 8 Warehouse 4 7 10 4 Xi Plant Location Yi Total Load - distance r the following 4 warehouses 3. Problem: Simon's Hair Salon is concerned about their rising costs of supplies, energy, and lab which hopefully will reduce the time required to perform most hair styles as well as resulting in They predict that the added investment will increase output levels as well as reduce energy co Using the following information, determine the current and expected single factor and total pro What other items should be considered, before making this capital investment? Do you think Inputs and Outputs Current (this year) Hairstyles per week 250 Labor costs per week $1,100 Energy costs per week $500 Material costs per week $300 Capital investment $0 ing costs of supplies, energy, and labor, so they are considering investing in better equipment, most hair styles as well as resulting in better perceived quality by their customers. put levels as well as reduce energy costs, since some of the new equipment (hair dryers) use less electricity. nd expected single factor and total productivity measures. What is the percentage change in productivity? his capital investment? Do you think the increase in output will overcome the capital costs? Expected (next year) 300 $1,200 $450 $350 $12,000 less electricity. productivity