Understanding the Digital Revolution

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

8 Pages1190 Words467 Views

This document is about understanding the digital revolution and its impact on various aspects of business operations. It includes tasks related to the cost of operating the business, order information, price consistency, and process involvement. The document also provides insights into the distribution of quotes and manufacturing costs over time. The Excel spreadsheet used for calculations and forecasting is also discussed. The bibliography section lists relevant sources for further reading.

Understanding the Digital Revolution

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

ShareRelated Documents
Running head: ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
ITECH1100 Understanding the Digital Revolution
Assignment 1 - Jacket Revival (30362822)
Name of the Student
Name of the University
Author’s Note
1
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
Bibliography...............................................................................................................................7
2
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
E Portfolio Page
Nam
e Working days
Working
hours(in week)
hours( in week)
Total working
hours in week
Arch
ie
Monday, Tuesday
and Wednesday 22.5 3 25.5
Barb
ara Thursday and Friday 15 0 15
Caro
l Every weekday 22.5 3 25.5
Name
No. of Working
days in a week
Working
hours in a
week
working
hours in a
week
Total
working
hours in a
week
Hourly
rates(in
\$)
Annual
cost(in
\$)
Archie 3 22.5 3 25.5 26 34476
Barbara 2 15 0 15 26 20280
Carol 5 22.5 3 25.5 24 31824
Replacem
ent
employee 66 39 10296
Fixed
cost(in \$) 9100
Utility
cost(in \$) 3120
Total
Outgoing
cost (per
annum in
\$) 109096
Simple excel formula is used for calculating the annual cost of the employees based
on the daily working hours spent for the operational activities. The overall cost calculated
using daily hours spent, times of the cost of the employee per hour; this resulted in the cost of
the employee for a single day that was further multiplied with the seven unit for the
calculation of employees’ cost for seven years. Thereafter, for the calculation of one-year

End of preview

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

Related Documents
|7
|1157
|186

|8
|1099
|492

|8
|1167
|187

|9
|1171
|326

|7
|946
|36

|8
|966
|44