If the first picture is not clear, please look at the following picture.

Woodplex Led is a medium-size company that specializes in making a hand-made furniture cover. The company has been relatively successful over the years due to its good quality product and the good relations it has with its suppliers of materials and staff on the production line. Woodplex Lid's management, however, anticipates the market becoming more competitive in the near future, not least dae to the weak UK cconomy and forecasts of slow growth. They are now seeking a way to lower the price of their product. A cheaper substitute material has been identified for the furniture cover but securing this material would involve signing a long-term contract with a new supplier. Woodplex Lid's management believe that it would be pradeni to delay signing a long-term contract untilan analysis can be made of how switching to a new material (and supplice) would affect the production process and operating profit. As a result of the above concern, the prospective supplier was therefore asked to supply Woodplex Lid the materials they needed for production during the most recent quarter. The managing director of Woodplex Lad has now asked for your help on this matter. You have been provided with the following standard cost data (1.0, based on the old supplier) and budgets. Unit selling price 300.00 Less: Direct materials: 2.5 metres 4.00 per metre Direct labour: 5 hours 24.00 per hour Variable overhead: 4.00 per direct labour hour Contribution 10.00 120.00 20.00 15000 Budget (based on old material supplier) 20,000 units Actual (based on new material supplier) 22.000 units Output (production and sales) Sales revenue Less: Direct materials Direct labour Variable overheads Fixed overheads Operatine toit 6,000,000 200,000 2,400,000 400,000 160,000 6.380,000 171,600 3,168,000 501,600 164,000 Actual direct material usage totalled 57,200 metres. All materials used during the quarter were sourced from the prospective supplier A total of 132.000 direct labour hours were worked during the quarter. During the quarter, a promotional price for the furniture cover was introduced following the recommendation of Woodplex Lid's marketing director. The marketing director argued that this would not only boost sales but also provide an opportunity to evaluate how customers would respond to their product when the substitute material is used. Woodplex Laduses a standard variable costing system for intermal reporting purposes Required: (a) Prepare a flexed budget that takes into account the change in output and sales during the quarter, based on the material from the new supplier (15 Marks) (b) Calculate for the quarter: 1) Sales margin price and volume variances ii) Direct material quantity and price variances i) Direct labour efficiency and rate variances iv) Variable overhead efficiency and spending variances v) Fixed overheads spending variance (25 Marks) (c) Drawing on your answers in (a) and (b) and any other financial or non-financial consideration you think would be relevant in this case, advise Woodplex Ltd whether or not it should sign a long-term contract with the new supplier. (10 Marks) TOTAL: 50 MARKS Please answer all the calculation questions. Woodplex Ltd is a medium-size company that specializes in making a hand-made furniture cover. The company has been relatively successful over the years due to its good quality product and the good relations it has with its suppliers of materials and staff on the production line. Woodplex Ltd's management, however, anticipates the market becoming more competitive in the near future, not least due to the weak UK economy and forecasts of slow growth. They are now seeking a way to lower the price of their product. A cheaper substitute material has been identified for the furniture cover but securing this material would involve signing a long-term contract with a new supplier. Woodplex Ltd's management believe that it would be prudent to delay signing a long-term contract until an analysis can be made of how switching to a new material (and supplier) would affect the production process and operating profit. As a result of the above concern, the prospective supplier was therefore asked to supply Woodplex Ltd the materials they needed for production during the most recent quarter. The managing director of Woodplex Ltd has now asked for your help on this matter. You have been provided with the following standard cost data (i.e., based on the old supplier) and budgets. Unit selling price 300.00 Less: Direct materials: 2.5 metres @ 4.00 per metre Direct labour: 5 hours @ 24.00 per hour Variable overhead: 4.00 per direct labour-hour Contribution 10.00 120.00 20.00 150.00 Output (production and sales) Sales revenue Less: Direct materials Direct labour Variable overheads Fixed overheads Operating profit Budget Actual (based on old (based on new material/supplier) material/supplier) 20,000 units 22,000 units 6,000,000 6,380,000 200,000 171,600 2,400,000 3,168,000 400,000 501,600 160,000 164,000 2.840.000 2,374.800 Actual direct material usage totalled 57,200 metres. All materials used during the quarter were sourced from the prospective supplier. A total of 132,000 direct labour hours were worked during the quarter. During the quarter, a promotional price for the furniture cover was introduced following the recommendation of Woodplex Ltd's marketing director. The marketing director argued that this would not only boost sales but also provide an opportunity to evaluate how customers would respond to their product when the substitute material is used. Woodplex Ltd uses a standard variable costing system for internal reporting purposes. Required: (a) Prepare a flexed budget that takes into account the change in output and sales during the quarter, based on the material from the new supplier. (15 Marks) (b) Calculate for the quarter: i) Sales margin price and volume variances ii) Direct material quantity and price variances iii) Direct labour efficiency and rate variances iv) Variable overhead efficiency and spending variances v) Fixed overheads spending variance (25 Marks) (e) Drawing on your answers in (a) and (b) and any other financial or non-financial consideration you think would be relevant in this case, advise Woodplex Ltd whether or not it should sign a long-term contract with the new supplier. (10 Marks) [TOTAL: 50 MARKS