A company has provided the following cost information from the most recent year of operations when 100.000 units are made: Units made 100,000 3 Required: 5 Part 1: Answer the following questions. 1 mark each for parts a-d: 6 7 variable vs. Cost Item # fixed 1 variable 2 variable 3 fixed 4 variable 5 fixed Amount 58,253 8,137 56,417 62,252 10,818 9 10 11 BONUS MARKS - Create a pivot table to summarize costs according to behavior to assist in answering part a and b. Place pivot table in cell H8. (2 marks) a. What is the total amount of variable costs? b. What is the total amount of fixed costs? Units sold for parts cand d: 0.000 c. What will be the total amount of variable costs if the above units are sold (units shown in cell F11)? d. What is the total amount of fixed costs if the above units are sold (units shown in cell F11)? 12 6 fixed 18,791 7 13 14 15 000 variable fixed fixed fixed variable variable 48,314 13,103 19,631 43,818 71,830 2,147 Part 2: Explain the following: 16 10 7 11 How do variable costs behave? (1 mark) 8 12 13 fixed 28,976