ITECH1100 Assignment: Digital Revolution Impact on Suite Central

This assignment analyzes the impact of the digital revolution on Suite Central, a custom suit manufacturer. The project involves calculating operating costs, analyzing profit margins by staff and material type, and visualizing data using charts. The student uses Excel to automate the quotation process, considering material, size, and stock availability. Furthermore, the assignment proposes an automated decision-making process for manufacturing based on suit popularity and stock status. The goal is to optimize business processes and enhance revenue by leveraging digital tools and data analysis. The student also includes an ePortfolio page for describing the work.

Running head: DIGITAL REVOLUTION FOR SUITE CENTRAL
Digital Revolution for Suite Central
Name of the Student
Name of the University
Authors note

1DIGITAL REVOLUTION FOR SUITE CENTRAL
Task 1
Suit Central operates in the clothing business as well manufacturing of the cloths. The
organization specializes in creating and delivering custom made one-of-a-kind suits for their
customers. In order to calculate the total operating, cost the following factors and payables
are calculated payable to the Augusta and Belle who work together in order to manufacture
the custom made suits, as well as to Chris who manages orders and delivery. In addition to
that, as provided, every staff is entitled with four weeks paid leave for which the organization
will require a casual replacement worker at the rate of $39 per hour. Along with this, the
utility cost, insurance and payable to the replacement worker for four weeks is also
calculated.
Suit
Central
Staff Day/
Hou
rs/
Day
Working
Hours
Extr
a
Hou
rs
Total
Working
hours
Pay
rate
Pay/
Week Pay/Year
Augusta
Mondays,
Tuesdays
and
Wednesda
ys 7.5 22.5 3 25.5
$
26.0
0
$
663.00 $ 34,476
Belle
Thursdays
and
Fridays 7.5 15 0 15
$
26.0
0
$
390.00 $ 20,280
Chris
Every
weekday 4.5 22.5 3 25.5
$
24.0
0
$
612.00 $ 31,824
Utility
Cost(At
$260 every
month) $ 3,120
Cost for
Replaceme
nt Worker 60 6 66
$
39.0
0
$2,574
.00 $ 10,296
Insurance
Cost $ 9,100

2DIGITAL REVOLUTION FOR SUITE CENTRAL
Total $109,096
Including all the payables the total operating cost is summed up to $109,096.
Task 2
For investigating the order information provided in the given past sales data, at first
the profit is measured by subtracting the manufacturing cost from the quote value. At first the
average profit from each staff at the organization is measured and calculated. Plotting the
average profit on the bar chart, the following chart is generated.
Augusta and Chris
Belle and Chris
0 20 40 60 80 100 120 140 160 180
Average of Profit by Staff
Total
Average Profit
Staff
From the above chart, it is clear that Augusta and Chris have generated provided
better average profit compared to the Belle and Chris.
In the next chart the profit from different materials used for the suit is calculated.

3DIGITAL REVOLUTION FOR SUITE CENTRAL
Cotton Leather Silk Tweed Wool
0
2000
4000
6000
8000
10000
12000
14000
2389.3
4867.4
12512.4
1515
6938.9
Sum of Profi t by Material
From the above chart, it is evident that maximum profit is gained from thee Silk based
suits.
The following chart depicts the sum of Quote amount by the three staffs of the
organization. From the representation of the bar chart, it can be stated that Augusta quoted
three times more than the total quote amount of Belle and Chris.
Augusta and Chris
Belle and Chris
0 5000 10000 15000 20000 25000 30000
Sum of Quote amount by Staff

4DIGITAL REVOLUTION FOR SUITE CENTRAL
Task 3
As there are five distinctive kind of materials and six unique sizes for the clients to
choose from for their custom suits; in this way, it makes the quotation process an tedious job
for the staff of the Suite Central in quoting a value for every custom made order while
keeping mind the profit of the association over the cost of the manufactured item.

5DIGITAL REVOLUTION FOR SUITE CENTRAL
Material Wool
Size S
Quote for
Suite 128
As shown in the above table from cells beside the Material and Size the staff of Suite
central will be able to select the mentioned attributes and finally the Cell aside of the blue
marked cell “Quote for Suite” will provide an automated quote.
Task 4
As a small company with the in house manufacturing unit the Suit Central should be
specific to begin the manufacturing of the Suits. it must think about the prominence of the
ordered suit and in addition the stock availability of the item. By making the manufacturing
process decision automated that relies on the prominence and ordered suit can be utilized in
an enhanced way so that the regardless of whether the manufactured product is not picked by
the concerned client along these lines being a popular item the item can be sold to another
client while enhancing the business revenue.
Material Wool
Size S
Quote for Suite 128
Select
Popularity Unpopular suite
Select Stock
Status Not in Stock
Decision do not start manufacturing of Suite

6DIGITAL REVOLUTION FOR SUITE CENTRAL
Bibliography
Hartmann, B., King, W. P., & Narayanan, S. (2015). Digital manufacturing: The revolution
will be virtualized. McKinsey Quarterly, Aug.
Helbing, D. (2019). Societal, economic, ethical and legal challenges of the digital revolution:
from big data to deep learning, artificial intelligence, and manipulative technologies.
In Towards Digital Enlightenment (pp. 47-72). Springer, Cham.
Lamberton, C. P., & Stephen, A. T. (2015). Taking stock of the digital revolution: A critical
analysis and agenda for digital, social media, and mobile marketing research.
Zysman, J., & Kenney, M. (2018). The next phase in the digital revolution: Platforms,
automation, growth, and employment. Communications of the Association of
Computing Machinery.