Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: une Ju

Question

Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: une July August Month Sales Revenue 100,000 180,000 190,000 120,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 $23,000, of which $8,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 Total Total Cash receipts: 3

Explanation / Answer

% of march sales uncollectible : 15+5=20%

march sales = 8000/ .20 = 40000

% of april sales uncollectible = 20+15+5 = 40%

april sales = 15000/.40 = $ 37500

Schedule of Budgeted cash collections May June July Total March sales 6000   [40000*15%] April sales 7500     [37500*20%] 5625   [37500*15%] May sales 59400     [100000*.60*(1-.01)] 20000   [100000*20%] 15000   [100000*15%] June sales 106920   [180000*.60*(1-.01)] 36000    [180000*.20] July sales 112860   [190000*.60*(1-.01)] Total collections 72900 132545 163860 369305

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.