# Question: CNX Motors is preparing a sales budget for the current

CNX Motors is preparing a sales budget for the current year for the service department that is based on last year’s actual amounts. Management is interested in understanding what might happen if the service department has an increase in sales volume (i.e., the number of mechanic hours) or an increase in the average revenue per mechanic hour. They believe it is unlikely that both would increase, due to economic conditions in the local market. Last year’s sales amounts were as follows:

Required

A. Compute the average revenue per mechanic hour for the current year based on last year’s actual data. You should round the average hourly rate to the nearest penny.

B. Prepare a monthly sales budget for the current year, assuming that monthly sales volume (i.e., mechanic hours) will be 10 percent greater than in the same month last year. Assume that the average revenue per mechanic hour is the same as you computed in question A. You should round budgeted hours to one decimal and budgeted revenues to the nearest dollar.

C. Prepare a monthly sales budget for the current year assuming that the average revenue per mechanic hour computed in question A increased by 5 percent. Assume that the number of mechanic hours stays the same as in the prior year. That is, there is no increase or decrease in the monthly sales volume. You should round the rate per mechanic hour to two decimals and budgeted revenues to the nearest dollar.

D. For the current year in total, is it more advantageous to increase sales volume by 10 percent or average revenue per hour by 5 percent? Remember the impact of variable and fixed costs on theseprojections.

Required

A. Compute the average revenue per mechanic hour for the current year based on last year’s actual data. You should round the average hourly rate to the nearest penny.

B. Prepare a monthly sales budget for the current year, assuming that monthly sales volume (i.e., mechanic hours) will be 10 percent greater than in the same month last year. Assume that the average revenue per mechanic hour is the same as you computed in question A. You should round budgeted hours to one decimal and budgeted revenues to the nearest dollar.

C. Prepare a monthly sales budget for the current year assuming that the average revenue per mechanic hour computed in question A increased by 5 percent. Assume that the number of mechanic hours stays the same as in the prior year. That is, there is no increase or decrease in the monthly sales volume. You should round the rate per mechanic hour to two decimals and budgeted revenues to the nearest dollar.

D. For the current year in total, is it more advantageous to increase sales volume by 10 percent or average revenue per hour by 5 percent? Remember the impact of variable and fixed costs on theseprojections.

## Answer to relevant Questions

Curiosity Corner sells books and various other reading-related products. One of the store’s most popular reading-related products is a book pillow for hard cover and soft cover books. The pillows each sell for $8.00. ...KenCor Pizza Emporium produces frozen pizzas for sale to grocery stores. The company has built a strong reputation for high-quality pizzas and has been profitable for a number of years. Because of increasing costs they are ...The static budget for the College Book Division of Chasse and Joos Publishers estimated sales revenue of $10,000,000 on sales of 165,000 units. The variable production costs (cost of goods sold) were estimated at $4,125,000, ...Multiple Choice Questions1. Which of the following statements about ratio analysis is not true?a. Financial ratios can show how a company has done in the past but are not very useful in predicting its future direction and ...Recent annual reports of two fast food chains (Company 1 and Company 2) reveal the following financial information (in millions):The income tax rate is 34 percent.RequiredA. Calculate the rate of return on assets for each ...Post your question