Need help with assignement. The last two are following Excel examples of how the assignment is supposed to look.

Thank you in advance and if you have any questions please let me know!

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. 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. 3. The final product (bags of chips) requires two direct materials: potatoes and packaging Potatoes 4 pounds of raw potatoes are required for each one-pound bag of potato chips. Management desires to have materials on hand (ie, pounds of potatoes) at the end of each month equal to 20 percent of the following month's production needs. The beginning materials inventory. April 2022. is expected to be 75.284 pounds. Potatoes cost $1.20 per pound Packaging Packaging material is purchased by the roll and 50 bags of chips are produced from each roll. The packaging is made from biodegradable, organic plant fiber that extends the shelf life of the potato chips while preserving its freshness. Management desires to have packaging on hand at the end of each month equal to 12 percent of the following month's production needs. The beginning inventory of packaging en rolls of packaging material) in April 2022 is expected to be 226 rolls. Packaging is expected to cost $14 per roll. Note, budgeted production in July is required in order to complete the direct materials budget for June. Also, use the @ROUNDUP function to round up to the nearest whole number rolls of packaging material to purchase (DM units to purchase for packaging). Further, because two direct materials are required for production potatoes and rolls of packaging - you will need a separate schedule for each direct material. Prepare a Direct Materials budget. W. This assignment requires you to prepare budgets for the second quarter (April. May, and June). Thus, you do not need to make budgets for July and August except for Salesik and Production and Milbudssts. You need some information from July and August to complete Dune budget schedule in Production budget and DM budget However there is not enough information to complete Augustin "Production and July and Augustin DM budgets, so please fill out Joly and August as much as you can with given information and let them have blanks incomplete because you just need partial info from those months for June budget (ie to calculate Jungs ending inventory 4. Each bag of chips requires 0.12 hours of direct labor. Each hour of direct labor costs the company S18. Prepare a Direct Labor budget $ $ 15.00 35% 65% 8% A B GBCoffee Company 2020 Budget Assumptions B Prepared by: Student Name 41 5 Sales Budget Assumptions 6 Unit Price 7 Percentage of Cash Sale 8 Percentage of Credit sale 9 Expected sales increase 10 11 2019 Sales 12 April 13 May 14 June 15 July 16 August 17 18 19 Production Budget Assumptions 20 21 22 23 Direct Materials Budget Assumptions 24 25 26 50,000 bags 55,000 bags 90,000 bags 75,000 bags 60,000 bags 11% G H 1 GBCoffee Company 2 2020 Budget Assumptions Prepared by: Student Name 4 5 6 April May June Quarter July August April May June Quarter July August $ $ 54,000.00 59,400.00 97,200.00 210,600.00 15.00 $ 15.00 $ 15.00 $ 15.00 810,000.00 $ 891,000.00 $ 1,458,000.00 $3,159,000.00 81,000.00 64.800.00 $ 15.00 $ 15.00 $ 1,215,000.00 $ 972,000.00 35% $ 65% $ 283,500.00 $ 311,850.00 $ 510,300.00 $1,105,650.00 526,500.00 579, 150.00 947.700.00 2,053,350.00 810,000.00 $ 891,000.00 $ 1,458,000.00 $3,159,000.00 8 Sales Budget 9 Unit Sales 10 Unit Price 11 Sales Revenue 12 13 Cash Sale 14 Credit Sale 15 Total 16 17 18 Production Budget 19 Unit sales 20 Desired ending inventory 21 Total needed 22 Beginning inventory 23 24 $425 250.00 $ 340,200.00 789,750.00 631,800.00 $1,215,000.00 $ 972,000.00 April May June Quarter July August