Under performing outlets, Ms. Dover wants to examine the

Under performing outlets

Assignment Help Basic Computer Science

Reference no: EM132852619

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.

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.

Reference no: EM132852619

Questions Cloud

What is the probability of women with bmi : The following table cross-classifies pregnant women in the study by their body mass index (BMI) at 16 weeks gestation and whether they had pre-term delivery.

Formulate a regression model : Assume sales depend on the price and advertising expenditure. Use the data below to formulate a regression model

Record the additional activity and revised income statement : Record the additional activity and a revised income statement for July 2018 and a revised balance sheet as of July 31, 2018

Find the? marginal-revenue equation : Find the? marginal-revenue equation and use it to find the marginal revenue for the production of the given number of bushels.

Under performing outlets : Ms. Dover wants to examine the data to see which, if any, stores are underperforming so that she can close under performing outlets if necessary.

Calculate income attributable to non-controlling interest : In 2020, PAR's net income was $300,000 and SUBS's net income was $72,000. Calculate income attributable to non-controlling interest

Determining the measure of central tendency : Which measure of central tendency (mean or median) should you report?

AF702 Strategic Financial Management Assignment : AF702 Strategic Financial Management Assignment Help and Solution, Qualifi Ltd - Assessment Writing Service - Identify a range of business resources to meet

What is the probability of scoring higher : A set of final exam scores in a statistics course was found to be normally distributed, with a mean of 84 and a standard deviation of 7.

User Account

All Pages