Hi, I am stuck on this chart please take a look at the attached file which shows the entire problem. Can you also provide me with the formula you used to get the numerical figures for indirect factory labor, power and light and indirect materials for the different quantities. Thank you.

Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 18,000 hours of productive capacity in the department: Leno Manufacturing Company - Press Department Factory Overhead Cost BudgetPress Department For the Month Ended October 31 1 Variable overhead cost: 2 Indirect factory labor 3 Power and light 4 Indirect materials $144,000.00 7,200.00 82,800.00 5 Total variable overhead cost $234,000.00 6 Fixed overhead costs: 7 Supervisory salaries $78,000.00 8 Depreciation of plant and equipment 48,000.00 9 Insurance and property taxes 28,000.00 10 Total fixed overhead cost 11 Total factory overhead cost 154,000.00 $388,000.00 Assuming that the estimated costs for November are the same as for October, prepare a flexible factory overhead cost budget for the Press Department for November for 16,000, 18,000, and 20,000 hours of production This is what I have so far. Please tell me the formula to figure out the first few lines when you provide tour response thank you. Direct labor hours 1 16,000 18,000 20,000 2 Variable overhead cost: Indirect fact 3 $128,000.00 $144,000.00 Pow er and l Indirect mate 4 5 7,200.00 82,800.00 Total variabl 6 $234,000.00 7 Fixed overhead cost: Supervisory Depreciation 9 10 48,000.00 Insurance a 8 $78,000.00 28,000.00 28,000.00 48,000.00 28,000.00 $154,000.00 $154,000.00 $154,000.00 Total factory 12 48,000.00 $78,000.00 Total fixed o 11 $78,000.00 $388,000.00