Required:

Part A: $(25$ marks$)$

Restate the segmented income statement using the statement the junior accountant prepared and the notes to the financial statements $($Chapter $7$ Appendix$)$

Check figures have been provided to ensure you are on the right track. If you are not arriving at the check figures, please discuss with your group members to determine where you went wrong! See the word document provided to your group containing the check figures!

Notes:

The percentage column should be taken as a percentage of sales $($for example, cost of goods sold $\%$ for mountain bikes should be taken as a $\%$ of mountain bike sales$)$ There may be small rounding differences where total amounts are off by $$1,$ that is ok$!$ Make sure you are using full Excel functionality and entering formulas into each cell. You cannot use your calculator and input the final answer.