You are in the business of providing consulting services for clients that need to pass health and safety inspections to stay in business. You are trying to raise capital to expand your business and are giving a meeting next week to some angel investors. Describe the first-year business results and determine whether or not this is a profitable venture. 

• You get paid revenue up front for your services, but if you fail to live up to the job you must provide refunds. You make the following upfront revenues from clients based on their level of risk:
  • Extremely High Risk = $2,250
  • High Risk = $1,750
  • Medium Risk = $1,000
  • Low Risk $750
• If a client passes their initial inspection, the business arrangement is done, and you keep all of the revenue. If a client fails a health inspection, you refund the client a flat fee of $2,500. If a client fails a safety inspection, you refund the client a flat fee of $2,000

 

Requirements: 

1. Create 5 descriptives that provide insights into the profitability of the venture. Each of the following variables MUST show up in at least once:
   • Inspection Date (feel free to analyze by month)
   • Facility Type
   • Risk Level
   • Inspection Type
   • Revenue
   • Refund
   • Income (Revenue - Refund)
2. A descriptive that Answers the following: 
3. Are healthy and safety inspections profitable ventures in each of the cities?