The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2% cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $85,000, of which $25,000 represents uncollected March sales and $60,000 represents uncollected April sales. (Hint: For collections of March and April receivables, start by determining total sales for the month. Assume the normal sales pattern.) Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections. The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. • 20 percent in the month following sale. • 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2% cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $85,000, of which $25,000 represents uncollected March sales and $60,000 represents uncollected April sales. (Hint: For collections of March and April receivables, start by determining total sales for the month. Assume the normal sales pattern.) Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections.
Expert Answer:
Answer rating: 100% (QA)
May Sales Sales Revenue 150000 2 Cash Discount for May sales 2 of 150000 3000 collected in May Tot... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0697789938
13th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
If we prolong a no n critical activity by any amount of time, we can still finish the project by the earliest possible completion time.
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Thompson Toy Company manufactures toy building block sets for children. Thompson is planning for 2017 by developing a master budget by quarters. Thompsons balance sheet for December 31, 2016,...
-
Water flows in a partially full 2-m-diameter circular pipe an average velocity of 2 m/s. If the water depth in the pipe is 0.5 m, determine the flow area, the wetted perimeter, the hydraulic radius,...
-
MULTIPLE CHOICES 1. The difference between power and influence is that: a. Only really powerful people have influence b. Power is potential influence over others' actions, whereas influence is actual...
-
Explain structural analysis and copytesting and how they are used in evaluating the creative strategy.
-
Derive Eqs. (13.113b) and (13.116b) for the Mathieu equation. Equation 13.113b and 13.116b:- a 11 + E 62 - 8 + (13.113b)
-
The following are comparative data for Sunshine State Equipment, Inc., for the 3-year period 20092011. Instructions: 1. From the foregoing data, calculate financial ratios for the three years...
-
Identify FIVE (5) ways of ensuring that an organization's total compensation system is fair internally as well as externally, with a brief description of each.
-
55 Jason Ready, single, attended the University of San Diego during 2015-2019 under the Army ROTC program. Excluding the school expenses covered by his ROTC scholarship, he incurred additional school...
-
Parallelism In Writing | Grammarl X 73 C Checkr Dashboard structure.com/courses/309795/assignments/5837417?module_item_id=13088641 Eni Sign In with Autho +Verification Rules - Background attesta......
-
Midge is a 10% limited partner in Wild Catter, an oil and gas drilling partnership. She received her partnership interest in exchange for a $10,000 investment in the partnership. The balance in her...
-
Group the data given in the table into the following groups: $351,000400,000; 401,000450,000; 451,000500,000; 501,000550,000; 551,000600,000; 601,000650,000; 651,000700,000; over 701,000. Use the...
-
Olena Mirrors records bad debt using the allowance, income statement method. They recorded $343,160 in accounts receivable for the year and $577,930 in credit sales. The uncollectible percentage is...
-
Under Subchapter K, the partnership files Form 1065 reporting its income to the IRS. Which statement is true? a. The partners pay income tax on the portion of that taxable income that is distributed...
-
What is the output of the following? A. 2 2 B. 2 3 C. 3 2 D. 3 3 E. The code does not compile. F. The code compiles but throws an exception at runtime. var listing = new String[] [] { { "Book",...
-
Due to the government budget crunch due to the pandemic, the economic manager of the country looked into tax compromises and abatements done during the year. Upon evaluation, it discovered a tax...
-
Determine the center and radius of each circle. Sketch each circle. 4x 2 + 4y 2 9 = 16y
-
What is meant by the term operating leverage?
-
M. K. Gallant is president of Kranbrack Corporation, a company whose stock is traded on a national exchange. In a meeting with investment analysts at the beginning of the year, Gallant had predicted...
-
The just completed year, Hanna Company had a net income of $35,000. Balances in the companys current asset and current liability accounts at the beginning and end of the year were: The Deferred...
-
For most data sets that are skewed to the right, the mean is less than the median. In Exercises 1316, determine whether the statement is true or false. If the statement is false, rewrite it as a true...
-
The mean is resistant. In Exercises 1316, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
Find the mean, median, and mode for the following data set: -20 15 21 -20 19
Study smarter with the SolutionInn App