Chapter 08 – Enterprise Business Systems
8-8
2. Collaborative CRM
a. How do these property transactions differ from commodity supply chain transactions?
Real estate transactions significantly differ based on type and circumstances unique to each property
b. What advantage do the real estate company and the law firm gain by adopting their client’s
technology platform (Lotus Notes/Domino)?
While the client can better monitor their vendor’s performance, the vendor has the ability to measure
c. Find a Lotus Notes/Domino product review on the Web, read it, and report your findings to the
class. Your presentation should answer the following questions: Who provided the review? What is
the reviewer’s relationship to the product? What did the reviewer like? What did the reviewer
dislike? What competitors were mentioned in the review? How did Lotus Notes/Domino compare?
Students should discover that Lotus Notes/Domino systems are built on a proprietary, cross platform
3. Enterprise Sales Support
Note: The first three questions in this exercise can be answered independently from each other. Each
a. Pending sales need Christina’s immediate attention. Help her spot these opportunities by
automatically highlighting them. Select the “Sales Leads” spreadsheet and use Excel’s Conditional
Formatting feature to set the cell shading color of each Status cell (Life, Auto, Home, Health) to
green if the status is “Sale” (S) and red if the status is “Pending” (P).
See Data Solutions Disk for the completed exercise. This task illustrates how dynamic formatting
b. Select the “Cover Sheet” spreadsheet. In cell C2, use the COUNTA function to count the total
number of sales leads in the Sales Leads sheet. In cells C5 through C8, use the COUNTIF function to
count the number of sales made for each type of insurance. In cells D5 through D8, divide the sales
made by the number of leads to calculate the percentage of sales. Write these formulas so they
calculate the correct answers even when Christina later adds more records to the list. Which product
has the highest sales rate?
See Data Solutions Disk for the completed exercise. This task exposes students to cross-sheet