Question 5 [20 marks] You are given the following data for John Smith & Co. for two successive periods. July August Materials Labour Overheads Production levels $300,000 $212,000 $418,000 10,000 units $360,000 $247,000 $453,000 12,000 units All production is sold for $100 per unit. a) Determine the break-even point for John Smith & Co. b) Prepare a chart in Excel that depicts the break-even point (4 marks) (6 marks) Provide an EXCEL graph detailing the necessary information to show the break-even points contained in your responses to parts (b) of this question. The graph must illustrate the B.E.P. and the region corresponding to profits and the region corresponding to losses." Hint: When you prepare the amortisation schedule, do not round the repayment to the nearest cent. Otherwise, the Outstanding Balance may not balance to 0 at the end of the term. You should use the format cells' in EXCEL to change the appearance of a number without changing the number itself c) Calculate the total interest and the total amount paid over the life of the loan. (2 marks)