please show your excel work

8 Version 1. Calculate if the scrap problem is caused by electricity shortages Periods 1 2 3 4 5 6 7 8 9 10 1 7 4 4 1 10 4 9 5 10 scraps electricity shortages 81 64 88 48 42 56 92 27 71 58 2. Respond to this statement: "The importance of the location decision is often vastly overrated; the fact that virtually every type of business is located in every section of the country means there should be no problem in finding a suitable location." 3. A manager has the option of purchasing one, two, or three machines. Fixed costs and potential volumes are as follows: Number of Machines Total Annual Fixed Costs Corresponding Range of Output Range break-even 1 0-300 9006 14216 2 300-600 3 14687 601-900 Variable cost per unit is 11 Revenue per unit is 24 If a new range is, how many machines should the manager purchase? 659 859 4. Determine which location has the higher factor rating given the following information Location score Factor Weight A B Labor cost 4 27 98 Material cost 5 79 82 Transportation cost 1 20 95