Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions