Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Looking at the Downtown location, how much did each customer spend, on average? At the Pacific Beach location? At the Oceanside location? Looking at theDowntown
Looking at the Downtown location, how much did each customer spend, on average? At the Pacific Beach location? At the Oceanside location? Looking at theDowntown location, what type of bike is the most profitable (after discount)? At the Pacific Beach location? At the Oceanside location? (Hint: Use the Pivot Table feature if you are familiar on how to use it.) Insert Page Layout Formulasata Review View Calibri (Body) -| 11 A^ A , Paste JB Bike Rental Downtown 18 Michael Airey Total Rental Bike Type Total Rental AmountAmount Name Hours 36.00 27.00 63.00 Cruiser 40.00 5 Ron Donahue 6 Julia Beeson 7 Phyllis DeBlanche 0.00 40.00 36.00 70.00 Cruiser s Arn 9 Rita Weiss 10 Thomas Shess 11 Don Braunagel 12 Laura Byrd 13 Cathy Clarde 14 Kevin Cox 15 Kathleen Gurnett 16 Margie 17 Thomas Arnold 18 Diane Nelson 19 Micheal Mode 20 Larry Edwards Cruiser Mountain Mountairn Mountain Mountairn Mountain Mountair 56.00 50.40 14.00 1s 3 $ 14.00 42.00 37.80 56.00 50.40 28.00 $ 28.00 Farnsworth Hybrid 12.00 Professional Professional Professional 12.00 $ 48.00 $ 48.00 $ 32.00 $ 32.00 43.20 644.00 591.00 22 Daily Total 23 Daily Average 24 25 26 Cruiser 27 Hybrid 28 Mountain 29 Professional 30 31 32 Discount Hour 33 Discount Amount 40.25 $3694 3.25 Rental Rates 10.00 12.00 14.00 16.00 Discount 10% Downtown Pacific Beach Ocean Beach Pivot Sheet Summary An Insert Page Layout Formulasata Review View Calibri (Body) -| 11 A^ A , Paste JB Bike Rental Downtown 18 Michael Airey Total Rental Bike Type Total Rental AmountAmount Name Hours 36.00 27.00 63.00 Cruiser 40.00 5 Ron Donahue 6 Julia Beeson 7 Phyllis DeBlanche 0.00 40.00 36.00 70.00 Cruiser s Arn 9 Rita Weiss 10 Thomas Shess 11 Don Braunagel 12 Laura Byrd 13 Cathy Clarde 14 Kevin Cox 15 Kathleen Gurnett 16 Margie 17 Thomas Arnold 18 Diane Nelson 19 Micheal Mode 20 Larry Edwards Cruiser Mountain Mountairn Mountain Mountairn Mountain Mountair 56.00 50.40 14.00 1s 3 $ 14.00 42.00 37.80 56.00 50.40 28.00 $ 28.00 Farnsworth Hybrid 12.00 Professional Professional Professional 12.00 $ 48.00 $ 48.00 $ 32.00 $ 32.00 43.20 644.00 591.00 22 Daily Total 23 Daily Average 24 25 26 Cruiser 27 Hybrid 28 Mountain 29 Professional 30 31 32 Discount Hour 33 Discount Amount 40.25 $3694 3.25 Rental Rates 10.00 12.00 14.00 16.00 Discount 10% Downtown Pacific Beach Ocean Beach Pivot Sheet Summary An
Looking at the Downtown location, how much did each customer spend, on average? At the Pacific Beach location? At the Oceanside location?
Looking at theDowntown location, what type of bike is the most profitable (after discount)? At the Pacific Beach location? At the Oceanside location? (Hint: Use the Pivot Table feature if you are familiar on how to use it.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started