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 $40,000. b. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $65,000 $70,000 $83,000 Sales on account $400,000 $525,000 $600,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 $280,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 $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,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 $40,000. b. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $65,000 $70,000 $83,000 Sales on account $400,000 $525,000 $600,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 $280,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 $161,000, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $430,000 for December. Of this amount, $50,000 is for depreciation. e. A new web server for the Marketing Department costing $76,000 will be purchased for cash during December, and dividends totaling $9,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:
Related Book For
Elementary Linear Algebra with Applications
ISBN: 978-0471669593
9th edition
Authors: Howard Anton, Chris Rorres
Posted Date:
Students also viewed these accounting questions
-
Entry for Jobs Completed; Cost of Unfinished Jobs The following account appears in the ledger prior to recognizing the jobs completed in August: Work in Process $9,100 73,980 79,810 41,950 Balance,...
-
Homework In a location of highway construction project, where the (cross and longitudinal ) sections of the earthworks profile in that location are as shown in the given figure. Estimate the totally...
-
Homework of Earthworks In a location of highway construction project , where the ( cross and longitudinal ) sections of the earthworks profile in that location are as shown in the given figure....
-
Graph each inequality or compound inequality. 5x - y > 6
-
LLB Industries borrowed $200,000 from Trust Bank by issuing a two-year, 10% note, with interest payable quarterly. LLB entered into a two-year interest rate swap agreement on January 1, 2011 and...
-
Life insurance companies must carefully monitor death rates. Before issuing a life insurance policy for a 19-year-old, the company needs to know the death rate for that age group. Find the death rate...
-
McCaw Cellular Communications reported earnings before interest and taxes of \($850\) million in 1993, with a depreciation allowance of \($400\) million and capital expenditures of \($550\) million...
-
The bank portion of the bank reconciliation for Phillips Company at October 31, 2014, was as follows. The adjusted cash balance per bank agreed with the cash balance per books at October 31. The...
-
Hi, Could you please answer the below questions with calculations? 1. Describe the business project and the investment choice to be made. a. Selecting which lighting fixtures to install for the...
-
Absorption Costing Versus Variable Costing. Prime, Inc., produces tricycles. The company has no finished goods inventory at the beginning of year 1. The following information pertains to Prime, Inc....
-
Golden Corporation's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable...
-
What is a modal Triggering Event? How are Triggering events characterized?
-
What is the relationship between UCs and Modes of Operations?
-
What are the relationships among Phases, Modes, and States of Operation?
-
How do we derive Modes and States?
-
When are Modes and States defined in a project? Why?
-
Assume the following events for a month for Company X: Beginning Balance of Inventory is 400 Units and the cost is $200 per Unit. October 5 Company X purchases 400 Units at a cost of $220 per Unit....
-
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...
-
Use Theorem 5.2.1 to determine which of the following are subspaces of Mnn. (a) All n x n matrices A such that AT = -A (b) All n x n matrices A such that the linear system Ax = 0 has only the trivial...
-
Find conditions that the b's must satisfy for the system to be consistent. x1 - 2x2 + 5x3 = b1 4x1 - 5x2 + 8x3 = b2 - 3x1 + 3x2 - 3x3 = b3
-
For which values of a will the following system have no solutions? Exactly one solution? Infinitely many solutions? x + 2y - 3z = 4 3x - y + 5z = 2 4x + y + (a2 - 14)z = a + 2
-
\(4-5 \times 6\) Perform the indicated calculation.
-
After all operations in parentheses have been performed, which operations should be performed next?
-
If many operations have the same precedence in an expression, in what order should the operations be performed?
Study smarter with the SolutionInn App