Question: Please answer part f and g. Figure AE-1 Excel Spreadsheet A B D E F G I 1 2 3 4 Make of Bike 5

Please answer part f and g. Figure AE-1 Excel Spreadsheet A BD E F G I 1 2 3 4 Make of BikePlease answer part f and g.

Figure AE-1 Excel Spreadsheet A B D E F G I 1 2 3 4 Make of Bike 5 Wonder Bike 6 Wonder Bike II 7 Wonder Bike Supreme 8 Lite Lift Pro 9 Lite Lift Ladies 10 Lite Lift Racer Bike Cost $325 $385 $475 $655 $655 $795 Resort Bicycle Rental Bicycle Inventory Valuation Saturday, May 27, 2018 Revenue as Number on Cost of Current Number of Total Rental Revenue per Percent of Cost Hand Inventory Rentals Revenue Bike of Inventory 12 $3,900 85 $6,375 $531 163.5% 4 $1,540 34 $4,570 $1,143 296.8% 8 $3,800 44 $5,200 $650 136.8% 8 $5,240 25 $2,480 $310 47.3% 4 $2,620 40 $6,710 $1,678 256.1% 3 $2,385 37 $5,900 $1,967 247.4% Microsoft Excel, Microsoft Corporation f. Give three examples of decisions that management of the bike rental agency might make from this data. g. What other calculation could you make from this data that would be useful to the bike rental management? Create a second version of this spreadsheet in your worksheet document that has this calculation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!