ITECH1100 Assignment 1: Shirt Scene Process Improvement Project

This project analyzes the business operations of "Shirt Scene," a custom shirt manufacturer, to improve its processes using Excel. The assignment begins by setting up the business context, including employee roles, work schedules, and operational costs. It then delves into order information, visualizing price ranges and profit margins by material type and employee contribution. The core of the project involves automating the quotation process and integrating inventory and production status to inform decision-making. The student uses tools like "AVERAGEIFS" to create price consistency and improve the overall efficiency of the business operations. The project highlights the impact of process automation and the digital revolution on business functions, data analysis, and IT solutions.

Running head: PROCESS AUTOMATION AND DIGITAL REVOLUTION
Process improvement and Digital Revolution
Name of the Student
Name of the University
Authors note

1PROCESS AUTOMATION AND DIGITAL REVOLUTION
Task 0- Setting up
Shirt Scene manufactures custom made shirts according to the orders placed by the
customers with different size and materials. The business is running by three employees
namely Abraham, Benedict, and Chris where Abraham, Benedict are responsible for
manufacturing and Chris is responsible for sales and delivery of the ordered shirts. Following
are the team timings for the employees for the standard 5 working days.
Shift Days
Co
unt
Hours/
Day
Shift
Hours/wee
k
Extra
Hours/Wee
k
Total
Time
Abra
ham
Mondays, Tuesdays and
Wednesdays 3 .7.5 22.5 3 25.5
Bened
ict Thursdays and Fridays 2 7.5 15 0 15
Chris every weekday 5 4.5 22.5 3 25.5
Task 1- Costs of operating the business
In order to get the total operational cost for Shirt Scene, it is important to include all
the costs and payable for the business such as utility, insurance cost as well as payable to the
permanent and part time employees of the organization.
In order to find out the cost the above table is extended which is presented below;

2PROCESS AUTOMATION AND DIGITAL REVOLUTION
Shift Days
C
ou
nt
Hou
rs/
Day
Shift
Hours/
week
Extra
Hours/
Week
Tota
l
Tim
e
Pay
Rat
e
Wee
kly
Pay
Year
ly
Pay
Abraha
m
Mondays,
Tuesdays and
Wednesdays 3 7.5 22.5 3 25.5
$
26.
00
$
663.
00
$
34,47
6.00
Benedic
t
Thursdays and
Fridays 2 7.5 15 0 15
$
26.
00
$
390.
00
$
20,28
0.00
Chris every weekday 5 4.5 22.5 3 25.5
$
24.
00
$
612.
00
$
31,82
4.00
$
-
$
-
Utility
Cost 260/Month
$
3,120
.00
Insuranc
e Cost
$
9,100
.00
Replace
ment
Worker 66
$
39.
00
$
2,57
4.00
$
10,29
6.00
Total
Operatin
g Cost
$1,09
,096.
00
From the above table it can be said that, including all the employee payable, insurance cost
and other costs the total is summed up to $1,09,096.
Task 2- Order information
As shirt scene, provides products in different ranges of prices thus charts are prepared
to find out which price segment is most popular.

3PROCESS AUTOMATION AND DIGITAL REVOLUTION
68
50 50
23
4 3 4 5 1 0 3
30-100 100-170 170-240 240-310 310-380 380-450
450-520 520-590 590-660 660-730 730-800
Price ranges
Count
From the above chart, it can be stated that maximum amount of quotes is made for the
shirts priced between the range $30-100. The number of quotes are 68. Again in the price
range $660-730 there is no quoted product.
In the next section, the sum of profit is compared by the material.
Cotton Leather Silk Tweed Wool
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
10000
2820.4
7201
9668.8
2103
4957.8
Sum of Profi t by Material
From the above chart, it is clear that the maximum amount of profit is generated by
the products made of silk. The lowest amount of profit is generated from the material Tweed.
In the next part, the contribution by different employees is compared.

4PROCESS AUTOMATION AND DIGITAL REVOLUTION
Abraham and Chris
65%
Benedict and Chris
35%
Count of Profi t by Employee
Abraham and Chris
Benedict and Chris
Here, it can be stated that 65% of the profit is generated by Abraham and Chris. On
the other hand, only 35% of the profit is generated by Benedict and Chris. s
Task 3- Price consistency
In order to quote prices consistent with the past sales records the following table is
created using “AVERAGEIFS.” Depending on the previous sales record and revenue the
quotation is made.
CHOSE MATERIAL FOR
ORDER Cotton
CHOSE SIZE FOR THE ORDER M
ESTMATED MINIMUM
QUOTE 75

5PROCESS AUTOMATION AND DIGITAL REVOLUTION
Task 4- Process improvement
In order to make the quotation process and manufacturing decision making process
automated the above table is extended. Where, the popularity and availability of stock is
considered to generate the decision.
CHOSE MATERIAL FOR
ORDER Cotton
CHOSE SIZE FOR THE ORDER M
ESTMATED MINIMUM
QUOTE 75
POPULARITY STATUS Not -Popular
INVENTORY STATUS Not Available
PRODUCTION STATUS
DO NOT
START