C | Chegg.com S MySeneca homepage Content S Academic Skills Return on Investment (ROI): | | + AutoSave Off Homework #3 v Search (Alt+Q) Sabita Chhengutala File Home Insert Draw Page Layout Formulas Data Review View Automate Help Comments Share General Calibri 12 ' ' Conditional Formatting $ % 9 Format as Table Insert Delete 48 Paste I U v Cell Styles Format Sort & Find & Filter Select v Analyze Sensitivity Data > Alignment > Number Styles Cells Editing Analysis Sensitivity Undo Clipboard Font A1 X fx A B D E F G H 1 2 Bushman Ltd is preparing its manufacturing overhead budget for 2022. Relevant data 3 are as follows: 4 5 6 1. Units to be produced (by quarters): 10,000, 12,000, 15,000, 18,000 7 2. Direct labour: 1.5 hours per unit 8 3. Variable overhead costs per direct labour hour 9 Indirect materials $0.70 10 Indirect labour $1.20 11 Maintenance $0.50 12 4. Fixed overhead costs per quarter Supervisory salaries $35,000 13 14 Depreciation $16,000 15 Maintenance $15,000 16 17 Prepare the manufacturing overhead budget for the year, showing quarterly data. (15 marks) 18 19 20 21 22 J K L M N P Q R S T U V W X Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Cover page Ready Accessibility: Good to go Q1 Q2 Q4 Q5 Q6 Q7 Q8 2C Mostly cloudy O Search ZOUDE ENG US + 82% 1:27 AM 2022-11-22