How much cash will be collected in January? In February? In March? For the quarter in total?

w - Insert Home Draw Formulas Page Layout File Acrot View Review Data Help Morningstar PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View f A3 1 H J K G F E D 1 The Master Budget 2 Cash collections budget NONCO 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 14 17 13 Its collection history indicates that credit sales are collected as follows: 25% in the month of the sale 15 50% in the month after the sale 16 20% two months after the sale 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? DE File Home Insert Draw Page Layout Formulas Data Review View Help Morningsta 0 PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Prote A1 (Always use cell references and formulas where appropriate to receiv C B D E F (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.) 2 3 Kessler Service 4 Cash Collections Budget 5 For the Quarter Ended March 31 5 Month January February March 1st Quarter 8 Cash sales in current month 9 Collection on credit sales: 10 25% of credit sales made in current month 11 50% of credit sales made one month ago 12 20% of credit sales made two months ago 13 Total cash collections 14 15 16 17 7 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 15 16 37 3 > INSTRUCTIONS TI