1. To confirm your understanding of the spreadsheet’s design, answer the following questions with respect to last year: a. How is the percentage in cell B3 calculated? Why do you think specifying the sales mix percentages for all products is important? b. How are the amounts in cells B7, B8, and B9 calculated? c. How are the amounts in cells Q7, Q8, and Q9 calculated? d. How is the amount in cell Q11 calculated? e. How are the percentages in cells R8 and R9 calculated? f. How is the amount in cell S9 calculated?

Read the overview below and complete the activities that follow. apartment complexes often look for ways to recruit new tenants and retain current tenants. although apartment complexes offer the tangible benefit of shelter to their tenants, many apartment complexes also offer additional services to tenants to encourage tenants to stay or to support the rent prices. the following scenario identifies the several service gaps of a company that runs an apartment complex as well as solutions for reducing these service gaps. concept review: customers have certain expectations about how a service should be delivered. a service gap occurs when the delivery of a service fails to meet customer expectations. there are four types of service gaps: knowledge gap, standards gap, delivery gap, and the communications gap. it is important for marketers to identify these gaps and develop strategies for minimizing them. match the example or solution to the appropriate service gap category.1. wait for repairs 5. train employees well2. understand expectations 6. incentives for tenants3. do not overpromise 7. family movie night4. empower employees 8. delayed lawn careservice gap example solutionknowledge gap standards gap delivery gap communication gap