Question

Calculate the cash receipts expected for the month of March. Collection patterns indicate 75% of the...

Calculate the cash receipts expected for the month of March. Collection patterns indicate 75% of the month's sales will be collected in the month of the sale, 20% in the following month, and 2 % two months after the sale. Sales forecasts are $250,000 in January, $325,000 in February, and $285,000 in March.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: Cash receipts fr the month of march is $283,750

January sales = 250,000 * 75% = $187,5000 which is collected in the same month

250,000 * 20% = $50,000 which is collected in the following month i.e February month

250,000 * 2% = $5000 which is collected from two moths of sales i.e march month

February sales = 325,000 * 75% = $243,750 in the same month

= 325,000 * 20% = $65,000 in the month of march

March sales = 285,000 * 75% = $213,750 in the same month.

Total of bold area is march month cash collection i.e 5000 + 65,000 + 213,750 =$283,750

Add a comment
Know the answer?
Add Answer to:
Calculate the cash receipts expected for the month of March. Collection patterns indicate 75% of the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • A) Need help with this chart B) Find March credit sales, collection of March sales in...

    A) Need help with this chart B) Find March credit sales, collection of March sales in April Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April Marcel Company projects the following sales for the first three months of the year: $12,600 in January: $10,200 in February; and $11,100 in March. The company expects 70% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the...

  • Requirement 2. Prepare a revised schedule of cash receipts from sales in account are 60% in...

    Requirement 2. Prepare a revised schedule of cash receipts from sales in account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? Requirement 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale. 30 blank, do not enter "0".) Cash Receipts from Customers...

  • a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare...

    a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare a schedule of monthly cash payments for January, February, and March. c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to...

  • Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash...

    Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020. The following data have been assembled: a. Actual sales for November and December of 2019 and forecasted sales data for the first four months of 2020 are as follows: November (actual) S450,000 December (actual) 750,000 January (estimate) 150,000 February (estimate) 75.000 March (estimate) 300,000 April (estimate) 500,000 b. C. Lannister pays for 20% of its inventory purchases...

  • Shown below are the expected sales for ABC Company: January February March April Sales for Cash...

    Shown below are the expected sales for ABC Company: January February March April Sales for Cash $22,000 $19,000 $26,000 $21,000 Sales on Account $118,000 $146,000 $133,000 $127,000 On average, 65% of the sales on account are collected in the month of sale, 27% are collected in the month following sale, and the remaining 8% are collected two months after the month of sale. Calculate ABC Company's budgeted accounts receivable at April 30.

  • Its collection history indicates that credit sales are collected as follows Gem Service anticipates the following...

    Its collection history indicates that credit sales are collected as follows Gem Service anticipates the following sales revenue over a five-month period: (Click the icon to view the sales data.) i Click the icon to view the collections data.) The company's sales are 20 % cash and 80 % credit How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in...

  • Topaz Service anticipates the following sales revenue over a five-month period: 3: (Click the icon to...

    Topaz Service anticipates the following sales revenue over a five-month period: 3: (Click the icon to view the sales data.) The company's sales are 40% cash and 60% credit. Its collection history indicates that credit sales are collected as follows: i (Click the icon to view the collections data.) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January,...

  • Ed’s Waterbeds has made the following sales projections for the next six months. All sales are...

    Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales.   March $ 32,000   June $ 36,000   April 38,000 July 44,000   May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....

  • Garnet Service anticipates the following sales revenue over a five-month period E Click the icon to...

    Garnet Service anticipates the following sales revenue over a five-month period E Click the icon to view the sales data) The company's sales are 40% cash and 60% credit For the Months of January through March Its collection history indicates that credit sales are collected as folows: (Click the icon to view the collections data) How much cash will be collected in January? In February in March? For the quarter info Quarter Cash sales Collection of credt sales: 25% Month...

  • Emerald Service anticipates the following sales revenue over a five-month period: Click the icon to view...

    Emerald Service anticipates the following sales revenue over a five-month period: Click the icon to view the sales data.) The company's sales are 40% cash and 60% credit its collection history indicates that credit sales are collected as follows: (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January February March...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT