Benchmark Assignment

User Generated

uhssf

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:mac LE, free of charge, from AnalystSoft.

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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
...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags