Excel HW
Bob_Usher
ALQASHAYAN-g016-xl-ch02-grader-2e-hw.xlsxSheet1
| Pasadena Facility: Inventory Status of Plants | |||||||
| As of September 30 | |||||||
| Statistics | Total Items in Stock | 1,650 | |||||
| Average Price | $ 56.90 | ||||||
| Median Price | $ 49.00 | ||||||
| Lowest Price | $ 18.00 | ||||||
| Highest Price | $ 175.00 | ||||||
| Specialty Plant Types | 6 | ||||||
| Specialty Quantity in Stock | 1419 | ||||||
| Quantity in Stock | Item# | Item Name | Retail Price | Size | Special Feature | Category | Stock Level |
| 78 | 1852 | Banana Cream | 13.95 | 14" | Pollenizer | Specialty | Ok |
| 135 | 2356 | Black Pie | 26.95 | 11" | Fall Color | Patio Roses | Ok |
| 28 | 2278 | Blanket Flower | 24.95 | 16" | Easy Care | Container Plants | Order |
| 23 | 2437 | Cashew Tree | 26.95 | 33" | Easy Care | Specialty | Order |
| 52 | 2582 | Chandler Blueberry | 18.65 | 24" | Easy Care | Container Plants | Ok |
| 19 | 2308 | Cinnamon Tree | 16.58 | 12" | Easy Care | Container Plants | Order |
| 37 | 1267 | Clematis Hank | 28.95 | 42" | Fall Color | Container Plants | Order |
| 26 | 2201 | Dwarf Banana | 18.59 | 24" | Easy Care | Edibles | Order |
| 36 | 2402 | Dwarf Raspberry | 28.95 | 28" | Easy Care | Edibles | Order |
| 78 | 2157 | Elite Gold Pineapple | 12.65 | 16" | Easy Care | Specialty | Ok |
| 49 | 2428 | Elite Pineapple | 38.95 | 28" | Easy Care | Edibles | Order |
| 58 | 1843 | Fragrant Plum | 24.95 | 10" | Showy | Bonsai | Ok |
| 150 | 2439 | Holiday Assortment | 34.95 | 35" | Pollenizer | Edibles | Ok |
| 52 | 2404 | Hot Chocolate | 10.59 | 18" | Pollenizer | Patio Roses | Ok |
| 42 | 2543 | Lavandula | 14.95 | 12" | Showy | Container Plants | Order |
| 95 | 1123 | Macadamia Nut | 15.42 | 24" | Fall Color | Edibles | Ok |
| 24 | 2202 | Magid Hybrid | 11.35 | 14" | Pollenizer | Patio Roses | Order |
| 93 | 1862 | Minny Pearl | 16.95 | 15" | Showy | Container Plants | Ok |
| 32 | 2580 | New Dimension | 31.95 | 26" | Pollenizer | Specialty | Order |
| 56 | 2317 | Pope Benedict | 11.35 | 16" | Pollenizer | Patio Roses | Ok |
| 65 | 2223 | Purple Splash | 25.95 | 14" | Showy | Patio Roses | Ok |
| 28 | 2158 | Salzia Glue | 15.95 | 12" | Fall Color | Specialty | Order |
| 27 | 2132 | September Raspberry | 7.58 | 12" | Fall Color | Edibles | Order |
| 24 | 2176 | Strawberry Sweet | 6.59 | 6" | Showy | Container Plants | Order |
| 49 | 2219 | Sunshine Dream | 16.57 | 24" | Fall Color | Patio Roses | Order |
| 45 | 2364 | Super Dwarf Tomato | 34.95 | 36" | Easy Care | Edibles | Order |
| 18 | 2268 | Tetrapleed Breeder | 54.95 | 24" | Fall Color | Specialty | Order |
| 56 | 2202 | Top Hat Blueberry | 18.95 | 18" | Easy Care | Edibles | Ok |
| 175 | 2266 | Wing Ding | 45.95 | 41" | Fall Color | Patio Roses | Ok |
ALQASHAYAN_g016_xl_ch02_grader_2e_hw
