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 $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 percent cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $29,000, of which $8,000 represents uncollected March sales and $21,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

1) Caclualtion of Cash collection From the month of May 201y to July 2017
Calcualtion of Monthly Collection from Sales
May-17 Jun-17 Jul-17 Aug-17
Sales $       1,00,000.00 $       1,80,000.00 $    2,00,000.00 $    1,40,000.00
60% in the month of Sales $           60,000.00 $       1,08,000.00 $    1,20,000.00 $       84,000.00
Less : Cash Discount 1% $               -600.00 $            -1,080.00 $        -1,200.00 $            -840.00
20 % in the month of Following Sale $           20,000.00 $       36,000.00 $       40,000.00
15% in the second month following sale $       15,000.00 $       27,000.00
5% is uncollectable $                       -   $                       -  
Total Cash Receipts $           59,400.00 $       1,26,920.00 $    1,69,800.00 $    1,50,160.00 $                          -  
Total Cash Receipts May-17 Jun-17 Jul-17 Total
$           59,400.00 $       1,26,920.00 $    1,69,800.00 $    3,56,120.00

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