A4CB

.pdf

School

Lamar University *

*We aren’t endorsed by this school

Course

5360

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

pdf

Pages

5

Uploaded by ChiefScorpionPerson933

Report
Using Tableau answer the following questions: 1. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) yields the maximum profit in each market size(major/small)? (2 points) Hint: drag and drop product type and market size from dimensions to columns and drag and drop profit from the fact table (measures) to rows. Go to Label > Show Mark Labels. Product Type Market Size Profit Coffee Major $53,001 Herbal Tea Small $34,418 2. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) yields maximum sales in each market (east/ west/south/central)? (4 points) Hint: product type in columns and market and sales in rows. Find out the maximum sales in each region. To clear rows and columns, drag and drop the fields to their original place. 1
Product Type Market Sales Coffee East $56,641 Herbal Tea West $72,288 Espresso South $44,990 Coffee Central $69,080 3. Which product (Amaretto, Columbian, Cafe Latte, etc.) and product type (Coffee/ Espresso/ Herbal Tea/ Tea) give the maximum profit in which State (California, Florida, Texas, Connecticut, etc.)? (6 points) Hint : product and product type in columns and state and profit in rows. Find out the maximum profit by clicking on the tallest bar graph. 2
Product Product Type State Profit Amaretto Coffee Colorado $3,410 Caffe Latte Espresso California $4,497 Caffe Mocha Espresso Illinois $6,575 Chamomile Herbal Tea Iowa $6,577 Columbian Coffee Massachusetts $12,489 Darjeering Tea Nevada $6,580 Decaf Espresso Espresso California $6,580 Decaf Irish Cream Coffee Illinois $3,463 Earl Grey Tea Iowa $5,624 Green Tea Tea Oregon $2,726 Lemon Herbal Tea New York $6,092 Mint Herbal Tea Nevada $3,457 Regular Espresso Espresso New York $7,589 4. Which product type (Coffee/ Espresso/ Herbal Tea/ Tea) in which market (east/ west/south/central) has the maximum inventory? (2 Points) Hint: product type in columns and market and inventory in rows. Find out the maximum inventory. 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help