I have som interesting data from a Consultancy Firm, which I want to model. I know it is a rookie question, but hiw can the following variables be modelled?
Variables (Data point per quarter):
- Revenue Growth (Percent)
Number of Clients (#)
Sales Activity (Percent of hours spent on sales work)
Chargeability (Percent of hours charged to clients)
Headcount Change (#)
Recruiting (#)
Attrition (Percent of headcount who left the company)
Employee Satisfaction (Percent)
Level 1:
Revenue = A1*Chargeability*Headcount + A2*Number Clients
Level 2:
Headcount = A3*Recruiting - A4*Attrition
Number of Clients = A5*Sales Activity
Level 3:
Attrition = - A6*Employee Satisfaction
How can I model this? All variables I measure the change from quarter to quarter to have same standard in measurement.