ITECH1100: Understanding the Digital Revolution - Suit Box Analysis

This assignment focuses on automating business processes for a small online store, Suit Box, using Microsoft Excel. It involves calculating operating costs, analyzing sales data to determine profit margins for different materials and employee performance, and creating automated quoting and decision-making tables using Excel functions like AVERAGEIFS, ROUND, and IF/ELSE conditions. The analysis includes visualizing data through charts to identify trends in material profitability, employee contribution, and product price ranges. The final automated tables allow for quick quote generation based on material and size selections, as well as manufacturing decisions based on popularity and stock status.

Running head: ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
ITECH1100: Understanding the Digital Revolution
Name of the Student
Name of the University
Authors note

2ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
Task 1
Being a small online store Suit Box produces custom made exceptional suits as per
their client’s requirements. As they solely sell their item through online stage with the staffs
Adrian, Bakari, Caitlin. Alongside them the business likewise requires a replacement worker
for about four months and need to pay their insurance and utility costs required for the
business. Following is the table that depicts all the required cost for business.
Suit Box
Staff
Day
Cou
nt
Hou
rs/
Day
Total
Shift
Hours
Extra Hours
for Social
Presence
Total
Working
hoursr
Pay
(skilled/p
art-time)
Pay/
Wee
k
Pay/
Year
Adrian 3 7.5 22.5 3 25.5 $ 26.00
$
663.
00
$
34,4
76
Bakari 2 7.5 15 0 15 $ 26.00
$
390.
00
$
20,2
80
Caitlin 5 4.5 22.5 3 25.5 $ 24.00
$
612.
00
$
31,8
24
Insurance
Cost
$
9,10
0.00
Utility Cost
every
month $ 260.00
$
3,12
0.00
Replaceme
nt Worker
Cost 66 $ 39.00
$2,5
74.0
0
$10,
296.
00
Total Operating Cost
$
109,
096
The total cost of operating the business is $ 109,096. This includes the utility, insurance
and payable to the permanent, part-time and replacement workers in the organization.

3ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
Task 2
From the given past sales data, the following charts are prepared to find out the
different aspects and variances in the orders with variance of the employee and other factors.
The first chart depicts the profit gained for different type of used materials for the
Suits. From the given chart the maximum difference between the quoted value and
manufacturing cost depicts the maximum amount of profit.
Cotton Leather Silk Tweed Wool
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
Sum of profi t by Material
Sum of profit
Sum of Manufacturing cost
($)
material
profit
From the above image, it can be stated that the organization gained maximum amount
of profit from the Leather products.
Now in the next chart, profit is compared with different employees for every material
used for the custom made suits.

4ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
Cotton
Leather
Silk
Tweed
Wool
Cotton
Leather
Silk
Tweed
Wool
Adrian and Caitlin Bakari and Caitlin
0 1000 2000 3000 4000 5000 6000
Sum of profi t by Employee
From the above chart it can be stated that, Adrian and Caitlin generated maximum
profit from leather products where as Bakari and Caitlin generated maximum profit from the
suits in which the wool is used as material.
The next chart shows the number of products for different price range. The table and
the chart shows the details of this aspect.
Range number of Products
25-100 25 10
0
64
100-
175
100 17
5
77
175-
250
175 25
0
48
325-
400
325 40
0
12
400-
475
400 47
5
1

5ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
475-
550
475 55
0
1
550-
625
550 62
5
0
625-
700
625 70
0
2
700-
775
700 77
5
2
25-100
100-175
175-250
325-400
400-475
475-550
550-625
625-700
700-775
0 10 20 30 40 50 60 70 80 90
Distribution of Products
From the above table and chart it is clear that maximum number of product is ordered
in the price range 100-175.
Task 3
After the examination of the information so as to robotize the citing procedure for
various mixes of size (XL, S, XXL, XS, L, M,) and materials (Cotton, Wool, Silk, Tweed,
Leather) for the arranged coats by the client, the accompanying table is made and the
statement esteem is created utilizing the "AVARAGEIFS" capacity of the Excel. So as to

6ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
make the procedure more straightforward to keep away from the decimal focuses after the
number esteem we have utilized the ROUND capacity of Excel.
Choose Material Wool
Choose Size S
Quote Amount for
Customer 139
Task 4
In order to get the automated table for the decision making of the suits IF, ELSE
conditions are utilized through which the parameters chosen by the staff of the organization is
assessed. Following is the table which is likewise accessible in the went with exceed
expectations sheet.
In order to do this the table created in the task 3 is extended and the parameters such
as popularity and availability is considered.
Choose Material Wool
Choose Size S
Quote Amount for
Customer 139
Popularity Status
unpopular
jacket
Stock Status In Stock

7ITECH1100: UNDERSTANDING THE DIGITAL REVOLUTION
Manufacturing Decision Do not start