AutoSave O OFF A A C . G ... Assignment 5 Activity Based Costing (2022-23) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA Wrap Text General Insert v Ex AY- O. x Delete Paste BIUV DVAv Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data P31 4 fx B G H K L M N P Q R S U 3 One of the biggest issues in the restaurant industry is not accurately knowing the cost for key activities in the business 6 Using the information found on page 219 of the textbook for Problem 5-7, you will practice this. Please respond to the questions below. Your answers to the questions, including the calculations should be presented on this sheet. 8 Clearly indicate which part of the requirement your calculations pertains. If the specific part of the question is not identified the calculations will not be considered for marks. 9 10 11 Requirement: 12 13 Part A (6 marks) 14 Compute the activity rate for each of the following three activities. 15 i) serving a party; 16 i) serving a dinner 17 iii) serving drinks 18 19 Part B (6 marks) 20 According to the Activity Based Costing (ABC) system, what is the total cost of serving each of the following parties of diners 21 22 i) a party of four diners who do not order drinks; 23 ii) a party of two diners who order four drinks in total; and 24 iii) a loner diner who orders two drinks. 25 26 27 Part C (6 marks) 28 Convert the total costs you computed in requirement B to costs per diner. 29 In other words, what is the average cost per diner for serving each of the following parties of diners? 30 31 i) a party of four diners who do not order drinks; 32 ii) a party of two diners who order four drinks in total; and 33 iii) a loner diner who orders two drinks. 34 35 36 Part D 2 marks 37 Why do the costs per diner for the above three different parties differ from each other and from the overall average cost of $14.50 per diner? 38 39 40 41 42 Instructions Question 1 Question 2 Question 3 Question 4 Assessment Criteria + Ready Accessibility: Investigate + 100%