logo

Understanding the Digital Revolution

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

8 Pages1190 Words467 Views
   

Added on  2023-04-21

About This Document

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.

   Added on 2023-04-21

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
Understanding the Digital Revolution_1
1
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
Table of Contents
Task 0 – Setting Up....................................................................................................................2
Task 1 – Cost of Operating the Business...................................................................................2
Task 2 – Order Information........................................................................................................3
Task 3 – Price Consistency........................................................................................................5
Task 4 – Process Involvement....................................................................................................5
Bibliography...............................................................................................................................7
Understanding the Digital Revolution_2
2
ITECH1100 UNDERSTANDING THE DIGITAL REVOLUTION
Task 0 – Setting Up
E Portfolio Page
Nam
e Working days
Working
hours(in week)
Additional Working
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
Task 1 – Cost of Operating the Business
Name
No. of Working
days in a week
Working
hours in a
week
Additional
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
Understanding the Digital Revolution_3

End of preview

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

Related Documents
Understanding the Digital Revolution
|7
|1157
|186

Understanding the Digital Revolution
|8
|1099
|492

ITECH1100 Understanding the Digital Revolution Assignment 1 - Hat Frenzy
|8
|1167
|187

Understanding the Digital Revolution
|9
|1171
|326

Understanding Digital Revolution
|7
|946
|36

Automated Solutions for Sock Life Employees using Excel
|8
|966
|44