These analytic queries (Table 3) involve computed columns using the results of base queries for revenues/costs. Profit involves sum of revenues from invoices minus sum of total costs from subjobs. Total costs are the sum of labor, material, machine, and overhead. The base query for cost summary calculates the sum of each cost component so total costs is the sum of the component costs. Profit margin is sum of profit divided by sum of revenues. Profit margin is a widely used business measure for comparing business performance across different kinds of products. Table 3: Analytic Query Requirements for Location Revenue Trends