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,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 77,000 $ 435,000 November $ 81,200 $ 538,000 December $ 87,800 $ 644,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 $341,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 $165,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $516,000 for December. Of this amount, $94,900 is for depreciation. e. A new web server for the Marketing Department costing $121,500 will be purchased for cash during December, and dividends totaling $13,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 Required 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 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,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October $ 77,000 $ 435,000 November $ 81,200 $ 538,000 December $ 87,800 $ 644,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 $341,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 $165,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $516,000 for December. Of this amount, $94,900 is for depreciation. e. A new web server for the Marketing Department costing $121,500 will be purchased for cash during December, and dividends totaling $13,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 Required 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
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...
-
What is the MFD? UFD? How are they related?
-
Rationalize the denominators in Problems 55 - 60. 3a-3b
-
Mya prefers Bundle A of goods over Bundle B. She also prefers Bundle B of goods over Bundle C. According to ? she must prefer Bundle A over Bundle C as well
-
Describe the categories of intentional torts. What is the difference between assault and battery? What is defamation of character? What two forms can it take? Under what circumstances can a...
-
Pantera Corporation manufactures several types of accessories. For the year, the gloves and mittens line had sales of $500,000, variable expenses of $375,000, and fixed expenses of $150,000....
-
4. The energy consumed by a machine is 14 kg m2/s. Convert this energy in lb, minute (min), and in. Note: 1 lb = 0.454 kg, 1 min = 60s, and 1 in = 0.0254 m. [A1] Lin
-
AG Mechanical is planning to acquire Foster Metal works. Foster's cost of equity is 12%; it is financed 80% by common equity and the remainder by debt at 7%. Foster's tax rate is 30%. Below is a...
-
Your company manufactures small kitchen appliances. It is introducing a new product line of appliances in various designer colours with distinctive features for small space kitchens. These new...
-
You have to develop a checklist for designing an effective cross-functional group. What are its elements?
-
You have to develop a checklist for designing an effective self-managed work group. What are its elements?
-
Differentiate between survey feedback and team building.
-
Explain why making groups larger does not always lead to an expected increase in performance.
-
Give an example of a person who is experiencing both intrasender and intersender role conflict.
-
Write a research paper on the following topic: Security Threat Groups/Gangs in Prison, Research the following Security Threat Groups/Gangs: The Aryan Brotherhood, Black Guerilla Family, the Folk...
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
Consider absence from work as an example of organizational behaviour. What are some of the factors that might predict who is likely to be absent from work? How might you explain absence from work?...
-
Do you think that organizations should base their hiring decisions on applicants personalities? What are the advantages and disadvantages of doing this? If an organization were to do this, what...
-
Use the contingency approach to describe a task or an organizational department where a more classical management style might be effective. Then do the same for a task or department where the human...
Study smarter with the SolutionInn App