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

Similar questions

New-Markups Department Store has annual credit sales of $ 300 million. John Harris, the collection manager, has estimated that it takes 10 days for a mailed payment to be credited to Newman’s account and that this time can be cut to 5 days if Newman opens up a lockbox account with a local bank. The account in which the checks are placed earns 8.4% annually. The lockbox agreement calls for a monthly payment of $1,350 and, in addition, a monthly charge of $0.06 per check. Newman’s currently processes 120,000 checks monthly. (Treat these expenses as if they occur at the beginning of the year.) a) What are Newman’s daily sales (assuming a 360-day year) b) By how much will Newman’s average bank balance increase if it adopts the lockbox? c) Should Mr Harris adopt the lockbox ? d) Suppose Newman’s has found a regular 20% of its customers account for 80% of credit sales. Should Mr Harris open up the lockbox and use it only for this 20% of the customers?
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…
Suppose that the Sales in December 2019 were 26,630. The sales are expected to grow by 7% in January 2020, by 5% in February 2020, and by 5% in March 2020. After that, the sales are expected to grow by 11%. The company's cash collection is as follows: 71% is collected in the same month and the remainder in the next month. What is the cash collection for July, 2020?
Fine Co. has the following sales forecasts for the third quarter of 2021: ₱85,000 (July), ₱88,000 (Aug), ₱82,000 (Sep). All sales are on credit. Seventy-five percent are collected in the month of sales and remainder is collected the following month. Minimum cash balance is ₱10,000. How much cash would be collected in August from sales?
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?
Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December
The management of Vuti has supplied the following sales amounts for the next five months: January February March April May R60 000 R75 000 R55 000 R65 000 R50 000 Additional information: • Off all sales 35% are cash sales based in value. • Of credit sales 50% is collected within the month of sales. Two-thirds of the credit sales collected within the month of sales receives 2% discount. A further 30% of credit sales is collected in the following month; and the remaining credit sales is collected in the month thereafter. Bad debts amounts to 3% of the credit sales. Required: Prepare a debtor's collection schedule that clearly shows how credit sales for the five months will be collected. NB: Round off calculations to two decimal places and the final amount to the nearest value.
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
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…
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…
Smith Inc. currently fills mail orders from all over the country and receipts were received in its head office. The company's average accounts receivable is P3,125,000 and is financed by a bank loan with 10% interest. Smith is considering a regional lockbox system to speed up collections. This system is projected to reduce the average accounts receivable by 15%. The annual cost of the lockbox system is P25,000. What is the estimated net annual savings in implementing the lockbox system? A. 22,985 B. 28,455 C. 25,750 D. 21,875
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?