Description
Review "Benchmark Assignment - Data Analysis Case Study" and "Benchmark Assignment - Data Analysis Case Study Data" for this topic's case study, evaluating operations for a local restaurant.
Although your friend and restauranteur Michael Tanaglia offered to go over your findings in person, you believe it would be appropriate to also prepare a report and document your findings in writing. In a 1,000-1,250-word report, explain your approach for each evaluation and the rationale for the methods you used. Include any recommendations based on customer satisfaction, forecasting, and staff scheduling data.
Use an Excel spreadsheet file for the calculations and explanations. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell). Students are highly encouraged to use the "Benchmark Assignment - Data Analysis Case Study Template" and "Benchmark Assignment - Data Analysis Case Study Linear Programming Template" to complete this assignment.
Mac users can use StatPlus
Prepare the assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to Turnitin. Please refer to the directions in the Student Success Center.
Explanation & Answer
use this
Linear, Integer and Mixed Integer Programming
Signs
<
=
>
Data
x1
x2
Minimize
10 AM-1 PM
1:00 PM - 4:00 PM
4:00 PM- 7:00 PM
7:00 PM- 10:00 PM
10:00 PM- 1:00 AM
1
3
5
5
7
4
Results
Variables
Objective
0
x3
1
4
5
6
6
4
x4
1
4
5
5
6
5
1
3
6
5
6
6
less than or equal to
equals (You need to enter an apostrophe first.)
greater than or equal to
Results
LHS
x5
1
4
6
6
5
5
sign
≤
>
≤
≤
>
RHS
3
4
6
7
4
0
0
Problem setup area
Slack/Surplus
0
0
0
0
0
0
3
4
6
7
4
< constraints
0
0
0
0
0
3
0
6
7
0
> constraints
0
0
0
0
0
> constraints
3
4
6
7
4
Forecasting
Moving averages - 4 period moving average
Num pds
Next period
Forecasts and Error Analysis
Forecast Error
Absolute
Demand
650
725
850
825
865
915
900
930
950
899
935
Squared
Abs Pct Err
762.5
102.5
102.5 10506.25
11.85%
816.25
98.75
98.75 9751.5625
10.79%
863.75
36.25
36.25 1314.0625
04.03%
876.25
53.75
53.75 2889.0625
05.78%
902.5
47.5
47.5
2256.25
05.00%
923.75
-24.75
24.75 612.5625
02.75%
919.75
15.25
15.25 232.5625
01.63%
Total
329.25
378.75 27562.313
41.83%
Average
47.035714 54.107143 3937.4732
05.98%
Bias
MAD
MSE
MAPE
SE
74.245959
1000
900
928.5
800
700
Value
Data
Period
Period 1
Period 2
Period 3
Period 4
Period 5
Period 6
Period 7
Period 8
Period 9
Period 10
Period 11
4
600
500
400
300
200
100
0
Forecasting
1000
900
800
700
600
500
400
300
200
100
0
0
2
4
6
Time
Series1
8
10
12
Dine In (1)/Take Out (2)
1
1
1
1
2
2
2
1
2
1
2
2
1
1
1
1
1
2
2
1
2
1
2
2
1
2
2
1
2
1
2
2
1
2
2
1
1
1
2
2
1
2
2
1
2
1
2
Satisfaction with ServiceSatisfaction with Food
4
4
2
3
3
3
5
5
3
4
2
4
3
4
4
3
3
3
2
3
1
3
2
2
5
4
4
5
4
5
3
4
4
3
3
4
3
4
4
5
4
5
2
3
3
5
3
4
3
4
4
5
3
3
4
4
3
4
4
5
2
3
2
2
4
4
3
2
3
3
3
3
...