Please complete questions 1 and 2.

Please include each formula used within an excel table. Thank you!

The Pickachip Company produces and sells organic plain potato chips. The one-pound family size bag of chips has two direct materials - potatoes and packaging. Pickachip is preparing budgets for the second quarter ending June 30, 2022. For each requirement below prepare budgets by month for April, May, and June, and a total budget for the quarter. 1. The previous year's sales (2021) for the corresponding period were: April 85,000 bags May 90,000 bags June 100,000 bags July 95,000 bags August 100,000 bags The company expects the above volume of sales to increase by 10% for the period April 2022 - August 2022. The budgeted selling price for 2022 is $11.50 per bag of chips. The company expects 10% of its sales to be cash (COD) sales. The remaining 90% of sales will be made on credit. Prepare a Sales Budget for Pickachip. - The company expects the above volume of sales to increase by 10% for the period April 2022 - August 2022. The budgeted selling price for 2022 is $11.50 per bag of chips. The company expects 10% of its sales to be cash (COD) sales. The remaining 90% of sales will be made on credit. Prepare a Sales Budget for Pickachip. 2. The company desires to have finished goods inventory on hand at the end of each month equal to 11 percent of the following month's budgeted unit sales. On March 31, 2022, Pickachip expects to have 10,285 bags of chips on hand. Prepare a Production budget