Johnson Corporation has the following sales forecasts for the first threemonths of the current year:MonthSalesJanuary$39,000February26,000March45,00085% of sales are collected in the month of the sale and the remainder iscollected in the following month.Accounts receivable balance (January 1)Cash balance (January 1)Minimum cash balance needed$25.80025.00022.000What is the cash balance at the end of January, assuming that cash is receivedonly from customers and that $50,000 is paid out during January?

Computation of the cash balance at the end of January:Cash balance, January 1$25,000Add: Cash…

Answered: Johnson Corporation has the following…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

See similar textbooks

Similar questions

Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Assume that it is now July of Year 1 and that the brothers are developing projected financial statements for the following year. Further, assume that sales and collections in the first half-year matched the predicted levels. Use the Year-2 sales forecasts shown in the following table to estimate next year’s receivables levels for the end of March and for the end of June.
Magenta Corporation has the following sales forecasts for the selected three-month period for the current year: Month Sales July $30,000 August 15,000 September 12,000 All sales are on account. Sixty percent of sales are collected in the month of the sale, and the remainder are collected in the following month. Accounts receivable balance (July 1) $28,000 Cash balance (July 1) 17,000 Minimum cash balance is $13,000. Cash can be borrowed in $2,000 increments from the local bank (assume no interest charges).What is the cash balance at the end of July, assuming that cash is received only from customers and that $53,000 is paid out during July? a.$18,500 b.$14,000 c.$25,000 d.$20,200
Data regarding a company's monthly sales for the last six months of the year and its projected collection patterns are shown below:Forecasated sales:July = P775,000August = P750,000September = P825,000October = P800,000November = P850,000December = P900,000Types of sales:Cash sales = 20%Credit sales = 80%Collection pattern for credit sales:In the month of sale = 40%In the first month following the sale = 57%Uncollectible = 3% The cost of merchandise averages 40% of its selling price. The company's policy is to maintain an inventory equal to 25% of the next month's forecasted sales. The inventory balance at cost is P80,000 as of June 30. How much is the total cash receipts that would be budgeted for the month of September?
Thomas & Cooke Corporation has the following sales forecasts for the first three months of the current year: Month Sales January $39,000 February 26,000 March 45,000 85% of sales are collected in the month of the sale and the remainder is collected in the following month. Accounts receivable balance (January 1) $25,800 Cash balance (January 1) 25,000 Minimum cash balance needed 22,000 What is the cash balance at the end of January, assuming that cash is received only from customers and that $50,000 is paid out during January?
Mercurius forecasts the following sales figures for the next four months. June July August September 420,000 350,000 380,000 440,000 Cash sales average 15% of total sales. Credit sales are collected 60% in the month of sale and 40% in the month following sale. What is Mercurius' estimated accounts receivable balance on 31 July?
Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in January; $10100 in February and $10400 in March. the company expects 60% of the sales to be cash and the remainder on accounts. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Account Receivable account has a zero on January. 1. Prepare a schedule of cash receipts for Marlin for January, February and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 70% in the month of the sale, 20% in the following month of the sale and 10% in the second month of the sale. What is the balance in Accounts Receivable on March 31?
Fine Co. has the following sales forecasts for the third quarter of 2021: P85,000 (July), P88,000 (Aug), P82,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 P10,000. How much cash would be collected in September from sales? A P61,500 P66,000 P87,250 D P83,500
Trapp Co. was organized on August 1 of the current year. Projected sales for the first three months are: August - $100,000; September - $185,000; October - $225,000. The company expects to sell 40% of its merchandise for cash. Of the sales on account, one-third is expected to be collected in the month of the sale and the remainder in the following month. 1.)What would be the amount collected from accounts receivable in the month of August from the August sales on account (credit sales for August x .333)? 2.)What would be the amount collected from accounts receivable in the month of September from the September sales on account (credit sales for September x .333)? 3.)What would be the total amount collected from accounts receivable in the month of September [(credit sales for September x .333) + (credit sales for August x .667)]?

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS