Please help me to solve this question.

The following budget is an excerpt of the budget planning being done at XYZ Corporation for the year 2021

Q1....................... Q2.......................... Q3.......................... Q4............................ Year Units sold 24,000................. 31,000.................... 28,000.................... 35,000........................ 118,000

Selling and Administrative Expenses Budget

The companys variable expenses include:

Shipping expenses: $1.20 per unit Sales commissions: $1.30 per unit Other expenses: $2.30 per unit

The companys fixed expenses are:

Advertising: $40,000 per quarter Salaries $150,000 per quarter Depreciation: $30,000 per quarter Other: $50,000 per quarter

Also, executive bonus payments of $25,000 will be made in Q2, and a corporate event of $15,000 will be paid in Q3.

Required: Prepare the companys selling and administrative budget for the upcoming year. Disclose both total selling and administrative expenses and cash disbursements for selling and administrative expenses.