Required Part 1: Answer the following questions for Cost Item 1 2 3 variable vs. fixed variable variable fixed variable fixed Amount 58,253 8,137 56,417 62,252 10,818 4 5 BONUS MARKS - Create a pivot table to me to w parta and b Place pivot table ince2 mars a. What is the total amount of variable costs b. What is the total amount of twed costs? Units sold for parts cand d: c. What will be the total amount of variable costs the above is we (units shown in cell F112 d. What is the total amount of fixed costs of the above us are sold is shown in cell F11)? 6 fixed 18,791 100 variable fixed fixed 48,314 13,103 19,631 9 Part 2 Explore How do variate cont behave man 20 lored (fixed 28,976 33 486 27 15 variable 14,003 What is an example of a variable con for flower delivery company in why it would be a variable cost 11 mark) 22 23 + 16 17 variable fixed variable 28,294 75,678 35,247 18 How do fixed costs behave? (1 mark) 19 fixed variable 20 21,708 56,521 How do fixed costs behave? (1 mark) What is an example of a fixed cost for a flower delivery company? Explain why it is a fixed cost (1 mark). Why is it important to know how costs behave (variable vs, fixed)? (1 mark) Required Part 1: Answer the following questions for Cost Item 1 2 3 variable vs. fixed variable variable fixed variable fixed Amount 58,253 8,137 56,417 62,252 10,818 4 5 BONUS MARKS - Create a pivot table to me to w parta and b Place pivot table ince2 mars a. What is the total amount of variable costs b. What is the total amount of twed costs? Units sold for parts cand d: c. What will be the total amount of variable costs the above is we (units shown in cell F112 d. What is the total amount of fixed costs of the above us are sold is shown in cell F11)? 6 fixed 18,791 100 variable fixed fixed 48,314 13,103 19,631 9 Part 2 Explore How do variate cont behave man 20 lored (fixed 28,976 33 486 27 15 variable 14,003 What is an example of a variable con for flower delivery company in why it would be a variable cost 11 mark) 22 23 + 16 17 variable fixed variable 28,294 75,678 35,247 18 How do fixed costs behave? (1 mark) 19 fixed variable 20 21,708 56,521 How do fixed costs behave? (1 mark) What is an example of a fixed cost for a flower delivery company? Explain why it is a fixed cost (1 mark). Why is it important to know how costs behave (variable vs, fixed)? (1 mark)