Ashton Company, a distributor of exercise equipment, is preparing a cash budget for December. It provided...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ashton Company, a distributor of exercise equipment, is preparing a cash budget for December. It provided the following Information: 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% are 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: For December: 1. Calculate the expected cash collections. 2. Calculate the expected cash disbursements for merchandise purchases. 3. Prepare a cash budget. Indicate in the financing section any borrowing needed during the month. Assume any Interest will not be paid until the following month. Complete this question by entering your answers in the tabs below. Required 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 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 0 0 0 0 S Ashton Company, a distributor of exercise equipment, is preparing a cash budget for December. It provided the following Information: 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% are 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: For December: 1. Calculate the expected cash collections. 2. Calculate the expected cash disbursements for merchandise purchases. 3. Prepare a cash budget. Indicate in the financing section any borrowing needed during the month. Assume any Interest will not be paid until the following month. Complete this question by entering your answers in the tabs below. Required 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 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 0 0 0 0 S
Expert Answer:
Answer rating: 100% (QA)
1 Calculate the expected cash collections for December The cash collections for December consist of ... 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
-
Question 4 20 pts Roberts Industries uses a cost system for their baseball caps. Below is the information for the fabric used as direct materials inventory at a standard cost. The controller has...
-
Question: 1. Other approaches that can be discussed in quality management: - Explain what is Deming approach and its importance - Compare the differences and the advantages and disadvantages of...
-
Rewrite this: Early Career Decision-Making: A significant proportion of students have already chosen their major prior to entering college or during their first year. This underscores the importance...
-
Please research a small business Chagrin Falls Popcorn Shop ( https://www.chagrinfallspopcorn.com/ ) social media, and mobile marketing they have been using, etc). In the final exam, you will put...
-
Would a profit-maximizing firm continue to operate if the price in the market fell below its average cost of production in the short run?
-
Occupational prestige is a statistic developed by sociologists to measure the status of one's occupation. Occupational prestige is also a component of what sociologists call socioeconomic status, a...
-
Kemico Ltd manufactures a variety of chemicals which it supplies in bulk to industrial customers. Its factory at Gritborough employs 50 people, and its annual turnover in 1995 was 7.5M. During 1995,...
-
What information does Alison need to determine the probable impact of Kelseys proposed project on the other projects in the department? Should her findings affect her decision about Kelseys project?...
-
Throughout this assignment, you should only use these accounts: Accounts Receivable Accounts Payable Accumulated Depreciation Accounting Expense Additional Paid-in Capital Advertising Expense...
-
State three (3) other names by which the nurse-client relationship is called. NB: Please type the solutions
-
Consider 4 planning departments A,B,C and D. The target production rate is 100 items per day for a product with 3 components. To produce one product: three component-1 two component-2 - one...
-
A new credit card company operating in Canada is investigating various market segments to determine their profitability. One of the segments of interest is that of immigrants who became permanent...
-
This tree has internal nodes nodes. It has leave nodes and The first node visited in an The last node visited in a PostOrder traversal is The first node visited in a InOrder traversal is PreOrder...
-
Find a function y(x) such that 7yyx and y(7) = 9.
-
Farmland Enterprises, Inc., headquartered in Des Moines, Iowa, is a major supplier of seed corn in the Midwest. The firm has a capital structure that consists of 70 percent equity and 30 percent...
-
Solano Company has sales of $780,000, cost of goods sold of $510,000, other operating expenses of $38,000, average invested assets of $2,300,000, and a hurdle rate of 12 percent. Required: 1....
-
Use Stokes' Theorem to evaluate f(y+sin x) dx+(z+cos y) dy+rdz, where C is the rve r(t) = (sint, cost, sin 2t), t = [0, 2].
-
Sanchez Company's manufacturing overhead budget for the first quarter of 2002 contained the following data. Actual variable costs were: indirect materials \($14,200\), indirect labor \($9,600\),...
-
As sales manager, Todd Keyser was given the following static budget report for selling expenses in the Clothing Department of Pace Company for the month of October. As a result oi this budget report,...
-
Haven Manufacturing Inc. has three divisions which are operated as profit centers. Operating data for the divisions listed alphabetically are as follows. Instructions (a) Compute the missing amounts....
Study smarter with the SolutionInn App