Can you put numbers in for me and show me step by step how to solve?
Question D: Cost Behavior Amber Foster Products, Inc., a discount store, has gathered data on its overhead activities and associated costs for the past 12 months. Amber Foster, a member of the CFO's office, believes that overhead activities and costs should be classified into groups that have the same driver. Amber has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of purchase orders. The following 12 months of data have been gathered for the receiving activity: Month Purchase Orders Recena.pt 1 2 3 4 $ 5 6 7 8 9 10 11 12 14. Using the high-low method, what is the cost formula for the receiving function? Summary Output of Least Squares Regression: ANOVA df SS MS F Significance F Regression Residual Total Coefficients Standard Error t Stat P-value Intercept X Variable 1 15. Using the provided summary output (that used the method of least squares), what is the cost formula for the receiving activity? 16. Using the cost formula you derived in question 15, how much would the total predicted cost be wit purchase orders? 17. The standard crrorche regression Using this information, your answer to items 15 and 16, and Exhibit 3.14 below, what is the pnfidence interval for the urchase order estimate? EXHIBIT 3.14 Table of Selected Values: t Distribution 90% 95% 99% Degrees of Freedom 1 6.314 12.708 63.657 2 2.920 4.303 9.925 3 2.353 3.182 5.841 4 2.132 2.776 4,604 5 2.015 2.571 4.032 6 1.943 2.447 3.707 7 1.895 2.365 3.499 8 1.860 2.306 3.355 9 1.833 2.262 3.250 10 1.812 2.228 3.169 11 1.796 2.201 3.106 12 1.782 2.179 3.055 13 1.771 2.160 3,055 14 1.761 2.145 3.012 15 1.753 2.131 2.947 16 1.746 2.120 2.921 17 1.740 2.110 2.898 18 1.734 2.101 2.878 19 1.729 2.093 2.861 20 1.725 2.086 2.845 30 1.697 2.042 2.750 00 1.645 1.960 2.576 *Values are based on the assumption that two tals are important-- they would be with confidence intervals and hypothesis tests of regression coefficients **For values above 30, simply use the last row