Question

Fallon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $172,800 to $215,400. Variable costs and their percentage relationship to sales are sales commissions 7%, advertising 4%, traveling 4%, and delivery 1%. Fixed selling expenses will consist of sales salaries $35,500, depreciation on delivery equipment $7,500, and insurance on delivery equipment $1,100.
Required:
Prepare a monthly flexible budget for each $11,100 increment of sales within the relevant range for the year ending December 31, 2017.

Answer 1

Answer:

Sales Revenue   Total expenses  

   $172,800               $71,748

   $183,900               $73,524

   $195,000              $75,300

  $206,100               $77,076

Explanation:

Note: See the attached excel file for the monthly flexible budget for the year ending December 31, 2017.

Also note that since it is stated that the budget must be for each $11,100 increment of sales within the relevant range of $172,800 to $215,400 of monthly expected sales, the highest expected sales that fall within the range is $206,100 in the attached excel file.

From the attached excel file, we have:

Sales Revenue   Total expenses  

   $172,800               $71,748

   $183,900               $73,524

   $195,000              $75,300

  $206,100               $77,076

Download xlsx