static budget vs flexible budget

eBook Show Me How Pnnt item Static Budget versus Flexible Budget The production supervisor of the Machining Department for Celtic Company agreed Celtic Company Machining Department Monthly Production Budget Wages $446,000 Utilities 36,000 Depreciation 61,000 Total $543,000 The actual amount spent and the actual units produced in the first three months in Amount Spent Units Produced January 128,000 February $514,000 494,000 471,000 March 117,000 105,000 The Machining Department sunancicor ho eBook Show Me How Print Item February 494,000 117,000 March 471,000 105,000 The Machining Department supervisor has been very pleased with this performance $543,000. However, the plant manager believes that the budget should not remain Machining Department. Additional budget information for the Machining Departmen $16.00 Wages per hour Utility cost per direct labor hour $1.30 0.20 Direct labor hours per unit Planned monthly unit production 140,000 a. Prepare a flexible budget for the actual units produced for January, February, and per unit amounts carried out to two decimal places. Celtic Company-Machining Department Flexible Production Budget For the Three Months Ending March 31 January February Units of production 128,000 117.000 March 105,000 per unit amounts carried out to two decimal places. Celtic Company Machining Department Flexible Production Budget For the Three Months Ending March 31 January February March Units of production 128,000 117,000 105,000 Wages Utilities Depreciation Total