d Document - Microsoft Word Table Tools Mailings View Review Design Layout Glenda is planning a trip of 7 days to Florida. She has located a condominium and has put a deposit down on the un The rental company has a maximum occupancy for the condominium of 7 adults. There is an amusement park that plans to visit. She is going to use her parents' car, an SUV that can carry up to 6 people and their luggage. The SUV travel an average of 9.4L/100km, the total distance is approximately 1,770 (travelling there plus driving around ever day), and the average price of gas is $1.6 per litre. A season passfor an amusement park she wants to visit is $167 pe person. Glenda estimates spending $40 per day per person for food. She estimates the costs for the trip as follows: $40 Condo Rental $1,400 Gasoline $270 Food (per person, per day) Amusement Park Season Pass (per person) $168 Now that she has cost estimates, she is trying to decide how many of her friends she wants to invite. Since the car can only seat 6 people, Glenda made a list of other girls to invite. Use herdata to answer the following questions and fill out the cost table. (Answers to enter in blue-coloured cells): Question 1. What are the total variable costs for the trip? 2. What are the average variable costs (per person) for the trip? 3. What are the total fixed costs for the trip? 4. What are the average fixed costs (per person) for the trip? 5. What are the average costs per person for the trip? 6. What would the trip cost Glenda if she were to go alone? 7. What additional costs would be incurred if a 7th girl was invited on the trip? Would this be a wise decision (from a cost perspective)? Why or why not? 8. Which cost will not be affected if a 7th girl was invited on the trip? Answer No. of people incl Glenda 1 2 Total Variable Cost Average Variable Cost Total Fixed Cost Average Fixed cost Average cost per Person o