Week 4 Case Study - Franchise Restaurant

This case study provides an opportunity for you to connect your weekly learning to real-world business situations. It will also help to develop your problem-solving skills.

Scenario

A Franchise Restaurant, Lafayette, has maintained three vegetable suppliers. The firm reported information about what it has purchased last few weeks from the suppliers as follows:

Bonner, Enz, and Walker are the names of the three suppliers.

Numbers are prices per unit.

Units are in $

ItemsBonnerEnzWalker

Vegetable 10.611.251.11

Vegetable 10.891.190.99

Vegetable 10.491.360.84

Vegetable 20.811.421.75

Vegetable 21.211.391.65

Vegetable 21.051.291.69

Vegetable 32.881.251.75

Vegetable 30.991.231.62

Vegetable 31.991.471.81

1- Using ANOVA, t-tests, and descriptive statistics, you are expected to provide the answers to the following questions.

Enter data into EXCEL (with variable names) and read the data using SPSS and provide the means of the following tables (provide your EXCEL Data file and SPSS results for the means).

ItemsBonnerEnzWalker

Vegetable 1

Vegetable 2

Vegetable 3

2.Compare the mean prices of items from the three suppliers and answer to questions:

a) whether means statistically differ among three suppliers and

b) whether means statistically differ by the categories of vegetables. (ANOVA and Post-Hoc tests)

3. Are price differences due to suppliers or items or both? Explain the situation related to the prices by suppliers and items and also explain the joint effect. In addition, provide the plot (horizontal: items and separate lines: suppliers).

Deliverables

Save your answers in a Word file and answer it. Plz also submit the supporting Excel and SPSS files.