Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sweeney Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit

Sweeney Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Sweeney Corporation has experienced the following collection pattern:

25% received in the month of the sale

50% received in the month after the sale

24% received two months after the sale

1% of the credit sales are never received

November sales for last year were $90,000, while December sales were $110,000. Projected sales for the next three months are as follows:

January sales. . . . . . . . . . . . . . . .

$165,000

February sales. . . . . . . . . . . . . . .

$115,000

March sales. . . . . . . . . . . . . . . . .

$190,000

Requirement

Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.)

Sweeney Corporation

Cash Collections Budget

For the Months of January through March

January

Cash sales

Collections on credit sales:

25% Month of sale

50% Month after

24% Two months after

Total cash collections

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Primary Science Audit And Test

Authors: Jenny Byrne, Andri Christodoulou, John Sharp

4th Edition

1446282732, 978-1446282731

More Books

Students also viewed these Accounting questions