Analyzing Digital Revolution in Garment Land - ITECH1100 Assignment 1

This assignment focuses on analyzing the business processes of Garment Land, a cloth manufacturing company, to identify areas for automation and improvement through the application of digital tools. The student utilizes Microsoft Excel to perform cost analysis, including calculating employee wages, fixed costs, and utility expenses. The assignment involves creating tables to record working hours, rates, and annual costs, providing a comprehensive overview of the company's financial operations. Furthermore, the student analyzes order information by generating graphs and pivot tables to identify quotation variations and manufacturing costs. A key aspect of the assignment is the development of a business process model (BPMN diagram) to automate quotation processes and ensure price consistency. The student also incorporates process improvements by adding new fields and drop-down lists to enhance the usability of the information system, making it easier for staff to select materials, sizes, and manage stock. The final outcome provides insights into how digital tools can streamline operations, improve employee productivity, and support organizational growth within Garment Land.

Running head: DIGITAL REVOLUTION
Assignment 1 – Garment Land
Name of the Student
Name of the University
Author’s Note

1
DIGITAL REVOLUTION
Task 0 – Setting Up
An analysis is made on the business process of Garment land which has the specialization
on manufacturing cloths and creating custom garments. Problems in the current business process
are evaluated for automating some of the business operation and reducing the manual steps that
are needed to be taken for performing different business operation. The fixed cost and the wages
of the staffs are recorded and the working hours and shift timing are recorded for development of
the solution to the problem of the organization. There are three team members Alexa, Briony and
Celia working for different schedule in the week. The working hours and the working days and
the fixed cost are recorded for the calculation of the cost of operating the business. A table is
created for recording the details and given below:
Name Working days
Workin
g
hours(i
n week)
Addition
al
Working
hours( in
week)
Total
Workin
g hours
(in
week)
Alexa Monday, Tuesday and
Wednesday 22.5 3 25.5
Briony Thursday and Friday 15 0 15
Celia Every weekday 22.5 3 25.5
Task 1 – Cost of Operating the Business
A table is created for calculating the wages for each of the staffs working with Garment
Land with the application of formulas and given below:

2
DIGITAL REVOLUTION
Name Working days Worki
ng
hours(
in
week)
Additio
nal
Workin
g
hours( i
n week)
Total
Worki
ng
hours
(in
week)
Rate
per
hour
($)
Annu
al
Cost
($)
Alexa Monday, Tuesday and
Wednesday
22.5 3 25.5 26 34476
Briony Thursday and Friday 15 0 15 26 20280
Celia Every weekday 22.5 3 25.5 24 31824
Replacement 66 39 10296
Annual Fixed
cost(in $)
9100
Annual Utility
cost(in $)
3120
Annual Total
Outgoing cost(in $)
109096
Thus from the above table it has been found that the cost of operation for Garment Land is $
109096

3
DIGITAL REVOLUTION
Task 2 – Order Information
For getting the details of the order information a graph is generated from the excel sheet
where new tables are added from pivot table for identification of quotation variation based on
time and identification of the manufacturing cost.
2018-06-04 2018-06-20 2018-07-09 2018-07-25 2018-08-09 2018-08-31 2018-09-17 2018-10-01
0
100
200
300
400
500
600
700
800
900
Quote amount
2018-06-04 2018-06-20 2018-07-09 2018-07-25 2018-08-09 2018-08-31 2018-09-17 2018-10-01
0
20
40
60
80
100
120
140
160
180
Manufacturing cost ($)
The category of materials are combined are analysed for finding the quote variation and
this is calculated with the calculation of standard deviation for the quotes. The standard deviation

4
DIGITAL REVOLUTION
is calculated with the help of pivot table and the following graph is shown for the demonstration
of standard deviation.
CottonL
CottonS
CottonXS
LeatherL
LeatherS
LeatherXS
SilkL
SilkS
SilkXS
TweedL
TweedS
TweedXXL
WoolM
WoolXL
WoolXXL
0
100
200
300
400
500
600
StdDev of Quote amount Count of Quote amount Average of Quote amount
The maximum variation is found for the silk xl garment type for the quotation given at
the end of three staffs. The average of quote amount is highest for the silk XXL type of garment
but the standard deviation of quote amount is less for it.
Task 3 – Price Consistency
The consistency of price is maintained for the ingle item manufactured by Garment Land
company and for this a linearity is needed to be maintained for creation of quotation based on
materials and the sizes. The business process model is created such that quotation that is needed
to be made by the staffs is automated. The development of the BPMN diagram helps in
identification of the requirement for development of the system and develop the information
system aligning the business needs for the elimination of the errors in the system. The
information system should be developed such that the organizational growth can be improved
and boost the productivity of the employees and support the growth of the organization.

5
DIGITAL REVOLUTION
The diagram describes that the staff working with the organization should be able to
select the material and its size based on the customer needs and the system should find the details
from the data inserted for displaying the result. The historical data is used and the average
quotation for the selected category is calculated for displaying the result.
Result:

6
DIGITAL REVOLUTION
Task 4 – Process Involvement
The business process can be improved with the addition of multiple fields and improve
the usability of the information system. The addition of new column depending on the result that
is need to be obtained from the information system helps in eliminating the errors. A drop down
list is used for reducing the effort of the user and reducing the risk of wrong entry in the database
for checking available items in the stock and finding the items that should be manufactured. The
popularity of the material can also be found from the count of quote amount and if the value is
less than 10 the item is displayed as unpopular or else popular.
Result:
To be used by Staffs
Material Size
Quote
Acceptance
Cotton S Accepted
Automatic Displays to Staffs
Popularit
y
Quote Amount
($) Stock Status Manufacture Item
Popular 84.061111 In stock
Do not Start
Manufacture

7
DIGITAL REVOLUTION
Bibliography
Bjola, Corneliu, and Marcus Holmes. Digital diplomacy: Theory and practice. Routledge, 2015.
Grech, V., 2018. WASP (Write a Scientific Paper) using Excel–12: Odds ratio and relative
risk. Early human development, 122, pp.58-59.
Locock, Andrew J., and Roger H. Mitchell. "Perovskite classification: An Excel spreadsheet to
determine and depict end-member proportions for the perovskite-and vapnikite-subgroups of the
perovskite supergroup." Computers & geosciences 113 (2018): 106-114.
Roose, Joachim. "Development of an Excel based calculation tool to assess the hydraulic
performance of rubble mound breakwaters and vertical seawalls." (2016).
Ryan, Damian. Understanding digital marketing: marketing strategies for engaging the digital
generation. Kogan Page Publishers, 2016.
Schön, Jürgen H. "Model Equations and Excel Worksheets." In Developments in Petroleum
Science, vol. 65, pp. 437-444. Elsevier, 2015.
Steen, John, Sam Macaulay, Nadja Kunz, and John Jackson. "Understanding the Innovation
Ecosystem in Mining and What the Digital Revolution Means for It." Extracting Innovations:
Mining, Energy, and Technological Change in the Digital Age.(CRC Press, New York,
2018) (2018).