Hi, I need help with creating a flexible budget with the provided data in the picture.

Thank you.

WEEK 5 LAB ASSIGNMENT Requirements: Assemble a exible budget containing the following xed and variable costs. Assumptions: Variable cost Variable selling and admin expenses Fixed selling and admin expenses Insurance expensed by quarter Oice salaries $ 40000 Taxes paid at end of the year Sales Budget Expected sales in units 1000 1800 Unit sales price $ 150 $ 150 $ 150 Total sales