Question: High-Low Method Quality Tools. Quality Tools Incorporated would like to estimate costs associated with its sales personnel. Salespeople are paid a salary plus commission. Commission

High-Low Method Quality Tools. Quality Tools Incorporated would like to estimate costs associated with its sales personnel. Salespeople are paid a salary plus commission. Commission rates vary among products and are based on sales dollars. The company reported the following monthly cost data related to sales personnel:

Reporting Period (Month) Total Costs Sales Amount
January $710,000 $13,800,000
February 695,000 13,600,000
March 765,000 15,100,000
April 650,000 12,000,000
May 775,000 15,500,000
June 750,000 14,700,000
July 715,000 14,500,000
August 680,000 13,100,000
September 830,000 16,500,000
October 815,000 16,000,000
November 800,000 15,600,000
December 690,000 13,200,000

Required:

  1. Use the four steps of the high-low method to estimate total fixed costs per month and the variable cost per sales dollar. State your results in the cost equation form Y = f + vX by filling in the dollar amounts for f and v.
  2. What would Quality Tools estimated costs be if it had sales of $12,500,000 next month?
  3. What would Quality Tools estimated costs be if it had sales of $20,000,000 next month? Why should you feel uncomfortable estimating costs for $20,000,000 in sales?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!