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:
- 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.
- What would Quality Tools estimated costs be if it had sales of $12,500,000 next month?
- 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
Get step-by-step solutions from verified subject matter experts
