3. Assuming the following level of cost-driver volume, what is the estimated purchasing department cost using simple regression for each of the cost drivers and using multiple regression. You should have 4 computations for this answer (you need to determne 3 since I have calculated the first one for you). You need to use cell references to calculate the cost estimation for each of the cost drivers listed below. Cost Drivers (independent variables): Dollar Value of Merchandise Purc Number of Purchase Orders Number of Su liers Solution: 79,000 16 Guidance: I have estmated the purchasing department costs using the simple regression table variables and the estmated cost driver level. Dollar Value of Merchandise Purchased Answer: S 1 547.50 You need to answer: Number of Purchase Orders Answer: Number of Suppliers Answer: Multiple regression Answer