logo

Automation of Business Processes for Suit Box

Automate a business process and visualize the impact of the automation using Microsoft Excel.

6 Pages730 Words455 Views
   

Added on  2022-11-13

About This Document

This document discusses the automation of business processes for Suit Box, including operational cost calculation, sales data analysis, quotation process automation, and production decision automation.

Automation of Business Processes for Suit Box

Automate a business process and visualize the impact of the automation using Microsoft Excel.

   Added on 2022-11-13

ShareRelated Documents
Running head: AUTOMATION OF BUSINESS PROCESSES FOR SUIT BOX
Automation of business processes for Suit Box
Name of the Student
Name of the University
Authors note
Automation of Business Processes for Suit Box_1
AUTOMATION OF BUSINESS PROCESSES FOR SUIT BOX
1
Task 0
According to the given information provided the business organization Suite Box runs
its business depending on the three employees which are Agnes, Bhavesh and Celeste. Out of
this three employees of the organization Agnes and Bhavesh are skilled manufacturing staffs
thus they manage the manufacturing of the suits and Celeste manages the ordering process as
well as the delivery of the products to the customers. According to the given data, the
following table is developed that shows the shift hours (day wise and weekly).
SuitBox
Name
Day
Count
Shift
hours
Overtime for Social
Presence
Shift Hour every
Week
Agnes 3 7.5 3 25.5
0
Bhaves
h 2 7.5 15
0
Celeste 6 4.5 3 30
Task 1
In this part, the operational cost for running the business is calculated. In order to do
this, the annual payment to the employees, cost required for the replacement worker (for four
weeks), insurance cost as well as utility cost if considered. The table below shows the
complete calculation for determining the total operational cost.
SuitBox
Name Day Count Shift hours
Overtime for
Social Presence
Shift Hour
every Week
Agnes 3 7.5 3 25.5
0
Bhavesh 2 7.5 15
0
Celeste 6 4.5 3 30
0
Automation of Business Processes for Suit Box_2
AUTOMATION OF BUSINESS PROCESSES FOR SUIT BOX
2
Replacement Worker
for Four Weeks 6 70.5
Name Pay/Hour
Wage
Paid/Week Wage Paid/Year
Agnes
$
26.00
$
663.00
$
34,476.00
$
-
$
-
Bhavesh
$
26.00
$
390.00
$
20,280.00
$
-
$
-
Celeste
$
24.00
$
720.00
$
37,440.00
Total Wage
$
92,196.00
Other Costs
Insurance Cost
$
9,100.00
Utility cost($
260/month)
$
3,120.00
Total
$
12,220.00
Replacement
Worker 10998
Total Operational Cost
$
1,15,414.00
After considering the all the variables required for the operational cost, the annual
cost is summed up to $ 115414.
Task 2
From the previous sales data certain insights are explored which are depicted below;
For the first graph the frequency of ordered suits are compared with the price ranges.
Automation of Business Processes for Suit Box_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Digital Revolution for Garment World
|7
|819
|465

Shirt Zombie: Understanding the Digital Revolution
|7
|895
|371

Automated Solution for Scarf Revival Clothing Manufacturer
|7
|893
|251

Understanding the Digital Revolution for Uniform Basement
|6
|813
|1

Automate a Business Process and Impact of the Automation
|6
|723
|415

Process Automation for Uniform Zombie
|6
|936
|64