
Excel Expert Required For Sales, Service & Inventory Management Report
- or -
Post a project like this3571
$$
- Posted:
- Proposals: 7
- Remote
- #1094595
- Awarded
Description
Experience Level: Intermediate
Description of excel work: Im looking for someone to create a management information report using Microsoft excel. I have already made a start on this by creating the data input sheet. I just need someone who can make it look aesthetically pleasing by creating tables, graphs and charts using the information on the data input sheet.
I want to be able to view the following information:
Sales
-Sales by day, week, month, quarter and YTD.
-Showing where the sales have come from at account level
-Product split by different items/SKU's
-Run rate - average sales per day, week or month over a certain time period
Service
-Average turnaround it takes to service a product
-Where was the faulty product sold
-When is the production date
-What action was taken
-What was the outcome
Inventory Management
-How many units in stock per item
-How many sold to date
-Sales rate per day, week, month, quarter, YTD
-Minimum threshold date
-Out of stock date
-Next delivery date
-Out of stock days (surplus/deficit)
Extra notes:
I want to be able to view the following information:
Sales
-Sales by day, week, month, quarter and YTD.
-Showing where the sales have come from at account level
-Product split by different items/SKU's
-Run rate - average sales per day, week or month over a certain time period
Service
-Average turnaround it takes to service a product
-Where was the faulty product sold
-When is the production date
-What action was taken
-What was the outcome
Inventory Management
-How many units in stock per item
-How many sold to date
-Sales rate per day, week, month, quarter, YTD
-Minimum threshold date
-Out of stock date
-Next delivery date
-Out of stock days (surplus/deficit)
Extra notes:
Fran V.
98% (44)Projects Completed
46
Freelancers worked with
31
Projects awarded
30%
Last project
19 Nov 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies