Cautious Company has the following sales projection (in units) for the next six months: Feb:...
80.2K
Verified Solution
Link Copied!
Question
Accounting
Cautious Company has the following sales projection (in units) for the next six months: Feb: 1600 Mar: 1800 Apr: 1400 May: 2100 Jun: 1700 Jul: 1200 Each unit sells for $39 through April and $42 starting in May. Cautious has prepared the following sales budget for the quarter of April, May and June:
Sales Budget
April
May
June
Total
Sales in units
1400
2100
1700
5200
Selling price per unit
x $39
x $42
x $42
Sales revenue
$54600
$88200
$71400
$214200
All of the sales are on credit. Cautious collects from customers as follows: 50% of sales in the month of sale 30% in the month following the sale, and 20% in the second month following the sale Prepare a cash receipts budget on paper or in Excel for the quarter of April, May and June. What is budgeted cash receipts in June? Example: Budgeted cash receipts for April would be 50% of April sales + 30% of March sales + 20% of February sales.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
