Yung Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be $892,000 in October, $954,000 in November,$1,040,000 in December, and $928,000 in January. Yung's sales are 25% cash and 75% credit. The company's collection history indicates that creditsales are collected as follows:20% in the month of the sale65% in the month after the sale8% two months after the sale7% are never collectedRequirements1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales.2. Prepare a cash collection budget for December and January. Round all answers up to the nearest dollar.Yung ReedsBudgeted Cash Collections from CustomersFor the Months of December and JanuaryDecemberCash salesCollection of credit sales:20% of current month credit sales65% of prior month credit sales8% of credit sales two months agoTotal collection of credit salesTotal cash collections$$260,000 $156,000465,07553,520934,595 $January232,000139,200507,00057,240935,440

Sales budget and cash collection budget is part of budgeting. It is preparing for the future period.…

Answered: Yung Reeds, a manufacturer of…

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

Memphis Company anticipates total sales for April, May, and June of $990,000 $1,090,000, and $1140,000 respectively. Cash sales are normally 20% of total sales. of the credit sales, 35% are collected in the same month as the sale, 60% are collected during the first month after the sale, and the remaining 5% are not collected. Compute the amount of cash received from credit sales during the month of May.
Cave Hardware's forecasted sales for April, May, June, and July are $220,000, $260,000, $190,000, and $300,000, respectively. Sales are 70% cash and 30% credit with all accounts receivables collected in the month following the sale. Cost of goods sold is 75% of sales and ending inventory is maintained at $55,000 plus 20% of the following month's cost of goods sold. All inventory purchases are paid 28% in the month of purchase and 72% in the following month. What are the cash collections budgeted for June at Cave Hardware? $267,000 $133,000 $211,000 $156,000
Craig has projected sales to be $90,400 in April; $96,400 in May; $104,500 in June and $93,600 in July. The history of Craig’s sales indicates 20% cash and the remaining 80% on credit. The company’s collection history indicates that credit sales are collected as follows: 30% collected in the month of the sale 60% collected in the month after the sale 8% collected two months after the sale 2% of credit sales are never collected
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 $74,000 in June, $68,000 in July, and $88,000 in August? Cash collected $fill in the blank 1
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $524,000 for April, $534,000 for May, and $559,000 for June. Total sales for March are $307,500. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts 524,000 ***** 534,000 June 559,000
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April May Collections of prior period sales Total cash receipts S S $ $ $ $ June
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
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
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 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 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 of August? How much of this is expected to be collected later? Amount…
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
Cash Collections for Belcher Motors found that 35% of its sales were cash and the remaining 65% are credit sales. Of the credit sales, the company collected 55% in the month of sale, 40% collected the month after the sale, and 5% collected the second month after the sale. May Sales were $100 000, April Sales were $115,000, and June Sales were 136,000. How much will be collected in the 3rd quarter if July sales are $180,000, August sales are 167,000, and September sales are $152,000, and include a total column for the 3rd quarter total.
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

SEE MORE QUESTIONS

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