Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
May June July
Projected total monthly sales
126,000$ 145,000$ 162,000$
Receipts from cash sales:
Cash sales
May sales on account:
Collected in May
Collected in June
Collected in July
June sales on account:
Collected in June
Collected in July
July sales on account:
Collected in July
Total cash collected
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Schedule of Collections from Sales
For the Three Months Ending July 31, 2014
An asterisk (*) will appear to the right of an incorrect entry.
May June July
Projected total monthly sales
126,000$ 145,000$ 162,000$
Receipts from cash sales:
Cash sales 10% 12,600$ 14,500$ 16,200$
Schedule of Collections from Sales
For the Three Months Ending July 31, 2014
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.