Fixed costs Direct material cost per unit Direct labor cost per unit Overhead per unit Transportation cost per unit Which location would minimize the total costs, given an annual production of 60,000 units? The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet Location 1 Location 2 Location 3 $120,000 $165,000 $140,000 $8.60 $8.80 $8.50 $4.90 $5.10 $4.40 $1.20 $1.10 $1.00 $1.35 $1.65 $1.50 Questions. 1. What are the total annual costs for each of the locations? Round your answers to the nearest dollar. Total Location 1 Location 2 $ Location 3 Excel File B13 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 template - Saved Data Home V A Location Analysis Annual Production osts Insert X fx Fixed Costs Direct material cost/unit Direct labor cost/unit Overhead/unit Transportation cost/unit Arial Fixed Costs Direct material cost Direct labor cost Overhead 21 22 Formulas Transportation cost Total Least-cost location Draw' B Location 1 Page Layout Location 1 $120,000.00 Location 1 10 $8.60 $4.90 $1.20 $1.35 60000 B Location 2 Location 2 O Search (Alt + Q) $165,000.00 Location 2 Formulas $8.80 $5.10 $1.10 $1.65 D Location 3 Data Location 3 $140,000.00 Location 3 A v $8.50 $4.40 $1.00 $1.50 Review E View Help F ab G Currency H File S B13 < V < > Home 11 12 Total Costs 13 14 15 16 17 18 19 20 21 22 Formulas 23 24 25 26 27 28 29 30 31 32 - V M A Insert Arial X fx Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Fixed Costs Direct material cost Direct labor cost Overhead Transportation cost Total Least-cost location Sheet1 + Draw B Location 1 Location 1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A Page Layout 10 V B Location 2 Location 2 #N/A #N/A #N/A #N/A #N/A #N/A Formulas Search (Alt+Q) V D Location 3 Location 3 #N/A #N/A #N/A #N/A #N/A #N/A Data Review ... E View F ab Help P G Currency H