ITECH1100: Understanding Digital Revolution - Dress Frenzy Assignment

This assignment solution for ITECH1100, "Understanding Digital Revolution," focuses on automating business processes for the fictional company, "Dress Frenzy." The solution utilizes Microsoft Excel to analyze operational costs, visualize quote values, and determine optimal manufacturing decisions. Task 1 calculates the total operational cost, considering employee salaries, social media management, and utility expenses. Task 2 analyzes historical quote data, material manufacturing costs, and profit margins for different dress materials, providing insights into the company's profitability. Task 3 automates the quoting process, allowing employees to select material and size to generate a relevant quote. Finally, Task 4 automates manufacturing decisions based on product availability and popularity. The assignment demonstrates the application of data analysis and automation to improve business efficiency and decision-making.

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

1ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
Task 0
Dress Frenzy operates its business of clothing by the employees Abbey, Bhavneet,
and Cindy. This business is specialized in manufacturing of custom made and one-of-a-kind
dresses. They sell their product exclusively through the online store. Following is the table
that shows the shift times, days of working and other details.
Empl
oyess Days
Hors/
everyda
y
Hours/
Every
week
Extra hour for
Social Media
Total
Working
time
Hours
/Year
Abbe
y
Mondays, Tuesdays
and Wednesdays 7.5 22.5 3 25.5 1326
Bhav
neet
Thursdays and
Fridays 7.5 15 0 15 780
Cindy Every Weekday 4.5 22.5 3 25.5 1326
Task 1
For finding out the total operating cost, the standard 5 working days are considered.
Along with that, the payable for the extra hours for managing the social media presence as
well as the utility and insurance cost is also considered. The payable to the replacement
worker is considered for 4 weeks. Following is the complete worked out table for calculating
the total cost.
Emplo
yess Days
Hor
s/
ever
yda
y
Hour
s/
Ever
y
week
Extra
hour for
Social
Media
Total
Work
ing
time
Ho
urs
/
Ye
ar
Da
y
Co
un
t
Cost
ever
y
hour
Cost
Ever
y
Wee
k
Cos
t/
Yea
r
Abbey
Mondays,
Tuesdays
and
Wednesda
ys 7.5 22.5 3 25.5
132
6 3
$
26.0
0
$
663.0
0
$
34,4
76.0
0
Bhavne
et
Thursdays
and
7.5 15 0 15 780 2 $
26.0
$
390.0
$
20,2

2ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
Fridays 0 0
80.0
0
Cindy
Every
Weeday 4.5 22.5 3 25.5
132
6 5
$
24.0
0
$
612.0
0
$
31,8
24.0
0
$
-
Insuran
ce Cost
$
-
$
9,10
0.00
$
-
Utility
Cost
$
-
$
3,12
0.00
$
-
$
-
Replac
ement
worker
cost
Every
week day 66
$
39.0
0
$
2,574
.00
$
10,2
96.0
0
$
1,09
,096
.00
From the above table, it can be stated that including all the information provided for
payable to the employees, insurance and other costs the total operational cost becomes
$109096 for every year.
Task 2
For the provided historical data, the minimum and maximum quote value are $28,
$809.7. The distribution of the different quote ranges and respective orders are plotted.

3ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
Count of quotes
0
10
20
30
40
50
60
70
80
Distribution of Quote Values
20-90 90-160 160-230 230-300 300-370 370-440
440-510 510-580 580-650 650-720 720-790 790-860
Here, it can be said that maximum number of orders are booked for the quote
value$90-160 and the minimum quote is recorded for $510-580, $650-720 and $790-860.
Now, the manufacturing cost for different materials is calculated and plotted.
Following is the generated plot.
Cotton Leather Silk Tweed Wool
0
500
1000
1500
2000
2500
3000
3500
4000
1257.5
2560.7
3489
508.2
3893.3
Sum of Manufacturing cost ($) by
Material
The maximum amount of cost is incurred for the clothing made of woollen material
which is $3893.3.
In the next chart, the profit from the clothing made of different materials are
explored.

4ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
Cotton Leather Silk Tweed Wool
0
2000
4000
6000
8000
10000
12000
2622.3
7091.6
10895
783.1
6382.5
Sum of Profi t by Material
From the above chart, it is clearly visible that, maximum profit is generated by the
clothing made of silk ($10895) and minimum is from Tweed ($783.1).
Total
0
5000
10000
15000
20000
19281.8
8492.7
Sum of Profi t by Employee
Axis Title
Axis Title
At the end the contribution of the different employees in the generated profit is
calculated. For Abbey and Cindy total generated profit is $19281.8 and on the other hand
Bhavneet and Cindy Generated $8429.7.

5ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
Task 3
As the business organizations makes dresses with five materials and six sizes
according to the customer requirements thus, it becomes very complex for the employees to
make quotes that are in relevance with past quote values for some specific combination while
maintaining the profitability of the organization.
Therefore, in order to make the quoting process easier one depending on the past
sales data following table is created for the employees where the employees will select the
material and size of the cloth and the last row will automatically display a relevant quote
value for the product.
SELECT MATERIAL FOR DRESS Silk
SELECT SIZE FOR DRESS XS
QOUTE FOR CUSTOMER 396
Task 4
In this part the manufacturing decision is automated depending on the availability of
certain product with specific material and size as well as its popularity. As the available
resources should be used optimally in order to maximize the profit from the business the
following table is created where the employees will be able to select the availability of the
products as well as the popularity and the automated table will display the decision for the
production of the dress.
SELECT MATERIAL FOR DRESS Silk

6ITECH1100: UNDERSTANDING DIGITAL REVOLUTION
SELECT SIZE FOR DRESS XS
QOUTE FOR CUSTOMER 396
SELECT POPULARITY OF DRESS POPULAR
SELECT AVAILABILITY OF DRESS AVAILABLE
PRODUCTION STATUS
Do Not Start
Manufacturing