please complete 7 and 8 with excel formulas. 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% 7. Prepare a Budgeted Manufacturing Cost per unit budget. Refer to exhibit 9-11 for guidance. To calculate FMOH/unit calculate total FMOH for the year and divide this by budgeted production for the year. The total production volume for the year is budgeted at 900,000 bags. 8. Prepare a Budgeted Income Statement for the quarter for Pickachip. Assume interest expense of $0, and income tax expense of 22% of income before taxes. Pickachip's goal for the quarter is to make its net income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to "Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue 10%) is met or not. >