PLEASE HELP ME WITH THIS FLEX BUDGET. THANKYOU

Requirements: Assemble a flexible budget containing the following fixed and variable costs.

Assumptions:

Per unit

Per Qtr

Per Year

Variable cost

$ 30.00

Variable selling and admin expenses

$ 10.00

Fixed selling and admin expenses

$ 20,000

Insurance expensed by quarter

$ 12,600

Office salaries

$ 40,000

Taxes paid at end of the year

$ 7,400

Sales Budget

Qtr 1

Qtr 2

Qtr 3

Qtr 4

Year

Expected sales in units

1000

1800

2000

1200

Unit sales price

$ 150

$ 150

$ 150

$ 150

Total sales