E11-7 Time allowed: 25 minutes You have been asked to prepare a December cash budget for...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66588af3e20c8_77166588af3dcc75.jpg)
Transcribed Image Text:
E11-7 Time allowed: 25 minutes 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: 1 The cash balance on 1 December will be 40,000. 2 Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October 65,000 400.000 November 70,000 525,000 December 83,000 600.000 3 Sales on account are collected over a three-month period in the following ratio: 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 uncollectable. Purchases of inventory will total 280,000 for December and 30% 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 4 Selling and administrative expenses are budgeted at $420,000 for December. Of this amount, 50,000 is for depreciation. 5 6 A new web server for the Marketing Department costing 76,000 will be purchased for cash during December, and dividends totalling 9,000 will be paid during the month. The company must maintain a minimum cash balance of 20,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. 2 Prepare a schedule of expected cash disbursements during December to suppliers for materials for Inventory purchases. 3 Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. E11-7 Time allowed: 25 minutes 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: 1 The cash balance on 1 December will be 40,000. 2 Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October 65,000 400.000 November 70,000 525,000 December 83,000 600.000 3 Sales on account are collected over a three-month period in the following ratio: 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 uncollectable. Purchases of inventory will total 280,000 for December and 30% 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 4 Selling and administrative expenses are budgeted at $420,000 for December. Of this amount, 50,000 is for depreciation. 5 6 A new web server for the Marketing Department costing 76,000 will be purchased for cash during December, and dividends totalling 9,000 will be paid during the month. The company must maintain a minimum cash balance of 20,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. 2 Prepare a schedule of expected cash disbursements during December to suppliers for materials for Inventory purchases. 3 Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month.
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Two automatic systems for dispensing maps are being compared by the state highway department. The accompanying breakeven chart of the comparison of these systems (System I vs System II) shows total...
-
Refer to the chapters opening feature about Devin Lazerine and his Rap-Up magazine. Required 1. What is the current circulation (to the nearest one hundred thousand) of Rap-Up magazine? 2. Assume...
-
Assume that you are a high-level manager for a shoe manufacturer. You know that your firm could increase its profit margin by producing shoes in Indonesia, where you could hire women for $100 a month...
-
Determine if the following graph represents the inequali x+2y8 y
-
The State Unemployment Tax Act, better known as SUTA, is a form of payroll tax that all states require employers to pay for their employees. SUTA is a counterpart to FUTA, the federal unemployment...
-
Huron Company produces a cleaning compound known as Zoom. The direct materials and direct labor standards for one unit of Zoom are given below: Direct materials Direct labor Hours Standard Quantity...
-
Variable costing income statement Sports Drinks, Inc. began business in the current year selling bottles of a thirst-quenching drink. Production for the first year was 249,600 bottles, and sales were...
-
Blossom Company has recorded the following items in its financial records: Cash in bank $49,000 Cash in plant expansion fund 104.200 Cash on hand 14,900 Highly liquid investments 36,800 Petty cash...
-
1. Discuss at least five major factors constraining growth and development in India. Explain in ten sentences. 2. Provide a brief discussion of potential policies in India that could address some of...
-
King Richard Radio's stock is expected to grow at a 10 percent rate for the next 3 years and then to level off at a constant growth rate of 3 percent per year thereafter. The company just paid a...
-
rn Linh Nguyen (SIN 808 785 448) is single with no dependants. Her address is 2209- 414 Gladstone Avenue, Your city, Your province, Your postal code. Linh was born on June 5, 1990. Her phone number...
-
If informal information systems are so pervasive, why do organizations need formal information and control systems?
-
What is the difference between the 'control' and 'strategy implementation' functions of management?
-
The feasibility constraints on the choice of controls should usually not be considered as absolute. Often each of the control types can be placed at a point on a continuum varying from 'totally...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App