please help me with this! answer all the parts. thank you so much! i really really appreciate it!!

Required information Chapter 8: Applying Excel [LO8-2, LOB-3, LO8-4] The Chapter 8 Fonm worksheet is to be used to create your own worksheet version of the Roview Problem in the text. Chapter 8: Applying Excel: Excel Worksheet (Part 1 of 2) Download the Applying Excel form and enter formulas in all celis that contain question marks. For example, in eetl 826 enter the formula * 85 : Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in ces C5 to 75,000 units. The required production for the year should be 274,000 units. The cost of raw materats to be purchased for the yeor should be $1,06,800, whereas the total cosh disbursements for the year should be $1,095,980, ff you do not get this answec, find the enors in your workshet and correct them. Save your completed Applying Excel form to your computer and then upload it here by cliching "Browse." Next, click "Save." You wilt use this worksheet to answer the questions in Part 2. e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? Yes No Construct the production budget Budgoted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units Construct the raw materials purchases budget Required production (units) Raw materials required to produce one une (pounds) Production needs (pounds) Add desirod ending itventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw matertals (pounds) Raw materials to be purchased (pounds) Cost of row materials per pound Cost of raw materals to be purchased Construct the schedule of expected cash payments Boginning balance accounts payable Fint-quarter purchases Socond-quater purchuses Third-quarter purchases Fourth-quarter purchases Total cash disbursements a. What are the total expected cash collections for the year under this revised budget? b. What is the total required production for the year under this revised budget? c. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Chapter B: Applying Excel Data Budgeted unit salet \begin{tabular}{|c|c|c|c|c|c|} \hline & Yoar 20 & Quarter & & Year 3 & Quarter \\ \hline 1 & 2 & r & 4 & r & r \\ \hline 40,000 & 60,000 & 100,000 & 50,000 & 70,000 & 80,000 \\ \hline \end{tabular} - Seling price por unt - Acoounta recelvable, beginning balance - Sales colected in the quarter sales am made - Sales colected in the quarter after sales are made - Detirnd ending finished goods inventory is - Finished goods inventory, beginning. - Para materala required to produce one unit - Destred ending inventory of raw materals is - Raw matecale inventory, beginning - Raw materal costs - Raw materiale purchases are poid and - Accounts payable for raw materas, beginning balance of the budgeted unit sales of the next quarter $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 12,000 units 5 pounds 10% of the next quarters production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the cuarter following purthase Enter a formule hito each of the cells manked weh a ? below Review Problem: Budget Schedules Censtruct the sales budget Budgeted unt taket Selling proe per unil Totat tales $81,500 Construct the schedule of expected cash collections Beginning batance accorints recelvable Fint-quarter sabe Second-quarter salos Third-quarter sales Fovith-guartertities Total cash collections \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & & B. & C. & D & E & F & G \\ \hline 1 & Chapter 8: Applying Excel & & & & & & & \\ \hline \multicolumn{9}{|l|}{2} \\ \hline 3 & Data & & & & & & \multicolumn{2}{|l|}{ Year 3 Cuarter } \\ \hline 4 & & & 1 & 2 & 3 & 4 & 1 & 2 \\ \hline 5 & Budgoted int salet & & 45,000 & 70,000 & 105,000 & 60,000 & 90,000 & 100,000 \\ \hline 6 & & & & & & & & \\ \hline 7 & - Selling prioe per unit & s & 7 & por unit & & & & \\ \hline 8 & - Accounts receivable, beginning balance & s & 65,000 & & & & & \\ \hline 9 & - Sales collected in the quarter sales are made & & 75% & & & & & \\ \hline 10 & - Sales collocted in the quarter after sales ore made & & 25% & & & & & \\ \hline & - Desired ending finished goods inventory is & & 30% & \multicolumn{5}{|c|}{ of the budgeted unit sales of the noxt quarter. } \\ \hline 11 & - Finished goods inventory, beginning & & 12,000 & units & & & & \\ \hline 12 & - Raw materials required to produce one unit & & 5 & pounds. & & & & \\ \hline 13 & - Desired ending inventory of raw matenals is & & 10% & \multicolumn{5}{|c|}{ of the next quartar's production needs } \\ \hline 14 & - Raw materials inventory, beginning & & 23,000 & pounds & & & & \\ \hline 15 & - Raw matoriai cots & $ & 080 & por pound & & & & \\ \hline 16 & - Raw matenals purchates are paid & & 60% & \multicolumn{5}{|c|}{ in the quarter the purchases are made } \\ \hline 17 & and & & 40% & \multicolumn{5}{|c|}{ in the quarter folowing purchase } \\ \hline 18 & - Acoounts payabie for faw malenals, beginning balance. & & 81,500 & & & & & \\ \hline 19 & & & & & & & & \\ \hline \end{tabular} Required information Chapter 8: Applying Excel [LO8-2, LO8-3, LO8-4] The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review. Problem in the text. Chapter 8: Applying Excel: Exercise (Part 2 of 2) Requirement 2: The company has just hired a new marketing manoger who insists that unit sales can be dramatically increased by dropping the selling price from \$B to $7. The marketing manager would like to use the following projections in the budget