Question

In: Accounting

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 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.

Perrier, Inc.
Schedule of Budgeted Cash Collections
Quarterly by Months
May June July Total
Total Cash receipts: $Answer $Answer $Answer $Answer

Solutions

Expert Solution

Schedule of budgeted cash collections

May June July Total
Total cash receipts 89,190 119,825 167,100 376,115

Working note:

i) Uncollected march sales $7,000 will be collected in May. 60% of march sales would have been collected in the month of March and 20% in the month of April. Thus $7,000 represents remaining 20% of March sale.

Hence, march sales = 7,000 x 100/20

= $35,000

Since 5% is uncollectible, hence amount to be received in May = 35,000 x 15%

= $5,250

ii) Uncollected April sales = $15,000. 60% of April sales would have been collected in the month of April. Thus $15,000 represents remaining 40% of April sales.

Hence, April sales = 15,000 x 100/40

= $37,500

Amount to be received in May = 37,500 x 20%

= $7,500

Amount to be received in June = 37,500 x 15%

= $5,625

Cash collections from customers summary

Sales/Accounts receivables May June July
March 7,000 5,250 0 0
April 15,000 7,500 5,625 0
May 130,000 76,440 26,000 19,500
June 150,000 0 88,200 30,000
July 200,000 0 0 117,600
Total 89,190 119,825 167,100

Related Solutions

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 $100,000 June 180,000 July 200,000 August 140,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 1...
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 $100,000 June 180,000 July 200,000 August 140,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 1...
Exercise 10-31 Cash Receipts and Payments [LO 10-4] Information pertaining to Noskey Corporation’s sales revenue follows:...
Exercise 10-31 Cash Receipts and Payments [LO 10-4] Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 115,000 $ 121,000 $ 74,000 Credit sales 282,000 409,000 208,000 Total sales $ 397,000 $ 530,000 $ 282,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of...
A record of transactions for the month of May was as follows: Purchases Sales May 1...
A record of transactions for the month of May was as follows: Purchases Sales May 1 (balance) 440 @ $5.80 May 3 220 @ $8.00 4 1,320 @ $5.70 6 1,040 @ 8.00 8 895 @ $5.90 12 995 @ 8.50 14 795 @ $6.00 18 500 @ 8.50 22 1,280 @ $6.10 25 1,415 @ 9.00 29 520 @ $6.15 Assuming that perpetual inventory records are kept in dollars, determine the ending inventory using LIFO. Ending inventory $
A record of transactions for the month of May was as follows: Purchases Sales May 1...
A record of transactions for the month of May was as follows: Purchases Sales May 1 (balance) 400 @ $5.00 May 3 200 @ $7.00 4 1,300 @ $4.90 6 1,000 @ 7.00 8 800 @ $5.10 12 900 @ 7.50 14 700 @ $5.20 18 400 @ 7.50 22 1,200 @ $5.30 25 1,400 @ 8.00 29 500 @ $5.35 Assuming that perpetual inventory records are kept in dollars, determine the ending inventory using LIFO. Ending inventory $
Which of the following sequences is correct? Select one a. Cash receipts budget-sales budget-production budget-budgeted income...
Which of the following sequences is correct? Select one a. Cash receipts budget-sales budget-production budget-budgeted income statement b. Sales budget-production budget-direct materials budget-budgeted income statement c Budgeted income statement-direct materials budget-production budget-sales budget O d Inventory budget-production budget-sales budget-selling and administrative budger
Sales for boxes of Girl Scout cookies over a 4-month period were forecasted as follows: 100,...
Sales for boxes of Girl Scout cookies over a 4-month period were forecasted as follows: 100, 120, 115, and 126. The actual results over the 4-month period were as follows: 110, 114, 119, 115. What was the MAD of the 4-month forecast? 5 0 108 7 None of the above
The revenue and cost information for Odessa Outfitters inc. for 2015 follows: Sales Revenue       560,000 COGS...
The revenue and cost information for Odessa Outfitters inc. for 2015 follows: Sales Revenue       560,000 COGS (at standart) 342,000 DM price variance      1,000 F DM quantity variance 6,000 F DL rate varinace          4,000U DL efficiency variance 2,000 F Overhead controllable variance 3,500U Overhead volüme variance    8,000f a)What is gross profit at standard? b)What is gross profit actual? c)Write journal entries for all variance accounts assuming all units are produced and sold in the same period.
Revenue and Cash Receipts Journals Lasting Summer Inc. has $2,360 in the October 1 balance of...
Revenue and Cash Receipts Journals Lasting Summer Inc. has $2,360 in the October 1 balance of the accounts receivable account consisting of $1,090 from Champion Co. and $1,270 from Wayfarer Co. Transactions related to revenue and cash receipts completed by Lasting Summer Inc. during the month of October 20Y5 are as follows: Oct. 3. Issued Invoice No. 622 for services provided to Palace Corp., $2,480. 5. Received cash from Champion Co., on account, for $1,090. 8. Issued Invoice No. 623...
A new audit client of your processes its sales and cash receipts and cash receipts documents...
A new audit client of your processes its sales and cash receipts and cash receipts documents in the following manner: Cash Receipts The mail is opened each morning by a mail clerk in the sales department. The mail clerk prepares a remittance advice (showing customer and amount paid) if one is not received. The cheque and remittance advices are then forwarded to the sales department supervisor, who reviews each cheque and forwards the cheque and remittance advices to the accounting...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT