Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the total order quantity for customers who are buying either tables (i.e. any kind of tables) or computer desk? [DSUM] What was the

  1. What is the total order quantity for customers who are buying either tables (i.e. any kind of tables) or computer desk? [DSUM]

  1. What was the minimum order quantity for orders placed by companies in New Jersey (NJ) or California (CA), and with order dates between 2/01/2011 and 4/30/2012, both dates inclusive? [DMIN]
  2. What is the total order quantity for Scandinavian desks with smooth finish? [DSUM]
Lone Pine Furniture (LPF) Database Sales Tax Percentage 9.50%
Q1 Q1 Q1 Q2 Q8 Q15 BONUS
Customer ID Order Number Customer Name State Customer Since Order Date Product Line Name Product Finish Product Description Order Quantity Selling Price Total Order Amount Sales Tax Final Order with tax Product Category Discounted Selling Price Shipment Date Discount Applicable
C1 9 American Euro Lifestyles NJ 3/6/10 3/16/12 Cherry Tree Cherry Gold, Antique End Table 44 $175.00
C1 16 American Euro Lifestyles NJ 3/6/10 1/9/12 Scandinavia Natural Oak, Aged Coffee Table 8 $225.00
C2 10 Battle Creek Furniture MI 5/5/10 3/6/12 Country Look Walnut Brown, Speckled Computer Desk 27 $325.00
C2 7 Battle Creek Furniture MI 5/5/10 2/5/12 Scandinavia Natural Ash, Smooth Computer Desk 45 $375.00
C3 5 California Classics CA 1/3/11 1/23/12 Scandinavia Natural Ash, Aged Computer Desk 35 $375.00
C4 14 Contemporary Casuals FL 5/5/10 2/21/12 Scandinavia Natural Elm, Smooth Coffee Table 15 $225.00
C4 6 Contemporary Casuals FL 5/5/10 2/15/12 Cherry Tree Cherry Gold, Antique End Table 30 $175.00
C4 8 Contemporary Casuals FL 5/5/10 1/17/12 Country Look Natural Maple, Stained Entertainment Center 18 $650.00
C4 13 Contemporary Casuals FL 5/5/10 1/9/12 Country Look Walnut Gold, Aged Computer Desk 20 $675.00
C1 17 Eastern Furniture NJ 4/15/10 2/13/12 Scandinavia Natural Mahogany, Smooth Dining Table 25 $900.00
C5 18 Eastern Furniture NJ 4/15/10 1/2/12 Country Look Natural Maple, Blocked Entertainment Center 26 $700.00
C6 12 Home Furnishings NY 10/17/10 1/26/12 Country Look Natural Maple, Smooth Entertainment Center 23 $735.00
C7 4 Impressions CA 4/25/10 1/3/2012 Scandinavia White Ash, Aged 8-Drawer Desk 22 $750.00
C7 15 Impressions CA 4/25/10 3/14/12 Country Look Walnut Espresso, Crackled Computer Desk 62 $250.00
C8 11 Mountain Scenes UT 10/17/12 3/18/12 Scandinavia Natural Ash, Smooth Computer Desk 35 $375.00
C9 1 Value Furniture TX 10/10/12 1/3/2012 Country Look Natural Maple, Smooth Entertainment Center 29 $750.00
C9 2 Value Furniture TX 10/10/12 1/3/2012 Cherry Tree Cherry Rust, Antique Writers Desk 42 $325.00
C9 3 Value Furniture TX 10/10/12 2/13/12 Scandinavia Natural Ash, Aged Dining Table 13 $800.00 You MUST set up all your criteria for following questions on this "Queries" sheet!
Except for Questions number 8, 9 and 15 (presented below), make use of criteria range provided for other questions in this QUERIES sheet
Provide your Excel formula/function in the box provided for each question

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

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Finance questions

Question

What is the difference between adsorption and absorption?

Answered: 1 week ago