Maluwana Stores had sales of K700, 000 in November and K850, 000 in December. It expects sales to be as follows during the first six months of the next year:

Month January February March April May June

Sales K500, 000 450,000 550,000 600,000 625,000 600,000

In the past, 17.5 percent of Maluwanas sales are paid in cash at the time of the sale, 52.5 percent are paid the following month, and 30 percent are paid in the second month following the sale.

1. Prepare a spreadsheet showing the expected inflow of operating revenues for the first six months of next year.
2. An analysis of the records of Maluwana Stores shows that the cost of goods they sell has averaged 70 percent of the Kwacha value of sales. To save inventory holding costs, Maluwana schedules its receipts of goods for the beginning of the month in which the goods are expected to be sold. Maluwana pays for 20 percent of its purchased goods in the same month that the suppliers deliver the goods. The store pays for 40 percent of its purchased goods in the month following delivery and for 40 percent of its purchased goods two months after delivery. Sales during November and December of last year and forecast sales for the first six months of next year are as given above. What are the cash outflows to pay for purchased goods for each of the first six months of next year?