ONLY #3 SKIP 1 AND 2

HERE IS THE INSTRUCTIONS:

I

Relevant information - Required Production January =90,000 units February =70,000 units March =125,000 units April =130,000 units - Pounds of materials needed per unit =3 pounds - Beginning raw materials inventory on January 1,20XX=50,000 pounds. - Percentage of the following month's production used to determine desired ending inventory =20% - Raw materials cost per pound =$2.5 per pound PREPARE A SCHEDULE OF CASH PAYMENTS FOR RAW MATERIALS (4 POINTS) Prepare the Schedule of Cash Payments for the first three months of Guidance's fiscal year (January, February, and March) and for the quarter, using the template in the Excel spreadsheet. HINT: cost of raw materials that Guidance is paying for comes from the last line of your direct materials budget. - Guidance's payment schedule: - 20% of purchases are paid for in the month of purchase 65% are paid for in the month after purchase 15% are paid for in the second month after purchase - Beginning accounts payable =$600,000. Assume 65% of the beginning accounts payable will be paid in January and 15% in February. Figures cause this problem has several areas that frequently pose problems for students, check figures are ovided to give you feedback as to whether your budget/schedule has errors. Create a INDEX and MATCH nested function so that the user can enter a month ('January', 'February', 'March' or 'Quarter') and excel returns the amount Direct Materials purchases for that month in cell B4 and how much cash is being spent in C4 on sheet "3) Management Lookup". (2 POINTS) \begin{tabular}{lll} Month & Direct Materials Purchased & Cash Paid for Materials \\ \hline Quarter & \end{tabular}