The case presents five potential allocation bases for assignning the company's $300,000 in plant-administration costs. Using the five years of data presented in case Exhibit 4, you should hypothesize which portential base would be the best choice. To make this decision, you need to look for the best correlation coefficient or regression fit. You need to show your support below, using Excel (insert --> charts--> scatter) 1. Determine the best allocation base for allocating plant-administration costs. Answer Question 1 here and show support for your choice below. Exhibit 4 Total Amin Ending Plant Cost Inventory Cost Personnel Number of Customers Total Direct % of Plant Labor Cost Capacity Used 2003 $300,000 $90,000 122 1200 $520,000 70.00% 2002 $295,000 $83,000 122 1250 $515,000 75.00% 2001 $285,000 $58,000 119 1100 $555,000 85.00% 2000 $280,000 $50,000 112 800 $540,000 90.00% 1999 $290,000 $76,000 116 600 $500,000 95.00%