Digital Revolution and Data Analysis for Pajama Bonanza - ITECH1100

This assignment focuses on analyzing the sales data of Pajama Bonanza, a custom pajama manufacturer, using Microsoft Excel. The solution includes calculating operational costs, analyzing order frequency and quote values, and visualizing data related to pajama sizes, materials, and manufacturing costs. The student creates a table using Excel functions to estimate quotes for customers, incorporating data validation and the averageifs function. The report assesses the feasibility of the product, analyzes data regarding the business process, and examines material and size data for proper data quotation. The assignment aims to automate business processes and visualize the impact of the automation, ultimately providing insights into the business's performance and potential areas for improvement.

Running head: DIGITAL REVOLUTION FOR SOCK REVIVAL
Digital Revolution for Pajama Bonanja
Name of the Student
Name of the University
Authors note

1DIGITAL REVOLUTION FOR SOCK REVIVAL
Task 1
Pajama Bonaza sales is basically focussed on manufacturing of custom pajamas and
hence wise sell their exclusive products. They have been selling their products with the help
of online store that they have. The staff members that present and have been working on the
projects are namely Audrey, Bernice and Cassandra. Audrey as well as Bernice is responsible
for manufacturing the pajamas. Cassandra on the other hand have been dealing with the
delivery of the orders. These employees have been coordinating in a proper manner which
helps in proper execution of the business. Following table depicts the calculation of
operational cot for business.
Name Days
Day
Cou
nt
Shif
t
hou
rs
Ov
erti
me
Total
Shift
Hour
wag
e/
Hou
r
Wee
klyP
ay
Ann
ual
Cost
Audrey Mondays, Tuesdays 2 6.5 3 16
$
24.0
0
$
384.
00
$19,
968.
00
0
$
-
$
-
Bernice
Wednesdays, Thursdays
and Fridays 3 6.5 19.5
$
24.0
0
$
468.
00
$24,
336.
00
0
$
-
$
-
Cassand
ra
Mondays, Tuesdays,
Wednesdays, Thursdays,
Fridays and Saturdays 6 2.5 3 18
$
32.0
0
$
576.
00
$29,
952.
00
$
-
$
-
Replace
ment
Worker Four Weeks 53.5
$
36.0
0
$
1,92
6.00

2DIGITAL REVOLUTION FOR SOCK REVIVAL
Insuranc
e cost
$18,
000.
00
$18,
000.
00
Annual
Utility
Cost
$
5,52
0.00
Annual
Operatin
g Cost
$99,
702.
00
Task 2
Proper understanding of the data that are available regarding the material of the
products are also important. This is one of the major reasons that proper management of the
manufacturing process will be performed. Another aspect that is to be considered is the size
of the product that is to be manufactured in the process. In case the manufacturing process
performs proper documentation better analysis of the product can be performed. Making
profit have been the major goal of the entire business management process.
Proper calculation of the operational process details is performed in order to proceed
with the business have been one of the major aspects that is to be considered. Proper
calculation of the quoting aspect also plays an important role in the process. Another aspect
that is to be considered is the change that takes place in the over-time duty process. Proper
visualization has been one of the major aspect that is to be considered. This helps in better
understanding of the business process.

3DIGITAL REVOLUTION FOR SOCK REVIVAL
Insights
While trying to find out the insights about the sales of the pajama’s at first the
frequency of the order count is placed against the price range.
Value of the
Quote
Count of Orders
30-100 84
100-170 57
170-240 44
240-310 13
310-380 7
380-450 1
450-520 4
520-590 5
590-660 2
660-730 0
730-800 4
Here, it can be said that the maximum number of pajama’s are ordered with in the price
range of $30-100.

4DIGITAL REVOLUTION FOR SOCK REVIVAL
For the first insight the sum of the quote amount is compared by the different sizes of the
pajamas that are available and booked by the customers from pajama Bonanja.
L M S XL XS XXL
0
2000
4000
6000
8000
10000
12000
3887.7
6139.1
4063.9
7944.2
11008.9
5166.8
Sum of Quote amount by Size
F
rom the above bar graph, it can be said that the maximum of pajamas are ordered with the XS
size that summed upto the quote amount of $11008.9 and minimum amount of orders are
placed for the L sized products that have the total quote amount of $3887.7.
In the next insight, manufacturing cost for pajamas that are made of different
materials are compared.
Cotton Leather Silk Tweed Wool
0
500
1000
1500
2000
2500
3000
3500
4000
4500
1541.2
2111.8
3221.3
641.5
4115
Sum of Manufacturing cost ($) by Material
Here it is clear that, highest amount of manufacturing cost is required for the Wool
made pajamas. On the other hand the minimum amount of manufacturing cost is required for
Tweed made pajamas.

5DIGITAL REVOLUTION FOR SOCK REVIVAL
Finally, the maximum amount of quote compares to the days. The following graph
shows the details.
Mon Tue Wed Thu Fri
8065.8 8323.3
9813.9
7080.9
4848.4
Sum of Quote by Days
Here it can be clearly seen that; on Wednesdays the maximum number of quotes are
placed with the value of $9813.9. On the other hand, minimum amount of quote is placed on
Fridays with the total quote value of $4848.4
Task 3
In order help the employees of the organization and provide a consistent quote for the
pajamas to their customers a table is created using different inbuilt excel functions. This
includes creating a list of variables and naming them, use of data validation in cells and
finally using averageifs control function for determining the estimated quote value. The
created table is depicted below;
Select Material Cotton
Select Size XS

6DIGITAL REVOLUTION FOR SOCK REVIVAL
Quote
Estimmate 54
Task 4
In this process the main aspect that is considered is that the data regarding the
feasibility of the product is analysed. After gaining the data regarding the processing of the
business assessment ensures the understanding the starting point of the project. It has been
seen that proper understanding of quote will be analysed as well. Manufacturing process
initiation will be considered in this section as well. Data regarding material as well as size of
the product is also stated and considered as well for proper quotation of the data.