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 will be $40,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales. Sales on account October $ 61,000 409,000 November $ 67,000 529,000 December $ 83,300 595,000 Sales on account are collected over a three-month period in the following ratio: 18% collected in the month of sale, 62% collected in the month following sale, and 19% collected in the second month following sale. The remaining 1% are uncollectible. c. Purchases of inventory will total $281,000 for December. 30% of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $163,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $429,000 for December. Of this amount, $49,000 is for depreciation. These are paid in the period incurred. e. A new Web server for the Marketing Department costing $75,000 will be purchased for cash during December, and dividends totalling $8,800 will be paid during the month. f. The company must maintain a minimum cash balance of $19,000. An open line of credit is available from the company's bank to bolster the cash position, as needed. Required: 1. Prepare a schedule of expected cash collections for December. ASHTON COMPANY Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections $ 2. Prepare a schedule of expected cash disbursements for materials during December to suppliers for inventory purchases. ASHTON COMPANY Schedule of Expected Cash Disbursements Payments to suppliers: November purchases (accounts payable) December purchases Total cash payments $ 0 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. ASHTON COMPANY Cash Budget For the Month of December Total cash available before current financing Deduct disbursements: Total disbursements Excess (deficiency) of cash available over disbursements Financing: Total financing $ $ 0 0 0 0 0 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 will be $40,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales. Sales on account October $ 61,000 409,000 November $ 67,000 529,000 December $ 83,300 595,000 Sales on account are collected over a three-month period in the following ratio: 18% collected in the month of sale, 62% collected in the month following sale, and 19% collected in the second month following sale. The remaining 1% are uncollectible. c. Purchases of inventory will total $281,000 for December. 30% of a month's inventory purchases are paid during the month of purchase. The accounts payable remaining from November's inventory purchases total $163,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $429,000 for December. Of this amount, $49,000 is for depreciation. These are paid in the period incurred. e. A new Web server for the Marketing Department costing $75,000 will be purchased for cash during December, and dividends totalling $8,800 will be paid during the month. f. The company must maintain a minimum cash balance of $19,000. An open line of credit is available from the company's bank to bolster the cash position, as needed. Required: 1. Prepare a schedule of expected cash collections for December. ASHTON COMPANY Schedule of Expected Cash Collections December cash sales Collections on account: October sales November sales December sales Total cash collections $ 2. Prepare a schedule of expected cash disbursements for materials during December to suppliers for inventory purchases. ASHTON COMPANY Schedule of Expected Cash Disbursements Payments to suppliers: November purchases (accounts payable) December purchases Total cash payments $ 0 3. Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. ASHTON COMPANY Cash Budget For the Month of December Total cash available before current financing Deduct disbursements: Total disbursements Excess (deficiency) of cash available over disbursements Financing: Total financing $ $ 0 0 0 0 0
Expert Answer:
Answer rating: 100% (QA)
Both schedules are correctly done hence not reproduced here The cash budget is shown belo... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0470423684
13th Edition
Authors: Donald E. Kieso, Jerry J. Weygandt, and Terry D. Warfield
Posted Date:
Students also viewed these accounting questions
-
What date or event does the profession believe should be used in determining the value of a share option? What arguments support this position?
-
What date or event does the profession believe should be used in determining the value of a stock option? Please discuss the arguments that support this position. ALSO, As it relates to securities,...
-
What date or event does the profession believe should be used in determining the value of a stock option? What arguments support this position?
-
Review the Financial Statements provided to each group on Blackboard (You may use laptops for this exercise). [ Focus on: a) Is the company Profitable b) Does the company have a lot of liabilities c)...
-
The real free rate is 2%. Inflation is expected to be 3% this year, 4% next year, and 3.5% thereafter. The maturity risk premium is estimated to be 0.005 ( (t - 1), where t = number of years to...
-
Taylor, I just got elected to serve a three-year term on the budgeting group Identify the dimension of the group structure exemplified in each statement. A. Formal group B. Informal group C....
-
In February 2007, The Elliot Group, Inc., an Illinois real estate developer, made a deal with the Village of Arlington Heights to develop property in that village. Arlington Market, LLC, was...
-
On July 1, 2014, Sutton Inc. invested $720,000 in a mine estimated to have 800,000 tons of ore of uniform grade. During the last 6 months of 2014, 120,000 tons of ore were mined and sold....
-
Hi guys, write 300 words for each of the discussion questions. 1) Compare and contrast benefits and challenges that exist between centralized database management systems and distributed database...
-
1. Liam Richardson is the business manager for the Smith & Lyngate Insurance agencies in the state of Maryland. Liam is interested in increasing the number of agents in Baltimore and plans to buy...
-
Ontario brought in rent control for most residential tenancies in 1975. What is rent control? Rules which limit what rent increases landlords can charge tenants Rules that provide the landlord with...
-
A toy rocket, launched from the ground, rises vertically with an acceleration of 39 m/s for 14 s until its motor stops. Disregarding any air resistance, what max- imum height above the ground will...
-
Solve the answers below RK #4 CHAP 04 i Saved The following condensed income statements of the Jackson Holding Company are presented for the two years ended December 31, 2024 and 2023: Help Save &...
-
Implement an interface called Developerinfo with the following constant variables: DEV_MONTHLY SALARY 150DD INTERN MONTHLY HOURS WORED = 150 STOCKS PER MONTH = 2000 Note: Make use of this interface...
-
- A block of mass m = 5,3 kg slides on a rough surface and moves toward a spring with a spring constant k = 2455 N/m, as shown in the figure below. When the block is d 15,5 m away from the spring, it...
-
Implement an interface called Developerinfo with the following constant variables: DEV_MONTHLY SALARY 150DD INTERN MONTHLY HOURS WORED = 150 STOCKS PER MONTH = 2000 Note: Make use of this interface...
-
Grocer, upset with the $50,000 loss in (c), above, fires manager at the end of the year and in the succeeding year, Grocer manages the store on a full-time basis and in that year makes a $60,000...
-
For liquid water the isothermal compressibility is given by; where r and b are functions of temperature only. If 1 kg of water is compressed isothermally and reversibly from I to 500 bar at 60(C. how...
-
Ford Motor Co. is considering alternate methods of accounting for the cash discounts it takes when paying suppliers promptly. One method suggested was to report these discounts as financial income...
-
Relative Sales Value Method During 2011, Crawford Furniture Company purchases a carload of wicker chairs. The manufacturer sells the chairs to Crawford for a lump sum of $60,000, because it is...
-
What are postretirement benefits other than pensions?
-
This question is an extension of Exercise 10.22. Consider the data file \(m r o z\) on working wives and the model \(\ln (W A G E)=\beta_{1}+\beta_{2} E D U C+\beta_{3} E X P E R+e\). Use the 428...
-
Consider the data file \(m r o z\) on working wives. Use the 428 observations on married women who participate in the labor force. In this exercise, we examine the effectiveness of alternative...
-
To examine the quantity theory of money, Brumm (2005) ["Money Growth, Output Growth, and Inflation: A Reexamination of the Modern Quantity Theory's Linchpin Prediction," Southern Economic Journal,...
Study smarter with the SolutionInn App