A Kyoto clothing wholesaler was preparing its sales budget for the first quarter of 2012. Forecast sales are: 

January   ¥200,000 

February ¥220,000 

March     ¥240,000 

Sales are 20 percent cash and 80 percent credit. Fifty percent of the credit accounts are collected in the month of sale, 40 percent in the month following the sale, and 10 percent in the following month. No uncollectible accounts are anticipated. Accounts receivable at the beginning of 2012 are ¥96 million (10 percent of November credit sales of ¥180 million and 50 percent of December credit sales of ¥156 million). 

Prepare a schedule showing sales and cash collections for January, February, and March 2012.