Problem:
Financial budgets: cash inflows Worthington Company makes cash (20% of total sales), credit card (50% of total sales), and account (30% of total sales) sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales are collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifies the projected sales for the next year:
Prepare a statement showing the cash expected each month from the collections from thesesales.