115112 Accounting for Decisions

Delys Darling has decided to start a shop selling water fountains for gardens and she has located a small shop at a retail park on the outskirts of town. The shop is to be called Nafura which is Arabic for Fountain and Delys intends to have the shop open for business on April 1 2021. Delys has been in business before and her Plan includes the following data:
 
Projected Sales
 

Month

Units

April

150

May

145

June

140

July

130

 
It is estimated that 80% of sales will be for cash with the remainder on credit. Credit sales will be received in the month after sale.
Although the business will stock a variety of water fountains, they are all the same size and will all sell for the same amount, of $180 per fountain.
Purchases and Inventories
The fountains are imported by a wholesaler in Auckland and each month Delys will purchase sufficient fountains to meet estimated sales for the following month. The average purchase price per fountain is $120.00. Payment will be made on the 20th of the month following purchase. (For the purposes of this assignment you may ignore any inventory held).
Non-Current Assets

It is business policy to use the straight line method of depreciation for all non-current assets.
The furniture and fittings for the shop cost $18,000 and have an expected life of 10 years with no residual value.
The office equipment cost $10,000 and it is estimated the useful life will be three years after which its residual value will be $1,000.

Other

Delys has employed a salesperson, Mere Matua to work part-time for $2,400 a month. Mere Matua is paid on the 20thof each month for that month. (Ignore PAYE and other deductions).
General costs (including utilities, telephone, stationery, ISP provider etc.) are estimated at $500 a month, paid on the 20thof the month following purchase. In March Delys incurred $186 of general costs which is shown as an Accounts Payable as at 31 March 2021.
The rent on the building is $350 a month and is paid quarterly in advance and the first payment is due on 1 April 2021.
The annual insurance premium from 1 April 2021 to 31 March 2022 is $1,800 payable on 3 May 2021.
Delys intends to spend $500 a month on Advertising in magazines such as Home and Garden and their terms are that accounts are paid in the month the advertisements appear.
The balance of Cash at Bank on 1 April is $10,000.
Delys intends to draw $3,000 out of the business each month.

Required
On the Data sheet, enter the given data which has not yet been entered
On the Sales, Purchases & NCA sheet, complete the revenue, cash collections, purchases and depreciation calculations for the quarter 1 April to 30 June 2021.
On the Cash Flow sheet, complete the Cash Flow Forecast for each of the three months April, May and June and the totals for the quarter 1 April to 30 June 2021. Note: Some cash flow rows have been named, but you will need to enter the remaining cash flow names yourself
On the Income Statement sheet, complete the Projected Income Statement for the quarter ended 30 June 2021. A month by month Income Statement is not required. Note: Some expenses have been identified but you need to enter the remaining expenses yourself.
Check the flexibility of your workbook by changing the estimated Average Selling Price per fountain on the Data sheet from $180 to $200. Enter the resulting Net Profit and Ending Cash Balance in the boxes provided on the Income Statement sheet (remember to change the Average Selling Price per fountain back to the original amount before submitting your assignment

Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Your college assignment will never turn out an untoward surprise! Whether you need research for high school, an undergraduate program, or a Master’s or Doctoral degree, you will get exactly what you are looking for to sound smart and well-informed. If you are pressed for time, request our experts! We are your academic saver. It is a perfect solution for people who need academic help but has no professionals nearby to provide it. Just redirect your home tasks to us and forget about any educational issues. With us, you will get 100% plagiarism-free content delivered on time by an experienced specialist in a particular field. Main Advantages of Collaboration with Us When you order professional assignments here, you will get: Original custom papers. We value your academic reputation. Just as well, we value the years of thorough work on our reputation for reliability and never compromise the originality of delivered papers. We will never endanger both. Every custom assignment is written from zero – the only possible first stage of work on the order is research. We apply the latest plagiary checking tools on the final stage, so plagiarism has no chance to emerge in your college assignment writing. Control over the order completion. To make the process of collaboration comfortable and efficient, we offer our clients to choose the writer themselves taking into account all the requirements and the budget. For you to save nerves, having entrusted your fateful task to some qualified “stranger”, we enable communication with the assigned writer in the process of order completion. Affordable assistance. . help with college assignments. We are eager to help you start investing in your career growth today. That is why our service is so affordable. We don’t charge to pay for the latest marketing tricks or advertisements – we choose the best experts in the labor market who write great custom papers in any area, level of complexity, and time frame. Our client’s grateful feedback is a top advertising trick. On-time delivery. The quality of a paper is only valued when it is delivered within the determined time frame – you will get your custom assignment writing service in time and have a couple of days to revise it and ask for changes in case they are needed. And you will still have time to learn the material. Protection. We value your trust and take all measures needed to keep your private and banking details safe. We offer only well-tested payment methods. Due to the system of encryption and protected servers, no third party can have access to your data. Custom support 24/7. We do our best to make the process of collaboration comfortable for the customer. Our “write my assignment” help is always here for you to provide a solution to your problems, give you a prompt answer to any question, and offer clarification as to any issue related to the services. Feel free to contact us anytime! If you feel that your dissatisfaction with student life is growing every day and you just feel exhausted, don’t hesitate to change the situation for the better today. Order your first assignment from reliable custom assignment services today to evaluate the advantages. Having seen the difference once, you won’t want to go back to your previous lifestyle. You deserve to find fulfilment in other spheres of your life, have hobbies, spend time with close people but continue making progress. It is possible when you have a professional helper. Don’t put off your life for someday after graduation!