Variance Analysis - Volume, Price & Mix
- or -
Post a project like this£350(approx. $435)
- Posted:
- Proposals: 24
- Remote
- #2439640
- OPPORTUNITY
- PRE-FUNDED
- Expired
Wordpress developer, Graphic designer, Web developer, App developer, Blog Writer translator
Doha
MS Excel & Word, Transcription, PDF Conversion, Editing, Filable PDF Form, Data Entry
Nashik
247858528905692851877284470527914212787127278298827453222645255262135226113002522480
Description
Experience Level: Expert
Invoice line item data at customer and product level, contains quantity, revenue, cost and profit per item.
Requirement -
To analyse data sets across 2 date ranges at this detailed level to determine variance between total profit for the 2 time periods.
Analysing
- Volume variance
- Price variance
- Mix variance - this is the impact of selling a different mix of products or customers in the different periods.
Output
- Clear understanding of why margin is lower or higher
- Have we sold more to lower margin customers - impact of this?
- Have we sold more lower margin products - impact of this
- Have we sold more generally?
- Have we sold for a lower price?
- Has our product cost of sales gone up or down?
Deliverable
- I will provide a sanitised data set at the same level as my actual data
- I would like an example set of formulas delivered so I can create own internal model either in Excel or using SQL in our BI reporting tool.
- I don't want a highly complex spreadsheet/macro driven model that we can't maintain or understand/explain.
Requirement -
To analyse data sets across 2 date ranges at this detailed level to determine variance between total profit for the 2 time periods.
Analysing
- Volume variance
- Price variance
- Mix variance - this is the impact of selling a different mix of products or customers in the different periods.
Output
- Clear understanding of why margin is lower or higher
- Have we sold more to lower margin customers - impact of this?
- Have we sold more lower margin products - impact of this
- Have we sold more generally?
- Have we sold for a lower price?
- Has our product cost of sales gone up or down?
Deliverable
- I will provide a sanitised data set at the same level as my actual data
- I would like an example set of formulas delivered so I can create own internal model either in Excel or using SQL in our BI reporting tool.
- I don't want a highly complex spreadsheet/macro driven model that we can't maintain or understand/explain.
Ed Y.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
14%
Last project
19 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Ed, this project has been published 3 weeks ago and it seems that it hasn't yet been awarded to anyone. Have you already hired someone for the job somewhere else? If the project hasn't yet been cancelled nor awarded, are you still interested in receiving a new proposal for it? I would like to know because if you are still accepting proposal, I will send you one.
-
Hi Ed, is is possible to view a sample of the data? Many thanks
-
Ed, what is the deadline for this?
827362821140820980
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