Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50%of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the monthfollowing the sale, net a 3% credit card fee. This means that if the sale is $100, thecredit card company's fee is $3, and Worthington receives $97. Account saleswill be collected as follows: 40% in the first month following the sale, 50% in the second monthfollowing the sale, 8% in the third month following the sale, and 2% never collected.The following table identifed the projected sales for the first year of operations:MonthSalesMonthJanuary $12,369,348 JulySales$21,747,839February 15,936,293 August14,908,534March13,294,309 September11,984,398April19,373,689 October18,894,535May20,957,566 November 21,983,545June18,874,717 December 20,408,367Complete the following statement showing the cash expected each month from the collections ofthese sales.Round all calculations to the nearest whole dollar amount.MonthJanuary $February $March $April $May $June $July $August $September $October $November $December $Cash Sales Credit Card Sales Account Sales Total Cash Collections$$"A$IA$$LA$$$$6A$$$+A$+ALALA$+A$LA$+A$$$ALAALAALALA$$+A$LA$LA$$

It is the process of undertaking plans to spend money. This plan enables the business in advance to…

Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50% of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales will be collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifed the projected sales for the first year of operations:

Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50% of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales will be collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifed the projected sales for the first year of operations:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Cash Accounts receivable Inventory Budgeted Balance Statemen July 31, 2021 Assets

A: *Estimated account receivable turnover: Credit sales = 345000×80% = $276000 Out of $276000, 30% will…

Q: A company is launching a new sales initiative and expects sales of $446,838 during the first year,…

A: Net working capital (NWC) is a financial metric that represents the difference between a company's…

Q: Bee Nay has projected sales of 200,000, gross profit rate of 40% and return on sales of 10%.…

A: Total assets are the resources owned by an entity either for the purpose of using them for daily…

Q: Romper Company expects its November sales to be 20% higher than its October sales, which were…

Q: Apollo Data Systems is considering a promotional campaign that will increase annual credit sales by…

A: 1. Accounts receivable = Sales/Accounts receivable turnoverAccounts receivable = $600,000/5 = $…

Q: Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that…

A: WORKING NOTE : 1) The cash sales for any month will be: 0.20 * Sales of that month. 2) Cash…

Q: 1. XYZ Company sells books to universities. The company policy is to sell 60% cash and the rest in a…

A: The difference between a company's total revenue and total costs over a given period is known as…

Q: Sunland Company estimates its sales at 400000 units in the first quarter and that sales will…

A: In this question, we need to compute the budgeted cash collections for the third quarter using the…

Q: Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If…

A: The cash budget is prepared to know the estimated cash receipt and cash expenses. it helps in the…

Q: Bruno Industries expects credit sales for January, February, and March to be $200,000, $260,000, and…

A: Cash collection budget :— This budget is prepared to estimate the collection of sales from customers…

Q: Valley's managers have made the following additional assumptions and estimates: Estimated sales…

A: The cash budget estimates the excess of cash balance available over the cash disbursements during…

Q: The Guitar Shoppe reports the following sales forecast: August, $120,000; September, $210,000. Cash…

A: Cash receipt budgets used by the entity to identify the amount of cash collected every month from…

Q: w months are planned as follows: 1. Demand: July 180,000 units, August 200,000 units, September…

A: Budget are the planned activity for collection and distribution of resources in such a way to…

Q: Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of…

A: The objective of this question is to calculate the amount of accounts receivable at the end of July…

Q: The Professional Service Company expects 70% of sales for cash and 30% on credit. The company…

A: Credit Sales of June: 70% will be collected in June. 25% will be collected in July. 5% are not…

Q: Calculate the expected total cash collections for July

A: Cash and cash equivalents (CCE) - is one of the important elements of the balance sheet which are…

Q: Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over the next few months are…

A: The cash budget is the budgeting statement prepared by the management by estimating future cash…

Q: Excel Berhad manufactures one product line – the Nexus. Sales of Nexus over the next few months are…

A: A cash budget is an estimate of a corporation's cash flows for a given time span. A cash budget is…

Q: Yung Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be…

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

Q: Simpson Glove Company has made the following sales projections for the next six months. All sales…

A: Budget means the expected value of future. Budget will be compared with actual value and variance is…

Q: Halifax Shoes has 39% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…

A: Budgeting is an important part of the business process. Without budgeting a business cannot track…

Q: Assume receivables of $20,000 at the start of the January are all collected during the month; if…

A: When a sale is made and cash is received at the time of sale it is referred to as cash sale, however…

Q: Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of…

A: The objective of the question is to calculate the amount of accounts receivable at the end of July…

Q: Graham Company projects the following sales for the first three months of the year: $10,600 in…

A: The cash collection schedule is prepared to estimate the amount of cash to be collected from…

Q: Office World Inc. has “cash and carry” customers and credit customers. Office World estimates that…

A: The Schedule of Collections from Sales shows the amount to be collected from the customers during a…

Q: alifax Shoes has 33% of its sales in cash and the remainder on credit. Of the credit sales, 65% is…

A: Companies gives credit to the customers and customers pay later on so cash money is blocke in credit…

Concept explainers

Conversion Cycle

Conversion cycle is also known as cash cycle or net operating cycle. Conversion cycle refers to how much time a company takes to turn its investments which is done from stock or any other financial resources into cash flows from sales.

Question

Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50%
of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month
following the sale, net a 3% credit card fee. This means that if the sale is $100, the
credit card company's fee is $3, and Worthington receives $97. Account sales
will be collected as follows: 40% in the first month following the sale, 50% in the second month
following the sale, 8% in the third month following the sale, and 2% never collected.
The following table identifed the projected sales for the first year of operations:
Month
Sales
Month
January $12,369,348 July
Sales
$21,747,839
February 15,936,293 August
14,908,534
March
13,294,309 September
11,984,398
April
19,373,689 October
18,894,535
May
20,957,566 November 21,983,545
June
18,874,717 December 20,408,367
Complete the following statement showing the cash expected each month from the collections of
these sales.
Round all calculations to the nearest whole dollar amount.
Month
January $
February $
March $
April $
May $
June $
July $
August $
September $
October $
November $
December $
Cash Sales Credit Card Sales Account Sales Total Cash Collections
$
$
"A
$
IA
$
$
LA
$
$
$
$
6A
$
$
$
+A
$
+A
LA
LA
$
+A
$
LA
$
+A
$
$
$
A
LA
A
LA
A
LA
LA
$
$
+A
$
LA
$
LA
$
$

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Define 'Budgeting':

VIEW

Step 2: Complete the table to show expected cash collections:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

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…
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
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
JoAnn Manufacturing has projected the following sales for the coming year: Sales $25,847.50 C$25,182.50 $22,604.17 Q1 $23,560.83 Q2 $ 54,750 $ 61,850 Q3 The company places orders each quarter that are 35 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? $70,050 Q4 $75,750
Financial information for Strawberry’s Place is as follows: Cash at 1/1/20X1 is $10,000. The firm desires to maintain a minimum balance of $10,000 at the end of each month. Total monthly sales are as follows: DecemberJanuaryFebruary 20X020X120X1 $120,000150,000 (est.)160,000 (est.) The sales are 40 percent cash and 60 percent credit card. Visa is the only acceptable credit card at Strawberry’s, and assume the charges are converted to cash the day of the sale. The brokerage charge is 2 percent of the sale. Expected other income is $2,000 from interest to be received in February. In addition, in January, a range with a net book value of $300 is expected to be sold for cash, resulting in a $1,000 gain on the sale. Food and beverages are paid for the month following the sale and average 40 percent and 25 percent, respectively. Food sales are four times beverage sales. Total sales consist of only food and beverage sales. Labor is paid for the last day of the month and…
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
Monthly sales for the Garden Centre are shown in the table below. Garden CentreSales Forecast Month Sales January $20,000 February $22,000 March $26,000 April $30,000 May $35,000 June $40,000 The Garden Centre purchases inventory two months in advance. They pay for 50% of the merchandise the month after the purchase, and the other 50% two months after the purchase. The Garden Centre’s gross margin is 40%. What are the Garden Centre’s payments to suppliers in March? Please avoid image based solutions thank you