Wk1.xlsx - 1.5 Sales Transactions Data Classification...

This preview shows page 1 - 10 out of 10 pages.

1.5 Sales Transactions Data Classification Cust ID Region Payment Transaction Code Source Amount 22:19 22:19 22:19 22:19 22:19 22:19 Classification Ordinal Categorical Ratio Ordinal Categorical Ratio
Product Time Of Day 22:19 22:19 Categorical Interval
Checking and Savings Account Balance Model BALANCE = -17,732 + 367 x AGE + 1300 x YEARS EDUCATION + 0.116 x HOUSEHOLD WEALTH a. 367 interpret ation is 1300 interpret ation is 0.116 interpret ation is b. AGE 32 years old EDUCATION 16 years WEALTH $ 150,000.00 PREDICTED BALANCE $ 32,212.00
H
ROI Model Fill in the Blanks E: Earnings T: Turnover S: Sales C: Cost of Sales TI: Total Investment CA: Current Assets T = S / TI FA: Fixed Assets MC: Mill Cost of Sales SC: Sales Expense FC: Freight and Delivery AC: Admin Costs TI = CA + FA Turn Total Investment Current Assets Fixed Assets
ROI = T * E / S E = S - C ROI nover Earnings Sales Cost of Sales Mill Cost of Sales Selling Expense F
C = MC + SC + FC + AC Freight and Delivery Admin Costs
Total Marketing Effort b b<0 b=0 0<b<1 a = 7 x -0.25 0 0.5 0.25 9.90 7.00 3.50 0.50 8.32 7.00 4.95 0.75 7.52

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture