hello so i am creating a master budget for uni and i am currently up to the overhead budget the budget is for one month.

Im stuck on the budgeted fixed overhead.

the annual fixed overhead is $115,614 how do i work this out because i feel like just dividing it by 12 wont be accurate for the month?

in my cost sheet the fixed overhead is 9.67 a unit. a unit takes 1.25 hours to produce. im not sure if that matters or helps?

AutoSave . Off ) excelmasterbudget . Saved 9 Search (Alt+Q) Mathew Favero MF X File Home Insert Page Layout Formulas Data Review View Help Comments Share Insert Calibri 11 ~ A A al Wrap Text Currency Ex AY O LA Ex Delete Paste Sort & Find & BID ~ ~ OVA v E Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Analyze = Formatting " Table Styles Format Filter ~ Select Data Clipboard Font N Alignment Number Styles Cells Editing Analysis B8 X V A B C D E F G H - Koala Rescue Bear Company-Koala Rescue Bear Division W N - Overhead budget For the month ending 31st of March 2022 4 Budgeted direct machine hours 1307.5 5 Variable overhead rate x$0.36 6 Budgeted variable overhead *$471 7 Budgeted fixed overhead 8 Total overhead 10 11 12 13 14 15 16 17 18 19 20 21 Cost Sheet Sales Budget Production Budget Direct materials budget Direct labour budget ... (+ Ready + 100% 1 0 0 ED( V) ENG 9:30 PM Type here to search O 99+ W X 10/03/2022