BLING MAX RAW DATA 1 PAGE AND 1 QUESTION

profiledrknlvely26
Q1BlingMaxRawDataWorksheetstudent0830161.xlsx
Home>Mathematics homework help>Statistics homework help>BLING MAX RAW DATA 1 PAGE AND 1 QUESTION

Q1- Raw data

Drive up Inter-arrival times (IAT) Wash Service Chosen by Customer Service Time (ST) All data in minutes
3.0 economy 6 Q2 BASE: Situation Now Q3: New Blow-off Q4: New Blow-off + 4 wash "a" Q5: New Blow-off + 4 wash "b"
1.0 deluxe 8 WASH MINUTES PRICE WASH MINUTES PRICE WASH MINUTES PRICE PROBABILITY WASH MINUTES PRICE PROBABILITY
3.0 economy 6 economy 6 $8.00 economy 5 $8.00 economy 5 $8.00 35% economy 5 $7.00 30%
5.0 custom 7 custom 7 $9.00 custom 6 $9.00 custom 6 $9.00 25% custom 6 $8.00 20%
2.0 economy 6 deluxe 8 $10.00 deluxe 7 $10.00 deluxe 7 $10.00 20% deluxe 7 $9.00 20%
1.0 economy 6 elite 8 $11.00 20% elite 8 $10.00 30%
1.0 deluxe 8 ANALYSIS OF SAMPLE VS FITTED DISTRIBUTIONS
1.0 economy 6 INTERARRIVAL TIMES: SERVICE TIMES:
10.0 deluxe 8 Descriptive Statistics IAT Sample IAT Fitted Descriptive Statistics ST Sample ST Fitted
2.0 custom 7 Mean Mean
2.0 custom 7 Std Dev Std Dev
4.0 economy 6 Min Min
1.0 deluxe 8 Max Max
23.0 economy 6 Data Count Data Count
2.0 custom 7
2.0 economy 6 distribution distribution
18.0 deluxe 8
4.0 deluxe 8
3.0 custom 7 LOAN CALCULATION
2.0 deluxe 8 Q3 Q4, Q5
21.0 deluxe 8 Q3 Blower Investment
1.0 deluxe 8 Q4, Q5 RainX Investmt
2.0 deluxe 8 TOTAL investment $ - 0 $ - 0
6.0 deluxe 8
14.0 custom 7 Loan principal $ - 0 $ - 0
18.0 economy 6 Annual interest rate
11.0 economy 6 Monthly interest rate
3.0 deluxe 8 Term years
1.0 deluxe 8 Term months
20.0 custom 7 Loan payment/mo
19.0 deluxe 8 Loan payment/yr
5.0 custom 7
3.0 deluxe 8
9.0 economy 6
10.0 custom 7
2.0 custom 7
1.0 economy 6
6.0 custom 7
3.0 deluxe 8
10.0 deluxe 8
2.0 deluxe 8
9.0 custom 7
2.0 custom 7
33.0 custom 7
1.0 custom 7
5.0 deluxe 8
7.0 economy 6
1.0 custom 7
7.0 economy 6
10.0 deluxe 8
4.0 custom 7
28.0 economy 6
1.0 custom 7
8.0 deluxe 8
2.0 custom 7
9.0 deluxe 8
1.0 custom 7
6.0 custom 7
5.0 deluxe 8
7.0 custom 7
20.0 custom 7
6.0 custom 7
11.0 economy 6
12.0 custom 7
9.0 custom 7
2.0 deluxe 8
16.0 custom 7
22.0 custom 7
9.0 custom 7
14.0 custom 7
15.0 custom 7
1.0 economy 6
7.0 economy 6
8.0 deluxe 8
13.0 economy 6
4.0 custom 7
33.0 deluxe 8
3.0 custom 7
1.0 deluxe 8
8.0 deluxe 8
7.0 deluxe 8
10.0 economy 6
11.0 deluxe 8
9.0 custom 7
5.0 custom 7
6.0 custom 7
5.0 deluxe 8
14.0 economy 6
7.0 deluxe 8
12.0 economy 6
6.0 deluxe 8
5.0 custom 7
8.0 deluxe 8
8.0 custom 7
12.0 economy 6
13.0 deluxe 8
11.0 deluxe 8
4.0 custom 7
14.0 custom 7
3.0 deluxe 8
5.0 custom 7
1.0 custom 7
17.0 custom 7
1.0 economy 6
3.0 economy 6
6.0 deluxe 8
4.0 economy 6
4.0 economy 6
5.0 deluxe 8
4.0 economy 6
1.0 deluxe 8
2.0 economy 6
1.0 custom 7
6.0 economy 6
2.0 deluxe 8
15.0 economy 6
6.0 economy 6
5.0 deluxe 8
7.0 deluxe 8
6.0 economy 6
9.0 economy 6
12.0 custom 7
13.0 custom 7
11.0 economy 6
15.0 deluxe 8
15.0 economy 6
7.0 custom 7
15.0 deluxe 8
7.0 deluxe 8
3.0 economy 6
10.0 deluxe 8
2.0 economy 6
4.0 custom 7
4.0 economy 6
3.0 economy 6
3.0 custom 7
3.0 economy 6
2.0 deluxe 8
8.0 economy 6
13.0 economy 6
12.0 custom 7
19.0 economy 6
8.0 custom 7
8.0 custom 7
1.0 deluxe 8
2.0 custom 7
4.0 economy 6

Summary

BLING MAX CAR WASH PERFORMANCE METRICS TABLE 1
Performance Measure Q2: BASE Situation now (long cycle + 3 wash levels) Q3: Improved (New Exit Blow-off, same 3 wash levels) Q4: New Choices & Prices (Q3 + 4 Wash Levels at Pricing "a") Q5: New Choices & Prices ( Q3 + 4 Wash Levels at Pricing "b")
1 Average number of cars washed per day
2 95% probability of cars washed per day exceeds
3 Average daily revenue
4 Average daily profit
5 Average annual revenue (adj for 6% rain days)
6 Average annual profit (adj for 6% rain days)
7 Average wait time (min)
8 % chance that customers wait 10 min or less
9 % chance that customers wait 10 to 20 min
10 % chance customers wait more than 20 min
11 Improvement in annual profit vs. BASE (Q2) as $
12 Improvement in average wait vs. BASE (Q2) as %
13 Simple payback vs. BASE (yrs @ 2 decimals)
14 Annual loan repayment
15 Profit Improvement (#11) less Loan Payment (#14)
TOTAL INVESTMENT
3 year loan monthly repayment