Question
Cautious Company has the following sales projection (in units) for the next six months: Feb: 11000 Mar: 12500 Apr: 10000 May: 13500 Jun: 11500 Jul:
Cautious Company has the following sales projection (in units) for the next six months: Feb: 11000 Mar: 12500 Apr: 10000 May: 13500 Jun: 11500 Jul: 9000 Each unit sells for $26 through April and $29 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 | 10000 | 13500 | 11500 | 35000 |
Selling price per unit | x $26 | x $29 | x $29 | |
Sales revenue | $260000 | $391500 | $333500 | $985000 |
All of the sales are on credit. Cautious collects from customers as follows: 50% of sales in the month of sale 25% in the month following the sale, and 25% 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?
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