Chapter 9 Assignment i Saved Problem 9-25 Applying the Flexible Budget Approach (LO3, L04] 15 points The Centrico Medical Laboratory, a government-sponsored charity, is located on the island of Ste. Lucretia. The laboratory has just finished its operations for September, which was a particularly busy month due to a chemical spill that affected a few neighbouring small islands, causing many illnesses. The chemical spill and contamination largely bypassed Ste. Lucretia's water supply, but residents of Ste. Lucretia willingly donated supplies and the laboratory assisted in the medical testing to help people on other islands. As a consequence, the medical laboratory collected and processed over 25% more laboratory samples from potentially ill residents than had been originally planned for the month. A report prepared by a government official comparing actual costs to costs included in the static budget for the medical laboratory appears below. (The currency in Ste. Lucretia is the East Caribbean dollar.) Continued support from the government depends on the lab's ability to demonstrate control over its costs: eBook Ask Chapter 9 Assignment (i Saved CENTRICO MEDICAL LABORATORY Cost Control Report For the Month Ended September 30 Static Budget Variance 230.00 Static Budget 770.00 Actual 1,000.00 Laboratory samples collected 15 points Variable costs: Medical supplies Lab tests Refreshments for staff and volunteers Administrative supplies $16,408.00 17,985.00 1,886.00 280.00 $11,935.00 14,476.00 1,540.00 462.00 $4,473.00 3,509.00 346.00 (182.00) eBook Ask Total variable cost 36,559.00 28,413.00 8,146.00 Print Fixed costs: Staff salaries Equipment depreciation Rent Utilities 286.00 20,500.00 3,206.00 2,600.00 518.00 20,500.00 2,920.00 2,600.00 485.00 33.00 Total fixed cost 26,824.00 26,505.00 319.00 Total cost $63,383.00 $54,918.00 $8,465.00 The managing director of the medical laboratory is very unhappy with this report, claiming that his costs were higher than expected due to the emergency on the neighbouring islands. He also points out that the additional costs were fully covered by payments from grateful recipients on the other islands. The government official who prepared the report counters that all of the figures were submitted by the medical laboratory to the government; he was just pointing out that actual costs were considerably higher than promised in the budget. Required: Chapter 9 Assignment i Saved Required: 1. Prepare a new performance report for September using the flexible budget approach. (Note: Even though there are no revenues in this setting, the flexible budget approach can still be used to prepare a flexible budget performance report. (Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance). Round your answers to 2 decimal places.) 15 points Centrico Medical Laboratory Flexible Budget Performance Report For the Month Ended September 30 Flexible Actual Costs Budget Cost Formula Incurred for Based on (per unit) 1,000 Lab 1,000 Lab samples samples eBook Costs Flexible Budget Variance Ask Print Variable costs: Medical supplies Lab tests Refreshments for staff and volunteers Administrative supplies Total variable cost Fixed costs: Staff salaries Equipment depreciation Rent Utilities Total fixed cost Total cost Chapter 9 Assignment i Saved Problem 9-15 Direct Materials Purchases and Direct Labour Budgets (LO2] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 15 points 1st Quarter 5,900 2nd Quarter 8,900 3rd Quarter 7,900 4th Quarter 6,900 Units to be produced Skipped In addition, 6,900 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,780. eBook Ask Print Each unit requires 8.90 grams of raw material that costs $1.20 per gram. Management desires to end each quarter with an inventory of raw materials equal to 10% of the following quarter's production needs. The desired ending inventory for the 4th quarter is 8,900 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter. Each unit requires 0.20 direct labour-hours and direct labourers are paid $9.70 per hour. Chapter 9 Assignment i Saved Required: 1. Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for materials for the upcoming fiscal year. Zan Corporation Direct Materials Budget 1st Quarter 2nd Quarter 15 3rd Quarter 4th Quarter Year points Skipped Required production in units of finished goods Units of raw materials needed per unit of finished goods Units of raw materials needed to meet production 0 0 0 0 eBook Total units of raw materials needed 0 0 0 Ask Print 0 0 0 0 Units of raw materials to be purchased Unit cost of raw materials Cost of raw materials to be purchased % 0 % 0 % 0 % 0 % Chapter 9 Assignment i Saved Schedule of Expected Cash Disbursements for Materials Beginning accounts payable 1st Quarter purchases 2nd Quarter purchases 3rd Quarter purchases 4th Quarter purchases Total cash disbursements for materials $ 0 $ 0 $ 0 $ 15 points 0 $ 0 Skipped eBook Ask 2. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced. Print Zancor Zan Corporation Direct Labour Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Required production in units Direct labour-hours per unit Total direct labour-hours needed Direct labour cost per hour Total direct labour cost $ 0 $ 0 $ 0 $ 0 $ 0