BIU- Merge & Center - $ - %, 8-98 Conditional Formats Cell Formatting Table Styles Styles Chipboard Font Alignment Number J32 fo A B D 27 28 Resort Bicycle Rental Bicycle Inventory Valuation Sunday, September 21, 2020 29 Revenue as Cost of current inventory Percent Number Total of cost of of Rental Revenue inventor net Rentals Revenue per Bike y revenue Number on Hand 30 2475 Make of Bike Bike cost Wonder Bike $325 Wonder B $385 Wonder B $475 LiteLift Pri $655 LiteLift Pri $655 LifeLite R $795 12 4 8 8 4 3 $3,900 $1,540 $3,800 $5,240 $2,620 $2,385 85 34 44 25 40 37 $6,375 $4,570 $5,200 $2,480 $6,710 $5,900 31 32 33 34 35 36 37 38 39 40 41 $531 $1,143 $650 $310 $1,678 $1,967 163% 297% 137% 47% 256% 247% Sheet1 Enter E O n UL