1 2 5 6 71 0910 11 12 13 14 15 Amanda is an accountant for IPC Sporling Equipment Ply Itd. The company sells one type of surfboard and has the following sales budget for that 2022 Expected sales units Selling Price Budgeled Sales revenue Q1 Q2 Q3 04 Total 12000 13000 14000 15000 54000 $50 $50 $50 $50 $50 $600,000 $650,000 $700,000 $750,000 $2,700,000 Amanda would like to prepare a production budget. It is estimated that the beginning Inventory for Q1 (2022) will be 1500 surfboards, which cost $35000 to produce in 2021 The inventory manager wants to ensure the ending inventory for each quarter is half the expected sales for the following quarter Expected sales for Q1 (2023) are 2500 surfboards. Required: a Prepare the producion budget in unils for Q1, Q2, Q3 and 24 for year 2022 Show your calculations. 14 marks] b Amanda prepares a materials budget for 2022. Each Surfboard requires a square metre (m) of fibre board. The opening material inventory is 550m? at $90 per m Amanda wants the material inventory at the end of each quarter to increase to 2000m2 al $90 per m2. The material cost is not expected to change in next year 15 marks] Why it is vital for Amanda to work together with her manager on production and material budget? [2 marks] d What could be some differences between budget prepared for a manufacturing enterprise such as IPC and that by a retail organisation which is involved in selling surfboards manufactured by IPC. [2 marks] e How would you identify and investigate budget variance? Why is this important for accountants? [2 marks]