ITECH1100 - Suit Oasis: Automating Processes and Impact Analysis

This report details the automation of business processes at Suit Oasis, an online custom suit retailer. It identifies key staff roles (Alfred, Bernice, Cassandra), their responsibilities, and associated operational costs. The report analyzes profit generation by employees and material types to identify trends, such as silk jackets in XL size being the most profitable. The core of the automation involves creating Excel-based tools to streamline the quote process, ensuring profitability based on historical data. The automated table enables efficient quoting for different sizes and materials. Further enhancement includes automating manufacturing decisions based on product popularity and stock availability, optimizing resource allocation and minimizing losses from uncollected orders. This study showcases how automation can improve efficiency and decision-making in a small business context. Desklib provides access to similar solved assignments for students.

Running head: AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Automate a business process and impact of the automation
Name of the Student
Name of the University
Authors note

1AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Task 1
Suit Oasis makes custom made Suits and they this product exclusively through their
online store. For this they have three staffs who work on different shifts and manages
different departments. The staffs are Alfred, Bernice, and Cassandra where Alfred and
Bernice are responsible for manufacturing the suits and the Cassandra manages the orders
and delivery of the products. Along with three employees the organization has to pay for
replacement casual worker, utility cost and Insurance.
Following table depicts the total cost for operating the business.
Suit
Oasis
Staff Day
Day
Coun
t
Shift
Hours/
Day
Total
Shift
Hour
s
Extra
Hours
Social
Presence
Total
Worki
ng
hoursr
Pay
(skille
d/part-
time)
We
ekl
y
Cos
t
An
nua
l
Cos
t
Alfred
Mond
ays,
Tuesd
ays
and
Wedn
esdays 3 7.5 22.5 3 25.5
$
26.00
$
663
.00
$
34,
476
Bernic
e
Thurs
days
and
Friday
s 2 7.5 15 0 15
$
26.00
$
390
.00
$
20,
280
Cassa
ndra
Every
weekd
ay 5 4.5 22.5 3 25.5
$
24.00
$
612
.00
$
31,
824
Utility
Cost
$260
every
month
$
260.00
$
3,1
20.
00
Repla
cemen
t
Work
er 66
$
39.00
$2,
574
.00
$
10,
296
.00

2AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Insura
nce
Cost
$
9,1
00.
00
Total
Operati
ng Cost
$
109
,09
6
Task 2
Following chart depicts the sum of profit generated by the employees with respect to
their working days.
Mon
Tue
Wed
Thu
Fri
Bernice and Cassandra
0 1000 2000 3000 4000 5000 6000 7000 8000
Sum of Profit by Suit Oasis Staff
From the above chart it is evident that, Alfred and Cassandra generated maximum
profit on Monday and Bernice and Cassandra generated maximum profit on Thursday.
The following chart depicts the profit by the material of the suits quoted by the
employees.

3AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Cotton
Leather
Silk
Tweed
Wool
Cotton
Leather
Silk
Tweed
Wool
Bernice and Cassandra
0 2000 4000 6000 8000 10000 12000
Sum of Quote amount by Suit Oasis Staff
From the above chart, it can be stated that jackets made of the Silk helped the
organization t get maximum revenue compared to the other materials.
L M S XL XS XXL
0
1000
2000
3000
4000
5000
6000
Sum of Profit by Size
The above chart depicts the maximum amount of profit is gained from the products
which are ordered with Excel size. Therefore, from here it can be stated that the most popular
jacket is with Xl size and of Silk material.

4AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Task 3
With the objective of making the quote process more efficient and easy for the staff
the following table is provided. Use of this table will help the staffs to quote a precise quote
for a specific size and material combination while maintain the profit for that product
according to the last business data about the manufacturing cost of the ordered product.
Choose Material for Suit Cotton
Choose Size of Suit M
Quote for this order 76
Task 4
The table created in task 3 is enhanced in order make the manufacturing decision
making automated relying upon past data. the past data will be helpful for finding the
popularity of a specific product and material. This can help in use of resources in an
optimized manner so that in case of a ordered product is not collected by the related
customer but being a popular jacket the it can be can be sold to another customer .
Choose Material for Suit Cotton
Choose Size of Suit M
Quote for this order 76
Choose Popularity unpopular

5AUTOMATE A BUSINESS PROCESS AND IMPACT OF THE AUTOMATION
Choose Availabilty of Product in Stock not in stock
Manufacturing status Do not Start manufacturing