7-31. Meals has many sources of income, but each source pays Meals differently. Specifically, Meals has contracts with the city, county, and state to provide food services. In addition, Meals has contracted with a private foundation to augment its foods with more healthful options. The city owes Meals $400,000: half of that debt is current, one quarter is more than 30 days but less than 61 days old, 15 percent is between 61 and 90 days old, and the remainder is more than 91 days old. The county owes Meals $900,000, only one third of which is current; another one third is more than 30 days but less than 61 days old, and the remainder is more than 90 days old. The state owes Meals $1.5 million; 40 percent is current, 30 percent is between 30 and 60 days old, 20 percent is between 61 and 90 days old, and the remainder is more than 91 days old. The foundation owes Meals $150,000, of which half is current and the other half is more than 30 days but less than 61 days old. Prepare an accounts receivable aging schedule for Meals by total dollars and by percent. PROBLEM 7-31 Meals for the Homeless Receivables Aging Schedule 1-30 Days 31-60 Days 61-90 Days >90 Days Total SO SO SO SO 0 0 - - Payer By Total Dollars City County State Foundation Total By Percent City County State Foundation Total SO SO SO SO $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 100% 100% 100% 100% 100% #DIV/0