Question 5 (22 marks) One of your housemates has a new job as an assistant accountant for Windsor Pty Ltd One of her first tasks was to prepare a manufacturing performance report for the company's single product for June. While working at home her laptop suffered a fatal error. Using your laptop, she retrieves her backup but realises it has only some of the information she had prepared. She has to present at the management meeting tomorrow morning, and has asked for your help. The available information is presented below: Windsor Pty Ltd Manufacturing Performance Report for June 2018 Variable Overhead Direct Material Direct Labour Fixed Overhead Standard cost allowed for actual output Flexible (2 hrs $21/hr) (?kg@S18/kg) 7 $60,000 Budget for Overhead Actual Costs $283,500 (14,000@S20.25/kg) 7 ? (8,800 @?/hr) Variances: MPV MQV $9,000U $13,200U S4,200F LRV LEV VSV S 3,960U $ 1,800F VEV FBV $4.875U PVV ? In addition to this data, your housemate recalls the following: Budgeted production was 500 units more than actual production All direct material purchased in June was used in production Overhead is allocated on the basis of direct labour hours The fixed overhead budgeted allocation rate is $6/direct labour hour Required: (a) Prepare a worksheet or analysis showing each of the manufacturing cost variances (i.., for materials, labour and overheads) under standard costing Note: Some information is provided above but some is missing and needs to be determined. Use your worksheet/analysis to determine the following information to assist your housemate: (0 (ii) (ii) (iv) (v) (vi) (vii) (vii) (ix) Actual production in units Standard kilograms of Direct material allowed per unit Direct Material Price Variance Standard direct labour hours allowed per unit Actual Direct Labour Rate Budgeted Variable Overhead Rate Actual Variable Overhead costs Actual Fixed Overhead costs Production Volume Variance (9 marks) Question 5 (22 marks) One of your housemates has a new job as an assistant accountant for Windsor Pty Ltd One of her first tasks was to prepare a manufacturing performance report for the company's single product for June. While working at home her laptop suffered a fatal error. Using your laptop, she retrieves her backup but realises it has only some of the information she had prepared. She has to present at the management meeting tomorrow morning, and has asked for your help. The available information is presented below: Windsor Pty Ltd Manufacturing Performance Report for June 2018 Variable Overhead Direct Material Direct Labour Fixed Overhead Standard cost allowed for actual output Flexible (2 hrs $21/hr) (?kg@S18/kg) 7 $60,000 Budget for Overhead Actual Costs $283,500 (14,000@S20.25/kg) 7 ? (8,800 @?/hr) Variances: MPV MQV $9,000U $13,200U S4,200F LRV LEV VSV S 3,960U $ 1,800F VEV FBV $4.875U PVV ? In addition to this data, your housemate recalls the following: Budgeted production was 500 units more than actual production All direct material purchased in June was used in production Overhead is allocated on the basis of direct labour hours The fixed overhead budgeted allocation rate is $6/direct labour hour Required: (a) Prepare a worksheet or analysis showing each of the manufacturing cost variances (i.., for materials, labour and overheads) under standard costing Note: Some information is provided above but some is missing and needs to be determined. Use your worksheet/analysis to determine the following information to assist your housemate: (0 (ii) (ii) (iv) (v) (vi) (vii) (vii) (ix) Actual production in units Standard kilograms of Direct material allowed per unit Direct Material Price Variance Standard direct labour hours allowed per unit Actual Direct Labour Rate Budgeted Variable Overhead Rate Actual Variable Overhead costs Actual Fixed Overhead costs Production Volume Variance (9 marks)