Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the excel formula for this 1 Pasadena Facility: Inventory Status of Plants 2 As of September 30 WHAT IS THE FORMULA FOR THESE

image text in transcribedWhat is the excel formula for this

1 Pasadena Facility: Inventory Status of Plants 2 As of September 30 WHAT IS THE FORMULA FOR THESE TWo 4 Total Items in Stock 5 Average Price 6 Median Price 7 Lowest Price 8 Highest Price 1650 56.89655172 49 18 175 10 Specialty Plant Types 11 Specialty Quantity in Stock 12 13 Quantity in Stock Item #/Category I 95 1123-Edibles 37 1267-Container Plant Clematis Hank 58 1843-Bonsai 78 1852-Specialty 93 1862-Container Plant Minny Pearl 27 2132-Edibles 78 2157-Specialty 28 2158-Specialty 24 2176-Container Plant Strawberry Sweet 26 2201-Edibles 56 2202-Edibles 24 2202-Vine Roses Magid Hybrid 49 2219-Vine Roses Sunshine Dream 65 2223-Vine Roses Purple Splash Item Name Retail Price Size Special Feature Macadamia Nut 15.42 24" Fall Color 28.95 42" Fall Color 24.95 10" Showy 13.95 14" Pollenizer 16.95 15" Showy 15 16 Fragrant Plum Banana Cream 18 September Raspb Elite Gold Pineapple Salzia Glue 19 7.58 12" Fall Color 12.65 16" Easy Care 15.95 12" Fall Color 6.59 6"Showy 18.59 24" Easy Care 18.95 18" Easy Care 11.35 14" Pollenizer 16.57 24" Fall Color 25.95 14" Showy 5.9541" Fall Color 54.95 24" Fall Color 24.95 16" Easy Care 16.58 12" Easy Care 11.35 16" Pollenizer 26.95 11" Fall Color 34.95 36" Easy Care 28.95 28" Easy Care 10.59 18" Pollenizer 38.95 28 Easy Care 26.95 33" Easy Care 34.95 35" Pollenizer 14.95 12" Showy 31.95 26" Pollenizer 18.65 24" Easy Care Dwarf Banana Top Hat Blueberry 25 26 Wing Ding Tetrapleed Breeder 175 2266-Vine Roses 29 30 18 2268-Specialty 28 2278-Container Plant Blanket Flower 19 2308-Container Plant Cinnamon Tree 56 2317-Vine Roses Pope Benedict 32 Black Pie Super Dwarf Tomato Dwarf Raspberry Hot Chocolate Elite Pineapple Cashew Tree Holiday Assortment 135 2356-Vine Roses 45 2364-Edibles 36 2402-Edibles 52 2404-Vine Roses 49 2428-Edibles 23 2437-Specialty 37 38 150 2439-Edibles 42 2543-Container Plant Lavandula 32 2580-Specialty 52 2582-Container Plant Chandler Blueberry New Dimension 43

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions

Question

a sin(2x) x Let f(x)=2x+1 In(be)

Answered: 1 week ago