I need help with this problem and entering the information by using cell reference formulas

Steps to Perform: Step Instructions Points Possible 1 20 How much cash will be collected in January? in February? In March? For the quarter in total? (Always use cell references and formulas where appropriate to receive full credit.) Total Points 20 M N B D E G H 1 The Master Budget 2 Cash collections budget 3 4 Kessler Service anticipates the following sales revenue over a five-month period: 5 6 November December January February March 7 Sales revenue $16,500 $11,200 $15,200 $13,200 $14,400 8 9 The company's sales are 10 30% cash 11 70% credit 12 13. Its collection history indicates that credit sales are collected as follows: 14 25% in the month of the sale 15 50% in the month after the sale 16 20% two months after the sale 17 5% are never collected 18 19 Use the blue shaded areas on the ENTERANSWERS tab for Inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from 20 the Instruction tab you will be marked wrong. 21 22 Requirement 23 How much cash will be collected in January? In February? In March? For the quarter in total? 24 25 Saving & Submitting Solution 26 1 Save file to desktop, 27 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 28 2 Upload and submit your file to be graded. 29 3. Navigate back to the activity window screen where you downloaded the initial spreadsheet 30 b. Click Choose button under step 3: locate the file you just saved and click Open Click Upload button under step 3 32 d. Click Submit button under step 4 33 31 C