##Introduction “Do people with lower incomes really eat more deli meat than those with higher incomes? And if so, which deli meat type do they used the most across different states? This research will uncover the truth behind which type of meat usage and spending habits.
Why should the Regork CEO be interested in this? By leveraging these insights, Regork can maximize profits while optimizing promotional spending, ensuring both increased revenue and cost savings. This research provides valuable insights into customer spending behavior, helping CEOs determine which time of the year should they operate marketing campaigns to attract new customers. Additionally, it allows companies to reassess long-standing coupon strategies that may have already shaped customer shopping habits.
How we addressed this problem statement? Descriptive Analysis: Utilizing data spanning in last year to analyze trends of shopping meat
Market Research: Analyzing the relationship between customer income and shopping behavior
Operation Strategy: Evaluating the most profitable states and target customer segments (e.g., income level, marital status) to optimize marketing strategies and implement targeted campaigns.
Proposed solution: Regork should strategically focus on offering turkeys in a range of sizes throughout the festival season, from October to January. This period represents a key opportunity to align with consumer demand during holidays and celebrations. By providing a variety of turkey sizes, Regork can cater to different customer needs, from small families to larger gatherings, thereby maximizing sales potential. Leveraging this seasonal demand will not only enhance customer satisfaction but also help establish Regork as a go-to brand for holiday meals, driving both short-term revenue and long-term brand loyalty.
Summary
## Welcome to the completejourney package! Learn more about these data
## sets at http://bit.ly/completejourney.
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.4 ✔ readr 2.1.5
## ✔ forcats 1.0.0 ✔ stringr 1.5.1
## ✔ ggplot2 3.5.1 ✔ tibble 3.2.1
## ✔ lubridate 1.9.4 ✔ tidyr 1.3.1
## ✔ purrr 1.0.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
##
## Attaching package: 'dbplyr'
##
##
## The following objects are masked from 'package:dplyr':
##
## ident, sql
## # A tibble: 75,000 × 11
## household_id store_id basket_id product_id quantity sales_value retail_disc
## <chr> <chr> <chr> <chr> <dbl> <dbl> <dbl>
## 1 2261 309 31625220889 940996 1 3.86 0.43
## 2 2131 368 32053127496 873902 1 1.59 0.9
## 3 511 316 32445856036 847901 1 1 0.69
## 4 400 388 31932241118 13094913 2 11.9 2.9
## 5 918 340 32074655895 1085604 1 1.29 0
## 6 718 324 32614612029 883203 1 2.5 0.49
## 7 868 323 32074722463 9884484 1 3.49 0
## 8 1688 450 34850403304 1028715 1 2 1.79
## 9 467 31782 31280745102 896613 2 6.55 4.44
## 10 1947 32004 32744181707 978497 1 3.99 0
## # ℹ 74,990 more rows
## # ℹ 4 more variables: coupon_disc <dbl>, coupon_match_disc <dbl>, week <int>,
## # transaction_timestamp <dttm>
## # A tibble: 92,331 × 7
## product_id manufacturer_id department brand product_category product_type
## <chr> <chr> <chr> <fct> <chr> <chr>
## 1 25671 2 GROCERY Natio… FRZN ICE ICE - CRUSH…
## 2 26081 2 MISCELLANEOUS Natio… <NA> <NA>
## 3 26093 69 PASTRY Priva… BREAD BREAD:ITALI…
## 4 26190 69 GROCERY Priva… FRUIT - SHELF S… APPLE SAUCE
## 5 26355 69 GROCERY Priva… COOKIES/CONES SPECIALTY C…
## 6 26426 69 GROCERY Priva… SPICES & EXTRAC… SPICES & SE…
## 7 26540 69 GROCERY Priva… COOKIES/CONES TRAY PACK/C…
## 8 26601 69 DRUG GM Priva… VITAMINS VITAMIN - M…
## 9 26636 69 PASTRY Priva… BREAKFAST SWEETS SW GDS: SW …
## 10 26691 16 GROCERY Priva… PNT BTR/JELLY/J… HONEY
## # ℹ 92,321 more rows
## # ℹ 1 more variable: package_size <chr>