Please complete the Selling and Administrative Expense Budget, and show your Excel formulas supporting your answer. Thank you

Buff Company expects variable selling and administrative expenses to fluctuate with unit sales volume according to the following rates Sales commissions: $3.30 pr unit sold 1.60 per unit sold Freight-out: $ Buff Company also incurs fixed selling and administrative expenses. The amounts of fixed selling and administrative expenses are already provided in the budget below. Use this information to complete the Selling and Administrative Expense Budget. Buff Company Selling and Administrative Expense Budget For the year ending December 31, 2017 Quarter 4 3,100 Year 9,500 1,400 2,400 Budgeted sales in units Variable expenses 2,600 Sales commissions ($3.30 per unit) Freight-out ($1.60 per unit) Total variable expenses Fixed expenses Advertising Sales salaries Office salaries Depreciation Property taxes and insurance $3,500 $13,300 $6,700 $1,400 $1,800 $3,500 $13,300 $6,700 $1,400 $1,800 $3,500 $13,300 $6,700 $1,400 $1.800 $3,500 $13,300 $6,700 $1,400 $1,800 $14,000 $53,200 $26,800 $5,600 $7.200 Total fixed expenses Total selling and administrative expenses