10 4 points You have been asked to prepare a December cash budget for Ashton Company,...
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/66588af349b1e_77166588af345096.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66588af385835_77166588af3804c8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/66588af3cbf47_77166588af3c4f12.jpg)
Transcribed Image Text:
10 4 points 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 $55,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales eBook Sales on account October November December $ 69,400 $ 88,400 $ 96,800 $ 445,000 $ 596,000 $625,000 Print References 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 $340,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 $173,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $510,000 for December. Of this amount, $55,100 is for depreciation. e. A new web server for the Marketing Department costing $83,000 will be purchased for cash during December, and dividends totaling $18,500 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. 10 4 points 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 $55,400. b. Actual sales for October and November and expected sales for December are as follows: Cash sales eBook Sales on account October November December $ 69,400 $ 88,400 $ 96,800 $ 445,000 $ 596,000 $625,000 Print References 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 $340,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 $173,500, all of which will be paid in December. d. Selling and administrative expenses are budgeted at $510,000 for December. Of this amount, $55,100 is for depreciation. e. A new web server for the Marketing Department costing $83,000 will be purchased for cash during December, and dividends totaling $18,500 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:
Posted Date:
Students also viewed these accounting questions
-
Mr. Sam Spade, the president of Ajax, recently read in a report that a competitor named Bendix has the following relationship between cost and production quantity: c = $3,000,000 - $18,000Q + $75Q 2...
-
An art gallery purchases a painting for \($11,400\) on terms FOB shipping point. Additional costs in obtaining and offering the artwork for sale include $ 130 for transportation-in, $ 150 for import...
-
Corn Company incurs a cost of $35 per unit, of which $20 is variable, to make a product that normally sells for $58. A foreign wholesaler offers to buy 6,000 units at $31 each. Corn will incur...
-
a) If cos 7 25 what are the other primary trig ratios? Include a sketch of the triangle with your solution. (3 marks) - (C2) b) Solve this triangle. (3 marks) - (C2)
-
The locus of midpoints of the perpendiculars drawn from points on line x = 2y to the line x = y is L1. Suppose (h, k) lies on L1. If line L2 passing through the points (h, k) and (4, 3) is...
-
Jane Cruise has U.S. dollars ($) amounting to $1,000,000, and is provided with the following quotes: Bank C: Euro/US dollar = 0.8529/$ Bank C: British pound /US dollar = 0.7601/$ Bank D: British...
-
Life insurance: $10,000 Cost per unit: $18.50 Increase or monthly payment: 8% What is the monthly premium??
-
Pierre put $5,000 in his TESA every year for 15 years. The account now has a balance of $107,900. Now he wants to start a new business and takes out $50,000. What percentage of tax has he paid on the...
-
What is China size of its economy, population, its major manufactured commodities, and its top two imported and two exported commodities. Data: Roots of Comparative Advantage: Use data, graphs,...
-
Table 1 shows information for exchange rates and price indexes for different countries and for the U.S. Country Currency Table 1 Currency per U.S. Price U.S. Dollar Index Country Price Index Bolivia...
-
Cash equivalents under IFRS: may be required to be reported separately from cash in the future. are generally disclosed separately from cash. are significantly different than the cash equivalents...
-
Classify some organizations you have dealt with in terms of their dominant culture. What effects did this culture have on the effectiveness of their operations?
-
Define management control, and justify why you consider your definition to be an improvement on others that have been advanced.
-
As a manager becomes more senior, it appears that he needs to rely more on formal information yet that his style of life encourages him to use it less. How would you explain this apparent paradox?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App