Find Jobs
Hire Freelancers

Develop employee workload analysis excel template

$250-750 USD

Ditutup
Dibuat sekitar 7 tahun yang lalu

$250-750 USD

Dibayar ketika dikirim
I am on the lookout for excel expert to help me with design of workload analysis excel template. I need to analyze work to produce man hour calculations for each job role in the organization. For example in call centers this would be the number of man hours required per call, or for the police this is separated into fixed and variable duties, such as the number of officers per incident per hour. I need to assess historical data to produce trends, averages and extreme situations. This work is very dependent upon the type of operation involved. In a call center this will be the call rate, done in half hour or quarter hour segments. For a hospital this could be the number of patients admitted per day. For a factory this would be the number of orders per day. For distribution of products this could be orders and quantity per hour. Essentially the final product should have three worksheets. The first worksheet will capture all key assumptions such as work days in any given year and productivity rate. Second worksheet will be a table that will have level 3 process activities in the first column and rows will contain job roles. Managers are expected to populate estimated workload, as well as define activities in accordance to frequency, complexity of work, KPIs etc. The third worksheet will contain dashboard with all the analysis including but not limited to required FTEs, analysis of activities, etc
ID Proyek: 12738994

Tentang proyek

23 proposal
Proyek remot
Aktif 7 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan

Tentang klien

Bendera UNITED ARAB EMIRATES
Abu Dhabi, United Arab Emirates
0,0
0
Memverifikasi Metode pembayaran
Anggota sejak Jan 10, 2017

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.