ITEC1100: Digital Revolution and Uniform Basement Business Analysis

This assignment analyzes the digital transformation of Uniform Basement, a custom uniform manufacturer. It begins by calculating the company's total operating costs, including employee salaries, utilities, and insurance. The assignment then explores sales data, visualizing quote counts and amounts across different price ranges and weekdays. The core of the assignment involves automating business processes using Excel. This includes creating a system for generating instant quotes based on material and size selections and automating production decision-making based on factors like material availability and popularity. The goal is to optimize efficiency and resource allocation within the business. The assignment utilizes data analysis and automation techniques to provide insights into the business operations. The student has used Microsoft Excel (or equivalent open-source software) for this assessment task.

Running head: UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
Understanding the Digital Revolution for Uniform Basement
Name of the Student
Name of the University
Authors note

1UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
Task 0
Uniform Basement manufactures and sales their custom made uniforms through the
online store with the help of the three employees namely Arthur, Briony, and Charles. Arthur
and Briony are full time and skilled employees who manages the manufacturing of the
Uniforms. On the other hand, Charles manages orders from the clients and delivery of the
products.
Task 1
In order to determine the total operating cost for the business of the that includes all
the necessary costs such as payable to the three employees and replacement worker, overtime
for managing the social presence, utility cost for the year, Annual insurance cost for the
business. After the accumulation and summing up all the costs we get the following table,
Shift Days
C
o
u
nt
Ho
urs/
Day
Shift
Hours
/week
Extra
Hours/
Week
Tot
al
Tim
e
Pay
Rate/
Hour
Week
ly
Paya
ble
Yearl
y
Paya
ble
Arthur
Mondays,
Tuesdays and
Wednesdays 3 7.5 22.5 3 25.5
$
26.00
$
663.0
0
$
34,47
6.00
Briony
Thursdays
and Fridays 2 7.5 15 0 15
$
26.00
$
390.0
0
$
20,28
0.00
Charles
every
weekday 5 4.5 22.5 3 25.5
$
24.00
$
612.0
0
$
31,82
4.00
$
-
Replac
ment
worker 66
$
39.00
$
2,574.
00
$
10,29
6.00
Utility
Cost
$
260
/Month
$
3,120
.00
Insuran $

2UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
ce Cost
9,100
.00
Total
Operati
ng Cost
$
1,09,
096.0
0
From the above table, after including all the costs for the business the annual cost is
summed up to $1,09,096.
Task 2
In order to explore different insights from the past sales data, following charts are
generated. The first chart below depicts that, count of quotes in different price ranges.
40-100
100-160
160-220
220-280
280-340
340-400
400-460
460-520
520-580
580-640
640-700
700-760
760-820
820-880
53
62
49
20
4
6
4
5
3
6
2
2
2
1
Count of Quotes
Count of Quotes
Count
Value

3UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
From, the above chart it can be stated that maximum amount of quotes for the
uniforms are priced between the price range$100-160. 62 products are quoted in the price
range of $100-160.
The next chart, shows the quote amount compared by week day.
Mon Tue Wed Thu Fri
0
2000
4000
6000
8000
10000
12000
9865.8
11464.1 10260.6
6067.9 6388.4
Sum of Quote amount by Day
From the above chart, it is clear that maximum amount of quotes is made on Tuesday
and the total quotation value is 11464.1. Minimum amount of quote was made on Thursday.
For the profit, this is also compared by weekdays and the following chart is
generated.

4UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
Mon Tue Wed Thu Fri
0
1000
2000
3000
4000
5000
6000
7000
8000
9000 7473.2
8668.6
7571.6
3942.8 4044.9
Sum of Profi t by Day
From the above chart, it is clearly visible that in accordance to the quote value
maximum profit is recorded for the day Tuesday.
Task 3
For the employees of the Uniform Basement, it is very complicated instantly quote
for the orders with 6 size options as well as 5 material options while confirming the order.
Thus in order to help the employees and to automate the quotation process of the
organization. In the accompanied excel sheet, the table for the automation is provided which
calculates the estimated quote depending on the selection of the material and size of the
ordered product.
SELECT MATERIAL Leather
SELECT SIZE XS
ESTIMATED
QUOTE 151

5UNDERSTANDING THE DIGITAL REVOLUTION FOR UNIFORM BASEMENT
In the above table, the employees of the organization will be able to select material and size
of the Uniform as ordered by the customer and the quote value will be provided in the cell
marked with green.
Task 4
In this part the production decision making process is automated using the formulas
of excel. In order to use the available scarce human and material resource this is done. Thus,
in case the customer does not take the delivery of the product then that should not be wasted
rather can be reused for another same order. The following is the table created for the same.
SELECT MATERIAL Wool
SELECT SIZE L
ESTIMATED QUOTE 133
SELECT POPULARITY Not Popular
SELECT
AVAILABILITY Available in Stock
DECISION
DO NOT
MANUFACTURE