Digital Revolution for Suite Scene

Running head: DIGITAL REVOLUTION FOR SUITE SCENE
Digital revolution for Suite Scene
Name of the Student
Name of the University
Authors note

DIGITAL REVOLUTION FOR SUITE SCENE
1
Task 0
The business operations of Suite Scene are handled by the three employees Alyx,
Bhavneet, and Carl. In these three employees, Alyx, Bhavneet are skilled and fulltime
employees with the pay rate of $26/Hour. On the Other hand, Carl is part time employee and
works at the pay rate of $24/hour. All these employees are entitled with four weeks of paid
leave. Following table, depicts their shift schedule for weeks;
Na
me Days
Day
Coun
t
Shift
hours
Overtime for
social Presence
Total
Shift
Hour
Alyx
Mondays, Tuesdays and
Wednesdays; 3 7.5 3 25.5
0
Bha
vnee
t Thursdays and Fridays 2 7.5 15
0
Carl
Mondays, Tuesdays, Wednesdays,
Thursdays, Fridays and Saturdays 6 4.5 3 30
As Carl works on Saturdays, thus the six working days are considered for him.
Task 1
In order to find out the operational cost for the business, the payable to permanent
and part time employees, utility as well as insurance cost for the business, cost for hiring the
replacement worker for four weeks is considered. Following table, depicts the total
operational cost along with that the components that are considered for calculating the same.
Name Days
Day
Cou
nt
Shif
t
hou
rs
Overtime
for social
Presence
Total
Shift
Hour
Pay
/
Ho
ur
Pay/
Year
Alyx Mondays, Tuesdays and
Wednesdays;
3 7.5 3 25.5 $
26.
00
$
34,4
76.0

DIGITAL REVOLUTION FOR SUITE SCENE
2
0
0
$
-
Bhavnee
t Thursdays and Fridays 2 7.5 15
$
26.
00
$
20,2
80.0
0
0
$
-
Carl
Mondays, Tuesdays,
Wednesdays, Thursdays,
Fridays and Saturdays 6 4.5 3 30
$
24.
00
$
37,4
40.0
0
Replace
ment
Worker 70.5
$
39.
00
$
10,9
98.0
0
Insuran
ce Cost
$
9,10
0.00
Utility
Cost
$
3,12
0.00
Annual
Cost
$1,1
5,41
4.00
After considering all, the provided information about the cost the total operational
cost is summed up to, $1,15,414.
Task 2
In this sections, different insights from the provided historical dataset is extracted
through the use of the charts that are available in Microsoft Excel.
For, the first chart depicted below is for finding out in which price range maximum
number of Suits are ordered from the customers.