expand icon
book Cornerstones of Cost Management 2nd Edition by Don Hansen ,Maryanne Mowen cover

Cornerstones of Cost Management 2nd Edition by Don Hansen ,Maryanne Mowen

Edition 2ISBN: 978-1111824402
book Cornerstones of Cost Management 2nd Edition by Don Hansen ,Maryanne Mowen cover

Cornerstones of Cost Management 2nd Edition by Don Hansen ,Maryanne Mowen

Edition 2ISBN: 978-1111824402
Exercise 15
High-Low Method, Method of Least Squares, Correlation, Confidence Interval
Big Mike's, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controller's department, believes that overhead activities and costs should be classified into groups that have the same driver. He 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 receiving orders. The 10 months of data shown on page 134 have been gathered for the receiving activity.
High-Low Method, Method of Least Squares, Correlation, Confidence Interval  Big Mike's, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controller's department, believes that overhead activities and costs should be classified into groups that have the same driver. He 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 receiving orders. The 10 months of data shown on page 134 have been gathered for the receiving activity.     Required:  1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination? 5. Prepare a 95 percent confidence interval for receiving costs when 1,200 receiving orders are expected.
Required:
1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders.
2. Select two points that make the best fit, and compute a cost formula for receiving costs.
3. Using the high-low method, prepare a cost formula for the receiving activity.
4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?
5. Prepare a 95 percent confidence interval for receiving costs when 1,200 receiving orders are expected.
Explanation
Verified
like image
like image
close menu
Cornerstones of Cost Management 2nd Edition by Don Hansen ,Maryanne Mowen
cross icon