I would like to include the number of sales representatives and sales assistens in my sales process as a factor that influences revenue. How can I do that?
I would like to include the number of sales representatives and sales assistens in my sales process as a factor that influences revenue. How can I do that?
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 22RA
Related questions
Question
I would like to include the number of sales representatives and sales assistens in my sales process as a factor that influences revenue. How can I do that?
Transcribed Image Text:# Number of Sales Assistants (Appointment) and Number of Sales Representatives (Conversion)
number_of_sales_assistants <- 10 # Sales assistants
number_of_sales_representatives
<- 5 # Sales representatives
#Sales process based on binomial distribution
#Basic sales process
#Leads
leads <- rbinom (1, target_group, lead_rate)
total_lead_cost <- leads * lead_cost
#Appointments
appointments <- rbinom(1, leads, appointment_rate_assistant)
total_appointment_cost <- appointments* appointment_cost
#Conversions
conversions <- rbinom (1, appointments, conversion_rate_representative)
total_conversion_cost <- conversions conversion_cost
*
# Revenue
revenue <- conversions * average_order_value_new
# Costs
total_costs <- total_lead_cost + total_appointment_cost + total_conversion_cost
# Profit
profit <- revenue total costs
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr