Question
As a Business Intelligence, Construct three graphs or charts and write a properly formatted paragraph about each one. Focus your writing on what the charts
As a Business Intelligence, Construct three graphs or charts and write a properly formatted paragraph about each one. Focus your writing on what the charts TEACH us about what is going on the company.
BEFORE PROCEEDING WITH YOUR PROJECT WORK |
In 2021, all blocks of cheese were priced at $8.00. Please adjust the prices in yellow on the DATA sheet. |
In 2021, we raised the price of our beef sticks to $15.00. Please adjust the price in yellow on the DATA Sheet. |
Product Name Category 1 Category 2 Price Each 2018 Quantity Sold 2018 Price Each 2019 Quantity Sold 2019 Price Each 2020 Quantity Sold 2020 Creamy White Cheese Cheese Curd 4 987 4 1147 5 4268 Golden (Yellow) Cheese Cheese Curd 4 1396 4 2121 5 3629 BBQ Lovers Cheese Cheese Curd 0 0 0 0 5 820 Bloody Mary Cheese Cheese Curd 0 0 0 0 5 290 Chili Cheese Cheese Curd 0 0 0 0 5 419 Chili Lime Cheese Cheese Curd 0 0 0 0 5 402 Chipotle Cheese Cheese Curd 0 0 0 0 5 628 Country Side Herb Cheese Cheese Curd 0 0 0 0 5 732 Dill Cheese Cheese Curd 0 0 0 0 5 464 Garlic & Herb Cheese Cheese Curd 0 0 0 0 5 689 Pizza Cheese Cheese Curd 0 0 0 0 5 386 Ranch Cheese Cheese Curd 0 0 0 0 5 415 Salsa Cheese Cheese Curd 0 0 0 0 5 513 Six Pepper Cheese Cheese Curd 0 0 0 0 5 486 Taco Cheese Cheese Curd 0 0 0 0 5 509 Tomato Basil Cheese Cheese Curd 0 0 0 0 5 689 Stuffing (Oct-Dec) Cheese Cheese Curd 0 0 0 0 5 62 Margarita (May-July) Cheese Cheese Curd 0 0 0 0 5 38 Dairy Delicious (Vanilla) Ice Cream Gelato 3 149 3 260 4 371 Cow-colate (Chocolate) Ice Cream Gelato 3 130 3 240 4 360 Udderly-Berry (Strawberry) Ice Cream Gelato 3 267 3 381 4 496 Muddy Green Tractor (Mint Chip) Ice Cream Gelato 3 269 3 382 4 500 Muddy Red Tractor (Chocolate Cherry) Ice Cream Gelato 3 265 3 375 4 489 Party Til The Cows Come Home (Birthday Cake) Ice Cream Gelato 3 168 3 284 4 403 Jersey With Attitude (Salted Caramel) Ice Cream Gelato 3 130 3 248 4 364 Red Holstein Delight (White Chocolate Raspberry) Ice Cream Gelato 3 216 3 202 4 217 Harvest Time Pie (Apple Pie) (Aug-Nov) Ice Cream Gelato 0 0 3 109 4 133 Moo-ry Christmas (Candy Cane) (Nov-Jan) Ice Cream Gelato 0 0 3 1977 4 2222 Carnival Cows (Cotton Candy (June-Aug) Ice Cream Gelato 0 0 3 80 4 75 Pasture Pie (Keylime Pie) (May-Aug) Ice Cream Gelato 0 0 3 75 4 40 String Cheese Cheese String Cheese 5 1008 5 2400 7 2613 Plain Cheese Driftless Flying Cheese 7 108 7 133 7 400 Rosemary and Garlic Cheese Driftless Flying Cheese 7 133 7 200 7 197 Pepper Cheese Driftless Flying Cheese 7 115 7 99 7 17 Honey Cheese Driftless Flying Cheese 0 0 7 5 7 0 Colby Cheese Block Cheese 5 2643 5 2403 2519 Colby Jack Cheese Block Cheese 0 0 5 217 311 Mozzarella Cheese Block Cheese 5 2345 5 2100 2675 Creamy White Cheddar Cheese Block Cheese 0 0 0 805 909 Apple Pie Cheese Block Cheese 0 0 0 0 21 Blond Cheddar Cheese Block Cheese 0 0 5 66 162 Blueberry Cheese Block Cheese 0 0 0 0 55 Caraway Cheese Block Cheese 0 0 0 0 98 Chipotle Cheese Block Cheese 0 0 0 0 77 Dill Cheese Block Cheese 0 0 5 10 40 Festive Fall (Orange Cranberry) Cheese Block Cheese 0 0 5 98 55 Garden Medley Cheese Block Cheese 0 0 0 0 50 Garlic & Herb Cheese Block Cheese 0 0 5 80 90 Green Olive Cheese Block Cheese 0 0 5 88 108 Haunted Pepper Cheese Block Cheese 0 0 0 0 59 Hot Blonde (Jalapeno) Cheese Block Cheese 0 0 0 0 47 Little Italy Cheese Block Cheese 0 0 0 0 55 Marble Cheese Block Cheese 0 0 0 0 30 Mild Salsa Cheese Block Cheese 0 0 0 0 39 Onion & Chive Cheese Block Cheese 0 0 0 0 50 Pine Creek (Itallian) Cheese Block Cheese 0 0 0 0 49 Red Wine Raspberry Cheese Block Cheese 0 0 0 0 45 Six Pepper Cheese Block Cheese 0 0 0 0 63 Tomato Basil Cheese Block Cheese 0 0 0 0 46 Original Beef Stick Sausage Stick 10 2654 10 2345 2643
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started