(Preparation of a cash budgef) Lewis Printing has projected is pales for the first 8 months of 2019 as follows Lewis collocts 30 percent of tis salos in the month of the sale, 50 porcent in the morth following the sale, and the remaining 20 porcent 2 months following the sale. During November and Docember of 2018, Lew's's sales were $240,000 and $165,000, respectively Lewis purchasos raw materiais 2 months in advance of iss sales. These purchases are equal to 70 porcent of its final aales. The supplior is paid 1 month afier delivery. Thus, purchases for April sales are made in February and payment is mado in March In addition, rent expense is $10,000 per month and other expenses fotal $25,000 a month. Beginning in March, quarterly tax prepayments of $21,500 are made. The company's cash balance as of December 31,2018 , was $26,000; a minimum balance of $15,000 must bo maintained at all times to sasisty the firmis bank line of credit agreemont. Lewis has arranged with its bank for short-torm credit at an interest rale of 18 porcent per annum (1.5 percent per month) to be paid monthly Borrowing to meet estimated monthly cash noeds takes place at the end of the month, and interest is not paid unte the end of the following month. Consequently, if the firm noeded to borrow $50,000 during Apri, then it would pay $750(=0.015$50,000) in interest during May. Finally, Lewwis follows a policy of repaying its outstanding short.term debt in arw month in which its cash balance excoeds the minimum desired balance of $15.000 a. Prepare a cash budgot for Lewis Printing covering the first 6 months of $21,500. Fit in thu Calinctions for the month of January. (Round to the nearest doliar.) Data table (Click on the following icon D in order to copy its contents into a spreadsheet.)