Cut Calibri (Body) 12 A A* Wrap Text General | Copy s-96 , i: Paste B IU Merge & Center .00 Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates 0 1 The Master Budget 2 Cash collections budget Kessler Service anticipates the following sales revenue over a five-month period November December 11,200 Januar Februa March 7 Sales revenue $15,200 $13,200 14,400 9 The company's sales are 10 30% cash 70% credit 12 13 ts collection history indicates that credit sales are collected as follows: 14 15 16 17 18 19 Use the blue shaded areas on the ENTERANSWERS tab for inputs. 25% 50% 20% 5% in the month of the sale in the month after the sale two months after the sale are never collected Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you 20 will be marked wr 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 28 2 Upload and submit your file to be graded. 29 30 a Create folder on desktop, and label COMPLETED EXCEL PROJECTS a Navigate back to the activity window-screen where you downloaded the initial spreadsheet b. Click Choose button under step 3; locate the file you jstsavd and click Open c. Click Upload button under step 3 d Click Submit button under step 4 32 34 5 Viewing Results 36 1 Click on Results tab in MyAccountingLab 37 2 Click on the Assignment you were working on 38 3 Click on Project link; this will bring up your Score Card 39 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback 40 41