Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales March April May $49,000 57,000 59,000 $45,000

image text in transcribed

Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales March April May $49,000 57,000 59,000 $45,000 June 51,000 July 0,000 August Sales in January and February were $48,000 and $47,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. Prepare a monthly cash receipts schedule for the firm for March through August. Ed's Waterbeds Cash Receipts Schedule Janua ebrua March April May June July August 47,000 S 45,000 S 51,000 S 15300 18000 40,000 S 57,000 S 17100 19600 48,000 $ Sales Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier 13500 18,800 9600 12000 20400 9000 49,000 S 14700 16000 10200 59,000 17700 22800 9800 9400 8000 Total cash receipts 41900 $ 42700 S 41400 S 40900 S 44700 S 50300 b. Of the sales expected to be made during the six months from March to August, how much will still be uncollected at the end of August? How much of this is expected to be collected later? Amount Uncollected Expected to be collected S

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

Step: 3

blur-text-image

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

Investing Amid Low Expected Returns Making The Most When Markets Offer The Least

Authors: Antti Ilmanen

1st Edition

1119860199, 978-1119860198

More Books

Students also viewed these Accounting questions