The Master Budget Cash collections budget Kessler Service anticipates the following sales revenue over a five-month period: Sales revenue November $16,500 December $11,200 January $15,200 February March $13,200 $14,400 The company's sales are 30% cash 70% credit Its collection history indicates that credit sales are collected as follows: 25% in the month of the sale 50% in the month after the sale 20% two months after the sale 5% are never collected (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.) Kessler Service Cash Collections Budget For the Quarter Ended March 31 Cash sales in current month Collection on credit sales: 25% of credit sales made in current month 50% of credit sales made one month ago 20% of credit sales made two months ago Total cash collections January Month February March 1st Quarter Grader - Instructions Accounting 2019 Project BT6e S9-11 v2 Project Description: BT6e S9.11 Steps to Perform: Step Points Instructions Possible 1 How much cash will be collected in January? In February? In March? For the quarter in total? 20 (Always use cell references and formulas where appropriate to receive full credit.) Total Points 20