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 $53,200. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 75,600 $410,000 November $ 89,000 December $ 88,200 $ 574,000 $ 609,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 $318,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 $172,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $525,000 for December. Of this amount, $57,700 is for depreciation. e. A new web server for the Marketing Department costing $82,000 will be purchased for cash during December, and dividends totaling $12,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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. Total cash collections Cash disbursements for merchandise purchases < Req 1 and 2 Req 3 > Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 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. Ashton Company Cash Budget For the Month of December Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance < Req 1 and 2 Req 3 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 $53,200. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 75,600 $410,000 November $ 89,000 December $ 88,200 $ 574,000 $ 609,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 $318,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 $172,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $525,000 for December. Of this amount, $57,700 is for depreciation. e. A new web server for the Marketing Department costing $82,000 will be purchased for cash during December, and dividends totaling $12,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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 3 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. Total cash collections Cash disbursements for merchandise purchases < Req 1 and 2 Req 3 > Complete this question by entering your answers in the tabs below. Req 1 and 2 Req 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. Ashton Company Cash Budget For the Month of December Beginning cash balance Add collections from customers Total cash available Less cash disbursements: Payments to suppliers for inventory Selling and administrative expenses New web server Dividends paid Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Total financing Ending cash balance < Req 1 and 2 Req 3
Expert 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...
-
Forecasts for next year for two firms, A and B are: Stock A Stock B Return on equity 17% 15% Earnings per share $ 5.00 $ 4.00 Dividends per share $ 3.00 $ 3.00 a. What are the dividend payout ratios...
-
Learning by doing is an integral part of the course experience albeit online. The intent of this assignment is for you to demonstrate your ability to apply course content. Thus in the Marketing...
-
Draw the most stable chair conformation of -D-galactose.
-
1. Give the linear programming problem whose matrix formulation is "Minimize CX, subject to the constraints AX ¥ B, X ¥ 0." 2. Give the linear programming problem whose matrix formulation is...
-
Suppose the LED band gap is \(2.5 \mathrm{eV}\), which corresponds to a wavelength of \(500 \mathrm{~nm}\). Consider the possible electron transitions in Figure P29.76. \(500 \mathrm{~nm}\) is the A....
-
Marvin Gaye Company has been having difficulty obtaining key raw materials for its manufacturing process. The company therefore signed a long-term non-cancelable purchase commitment with its largest...
-
The Mixing Department of Premium Foods has 50,000 equivalent units of materials and 36,000 equivalent units of conversion costs for October. The Mixing Department of Premium Foods has direct...
-
Make a detailed presentation on The Scope and Challenge of International Marketing
-
Which sources of INTERNATIONAL LAW are the best in helping to control the covid 19, the pandemic. Give reasons and examples for the particular sources. (Sources of international law: Treaty,...
-
Treaties are an important element of international law give two reasons why this is the case when compared to other sources of international law
-
Argue why there is relationship of human right and international law. Integrate international law and human rights ties with divine providence in the argument.
-
Despite considerable emphasis by some international law scholars on court cases and precedents, can an argument be made that treaty law is the most important source of international law? Why?
-
Comment on the role of state sovereignty in international law. What are some benefits and risks of allowing state sovereignty to trump other factors in the development and application of...
-
Analyze the individual research topic from the perspective of a designer. And look at SHNEIDERMAN'S eight golden rules of interface design and Norman's seven principles for transforming difficult...
-
Pedro Bourbone is the founder and owner of a highly successful small business and, over the past several years, has accumulated a significant amount of personal wealth. His portfolio of stocks and...
-
With the availability of free credit reports, consumers are encouraged to check their report every 4 months-one report from each of the three major bureaus. In the past, consumers also were...
-
A leading financial publication reported that the average baby boomer credit user will pay approximately $1,200 in interest annually. If, instead of paying interest, this amount was saved every year,...
-
Some credit card issuers are beginning to assess fees and other charges on convenience users. Ask your friends and peers if they think a convenience credit card user should be charged for the...
Study smarter with the SolutionInn App