Help me with a flexible budget excel spreadsheet Part $2)$ DIRECTIONS for Flexible Budget Performance Report:

$1)$ Copy and Paste all of the line items $($account names$)$ from the master budget performance report into the Flexible Budget Performance report.

$2)$ Copy and Paste all of the actual figures to the actual column of the Flexible Budget Performance report.

$3)$ Formulate the Master Budget figures by referencing the appropriate cells in the master budget performance report $($e$.$g$.=$B$7).$ By doing so$,$ If any assumptions change, they will ripple through BOTH performance reports.

$4)$ Build the Flexible Budget by using the ACTUAL SALES VOLUME achleved along with the original budget assumptions. This is very similar to building a master budget, except you are using actual sales volume. Assume the actual sales volume achieved is in the same relevant range as the original budget assumptions.

$5)$ Try using the "accounting" or "currency" settings to get dollar signs, commas, and brackets on negative numbers. Add underlines and double underlines as needed. Remove any decimals.

$6)$ Head the appropriate column for the Volume Variance and then use Excel formulas to populate the cells in that column $($e$.$g$.,+$ H$33-$J$33).$ Once you get the first cell done, copy and paste $($or drag$)$ the formula to the other cells.

$7)$ Head the appropriate column for the Flexible Budget Variance and then use Excel formulas to populate the cells in that column $($e$.$g$.+$ F$33$H$33).$ Again, copy and paste the formulas to the other cells.

$8)$ Use the following check figures to check your formulas so far:

Shipping Expense: $\backslash (\backslash$$ $44,213\backslash$$ $1,293\backslash$$ $42,920\backslash$quad $\backslash$$ $2,920\backslash$$ $40,000\backslash )$

$9)$ Format cells appropriately. Attention to detail makes a report lookmore professional. $($For example, dollar signs using the accounting or currency format, underlines and double underlines where appropriate, zero decimal places for dollar amounts, etc.,$).$

$10)$ To save time, we won't add the $\backslash ($ U $\backslash )$ and $\backslash ($ F $\backslash )$ designations to the flexible budget performance report. However, you'll need to mentally figure out which way they go$.$ The interpretation of the volume variance is a little problematic because it compares two budgets, rather than budget vs$.$ actual. HINT: Think of the MASTER BUDGET as the company's target when determining whether the volume variance should be designated as $\backslash (\backslash$mathrm$\{$I$\}$ U $\backslash )$ or $\backslash ($ F $\backslash ).$

$11)$ Complete worksheet: Analysis$-$ page $1.$

$12)$ Complete worksheet: Analysis$-$ page $2.$