AutoSave O OFF m A C . G ... Assignment 4 (2022-23) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial AA ab Wrap Text v General Insert v v 12 Ex AY- O. Ex Delete Analyze MVAv E Merge & Center v $ ~ % 9 Conditional Format Cell Sort & Find & Sensitivity Paste BIUVE Formatting as Table Styles Format v Filter Select Data B11 X V fx b. Car insurance B C D E F G H K L M Q A N W N H Question 3 (10 Marks) Lisa is about to start her first year of university and is deciding whether to take the bus to school or to drive to school with her car. Parking at the school is $10.00 per day ($200 per month). Her monthly insurance cost is $120 and monthly maintenance is $40. To ensure her car is functioning at its maximum capacity, Lisa spends the same amount on maintenance each month regardless of kilometers driven. She also expects that she will pay an additional $75 in gas if she were to drive her car to school. There are a few different options to buy bus tickets as follows: individual rides are $5.00 (one-way), a round trip option per day is $8.00 or a monthly bus pass would cost $120. Lisa has decided she'll either take the bus for the full month or drive for a full month. Required: 0 00 n UT Determine if each of the costs are relevant (R) or not relevant (N) to Lisa's decision and explain why you made this decision. Note: 1 mark for indicating relevant or not relevant and 1 mark for the explanation. a. Parking b. Car insurance 12 c. Car maintenance 13 d. Gas e. Bus pass 15 16 18 19 20 21 23 24 25 26 28 29 30 31 32 33 Instructions Question 1 Question 2 Question 3 Question 4 Assessment Criteria + Accessibility: Investigate + 100% Ready