Ed's Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 12,000 June $14,000 April 16,000 July 17,000 May 10,000 August 18,000 Sales in January and February were $13, 500 and $13,000 respectively.Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent arecollected in the following month, and 20 percent are collected two months after sale. a. Prepare a monthly cash receipts schedule forthe firm for March through August. Ed's Waterbeds Cash Receipts Schedule January February March April May June July August Sales $$ $ $ $ $ $ $ Collections of current sales Collections of prior month's sales Collections of sales 2 months earlier Total cash receipts $ $ $ $$$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 ofAugust? How much of this is expected to be collected later? Amount Uncollected $ Expected to be collected $

The objective of the question is to prepare a monthly cash receipts schedule for Ed's Waterbeds for…

Answered: Ed's Waterbeds has made the following…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Vertical Ladder Company (VLC) forecasts its sales for January through April will be $40,000, $60,000, $100,000, and $90,000, respectively. All sales are made on credit, and it is expected that 40 percent of sales will be collected in the month of the sale and the remainder will be collected the month following the sale. Customers who pay in the month of the sale will take the 2 percent cash discount VLC offers for paying early. VLC normally purchases and pays for raw materials, which cost 45 percent of sales, one month prior to selling the finished products. Employees' wages represent 20 percent of sales and rent is $6,000 per month. At the beginning of February, VLC expects to have $4,000 in cash, which is $1,000 greater than its target cash balance. Using the information provided, construct VLC's cash budget for February and March. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". February March…
Shadee Corporation expects to sell 630 sun shades in May and 420 in June. Each shades sells for $18. Shadee's beginning and ending finished goods inventories for May are 85 and 60 shades, respectively. Ending finished goods inventory for June will be 55 shades. It expects the following unit sales for the third quarter. July August September 530 480 440 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale, 38 percent is collected during the following month, and 10 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September. Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August September
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…
Vishnu
Watt's Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March April May June July August $ 42,000 48,000 37,000 46,000 54,000 56,000 Sales in January and February were $45,000 and $44,000, respectively. Experience has shown that of total sales, 10 percent 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. Prepare a monthly cash receipts schedule for the firm for March through August. Credit sales Collections: In month of sale One month after sale Watt's Lighting Stores Cash Receipts Schedule January February March April May June July August Two months after sale $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 Total cash receipts
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell any plant and…
Shadee Corporation expects to sell 590 sun shades in May and 360 in June. Each shades sells for $15. Shadee's beginning and ending finished goods inventories for May are 80 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. It expects the following unit sales for the third quarter. July August September 545 450 430 Sixty percent of Shadee's sales are cash. Of the credit sales, 52 percent is collected in the month of the sale. 40 percent is collected during the following month, and 8 percent is never collected. Required: Calculate Shadee's total cash receipts for August and September Note: Do not round your intermediate calculations. Round your answers to the nearest whole dollar. Total Cash Receipts August September
Earthie's Shoes has 55% of its sales in cash and the remaining 45% are credit sales. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August? NOTE: Enter amounts rounded to the nearest whole dollar. Cash sales Cash for collections the month of sale Cash for collections the month after sale Cash for collections two months after sale TOTAL cash receipts S S LA

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS