Prepare a flex budget

$\backslash$table$[[,$A$,,$B$,$C$,$D$,E$

prepare a flex budget BARTON ROBOTICS Manufacturing Overhead Static Budget Report For theYear Ended December 31 , 2022 9 10 12 13 14 Production in un Costs Indirect materials Indirect labour Utilities De preciation Property taxes Su rvision Bud t 10,000 s 250000 190.000 280,000 70,000 50 ooo 1 100000 Actual s 12,000 295.000 312.000 280000 70000 50 ooo Diffe rence Favourable - F Unfavourable - U 45,000 52,000 35,000 0 0 1.0 What would the volume variance be ? 2.0 Ifthe actual data given was just for one period, say the month ended August 31st, but the budget given was based on annual numbers how would this change how you prepare the flexible budget for August? 3.0 If utilities of $190,000 were a mixed cost with the fixed component equal to this change how you prepare the flexible budget for August?