a. The cash balance on December 1 is $45,600. b. Actual sales for October and November...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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% is 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: 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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Required 3 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. < Prev 6 of 7 Next > 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% is 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: 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. Complete this question by entering your answers in the tabs below. Req 1 and 2 Required 3 1. Calculate the expected cash collections for December. 2. Calculate the expected cash disbursements for merchandise purchases for December. < Prev 6 of 7 Next >
Expert 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
-
Write an essay:(300-400) on the following topics: What is the purpose of a small grocery store that sells goods and household items. What is the mission of a small grocery store that sells goods and...
-
Forecasts for next year for two firms, A and B are: Stock A Stock B Return on equity 17% 15% Earnings per share $ 5.00 $ 4.00 Dividends per share $ 3.00 $ 3.00 a. What are the dividend payout ratios...
-
Initial Population: Generation 1: Generation 2: Lab Genetic Algorithms Instructions Creating the Initial Population: The initial population was created using a random bit string generator. This step...
-
The hemispherical dome in Fig P2.91 weighs 30 kN and is filled with water and attached to the floor by six equally spaced bolts. What is the force in each bolt required to hold the dome down? cm e m...
-
Two parcels of land are being considered for a new office building. Both sites cost the same amount but differ mainly in their annual property tax assessments. The parcel in City A has a current...
-
A recent General Social Survey asked the following two questions of a random sample of 1492 adult Americans under the hypothetical scenario that the government suspected that a terrorist act was...
-
The balance sheets and additional information relating to Pennylane Ltd are given below. Prepare a cash flow statement for Pennylane Ltd for the year ended 31 December 2003 as required under FRS 1...
-
West Palm Company engaged in the following transactions involving promissory notes: May 3 Sold engines to Mittal Company for $120,000 in exchange for a 90-day, 12 percent promissory note. 16 Sold...
-
You want to buy a car, and a local bank will lend you $30,000.The loan would be fully amortized over 5 years (60 months), and thenominal interest rate would be 9%, with interest paid monthly.What i 2...
-
On March 31, 2019, Home Decorating Pavilion received a bank statement showing a balance of $9,840. The balance in the firm's checkbook and Cash account on the same date was $9,994. The difference...
-
Consider the valuation of a European call on Microsoft with strike price of 1 0 0 . 0 0 and 3 - months time to maturity. The current price is 1 0 0 . 0 0 and the volatility is 4 0 % over the option ...
-
A researcher builds a model in which a firm s liquidity ratio depends on the firm s profitability ratio and a dummy variable indicating whether the firm is listed on the stock exchange. In a second...
-
Personal Philosophy (aka Mission Statement): This section will provide inner insights about you. Explain your values and convictions, or the "rules" by which you live your life? 2. Demographic...
-
Simplify. (-8x2+2x-3)-[(4x2 - 1x + - [(4x - 1x+8) 2(-x + x + 3)] - G
-
2. Look at these two competing credit card offers: Offer A $120 annual fee 0% interest for the first year (22% interest thereafter) Extra travel miles 0.5% interest on CashAdvance Discount on travel...
-
Please view the video and tell me what are your thoughts on Gary's advice, and how it might influence your own marketing strategy and tactics for your term project. While several of the organizations...
-
Vince, Inc. has developed and patented a new laser disc reading device that will be marketed internationally. Which of the following factors should Vince consider in pricing the device? I. Quality of...
-
Worldwide Credit Card Inc. uses standards to control the labour time involved in opening mail from cardholders and recording the enclosed remittances. Incoming mail is gathered into batches, and a...
-
Phillips Company manufactures air-conditioning units for commercial buildings and has noticed considerable variation in shipping expenses from month to month as per the data below: What is the fixed...
-
Classic Sound is a s tart-up company that produces vinyl records for numerous record labels worldwide. The company has two full-time employees working in the production department while the CEO spl...
-
\(\frac{11^{3}}{11^{7}}\) Simplify the expression.
-
\(\frac{a^{14}}{a^{5}}\) Simplify the expression.
-
\(\frac{7^{14}}{7^{23}}\) Simplify the expression.
Study smarter with the SolutionInn App