Eileen Dover, CEO of Good For You! Bakery, decided to open outlet stores two years ago. In some ways, this was a good decision as some stores appear to be doing well. However, the overhead to operate brick-and-mortar stores is high. Ms. Dover wants to examine the data to see which, if any, stores are underperforming so that she can close underperforming outlets if necessary.
Good For You! Bakery has data stored in two separate legacy tables: one table for sales data, and one table for cost data. When Ms. Dover created these tables early in the business, she associated each record with a unique store number. (In SAS®, each record is called an observation.)
Now Ms. Dover wants you to pull all of this data into two data sets in SAS® , join the data sets, and answer the following questions:
Which three stores netted the most profit in 2017? (Note that profit is equal to sales revenue minus costs.)
Which three stores netted the least profit in 2017?
What recommendation would you give the CEO regarding potential store closings? Include your rationale in detail.