Scarf World: Digital Revolution Analysis and Automation Project

This assignment focuses on analyzing the digital revolution within Scarf World, a clothing manufacturer specializing in custom scarfs and selling exclusively through an online store. The analysis includes calculating operational costs, examining price quotations, and order data to identify trends. The assignment also explores automating the quotation process by allowing customers to select materials and sizes, providing instant price quotes and estimated manufacturing costs. Furthermore, it investigates the implementation of a system to check product popularity and stock availability, optimizing resource allocation and production decisions. The student utilizes Excel to complete these tasks, demonstrating skills in business process automation and data visualization. The provided solution offers insights into the financial aspects, order patterns, and potential for automation within the business.

Running head: DIGITAL REVOLUTION FOR SCARF WORLD
Digital revolution for Scarf World
Name of the Student
Name of the university
Authors note

1DIGITAL REVOLUTION FOR SCARF WORLD
Task 0
Scarf World, which is a small organization, is involved in clothing manufacturer and
specializing in designing custom, one-of-a-kind scarfs. They exclusively sell their product through
their online store. This online exclusive store sells majority of its products through online stores.
Three employees Amy, Barry, and Carl manage this organisation. While Amy and Barry manage
manufacturing of scarfs, Carl manages order, sales and delivery. Following table shows the details of
their shift;
N
ame Shift Days
Shi
ft Hours
Tot
al Hours
Ex
tra time
Total
work Hour
A
my
Mondays,
Tuesdays and
Wednesdays 7.5
22.
5 3 25.5
B
arry
Thursdays and
Fridays 7.5
22.
5 22.5
C
arl
Every
weekday(Monday to
Saturday) 4.5 27 3 30
Task 1
To calculate complete operational cost, information regarding payable for worker
replacement, cost for utility, and cost for insurance and payable to three permanent employees are
considered. In doing these calculations, six working days has been considered which is standard in the
industry.
The following table provides details about all the operational costs that is considered in this
calculation that the organization has invested.

2DIGITAL REVOLUTION FOR SCARF WORLD
Na
me
Shift
Days
S
hift
Hours
T
otal
Hours
E
xtra
time
T
otal
work
Hour
P
ay
every
hour
A
nnual
Cost
Am
y
Monday
s, Tuesdays and
Wednesdays
7
.5
2
2.5 3
2
5.5
$
26.00
$
34,476.
00
Bar
ry
Thursda
ys and Fridays
7
.5
2
2.5
2
2.5
$
26.00
$
30,420.
00
Car
l
Every
weekday(Mond
ay to Saturday)
4
.5
2
7 3
3
0
$
24.00
$
37,440.
00
Rep
lacement
cost
7
8
$
39.00
$
12,168.
00
Ins
urance
Cost
$
9,100.0
0
Util
ity cost $

3DIGITAL REVOLUTION FOR SCARF WORLD
3,120.0
0
Tot
al
Operation
al Cost
$1,26,7
24.00
From the above table, it can be stated that the total cost of operation is $1,26,724.00
Task 2
In this context, analysis has been made about price quotation and order received. Different
quotation range has been considered and number of orders received are mapped with that quotation
range.
Count of Quotes
51
44
25
5 2 2 5 6 2 3
Chart Title
100-170 170-240 240-310 310-380 380-450 450-520
520-590 590-660 660-730 730-800 Series11
The above chart shows that maximum orders received with quotation range of 100-170 and
total 51 orders received in this quotation range. Next significant order made was in quotation range of
170 to 240 and number of orders received was 44. 25 orders received in the quotation range of 240-
310. 5 orders received in the quotation range of 310-380. 2 orders received in the quotation range of
380-450. 2 orders received in the quotation range of 450-520. 5 orders received in the quotation range

4DIGITAL REVOLUTION FOR SCARF WORLD
of 520-590. 6 orders received in the quotation range of 590-660. 2 orders received in the quotation
range of 660-730 and 3 orders received in the quotation range of 730-800. So quotation range of 380-
450, 450-520 and 660-730 have lowest number of order and that is 2.
L M S XL XS XXL
0
500
1000
1500
2000
2500
1873.9
2408
1224.1
2035.7
2376.6
1692.9
Sum of Manufacturing cost ($) by Size
The above chart describes that manufacturing cost of medium size scarf is highest with
$2408, and next highest manufacturing cost is for extra short (XS) with $2376. Lowest manufacturing
cost is for small size scarf with $1224.1.
Jun Jul Aug Sep Oct
4558.7
5185
6780.3
8684
3482
Sum of Profi t by Month
The above figure shows analysis of total profit with per month analysis. It is seen that per
month profit has continuously increased from June to September and then started decreasing.

5DIGITAL REVOLUTION FOR SCARF WORLD
Task 3
In order to automate the quotation process scarf world has option to select material for scarf
and chose size of scarf as well. This provides quotation price for consumer and provides estimated
cost for manufacturing.
CHOOSE MATERIAL
Woo
l
CHOOSE SIZE L
QUOTE PRICE FOR CUSTOMER 142
ESTIMATED MANUFACTURING
COST 62
Task 4
In order to help scarf world to optimize their resource and reduces chances for loss in the
market, scarf world have option to check automatically if a product based on its popularity is available
or not. Now based on this information, they are able to decide whether to start or not, thus optimizing
resources and increasing chance of profit as well.
CHOOSE MATERIAL Wool
CHOOSE SIZE L
QUOTE PRICE FOR 142

6DIGITAL REVOLUTION FOR SCARF WORLD
CUSTOMER
ESTIMATED
MANUFACTURING COST 62
CHOOSE POPULARITY
POPULA
R
SELECT AVAILABILITY
NOT IN
STOCK
PRODUCTION DECISION START