gxwHMsSvgtjkswDhMzxNWdMmxpT?projector=1&messagePartld=0.2 Question 2: (14 marks) Sanitex Inc. manufactures "Purox, a hand sanitizer liquid at its Kamloops production facilities. The marketing department has forecasted the following sales of Purox for the next 5 months: Months Forecasted Sales April June July August 300 400 500 600 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 cnough finished goods inventory to satisfy 20% of the next month's estimated sales. At the end of March, Sanitex had 60 barrels of Purox 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. Recuired Part 1: Prepare a production budget for the second quarter of the year April to June showing the barrel Punas to homectus Part 2: Pem en t e sesonger or the year im Winter 2020 - Word Search ces Mailings Review View Help l AaBbc | | Emphasis Heading I Normal Strong Paragraph August Styles 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 Puros in ending inventory. To manufacture a barrel of Purex, 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. T 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