DeWitt Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from $167,300 to $202,400. Variable costs and their percentage relationship to sales are: Sales Commissions 6%, Advertising 5%, Traveling 3%, and Delivery 2%. Fixed selling expenses will consist of Sales Salaries $34,721, Depreciation on Delivery Equipment $6,948, and Insurance on Delivery Equipment $1,115.
Prepare a monthly flexible budget for each $11,700 increment of sales within the relevant range for the year ending December 31, 2014