Question
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:
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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