ITECH1100: Digital Revolution for Hat Hideout - Business Analysis

This assignment analyzes the digital revolution's impact on Hat Hideout, a custom hat manufacturer, by examining employee performance, automating business processes, and visualizing data. The analysis includes employee work hours, wages, and paid leave, alongside the costs associated with replacement workers, insurance, and utilities. The solution uses charts to depict insights derived from past sales data, including order price ranges and employee contributions to quotes and average profit. Furthermore, the assignment automates the quotation process using the AVERAGEIFS function and production decisions based on material, size, popularity, and stock availability. Overall, the goal is to provide insights and automation strategies to improve business efficiency and revenue generation.

Running head: DIGITAL REVOLUTION FOR HAT HIDEOUT
Digital revolution for Hat Hideout
Name of the Student
Name of the University

1DIGITAL REVOLUTION FOR HAT HIDEOUT
Task 0
To be a manufacturer of Hats that are custom made on the basis of the requirements of
customers, it is very important for managing the resources. The resources are to be managed so
that they are able to improve the revenue from their business. This particular business manages
their business with the help of three employees belonging to the organization. These employees
are Allie, Beatrice, and Charlotte. Among these employees two of them named Allie, Beatrice
are very skilled staffs who are responsible for handling the department of manufacturing along
with the hourly payable of around $26. Besides this, Charlotte is an employee who works on a
part time shift and receives hourly payment of around $24.
Nam
e Days
Day
Coun
t
Shift
hours
Overtime for
social Presence
Total
Shift
Hour
Allie
Mondays, Tuesdays and
Wednesdays; 3 7.5 3 25.5
0
Beat
rice Thursdays and Fridays 2 7.5 15
0
Char
lotte
Mondays, Tuesdays,
Wednesdays,Thursdays, Fridays and
Saturdays 6 4.5 3 30
Task 1
On the basis of the available data, all the employees are entitled for yearly weeks of the
paid leave. In the four weeks, the companies tend to manage their business with replacing a
worker. The worker, who is hired in replacement, is hired at a rate of around $39 every hour. For

2DIGITAL REVOLUTION FOR HAT HIDEOUT
the purpose of calculating the wages, almost 5 working days have been considered. Along with
this, the annual utility and insurance cost have also been considered.
Name Days
Da
y
Co
unt
Shi
ft
hou
rs
Overtime
for social
Presence
Total
Shift
Hour
Ho
url
y
Pay
Pa
y
We
ek
Yea
rly
Pay
Allie
Mondays, Tuesdays
and Wednesdays; 3 7.5 3 25.5
$
26.
00
$
66
3.0
0
$
34,4
76.0
0
0
$
-
$
-
Beatrice Thursdays and Fridays 2 7.5 15
$
26.
00
$
39
0.0
0
$
20,2
80.0
0
0
$
-
$
-
Charlotte
Mondays, Tuesdays,
Wednesdays,Thursday
s, Fridays and
Saturdays 6 4.5 3 30
$
24.
00
$
72
0.0
0
$
37,4
40.0
0
$
-
Casual
replacement
Worker for
Four weeks 70.5
$
39.
00
$2,
74
9.5
0
$
10,9
98.0
0
Insuarnace
and Utility
Cost
$
3,1
20.
00
$9,
10
0.0
0
$
12,2
20.0
0

3DIGITAL REVOLUTION FOR HAT HIDEOUT
Total
Cost
$
1,15
,414
.00
From the above, table it can be stated that , total cost is $1,15,414.
Task 2
From the analysis that has been carried out on the basis of the data that has been retrieved
from past sales the following charts have been generated. Various insights have been depicted
from the provided charts below.
1
60
64
39
9
3 5 6 7
1
Chart Title
20-100
100-180
180-260
260-340
340-420
420-500
500-580
580-660
660-740
From the above chart it can be stated that, the maximum number of orders are booked in
the price range $100-180.
In the next insight the quotes value is compared by the employees.

4DIGITAL REVOLUTION FOR HAT HIDEOUT
Allie and Charlotte
Beatrice and Charlotte
15000 15500 16000 16500 17000 17500 18000 18500 19000 19500 20000
16752.8
19721.3
Sum of Quote amount by Employee
From the above chart, it can be stated that maximum amount of quotes is done by the
Beatrice and Charlotte.
In the following insight, the average profit is compared by the employees.
Allie and Charlotte
Beatrice and Charlotte
0 20 40 60 80 100 120 140 160 180
162.7
115.964406779661
Average of Profi t by Employee
From the chart that has been presented above, it could be stated that highest amount of
average profit has been generated by employees named Allie and charlotte.

5DIGITAL REVOLUTION FOR HAT HIDEOUT
Task 3
For this section the, Quotation process for the employees is automated. Using the
averageifs function the automation is done. Following table can be used for automation of the
quotes depending on the size and material.
CHOOSE MATERIAL Cotton
CHOOSE SIZE M
ESTIMTED QUOTE 78.16
Task 4
In this section the production decision of the products is automated. Depending on the
availability of the products and popularity the above table is extended. As shown below, the
employee can get the decision for the production after choosing the values for the parameters.
CHOOSE MATERIAL Cotton
CHOOSE SIZE M
ESTIMTED QUOTE 78.16
CHOSE POPULARITY Popular
CHOOSE STOCK
STATUS Not in Stock
PRODUCTION
DECISION START

6DIGITAL REVOLUTION FOR HAT HIDEOUT