A) Complete a cash collections schedule from the given information July August September Total Budgeted Sales $300,000 $400,000 $500,000 $1,200,000 Beginning A R balance for July is $125,000 Collections pattern is 65 in the month of sale, 35 the month following sale July August September Total Beginning A R July Sales August Sales September Sales Total B) Complete a production budget from the given information July August September Total Budgeted Sales in units 60,000 40,000 70,000 170,000 The company desires an ending inventory balance of 20 of the following months budgeted sales The beginning inventory balance at the start of July was 12,000 units Budgeted sales for October is 50,000 units July August September Total Budgeted Sales Desired ending inv total needs Beginning inv Total Production

The Answer is in the image, click to view ...

Question: A) Complete a cash collections schedule from the given information: July August September Total Budgeted Sales $300,000 $400,000 $500,000 $1,200,000 Beginning A/R balance for July

A) Complete a cash collections schedule from the given information:

	July	August	September	Total
Budgeted Sales	$300,000	$400,000	$500,000	$1,200,000

Beginning A/R balance for July is $125,000. Collections pattern is 65% in the month of sale, 35% the month following sale.

	July	August	September	Total
Beginning A/R
July Sales
August Sales
September Sales
Total

B) Complete a production budget from the given information:

	July	August	September	Total
Budgeted Sales in units	60,000	40,000	70,000	170,000

The company desires an ending inventory balance of 20% of the following months budgeted sales. The beginning inventory balance at the start of July was 12,000 units. Budgeted sales for October is 50,000 units.

	July	August	September	Total
Budgeted Sales
+Desired ending inv.
= total needs
-Beginning inv.
=Total Production

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

31.25 pts A retail tenant pays percentage rent of 3% over a natural breakpoint based upon a rental rate of $10 per square foot. The tenant leases 4,000 square feet and is estimated to generate...

show work please Chapter 8 #1 Complete a cash collections schedule from the given information: July August September Total Budgeted Sales $300,000 $400,000 $500,000 $1,200,000 Beginning A/R balance...

Complete a cash collections schedule from the given information: July August September Quarter Budgeted Sales $300,000 $400,000 $500,000 $1,200,000 Beginning A/R balance for July is $125,000....

Note 1 2 3 4 5 QUESTION 2 15 MARKS Vets on Vaal, is a veterinary practice situated in Parys, a small town in the Free State. Vets on Vaal is both a small and large animal vet practice. The practice...

i) The company has an agreement with a local bank that allows it to borrow in increments of $1,000 at the beginning of the month, up to a total of $40,000. The company will pay as much of its loan as...

QUESTION 2 Albert Holland, manager of Palm Beach Surfing Supplies has provided the following estimated figures for the months of July to October: Estimated cash balance at the end of August is $50...

only need questions 5-8 thats where I am stuck Case Study 2 Fall 1 2019 Master Budgeting and Pro-Forma Financial Statements You have just been assigned to a new manager who believes you have...

1. Silver Company makes a product that is very popular as a Mothers Day gift. Thus, peak sales occur in May of each year, as shown in the companys sales budget for the second quarter given below:...

The budget director of Heather's Florist has prepared the following sales budget. The company had $400,000 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of...

Q1 The management of Unter Corporation, an architectural design firm, is considering an investment with the following cash flows: Year Investment Cash Inflow $ 68, 000 $ 7, 000 $ 8, 000 $ 14, 000 to...

The budgets will be prepared based on the following information: a. Sales on account are budgeted at $15,000 for Month 1, $23,000 for Month 2, and $30,000 for Month 3. Cash sales are 2,000 in Month...

What is the value of L if the pressure reading in A is 150 kPa absolute? SGair = 0.002, SGHg = 13.58, SGlil 0.85, SGwater = 0.998 (6pts.) Air 32 cm 18 cm 35 15 cm Mercury Water

In the product F = qv x B, take q = 2, v = 2.0i + 4.0j + 6.0k and F = 4.0i = 20j + 12k. What then is B in unit-vector notation if Bx = By?

C 4 1 0 - 1 grams. D 4 1 0 3 grams. E 4 1 0 - 6 grams. 2 . The distance d that a certain particle moves may b e calculated from the expression d = a t + b t 2 where a and b are constants; and t i s...

Code in C only. Chef is very fond of horses. He enjoys watching them race. As expected, he has a stable full of horses. He, along with his friends, goes to his stable during the weekends to watch a...

Code only in C. Chef is very fond of horses. He enjoys watching them race. As expected, he has a stable full of horses. He, along with his friends, goes to his stable during the weekends to watch a...

PQR company manufactures three finished goods: X, Y, and Z. The selling price, variable costs, and contribution margin for one unit of each product are given in the following table: Selling price...

Outline and discuss two (2) attribute of a good Investment Promotion and Protection Agreement.

Question 1 7 ( 5 points ) What is the employee's responsibility in the self - assessment stage of career management? Provide assessment information to identify strengths, weaknesses, interests, and...

5.98 Financial Managers, Inc., buys and sells a large number of stocks routinely for the various accounts that it manages. Portfolio manager Sarah Bloom has asked for your assistance in the analysis...

5.97 Financial Managers, Inc., buys and sells a large number of stocks routinely for the various accounts that it manages. Portfolio manager Andrea Colson has asked for your assistance in the...

5.93 In a large department store a customer-complaints office handles an average of six complaints per hour about the quality of service. The distribution is Poisson. a. What is the probability that...