Understanding Digital Revolution for Suite Scene: ITECH1100

This assignment solution for ITECH1100 focuses on automating business processes for a custom suit manufacturer, Suite Scene, using Microsoft Excel. The solution begins with setting up an ePortfolio and calculating employee wages, including paid leave, replacement worker costs, and utility expenses. It then analyzes past sales data, generating charts to visualize profit distribution by employee, material, and size, identifying key insights such as the profitability of silk and XL size suits. The core of the solution involves automating the quotation process using the "averageifs" formula, enabling faster and more consistent price quotes based on past sales data. Furthermore, the solution extends this automation to production decisions, incorporating material popularity and inventory availability to provide employees with clear production guidelines. The assignment demonstrates the application of Excel for data analysis, process automation, and informed decision-making within a business context.

Running head: UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Understanding Digital revolution for Suite Scene
Name of the Student
Name of the University
Authors note

1UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Task 0
For Suite scene, being the manufacturer of the custom made suits according to the
requirements of the customer, it is important to manage their resources so that they can
improve their revenue from the business. The business manages their business with the help
of their three employees Arthur, Bethany, and Cynthia. Out of this employees, Arthur and
Bethany are skilled staff who handles the manufacturing department with the hourly payable
of $26. On the counterpart, Cynthia is a part time employee and works at the hourly payable
of $24.
Following is the table that shows different details of the employees, their shift hours
and payable.
Na
me
of
the
Staf
f
Worki
ng
Days
Wee
kly
work
ing
days
Work
ing
time
(in
hours
)
Total
worki
ng
hours
weekly
Extra
Hours
workin
g every
week
Total
Workin
g hours
every
week
Total
worki
ng
hours
yearly
Arth
ur
Monday
,Tuesda
y and
Wednes
day 3 7.5 22.5 3 25.5 1326
Beth
any
Thursda
y,
Friday 2 7.5 15 0 15 780
Cynt
hia.
Monday
to
Friday 5 4.5 22.5 3 25.5 1326

2UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Task 1
According to the available information, all three employees are entitled for the yearly
four weeks of paid leave. In this four week the organizations manage their business with a
replacement worker. This replacement worker is hired at the rate of $39 per hour. For the
calculation of the wages, 5 standard working days are considered. In addition to that,
insurance cost and the annual utility cost is also considered.
Staff
Days’
work
on
Wee
kly
work
ing
days
Work
ing
time
(in
hours
)
Total
workin
g
hours
weekly
Extra
Hours
working
every
week
Total
Workin
g hours
every
week
C
os
t/
ho
ur
wee
kly
pay
eble
yea
rly
pay
abl
e
Arthur
Monday
,Tuesda
y and
Wednes
day 3 7.5 22.5 3 25.5
$
26
.0
0
$
663.
00
$
34,
476
.00
Bethany
Thursda
y,
Friday 2 7.5 15 0 15
$
26
.0
0
$
390.
00
$
20,
280
.00
Cynthia
Monday
to
Friday 5 4.5 22.5 3 25.5
$
24
.0
0
$
612.
00
$
31,
824
.00
Insurance
and rent
Payable
$
9,1
00.
00
Replaceme
nt worker
Payable for
Four
Weeks 60 6 66
$
39
.0
0
$
2,57
4.00
$
10,
296
.00
Monthly
Utility cost 260
$
3,1
20.
00

3UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Annual
Operating
cost
$
1,0
9,0
96.
00
From the above table the total operating cost is calculated and the value is summed
up to, $1,09,096. This includes the payable to the replacement worker for four weeks.
Task 2
From the analysis of the past sales data the following charts are generated. Different
insights are depicted from the following charts.
Arthur and Cynthia
71%
Bethany and Cynthia
29%
Sum of Profi t by Employees
Arthur and Cynthia
Bethany and Cynthia
From the above cart it can be stated that maximum profit is generated by the
employees Arthur and Cynthia (71% of the total profit). As Cynthia works on every weekday
thus we coupled the employees who work on a certain weekday.
The following chart depicts the share of profit contributed by the different
manufacturing materials.

4UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Cotton
Leather
Silk
Tweed
Wool
0 2000 4000 6000 8000 10000 12000
2881.6
6801.9
10035.2
1578.1
5536.8
Sum of Profi t by Material
Total
Sum of profit
Material
The above chart shows that; the maximum profit is generated by the products made
with silk with the profit value $10035.2.
Finally, for the products with the size XL and made of silk has generated maximum
profit as recorded in the past sales data.
Leather
Wool
Leather
Tweed
Cotton
Silk
Wool
Leather
Tweed
Cotton
Silk
Wool
Leather
Tweed
L M S XL XS XXL
0 500 1000 1500 2000 2500 3000
385.1 885.4 2133.5
799
729.4
839.8
1136.8
494 1312.7
448.8 1089.2
1047.2
140.1 666.9
194 1031.4 2596
369.4 947.3
664.8 2141.2
1386.3
479
708.8
459.5814.9 1735.4
95.6 1102.1
Sum of Profi t by Size
Total

5UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Task 3
As the products are manufactured according to the requests of the customers thus in
order to use the available resources in an optimized while improving the revenue from the
business. Therefore, depending on the past sales data the quotation process is automated. In
order to automate this process, the “averageifs” formula is used so that the quoted value can
be consistent with the provided past sales data. Following is the table that can be used by the
employees in order to get a faster quote depending on the past sales.
Select Material for suite Cotton
Select Size for Suite S
Estimated Quote Price 73
Task 4
In the next part the production decision is automated depending on the selection of the
popularity and stock availability of a specific kind of suite. Therefore, extending the
previously created table, two new rows are added for the employees as shown in the
following tables provided in the accompanied excel sheet.

6UNDERSTANDING DIGITAL REVOLUTION FOR SUITE SCENE
Select Material for suite Wool
Select Size for Suite XS
Estimated Quote Price 100
Select Popularity Not-Popular
Select Availability
Not-Available in
inventory
Decision on production DO NOT START
From the above table the, the employees will be able to get the decision for the
production of a specific order according to the requested size and availability in the
inventory.