Instructions: The attached excel file includes the raw data (which has not been reviewed for errors). A
Question:
Instructions:
The attached excel file includes the raw data (which has not been reviewed for errors). A second tab includes graphs that provide a visual analysis of each of the possible cost drivers against total operating cost. Review the results to determine if there are any outliers that should be corrected. It is noted that the intern has been known to have made mistakes in data entry before by entering double zeroes on accident. Also, there are no other known errors or outliers that should have occurred. Using the graphs, determine if there are any situations where this has occurred.
If any errors are discovered, they should be corrected (not deleted), and you should use the cleaned-up data file for the remainder of this assignment.
Questions:
3. Prepare a visual diagram of the relationship between total operating cost and the single best driver identified in question 2a above. Add a regression trend line to the graph.
a. What is the estimate of weekly fixed cost?
Round your answer to the nearest whole dollar.
b. What is the estimate of variable cost per unit of x?
Note: Round your answer to the nearest cent (two decimal places).
c. What percentage of the variation in operating cost can be explained by the single best cost driver?
Note: Round your answer to the nearest whole percentage (e.g., 0.195 = 20%).
4. Run a multiple regression that includes five possible cost drivers. You should omit any redundant variables that are perfectly correlated.
a. What percentage of the total variation in operating cost can be explained by all five cost drivers combined?
Note: Round your answer to the nearest whole percentage.
b. What percentage of the variation in operating cost is NOT explained this by this model?
Note: Round your answer to the nearest whole percentage.
5. Use the multiple regression model to predict the total annual operating cost for next year if the company expects 170,000 total meals produced (donated and customer meals combined), 8,000 direct labor hours, 30,000 meal kits delivered, 150 new menu items, and 750 shipments of donated meals.
Be sure to multiply the intercept by 52 weeks to convert from weekly to annual fixed cost.
Note: Round your final answer to the nearest $10,000 (to avoid rounding errors in the individual coefficients).
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley