The Production Department planned to work 8,000 labor-hours in March; however, it actually worked 8,400 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor Indirect labor $ 134,730 $ 19,860 Utilities $ 14,570 Supplies $ 4,980 Equipment depreciation $ 54,080 Factory rent $ 8,700 Property taxes Factory administration 69 $ 2,100 $ 26,470 Required: 1. Prepare the Production Department's planning budget for the month. 2. Prepare the Production Department's flexible budget for the month. 3. Prepare the Production Department's flexible budget performance report for March, including both the spending and activity variances. John Fleming, chief administrator for Valley View Hospital, is concerned about the costs for tests in the hospital's lab. Charges for lab tests are consistently higher at Valley View than at other hospitals and have resulted in many complaints. Also, because of strict regulations on amounts reimbursed for lab tests, payments received from insurance companies and Governmental units have not been high enough to cover lab costs. 4