Need help preparing a flexible manufacturing overhead budget

prepared based on machine hours. Given the range of activity above,Prepare the budget using increments of 1,000 machine hours. Info in pic, spreadsheet pic attached just to show layout needed

The following budget information relates to I Company. 1|ul'ariable manufacturing overhead costs per machine hour are as follows Expected annual operating capacity 120,000 Direct Labor Hours 1|ul'ariable overhead costs Indirect labor $310,000 Indirect materials 100,000 Factory supplies 34,000 Total variable 444,000 Fixed overhead costs Depreciation 1?0,000 Supervision 120,000 Property taxes 95,000 Total fixed 335,000 Total costs The relevant range for monthly activity is expected to be between 10,000 and 12,000 direct labor hours. Instructions The Company would like a flexible manufacturing overhead budget prepared based on machine hours. Given the range of activity above,Prepare the budget using increments of 1,000 machine hours.