this is intro managerial accounting

Question 2: (14 marks) Sanitex Inc. manufactures "Purox", a hand sanitizer liquid at its Kamloops production next 5 months: facilities. The marketing department has forecasted the following sales of Purox for the Months Forecasted Sales April (in barrels) 300 May 400 June 500 July 600 August 700 The significant increase in sales is a reflection of the marketing department's belief that with the progression of the Covid-19 pandemic, people will buy more of the sanitizer. The company policy is to have enough finished goods inventory to satisfy 20% of the next month's estimated sales. At the end of March, Sanitex had 60 barrels of Purex in ending inventory. To manufacture a barrel of Purox, 12 liters of a powerful disinfectant called "Super Clorox" are needed. Sanitex Inc. purchases Super Clorox at a price of $1.50 per liter. Super Clorox is often in short supply and therefore Sanitex has a policy of maintaining an inventory at the end of each month equal to 30% of the next month's production needs. Unfortunately, Sanitex was not able to meet this requirement at the end of March and was left with only 720 liters of Super Clorox to begin the month of April. Note to students: Answer the question in the Excel worksheet template under the tab "Question 2" provided by your instructor. Required: Part 1: Prepare a production budget for the second quarter of the year (April to June) showing the barrels of Purox to be manufactured. Part 2: Prepare a raw materials purchase budget for the second quarter of the year showing the amount and cost of Super Clorox to be purchased, Note For both budgets, you must show a total column for the quarter in addition to each separate month