Calculate the GST exclusive and GST inclusive sales price for the Tough-let

Part A (using the excel file provided on the Moodle) 1) Calculate the GST exclusive and GST inclusive sales price for the Tough-let 2) Produced a projected profit/loss value for each scenario. To do so you will need to calculate: a. Sales commission b. Depreciation on Shop Fittings c. Depreciation on Computers d. Depreciation on Office Fitout e. Interest on the loan.+ 3) Calculate the tax payable for the Company 4) Calculate the tax payable for each of the employee Part B 1) Advise your client on which scenario you would suggest they select. Explain why you would advise this selection 2) Comment on the variance noted between scenario 2 and 3. 3) Break Even Analysis a. You must calculate the break even Analysis mathematically b. Show the break even analysis graphically 4) Produce a Pie Graph showing the break-up of expenses in the business. Comment on the pie graph.