Sheng is planning his cash flow for the three months January to March 2021. Information about...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sheng is planning his cash flow for the three months January to March 2021. Information about his revenues and costs is available. • Sheng will have a bank balance of $5 284 on 1 January 2021. • Sales and purchases will be as follows: November 2020 $ December 2020 $ • • 58 300 26 235 January 2021 $ 51 200 SALES PURCHASES 23 040 40% of the sales income will be received in the month following the sale and 58% will be received two months after the sale. The remainder will be written off as an irrecoverable debt. February 2021 $ 48 700 21 915 56 100 25 245 March 2021 $ 46 300 20 835 • Purchases will be made on one month's credit. • Inventory on 1 January 2021 will be $30 180 and on 31 March 2021 $32 630 • Wages and salaries will be $11 340 per month and other costs will be $1 875 per month, both payable in the month in which they are incurred. Drawings of $4 500 will be taken each month. Heat, light and power will be $720 per month and will be paid quarterly in February, May, August and November. Sheng will buy a delivery van for $40 000 in January 2021 and will pay for it immediately. • Sheng has non-current assets that were bought in October 2018 at a cost of $57 000. These have a useful life of 5 years. Sheng uses the straight line method of depreciation. • Bank charges are 2% per month when the business is overdrawn and are calculated on the balance at the end of the previous month. (a) Prepare the cash budget for each of the three months January to March 2021. The budget should be in columnar format and all figures should be calculated to the nearest $. (b) State two internal actions that Sheng could take to improve his cash flow during the three months January to March 2021. If a business does not manage its cash flow efficiently, it may have a bank balance that is overdrawn. (c) Explain two reasons why it is important for a business to manage its cash flow efficiently. Question 3 Thornton Ltd is a haulage company that operates 8 lorries. The business uses a traditional overhead absorption costing system for its operational overheads and administrative overheads. The budgeted overhead costs for 2020 were as follows. Each lorry, which cost $120 000, is budgeted to travel 72 000 km during the year. The lorries are expected to have a useful life of 6 years after which they will each have a scrap value of $15 000 Road fund licences and insurances for the year are $3 000 per lorry. Servicing and repairs per lorry amount to $715 per 18 000 km. Tyres are replaced every 36 000 km at a cost of $340 each. Each lorry has 8 tyres. Office rent, rates and insurance will be $42 000 for the year. Other administrative overheads will be $90 000 for the year. A total of 750 jobs are expected in 2020. The business is not seasonal in nature and work is evenly distributed throughout the year. (a) Calculate the following overhead absorption rates for 2020. (i) Operational overheads per km. (ii) Administrative overheads per job (b) Explain one reason why the company uses predetermined overhead absorption rates. (c) Explain why the company may have used km as a basis for absorbing operational overheads and jobs for absorbing administrative overheads. (i) Operational overheads. (ii) Administrative overheads. In November 2020, administrative overheads increased by 5%. During November 2020, the business carried out 71 jobs and lorries travelled a total distance of 37 900 km. (d) Calculate, for November 2020, the total amount of over-absorption or under- absorption of: (i) operational overheads (ii) administrative overheads. (d) Evaluate how the over-absorption or under-absorption of overheads will affect the business if the November 2020 level of activity continues. i. ii. Positive factors Negative factors Conclusion Sheng is planning his cash flow for the three months January to March 2021. Information about his revenues and costs is available. • Sheng will have a bank balance of $5 284 on 1 January 2021. • Sales and purchases will be as follows: November 2020 $ December 2020 $ • • 58 300 26 235 January 2021 $ 51 200 SALES PURCHASES 23 040 40% of the sales income will be received in the month following the sale and 58% will be received two months after the sale. The remainder will be written off as an irrecoverable debt. February 2021 $ 48 700 21 915 56 100 25 245 March 2021 $ 46 300 20 835 • Purchases will be made on one month's credit. • Inventory on 1 January 2021 will be $30 180 and on 31 March 2021 $32 630 • Wages and salaries will be $11 340 per month and other costs will be $1 875 per month, both payable in the month in which they are incurred. Drawings of $4 500 will be taken each month. Heat, light and power will be $720 per month and will be paid quarterly in February, May, August and November. Sheng will buy a delivery van for $40 000 in January 2021 and will pay for it immediately. • Sheng has non-current assets that were bought in October 2018 at a cost of $57 000. These have a useful life of 5 years. Sheng uses the straight line method of depreciation. • Bank charges are 2% per month when the business is overdrawn and are calculated on the balance at the end of the previous month. (a) Prepare the cash budget for each of the three months January to March 2021. The budget should be in columnar format and all figures should be calculated to the nearest $. (b) State two internal actions that Sheng could take to improve his cash flow during the three months January to March 2021. If a business does not manage its cash flow efficiently, it may have a bank balance that is overdrawn. (c) Explain two reasons why it is important for a business to manage its cash flow efficiently. Question 3 Thornton Ltd is a haulage company that operates 8 lorries. The business uses a traditional overhead absorption costing system for its operational overheads and administrative overheads. The budgeted overhead costs for 2020 were as follows. Each lorry, which cost $120 000, is budgeted to travel 72 000 km during the year. The lorries are expected to have a useful life of 6 years after which they will each have a scrap value of $15 000 Road fund licences and insurances for the year are $3 000 per lorry. Servicing and repairs per lorry amount to $715 per 18 000 km. Tyres are replaced every 36 000 km at a cost of $340 each. Each lorry has 8 tyres. Office rent, rates and insurance will be $42 000 for the year. Other administrative overheads will be $90 000 for the year. A total of 750 jobs are expected in 2020. The business is not seasonal in nature and work is evenly distributed throughout the year. (a) Calculate the following overhead absorption rates for 2020. (i) Operational overheads per km. (ii) Administrative overheads per job (b) Explain one reason why the company uses predetermined overhead absorption rates. (c) Explain why the company may have used km as a basis for absorbing operational overheads and jobs for absorbing administrative overheads. (i) Operational overheads. (ii) Administrative overheads. In November 2020, administrative overheads increased by 5%. During November 2020, the business carried out 71 jobs and lorries travelled a total distance of 37 900 km. (d) Calculate, for November 2020, the total amount of over-absorption or under- absorption of: (i) operational overheads (ii) administrative overheads. (d) Evaluate how the over-absorption or under-absorption of overheads will affect the business if the November 2020 level of activity continues. i. ii. Positive factors Negative factors Conclusion
Expert Answer:
Answer rating: 100% (QA)
A CASH BUDGET JANUARY Opening Bank Balance Given 5284 Cash Sales 40 of January Sales Given January Sales 56100 56100 40 22440 Cash from Previous Sales Nov Dec Given November and December Sales 51200 5... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1111530266
11th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these accounting questions
-
Journal Entries NEW Jan 1 Simon invested $60,000 cash into the business by purchasing capital stock at $10.00 par value. Jan 2 The Company borrowed $100,000 on a short-term 90 day, 12.0% note...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
According to Electronic Designs 2012 Engineering Salary Survey, the mean base salary of a software engineering manager is $126,417the highest mean among all types of engineers. In contrast, a...
-
An extremely well-constructed rocket has a mass ratio (m0/m) of 10. A new fuel is developed that has an exhaust velocity as high as 4500 m/s. The fuel burns at a constant rate for 300 s. Calculate...
-
Talia Finn is working as an analyst for the Drug Enforcement Agency (DEA) and has been assigned to a case in which the suspect is believed to be engaged in a rather large drug-dealing operation...
-
Gold-on-gold nuclear collisions at the Relativistic Heavy Ion Collider (RHIC) at the Brookhaven National Laboratory create a quark-gluon plasma with an energy density of about \(4 \mathrm{GeV} /...
-
Tomlinson Corporation is a biotech company based in Milpitas. It makes a cancer-treatment drug in a single processing department. Direct materials are added at the start of the process. Conversion...
-
Direct Labor Budgeted $14,200, Actual $14,200, Indirect Labor Budgeted 5,800, Actual 5,400, Utilities Budgeted 1,900, Actual 2,200, Rent Budgeted 3500, Actual 3500, Marketing Budgeted 150, Actual...
-
MPS, Inc. has the following unadjusted account balances as of December 31, 2022, the companys year-end: Cash: $430,000 Accounts Receivable: $2,000 Prepaid Insurance: $14,000 Prepaid Rent: $22,000...
-
What should each of these people now do give that we are in the present predicament? Read the case study the empowerment Effort and answer the above question
-
Explain the activity based costing process. Discuss a real work example of how activity-based costing impacted the success of a company.
-
Explain with example four (4) issues concerning Human Resource Management when implementing strategy. (10 marks) Issue 1: Assessing staffing needs/costs. Issue 2: Work life balance issue. Issue 3:...
-
Discuss the Marxist perspective on employer relations and state how it's applicable to modern day workpalces.
-
1. Explain how the process the team followed might align with DMAIC, the Deming Cycle, and the creative problem-solving process 2. Explain how the process the team followed might align with DMAIC,...
-
Explain the importance of using a structured innovation process in your organization to enable innovation.
-
Candle Light Bus Lines Ltd. runs a series of bus routes between cities across Canada. A new route, between Kenora and Thunder Bay, has been planned for next year. The sales manager has come up with a...
-
A crop-dusting plane flies over a level field at a height of 25 ft. If the dust leaves the plane through a 30 angle and hits the ground after the plane travels 75 ft, how wide a strip is dusted? See...
-
David Lyons, CEO of Lyons Solar Technologies, is concerned about his firm's level of debt financing. The company uses short-term debt to finance its temporary working capital needs, but it does not...
-
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Debt ratio: 40% Quick ratio: 0.80 Total assets turnover: 1.5...
-
Woidtke Manufacturing's stock currently sells for $22 a share. The stock just paid a dividend of $1.20 a share (i.e., D0 5 $1.20), and the dividend is expected to grow forever at a constant rate of...
-
In the dark of night on July 28, 2012, in Oak Ridge, Tennessee, an 82 year-old nun and two Army veterans, ages 57 and 63, cut their way through four layers of fences and reached a building where the...
-
Should swearing be illegal? Why or why not?
-
Compare and contrast five types of terrorism.
Study smarter with the SolutionInn App