Cannington Outlet is an independently owned sports and outdoor products discount chain with ten stores located...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cannington Outlet is an independently owned sports and outdoor products discount chain with ten stores located in Hong Kong. Rapid expansion has created the need for careful planning of cash requirements to ensure that the chain is able to replenish stock adequately and meet payment schedules to creditors. Christopher Lee, founder of the chain, has established a banking relationship that provides a $2,000,000 line of credit to Cannington Outlet. The chain must maintain a minimum cash balance of $80,000 at the end of each month. Cannington Outlet attempts to borrow, at the beginning of the month, as little as possible. The interest rate on the loans is 12% per annum and for simplicity we will assume that interest is not compounded. The chain would, as far as it is able, repay the loan plus accumulated interest at the end of the month following the loan. The chain currently has no outstanding loans. The following cash receipts and disbursements data apply to the fourth quarter of Year 2021: • The estimated cash balance as at 1 October is $88,000. Some of the actual and expected sales data for August 2021 to January 2022 are extracted and summarized as follows: Cash sales Sales on account Total sales August (actual) 2021 2022 January September October November December (actual) (estimated) (estimated) (estimated) (estimated) $140,000 $290,000 $440,000 $1,040,000 $1,280,000 $1,350,000 $1,420,000 $1,880,000 $1,490,000 $1,710,000 $2,320,000 $2,100,000 Projected cash collection of sales on account is estimated to be 70% in the month of the sale, 20% in the month following the sale, and 6% in the second month following the sale. The 4% beyond the second month following the sale is determined to be uncollectible. The chain is scheduled to receive $300,000 cash on a note receivable in October. • All merchandise purchases are made on account as the chain has excellent credit with all vendors because of a strong payment history. Each month's ending inventory must equal 25% of the following month's cost of goods sold. The cost of goods sold is 60% of total sales. The chain pays for 80% of its merchandise purchases in the month of the purchase and the remaining 20% in the month following the purchase. The ending inventory balance and accounts payable balance as at 30 September is $223,500 and $175,000, respectively. All of the accounts payable at 30 September will be paid in October. Monthly selling and administrative expenses during October, November, and December are estimated to be $380,000, $410,000, and $460,000, respectively; these amounts include $30,000 of depreciation each month. Dividends of $250,000 will be declared and paid in November. Equipment costing $530,000 and $200,000 will be purchased for cash in October and December, respectively. Required: (i) (ii) Prepare a schedule of expected cash collections from customers for October, November, and December. (6 marks) Prepare the following budgets for merchandise purchases: (a) A merchandise purchases budget for October, November, and December (5 marks) (b) A schedule of expected cash disbursements for merchandise purchases for October, November, and December. (3 marks) (iii) Prepare a cash budget for October, November, and December. (11 marks) Cannington Outlet is an independently owned sports and outdoor products discount chain with ten stores located in Hong Kong. Rapid expansion has created the need for careful planning of cash requirements to ensure that the chain is able to replenish stock adequately and meet payment schedules to creditors. Christopher Lee, founder of the chain, has established a banking relationship that provides a $2,000,000 line of credit to Cannington Outlet. The chain must maintain a minimum cash balance of $80,000 at the end of each month. Cannington Outlet attempts to borrow, at the beginning of the month, as little as possible. The interest rate on the loans is 12% per annum and for simplicity we will assume that interest is not compounded. The chain would, as far as it is able, repay the loan plus accumulated interest at the end of the month following the loan. The chain currently has no outstanding loans. The following cash receipts and disbursements data apply to the fourth quarter of Year 2021: • The estimated cash balance as at 1 October is $88,000. Some of the actual and expected sales data for August 2021 to January 2022 are extracted and summarized as follows: Cash sales Sales on account Total sales August (actual) 2021 2022 January September October November December (actual) (estimated) (estimated) (estimated) (estimated) $140,000 $290,000 $440,000 $1,040,000 $1,280,000 $1,350,000 $1,420,000 $1,880,000 $1,490,000 $1,710,000 $2,320,000 $2,100,000 Projected cash collection of sales on account is estimated to be 70% in the month of the sale, 20% in the month following the sale, and 6% in the second month following the sale. The 4% beyond the second month following the sale is determined to be uncollectible. The chain is scheduled to receive $300,000 cash on a note receivable in October. • All merchandise purchases are made on account as the chain has excellent credit with all vendors because of a strong payment history. Each month's ending inventory must equal 25% of the following month's cost of goods sold. The cost of goods sold is 60% of total sales. The chain pays for 80% of its merchandise purchases in the month of the purchase and the remaining 20% in the month following the purchase. The ending inventory balance and accounts payable balance as at 30 September is $223,500 and $175,000, respectively. All of the accounts payable at 30 September will be paid in October. Monthly selling and administrative expenses during October, November, and December are estimated to be $380,000, $410,000, and $460,000, respectively; these amounts include $30,000 of depreciation each month. Dividends of $250,000 will be declared and paid in November. Equipment costing $530,000 and $200,000 will be purchased for cash in October and December, respectively. Required: (i) (ii) Prepare a schedule of expected cash collections from customers for October, November, and December. (6 marks) Prepare the following budgets for merchandise purchases: (a) A merchandise purchases budget for October, November, and December (5 marks) (b) A schedule of expected cash disbursements for merchandise purchases for October, November, and December. (3 marks) (iii) Prepare a cash budget for October, November, and December. (11 marks)
Expert Answer:
Related Book For
Cost Management Accounting and Control
ISBN: 978-0324559675
6th Edition
Authors: Don R. Hansen, Maryanne M. Mowen, Liming Guan
Posted Date:
Students also viewed these accounting questions
-
An annuity paying $1400 at the end of each month (except for a smaller final payment) was purchased with $225,000 that had accumulated in an RRSP. The annuity provides a semiannually compounded rate...
-
An annuity paying $1400 at the end of each month (except for a smaller final payment) was purchased with $225,000 that had accumulated in an RRSP. The annuity provides a semiannually compounded rate...
-
At the end of each month during the school term (or a date specified by your professor), you should evaluate the performance and behavior of your stocks. a. Determine whether the performance of each...
-
Two long wires are placed in the x-y plane, as shown in the figure. Each wire carries a current of 1.5 A, directed out of the page. If the distance d = 3.0 m, what is the net magnetic field due to...
-
Access the website for CVS Corporation and locate the companys 2005 annual report. Conduct a comprehensive ratio analysis that compares the companys performance in 2005 and 2004. If you have computed...
-
What strategic issues and problems does Tiffany & Co. management need to address?
-
A stock dividend a. Decreases Common Stock b. Increases Retained Earnings c. Has no effect on total equity d. All of the above
-
1. Wages and prices will increase when actual output exceeds potential. __________(True/False) 2. The short run in macroeconomics is the time period over which __________do not adjust to economic...
-
You are an art salesperson whose job is to sell paintings. You sell paintings at art festivals, as well as out of your studio on non- festival days Festivals occur once every 20 days and there is...
-
In Part III (Appendix 11B) of the audit case, the audit staff of Adams, Barnes & Co. identified specific revenue risks on working paper RA-12 (page 494). However, the Summary of Audit Approach...
-
You did a presentation and was extremely nervous. Self evaluation to answer the following questions. 1. Describe your voice, gestures, and body language (posture, use of space, etc.). What message(s)...
-
Use a Lagrange multiplier test for serially correlated errors.
-
Estimate and interpret the estimates from finite and infinite distributed lag models.
-
Use a correlogram of residuals to test for serially correlated errors.
-
Explain the differences between time-series models for forecasting and time-series models for policy analysis.
-
Contrast the assumptions for a finite distributed lag model with those for an infinite distributed lag model.
-
In the figure, the coefficient of friction between the mass and the plane is 0.2. How much work is done by the force F in moving the mass up the plane a distance of 4m? (sin36.9= 0.6, cos36.9=0.8,...
-
Archangel Corporation prepared the following variance report. Instructions Fill in the appropriate amounts or letters for the question marks in the report. ARCHANGEL CORPORATION Variance...
-
What is productivity measurement?
-
Owens Company has a decentralized organization with a divisional structure. Two of these divisions are the Appliance Division and the Manufactured Housing Division. Each divisional manager is...
-
Myers Electronics, Inc., produces hand-held calculators. Three of the major electronic components are produced internally (components 2X334K, 5Y227M, and 8Z555L). There is a separate department in...
-
The water tank shown in Fig. 14.33 is supported by a hollow circular steel column. The tank, made of steel, is in the form of a thin-walled pressure vessel and has a capacity of 40,000 litres. Design...
-
Using the third-order Runge-Kutta method, solve Problem 11.15. Data From Problem 11.15:- Using the second-order Runge-Kutta method, solve the differential equation \(\ddot{x}+1000 x=0\) with the...
-
Linear acceleration method a. Assumes that acceleration varies linearly between \(t_{i}\) and \(t_{i}+\theta \Delta t ; \theta \geq 1\) b. Assumes that acceleration varies linearly between \(t_{i}\)...
Study smarter with the SolutionInn App