Calculate the minimum profit, maximum profit, standard deviation of this question using excel: There is an increasing demand for food delivery amongst Singaporeans due to its convenience. GetGo can capitalise on this market trend by launching a food delivery service using their existing customer base (GetGo Classic), as well as target the higher socio-economic population who would be more willing to pay a subscription price of $5 monthly for priority deliveries, better trained delivery staffs and delivery by cars instead of motocycles (GetGo Premium).  Through primary research, GetGo found that the total number of deliveries for Classic will be 8 per month while the total number of deliveries for Premium will be 5 per month. To entice users to purchase premium, GetGo will lower platform fees to be $0.20/order as compared to classic at $0.40 per order. As Classic deliveries are done by motorcycles, there are more deliverymen available (5000-10000) as compared to Premium deliveries which are done by car drivers (3000-5000).  Variables GetGo Classic GetGo Premium Demand  (Number of Food Orders) λ = 8 per month λ = 5 per month Subscription cost per month (Fixed C) $0 $5 Number of Driver/Deliveryman R~U[5000,10000] R~U[3000,5000] Platform Fee (Variable C) $0.40/order $0.20/order

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.6: Regression And Median-fit Lines
Problem 4GP
icon
Related questions
Question

Calculate the minimum profit, maximum profit, standard deviation of this question using excel:

There is an increasing demand for food delivery amongst Singaporeans due to its convenience. GetGo can capitalise on this market trend by launching a food delivery service using their existing customer base (GetGo Classic), as well as target the higher socio-economic population who would be more willing to pay a subscription price of $5 monthly for priority deliveries, better trained delivery staffs and delivery by cars instead of motocycles (GetGo Premium).  Through primary research, GetGo found that the total number of deliveries for Classic will be 8 per month while the total number of deliveries for Premium will be 5 per month. To entice users to purchase premium, GetGo will lower platform fees to be $0.20/order as compared to classic at $0.40 per order. As Classic deliveries are done by motorcycles, there are more deliverymen available (5000-10000) as compared to Premium deliveries which are done by car drivers (3000-5000). 

Variables GetGo Classic GetGo Premium

Demand 

(Number of Food Orders)

λ = 8 per month

λ = 5 per month

Subscription cost per month (Fixed C)

$0

$5

Number of Driver/Deliveryman

R~U[5000,10000]

R~U[3000,5000]

Platform Fee (Variable C)

$0.40/order

$0.20/order

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt