You are a data analyst for Rainbow Bridge World $($RBW$),$ the Korean agency for a lot of musical talent, including the famous K$-$pop group MAMAMOO. The group has just released a new album, and various merch $($trading cards, t$-$shirts, plushies, etc.$)$ accompanied this album release. You$$ve been put in charge of presenting a data$-$driven story of their release campaign$$s performance. RBW has provided you with the following data sets:

transaction$\_$data: This table contains transaction level data for the label$$s Ecommerce store. Within the data are the following columns:

Transaction id: Uniquely identifies each transaction. Note: there can be multiple purchases associated with each transaction.

Days since release: the number of days since the release of MAMAMOO$$s album.

User is superfan: Whether the user associated with the transaction is a superfan of MAMAMOO $(1)$ or not $(0).$

Product: The product being purchased

Number Purchased: The amount of a product that was purchased in a given transaction.

pricing: This table contains the pricing schedule for each product on each day since the release. Prices are in dollars. This table contains the following columns:

Days since release: the number of days since the release of MAMAMOO$$s album.

product: The product under consideration

price: The price of a given product $($per unit, in dollars$)$ a given number of days since the album release

shipping: This table contains shipping costs to be paid by the purchaser of the merch. This table contains the following columns:

item$\_$count: The number of items being shipped

shipping: The shipping cost, in US dollars

costs: This table contains the total costs $($per unit$),$ paid by RBW$,$ to produce and stock each product. This table contains the following columns:

Product: The product being produced

cost: The cost to produce and stock the product $($per unit$)$

Instructions

The Ecommerce division has asked you to answer the following questions regarding merch sales during the album release campaign. Answer the questions, and then provide your recommendations to the Ecommerce division. Round all numeric answers to $2$ decimal places.

Here is the data to use for this analysis: kpop$\_$case$\_$data.xlsx