Download High-Low Method for Mixed Costs: Lab Exercise 1 Answer Key and more Cheat Sheet Cost Accounting in PDF only on Docsity!
BM
01 Laboratory Exercise 1 Answer Key _Property of STI_* Page 1 of 2
Laboratory Exercise
Applying High-Low Method in Separating
Mixed Costs using MS Excel
Machine Hours and Utility Costs for Automotive Inc.
Month Machine Hours Utility Costs
November 4,500 65,
March 1,900 28,
Difference 2,600 37,
Variable Cost (VC) per unit 14.
Highest Level variable cost 64,038.
Lowest level variable cost 27,038.
Highest Level fixed cost 961.
Lowest level fixed cost 961.
Table 1. Machine Hours and Utility Costs for Automotive Inc.
BM
01 Laboratory Exercise 1 Answer Key _Property of STI_* Page 2 of 2
Table 2. High-low method of machine hours and utility costs for Automotive Inc.
Rubric for grading the output:
CRITERIA PERFORMANCE INDICATORS POINTS Neatness and Organization
The spreadsheet has exceptional formatting, and the information is well- organized.
Formulas The spreadsheet formulas are well-developed and will correctly determine the needed information.
Titles, Labels, and Headings The spreadsheet contains clearly labeled rows and columns.^10
Content
The spreadsheet meets all the necessary requirements to interpret the result of the operation.
TOTAL 100
Graph 1. Machine Hours and Utility Costs for Automotive Inc.
