need help finishing this problem - please show work

Static Budget versus Flexible Budget The production supervisor of the Machining Department for Niland Company agreed to the following monthly state budget for the upcoming year Niland Company Machining Department Monthly Production Budget Wages $1,256,000 Utilities 84,000 Depreciation 140,000 Total $1,480,000 The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows: Amount Spent Units Produced January $1,396,000 128,000 February 1,339,000 117.000 March 1,274,000 105,000 The Machining Department supervisor has been very pleased with this performance because actual expenditures for January March have been significantly less than the month static budget of 1,400,000. However, the plant manager believes that the budget shold not remain fixed for every month but should exor adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows Wages per hour SLB cost per direct labor hour Direct labor hours per unit 0.5 Planned monthly unit production 140,000 . Prepare a rexile budget for the tual units produced for January, February, and March in the Machining Department Anume depreciation fue cow. If rouret, e per une amounts carried out to two decimal places Niland Company Machining Department Budget For the Three Months Ending March 31 January February March Units of production 120.000 117,000 105,000 Wees 33 X 12.166.000 1. X ORIES AUX 10,10X 11.000 x X O X Depreciation X Niland Company Machining Department Budget For the Three Months Ending March 31 January February Units of production 120,000 117.000 Wages 2.304,000 X 3.106,000 X Utilities 15,00 X 100,00 X Depreciation 64,000 X 51.500 X March 105,000 1.490,000 X 126,000 X $2.500 X 2,521,600 X 2.304.900 X 2,061.00 X Total Supporting calculations Units of production 120,000 0.51 117,000 0.5 105,000 25 Hours per unit Total hours of production 5.00 5250 X 6600 18 Wages per hour IN Total wages 1.153,000 11,00 50 X 500 $8.50 5.250 x Total hours of production Utility costs per hour 1.20 S 1.30 1.30 Total utilities 76.00 10.00 4,300 X Check wy Wort For each level of production, thow was and practice Lemon Obiectiv 2.caring Object March 2,068,500 b. Compare the flexible budget with the actual penditures for the first three months January February Total ble budget 2.521,600 X 2,304,900 Actual con 1,596.000 1.339,000 Faces of actual cost over budget 1,125,600 X 965,900 x 1.274,000 794,500 x 1.152,000 1.153.00 Total wages Total hours of production Utility costs per hour 64.000 $250 58.500 1.30 1.20 120 Total utilities 7610 70.2007 100 * Ca My H. For each level of production show wages, writes, and deprecation Learning Objective 2. Learning Obiective 4 b. Compare the nexible budget with the actual expenditures for the first three months January February Total flexible budget 2,521,600 X 2,304,900 X Actual cost 1,396,000 1,339,000 oss of actual cost over budget 1,125,600 x 55,900 X What does this comparison The Machining Department has performed better than originally thought No The department is spending more than would be expected VG March 2,068,500 X 1,274,000 794,500 X