Question
Schedule of Cash Collections on Accounts Receivable and Cash Budget Lopez Inc. found that about 45% of its sales during the month were for cash.
Schedule of Cash Collections on Accounts Receivable and Cash Budget
Lopez Inc. found that about 45% of its sales during the month were for cash. Lopez has the following accounts receivable payment experience:
Percent paid in the month of sale | 25 | ||
Percent paid in the month after the sale | 68 | ||
Percent paid in the second month after the sale | 5 |
Lopez's anticipated sales for the next few months are as follows:
April | $250,000 | ||
May | 290,000 | ||
June | 280,000 | ||
July | 295,000 | ||
August | 300,000 |
Required:
1. Calculate credit sales for May. $___
Calculate credit sales for June. $_______
Calculate credit sales for July. $_________
Calculate credit sales for August. $_____________
2. Prepare a schedule of cash receipts for July and August. Round your answer to the nearest whole dollar, if necessary. If an amount box does not require an entry, leave it blank or enter "0". Be sure to enter percentages as whole numbers.
Bennett Inc. Schedule of Cash Receipts For July and August | ||||||
July | August | |||||
Cash sales | $ | $ | ||||
Payments on account: | ||||||
From May credit sales: | ||||||
$_____ _____% | ||||||
From June credit sales: | ||||||
$_____ _____ % | ||||||
$______ _____ % | ||||||
From July credit sales: | ||||||
$____ _____% | ||||||
$______ ________ % | ||||||
From August credit sales: | ||||||
$______ ______% | ||||||
Cash receipts | $ | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started