eTiling is a tiling business that started six months ago. It is owned and run by...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
eTiling is a tiling business that started six months ago. It is owned and run by a gentleman named Alan border. He has set up his company as a sole trader and wants to build the business over the next five years. eTiling specialises in laying the wall and floor tiles during the bathroom renovation process. This includes waterproofing the wet areas. It is now December and Alan wants to forecast how much money he thinks he can make in the next calendar year (January to December). Goals: • To make a Net Profit of $52,000 in the first 6 months of the calendar year (January to June) . To make a Net Profit of $110,000 in the first 12 months (January to December) Legal requirements: • Ensure his QBCC tiling licence is up-to-date • Ensure his power tools are tested and tagged • Ensure that he is registered for GST (Goods & Services Tax) • Ensure he has adequate insurance Capital: . Richard's parents have agreed to loan him $10,000 to assist in the new year as they have seen his progress during the first 6 months and have confidence that he can pay them back over time. Key Performance Indicators: • Reach $30,000 in revenue each month • Increase the number of tiling jobs to at least 15 a month • Become a contractor for a new Real Estate Agent Specialist services required to assist: . An Accountant Alan is paid on completion of his work and does not have any credit accounts with suppliers. Your Task Refer to the Case study Alan has examined his records so far and revealed the following . The income per renovation job is $1500 including GST. He completed the following number of jobs • July - 2 . August - 4 . Sept-4. . Oct - 6 .Nov-8 . Dec - 12 . His cost of sales per renovation job is as follows, including GST . Tiles $400 . Glue and grout $200 . Equipment hire $50. . Levelling system $250 His monthly operating expenses are as follows, including GST • Accounting $100 . Advertising $200 . Motor vehicle expenses $400 . Telephone and website $120 • Tools $100 . Licence costs $50 . Insurance $100 A copy of his last 6 months profit and loss is available to view. He expects to maintain 12 renovation jobs a month from his current advertising. Alan has now signed an agreement with My Real Estate group to provide his services starting January 1st. This should provide him with an additional 6 renovation jobs per month. He has also been approached by a marketing company to add a quote system to his website that will give him an additional 2 jobs per month from Jan 1st. The cost of the quote system is $300 per month (added to telephone and website costs) Motor vehicle expenses will increase to $600 per month. He will use an Accountant in July for a cost of $400. In August he will pay $6500 income tax The bank balance at the beginning of January was $5,000 Using the above information 1 Prepare a cash flow forecast for the period January to December using the Cashflow Forecast template attached. Include 10% GST in your cash incoming and cash outgoing calculation but disregard any other GST payments or tax allowances in this instance. 2 Prepare a monthly profit and loss for the period January to December using the P&L statement template attached. Sales Renovation Less cost of goods sold Tiles Glue and Grout Equipment Hire Leveling system More... Gross profit/net sales Expenses Accountant fees Advertising and marketing Tools Telephone Licence Motor vehicle expenses Insurance Total expenses NET PROFIT (net income) Assumptions: Figures exclude GST. Profit and loss for eTiling August July 3000 800 400 100 500 $1,200 100 200 100 120 50 400 100 $1,070 $130 6000 1600 800 200 1000 $2,400 100 200 100 120 50 400 100 $1,070 $1,330 September 6000 1600 800 200 1000 $2,400 100 200 100 120 50 400 100 $1,070 $1,330 October November December Yearly total 9000 2400 1200 300 1500 $3,600 100 200 100 120 50 400 100 $1,070 $2,530 12000 3200 1600 400 2000 $4,800 100 200 100 120 50 400 100 $1,070 $3,730 18000 4800 2400 600 3000 $7,200 100 200 100 120 50 400 100 $1,070 $6,130 $54,000 $14,400 $7,200 $1,800 $9,000 $0 $21,600 $600 $1,200 $600 $720 $300 $2,400 $600 $6,420 $15,180 eTiling is a tiling business that started six months ago. It is owned and run by a gentleman named Alan border. He has set up his company as a sole trader and wants to build the business over the next five years. eTiling specialises in laying the wall and floor tiles during the bathroom renovation process. This includes waterproofing the wet areas. It is now December and Alan wants to forecast how much money he thinks he can make in the next calendar year (January to December). Goals: • To make a Net Profit of $52,000 in the first 6 months of the calendar year (January to June) . To make a Net Profit of $110,000 in the first 12 months (January to December) Legal requirements: • Ensure his QBCC tiling licence is up-to-date • Ensure his power tools are tested and tagged • Ensure that he is registered for GST (Goods & Services Tax) • Ensure he has adequate insurance Capital: . Richard's parents have agreed to loan him $10,000 to assist in the new year as they have seen his progress during the first 6 months and have confidence that he can pay them back over time. Key Performance Indicators: • Reach $30,000 in revenue each month • Increase the number of tiling jobs to at least 15 a month • Become a contractor for a new Real Estate Agent Specialist services required to assist: . An Accountant Alan is paid on completion of his work and does not have any credit accounts with suppliers. Your Task Refer to the Case study Alan has examined his records so far and revealed the following . The income per renovation job is $1500 including GST. He completed the following number of jobs • July - 2 . August - 4 . Sept-4. . Oct - 6 .Nov-8 . Dec - 12 . His cost of sales per renovation job is as follows, including GST . Tiles $400 . Glue and grout $200 . Equipment hire $50. . Levelling system $250 His monthly operating expenses are as follows, including GST • Accounting $100 . Advertising $200 . Motor vehicle expenses $400 . Telephone and website $120 • Tools $100 . Licence costs $50 . Insurance $100 A copy of his last 6 months profit and loss is available to view. He expects to maintain 12 renovation jobs a month from his current advertising. Alan has now signed an agreement with My Real Estate group to provide his services starting January 1st. This should provide him with an additional 6 renovation jobs per month. He has also been approached by a marketing company to add a quote system to his website that will give him an additional 2 jobs per month from Jan 1st. The cost of the quote system is $300 per month (added to telephone and website costs) Motor vehicle expenses will increase to $600 per month. He will use an Accountant in July for a cost of $400. In August he will pay $6500 income tax The bank balance at the beginning of January was $5,000 Using the above information 1 Prepare a cash flow forecast for the period January to December using the Cashflow Forecast template attached. Include 10% GST in your cash incoming and cash outgoing calculation but disregard any other GST payments or tax allowances in this instance. 2 Prepare a monthly profit and loss for the period January to December using the P&L statement template attached. Sales Renovation Less cost of goods sold Tiles Glue and Grout Equipment Hire Leveling system More... Gross profit/net sales Expenses Accountant fees Advertising and marketing Tools Telephone Licence Motor vehicle expenses Insurance Total expenses NET PROFIT (net income) Assumptions: Figures exclude GST. Profit and loss for eTiling August July 3000 800 400 100 500 $1,200 100 200 100 120 50 400 100 $1,070 $130 6000 1600 800 200 1000 $2,400 100 200 100 120 50 400 100 $1,070 $1,330 September 6000 1600 800 200 1000 $2,400 100 200 100 120 50 400 100 $1,070 $1,330 October November December Yearly total 9000 2400 1200 300 1500 $3,600 100 200 100 120 50 400 100 $1,070 $2,530 12000 3200 1600 400 2000 $4,800 100 200 100 120 50 400 100 $1,070 $3,730 18000 4800 2400 600 3000 $7,200 100 200 100 120 50 400 100 $1,070 $6,130 $54,000 $14,400 $7,200 $1,800 $9,000 $0 $21,600 $600 $1,200 $600 $720 $300 $2,400 $600 $6,420 $15,180
Expert Answer:
Answer rating: 100% (QA)
Steps Step 1 of 2 Balance sheet items of Bob the Builder Pty Ltd is given below Cash 125632 Petty ca... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Evaluate and simplify the following derivatives. d dx -(x Inx)
-
Using Wal-Marts 2009 Form 10-K in Appendix A, answer the following questions: 1. What type of items compose Wal-Marts inventory? 2. Review Wal-Marts balance sheet to determine the amount of inventory...
-
The partner in charge of the Kappeler Corporation audit comes by your desk and leaves a letter he has started to the CEO and a copy of the cash flow statement for the year ended December 31, 2020....
-
Who are the principal recipients of the auditor's required communication of material weaknesses in internal accounting control?
-
Identifying cash inflows and outflows Required Indicate which of the following items will result in cash inflows and which will result in cash outflows. The first one is shown as an example. Item...
-
Critical reflection about Land Titles & Boundaries of land Here are some questions that might guide your thinking: In preparing for or answering each of the workshop discussion questions, what most...
-
Which of the following is a positive reason for learning chemistry? (a) Chemistry is relevant to daily life (b) Chemistry offers career opportunities (c) Chemistry studies interesting topics (d)...
-
g. The trait dimension most relevant to consumer behavior is the extent to which consumers are inner-directed versus outer-directed. 1) Inner-directed individuals consume to express a unique sense of...
-
Discuss investment strategies with regard to diversification and asset allocation for someone in their 20 s versus someone in their 40s. How does risk tolerance change with age? Discuss in pairs or...
-
When a chemical process is called stochastic process? Give some examples.
-
What are the advantages of MPC over PID control? Explain your answer considering both economic and technical point.
-
Retailers, airlines, and hotel chains have well-developed customer loyalty programs. Pick one of the following companies and evaluate its customer loyalty program against one of its competitors in...
-
Use the = RAND( ) function in your spreadsheet to create 100 samples of size 25 (which are effectively all from the same population). Compute the mean and standard deviation of each sample. Calculate...
-
The Village on Manchester's garbage trucks accidentally sideswiped two parked automobiles during the year ended December 31, 2021. One case was settled for $3,000 in 2021, and the Village expects to...
-
Chao, Louis, and Mari, unrelated individuals, own all of the shares of Cerise Corporation. All three shareholders have been active in the management of Cerise since its inception. In the current...
-
A metropolitan school system consists of two districts, east and west. The east district contains 35% of all students, and the west district contains the other 65%. A vocational aptitude test was...
-
Under what conditions will the single-server queuing model with Poisson arrivals and undefined service times provide the same operating characteristics as the basic model with exponentially...
-
A city is served by two newspapersthe Tribune and the Daily News. Each Sunday readers purchase one of the newspapers at a stand. The following matrix contains the probabilities of a customers buying...
-
Sketch a simple common-gate amplifier circuit and discuss the general ac circuit characteristics (voltage gain and output resistance).
-
How does the transistor width-to-length ratio affect the small-signal voltage gain of a common-source amplifier?
-
Sketch a simple source-follower amplifier circuit and discuss the general ac circuit characteristics (voltage gain and output resistance).
Study smarter with the SolutionInn App