Exercise 9-28 Using Budgets for Financial Planning (LO 9-2, 9-5, 9-7) Sound Investments, Inc. is a large retailer of stereo equipment. The controller is about to prepare the budget for the first quarter of 20x2. Post experience has indicated that 75 percent of the store's sales are cash sales. The collection experience for the sales on account is as follows: 80 percent during month of sole 15 percent during month following sale 5 percent uncollectible The total sales for December 20x1 are expected to be $202,000. The controller feels that sales in January 20x2 could range from $112,000 to $172,000. Required: 1. Demonstrate how financial planning can be used to project cash receipts in January of 20x2 for three different levels of January soles. Use the following columnar format Total Sales in January, 20x2 112,000 $ 142,000 5 172,000 Cash receipts in January 20x2 From December sales on account From January cash sales From January sales on account Total cash receipts $ 0 $ 0 $ 0