x D KINGDOM UNIVE Selling Expenses Admin Expenses General Expenses Selling Expenses Admin Expenses General Expenses Marketing Expenses Advertising Expenses Depreciation Expenses Rent Expenses Depreciation Expenses Selling Expenses Rent Expenses Wages Wages 500 100 200 300 400 200 100 150 100 500 50 150 500 100 100 Questions: Question 1 Open sbeet 1 from the file ACCT317, then fill the colored cells with the appropriate mathematical functions to analyse the data (4 Marks) Question 2: Open sheet 2 from the file ACCT317, then fill the colored cells with the appropriate mathematical functions to calculate depreciation using straight line, Sum-of-the-years-digits method and double declining method (4 Marks) Question 3i Open shost. J. from the ACCI31.the. All the colored cells with the appropriate mathematical functions to prepare the adjusted trial balance, Income statement and Balance sheet (6 Marks) Question 4Open shellrom the le. ACCES.All the colored cells with the appropriate mathematical functions to prepare production budget. (3 Marks) Question 5: Open sheets from the file ACCT317, then fill the colored cells with the appropriate mathematical functions for breakeven analysis Marks Note: All Answers will be generated in MS Excel and uploaded to LMS All assessment forms, model answers, and student's filles included in LMS. x D KINGDOM UNIVE Selling Expenses Admin Expenses General Expenses Selling Expenses Admin Expenses General Expenses Marketing Expenses Advertising Expenses Depreciation Expenses Rent Expenses Depreciation Expenses Selling Expenses Rent Expenses Wages Wages 500 100 200 300 400 200 100 150 100 500 50 150 500 100 100 Questions: Question 1 Open sbeet 1 from the file ACCT317, then fill the colored cells with the appropriate mathematical functions to analyse the data (4 Marks) Question 2: Open sheet 2 from the file ACCT317, then fill the colored cells with the appropriate mathematical functions to calculate depreciation using straight line, Sum-of-the-years-digits method and double declining method (4 Marks) Question 3i Open shost. J. from the ACCI31.the. All the colored cells with the appropriate mathematical functions to prepare the adjusted trial balance, Income statement and Balance sheet (6 Marks) Question 4Open shellrom the le. ACCES.All the colored cells with the appropriate mathematical functions to prepare production budget. (3 Marks) Question 5: Open sheets from the file ACCT317, then fill the colored cells with the appropriate mathematical functions for breakeven analysis Marks Note: All Answers will be generated in MS Excel and uploaded to LMS All assessment forms, model answers, and student's filles included in LMS
