Please complete questions 5 and 6. 1. is provided for data. Please show formulas within excel data 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% 5. Pickachip budgets indirect materials (e.g., salt, oil) at $0.06 per bag. Pickachip treats indirect labor and utilities as mixed costs. The variable components are $0.40 per bag for indirect labor and $0.20 per bag for utilities. The following fixed costs per month are budgeted for indirect labor, $25,000, utilities, $5,000, and other, $12,000. Prepare a Manufacturing Overhead budget. 6. Variable selling and administrative expenses are $1.20 per bag of chips sold. Fixed selling and administrative expenses are $45,000 per month. These costs are not itemized, i.e., the budget has only two line items variable operating expenses and fixed operating expenses. Prepare an Operating Expenses budget. 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