You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $45,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 76,000 $ 450,000 November $ 76,400 $ 569,000 December $ 90,800 $ 604,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible. c. Purchases of inventory will total $288,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $162,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $495,000 for December. Of this amount, $88,800 is for depreciation. e. A new web server for the Marketing Department costing $83,500 will be purchased for cash during December, and dividends totaling $17,000 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month. You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $45,600. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 76,000 $ 450,000 November $ 76,400 $ 569,000 December $ 90,800 $ 604,000 Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected in the second month following sale. The remaining 2% is uncollectible. c. Purchases of inventory will total $288,000 for December. Thirty percent of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $162,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $495,000 for December. Of this amount, $88,800 is for depreciation. e. A new web server for the Marketing Department costing $83,500 will be purchased for cash during December, and dividends totaling $17,000 will be paid during the month. f. The company maintains a minimum cash balance of $20,000. An open line of credit is available from the company's bank to increase its cash balance as needed. Required: 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that any interest will not be paid until the following month.
Expert Answer:
Answer rating: 100% (QA)
Answer To prepare the December cash budget for Ashton Company we need to follow these steps 1 Calcul... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781259275814
11th Canadian Edition
Authors: Ray H Garrison, Alan Webb, Theresa Libby
Posted Date:
Students also viewed these accounting questions
-
Initial Population: Generation 1: Generation 2: Lab Genetic Algorithms Instructions Creating the Initial Population: The initial population was created using a random bit string generator. This step...
-
What are the energies of the two longest-wavelength lines in the Paschen series for hydrogen? What are the corresponding wavelengths? Give your answers to two significant figures.
-
(a) Show that the companion matrix C(p) of p (x) = x3 + ax2 + bx + c has characteristic polynomial - (3 + a2 + b + c). (b) Show that if A is an eigenvalue of the companion
-
Suppose that the inflation rate is expected to be 2.40% in the near future using the data provided above, what would be your predictions for the following? (Round your answers to 2 decimal places.)...
-
Provide the ideal gain scheduling for Figure 12.16 as a function of Q. DATA FROM FIGURE 12.16 Assume inertia varies with theta as follows: where JM is the motor inertia, JL is the load inertia, and R...
-
Refer to question 10. Suppose that the consultants fee is $5,000 and the utility function for the owner of Morley Properties can be approximated by the exponential utility function: U(x) = 1 e-x/R...
-
2 Photometry (18 points) Fixtures A and Fixture B are 2'x4' two-lamp fluorescent luminaires. Their candlepower distribution is as shown below. Find the illuminance levels at point a and point c. Show...
-
Assume you are in civil litigation and the complaint and answer have been filed with the court. As a result, you are now in the discovery stage of the case. Describe the methods of discovery that are...
-
Shanahan Construction Company has entered into a contract beginning January 1, 2015, to build a parking complex. It has been estimated that the complex will cost \($600\),000 and will take 3 years to...
-
Meng Group is preparing the comparative financial statements for the annual report to its shareholders for fiscal years ended May 31, 2015, and May 31, 2016 (yen in thousands). The income from...
-
On July 10, 2015, Amodt Music sold CDs to retailers on account and recorded sales revenue of 700,000 (cost 560,000). Amodt grants the right to return CDs that do not sell in 3 months following...
-
Tablet Tailors sells tablet PCs combined with Internet service (Tablet Bundle A) that permits the tablet to connect to the Internet anywhere (set up a Wi-Fi hot spot). The price for the tablet and a...
-
Comparative Analysis Case adidas and Puma The financial statements of adidas (DEU) and Puma (DEU) are presented in Appendices B and C, respectively. The complete annual reports, including the notes...
-
Read the following postings and comment on at posts. Make sure your comment is a relevant, informative comment: The only issue in regards to tort law cases that I have had any personal experience...
-
From 1970 to 1990, Sri Lanka's population grew by approximately 2.2 million persons every five years. The population in 1970 was 12.2 million people.What is the best formula for P, Sri Lanka's...
-
Write a numerical algorithm to solve Eq. 8.71 for \(A_{n}\). Obtain lift coefficients for \(h / 2 b=2\) and \(\mathrm{AR}=6,10\) at \(\mathrm{AoA}=12\). Eq. 8.71 Asin no 1 (y) 1 ban b 4h2b2 (cos...
-
Using (8.76) find the chord wise variation of the lift as \(L^{\prime}(x)\). Eq 8.76 1 za 2hg ax ax ax - (x)- aza
-
Why are none of the bulbs in Figure 31. 24 lit? Data from Figure 31. 24 Figure 31.24 (1) (iii) NNN
Study smarter with the SolutionInn App