Calculate the GST and Interest Expense - Analysis Graphically - Statistics Assignment Help

Assignment Task :

Business Problem Scenario

You have been approached by your client, Banana Industries Pty Ltd, to assist them in planning a new business venture. The business is planned to start on 1 July 2020. Banana Industries has developed a new corporate boardroom webcam system which will be competing with others for the massive uptake in videoconferencing technology due to Covid-19. Banana Industries requires you to prepare a budget and analysis of two separate scenarios they have determined to be likely, and have provided you with the following information

Scenario #2 The marketing department at Banana Industries believes that by selling a slightly higher quality webcam system, a higher price and mark-up would be acceptable in the market. They have estimated that with an increased cost per unit [$3900] a mark-up of 70% would be achievable. To support this price increase, marketing and advertising expenditure would increase from 8% to 11%. Annual sales are expected to increase by 10 units compared to scenario #1. Assessment 2:

Tasks:

Part A

1) Calculate the GST exclusive and GST inclusive sales price for each boardroom webcam.

2) Calculate interest expense, and depreciation expense, on the separate sheets included in the Excel file on Moodle. Don’t forget to include these expenses in your P&L in the next step.

3) Produce a projected profit and loss statement for the financial year ending 30-June-2021 for each of the two scenarios.

4) Calculate on the P&L sheet, the tax payable for Banana Industries Pty Ltd [a ‘base-rate’ entity], and Net Profit After Tax, for each of the two scenarios.

Part B 

1) Advise your client on which scenario should be selected. Explain and justify why you would advise this selection (approx. 150 words).

2) Comment on any variances between the scenarios

3) Explain the difference between straight-line depreciation and reducing balance depreciation to your client. Reference any materials cited (approx. 150 words).

4) Prepare break-even analysis on the scenario you recommended in part B[1] above:

a. Calculate the break even analysis mathematically.

b. Show the break even analysis graphically.

c. Explain break-even analysis and why it is an important tool for business. (References required)

5) Produce a Pie Graph showing the break-up of all expenses in the under the scenario recommended in part B[1] above. Comment on the pie graph

6) From your analysis provide your recommendation to the client with supporting evidence (hints: consider contribution margins, NP and GP analysis, and the current economic outlook).

This Statistics Assignment has been solved by our Statistics Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.