Question

The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...

The sales budget for Perrier Inc. is forecasted as follows:

Month Sales Revenue
May $130,000
June 150,000
July 200,000
August 130,000

To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales:

  • 60 percent in the month of sale.
  • 20 percent in the month following sale.
  • 15 percent in the second month following sale.
  • 5 percent uncollectible.

The company gives a 2 percent cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $22,000, of which $7,000 represents uncollected March sales and $15,000 represents uncollected April sales. Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections.

May June July Total
Total Cash receipts ???? ???? ???? ????
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30%...
CAT Co. had forecasted sales as follows: -April: $406,000 -May: $452,000 -June: $496,000 Sales are 30% credit and 70% cash. 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Total sales for the months of February and March were $950,000 with February having $500,000 credit sales and March $400,000. Prepare a sales budget schedule and a cash collections budget schedule for the months...
E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July,...
E Company has budgeted sales revenues of $170,000 for May, $215,000 for June, $240,000 for July, and $160,000 for August. To prepare a cash budget, the company must determine the budgeted cash collections from sales. Generally the trend has been 55 percent collected in the month of sale, 25 percent collected in the month following sale, 18 percent collected in the second month following sale, and 2 percent uncollectible. Also, E Company grants a 2 percent cash discount to customers...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30%...
Y&Z Co had forecasted sales as follows: -April= $406,000 -May= $452,000 -June= $496,000 Sales are 30% credit and 70% cash 50% of the credit sales are collected in the month of the sale, 30% in the month following the sale, and 20% in the following month. Totals sales for the months of February and March were $900,000 with February having $500,000 credit sales and March $400,000 Prepares a sales budget schedule and a cash collections budget schedule for the months...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June    ...
Northern Company has budgeted sales for the upcoming months as follows: April     450,000 May     465,000 June     490,000 July       515,000 August    500,000 Septemeber    475,000 18% percent of the sales are credit sales and the remainder are cash sales. Credit sales are collected 45% in the month of sale, 36% in the month following the sale, and 19% in the second month following the sale. Required: Prepare a schedule of cash collections for June, July, & August
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit...
The following is the sales budget for the given months of Hecto, Ltd.: Cash Sales Credit Sales May $59,000 $283,000 June $43,000 $236,000 July $33,000 $205,000 August $47,000 $268,000 September $46,000 $197,000 Additional information to be used determining the expected cash collections each month that will be used in preparing the cash budget: Collections on Credit sales: 50% in month of sale 20% in month following sale 30% in second month following sale The Accounts Receivable balance on May 1...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 50,000 $ 150,000 February $ 55,000 $ 170,000 March $ 29,000 $ 130,000 April $ 24,000 $ 109,000 May $ 34,000 $ 200,000 June $ 80,000 $ 30,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 40,000 $ 140,000 February $ 45,000 $ 160,000 March $ 42,000 $ 120,000 April $ 37,000 $ 122,000 May $ 47,000 $ 190,000 June $ 70,000 $ 160,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 70,000 $ 170,000 February $ 75,000 $ 190,000 March $ 27,000 $ 150,000 April $ 22,000 $ 107,000 May $ 32,000 $ 220,000 June $ 100,000 $ 10,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT