Question
Schedule of Cash Collections on Accounts Receivable and Cash Budget Bennett Inc. found that about 40% of its sales during the month were for cash.
Schedule of Cash Collections on Accounts Receivable and Cash Budget
Bennett Inc. found that about 40% of its sales during the month were for cash. Bennett 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 |
Bennett'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. $fill in the blank 5b6171091f8d067_1
Calculate credit sales for June. $fill in the blank 5b6171091f8d067_2
Calculate credit sales for July. $fill in the blank 5b6171091f8d067_3
Calculate credit sales for August. $fill in the blank 5b6171091f8d067_4
2. Prepare a schedule of cash receipts for July and August. Round your answers 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 | $fill in the blank 45a892f9af7f05e_1 | $fill in the blank 45a892f9af7f05e_2 | ||||
Payments on account: | ||||||
From May credit sales: | ||||||
$fill in the blank 45a892f9af7f05e_3 fill in the blank 45a892f9af7f05e_4 % | fill in the blank 45a892f9af7f05e_5 | fill in the blank 45a892f9af7f05e_6 | ||||
From June credit sales: | ||||||
$fill in the blank 45a892f9af7f05e_7 fill in the blank 45a892f9af7f05e_8 % | fill in the blank 45a892f9af7f05e_9 | |||||
$fill in the blank 45a892f9af7f05e_10 fill in the blank 45a892f9af7f05e_11 % | fill in the blank 45a892f9af7f05e_12 | |||||
From July credit sales: | ||||||
$fill in the blank 45a892f9af7f05e_13 fill in the blank 45a892f9af7f05e_14 % | fill in the blank 45a892f9af7f05e_15 | |||||
$fill in the blank 45a892f9af7f05e_16 fill in the blank 45a892f9af7f05e_17 % | fill in the blank 45a892f9af7f05e_18 | |||||
From August credit sales: | ||||||
$fill in the blank 45a892f9af7f05e_19 fill in the blank 45a892f9af7f05e_20 % | fill in the blank 45a892f9af7f05e_21 | fill in the blank 45a892f9af7f05e_22 | ||||
Cash receipts | $fill in the blank 45a892f9af7f05e_23 | $fill in the blank 45a892f9af7f05e_24 |
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