I have been told to create a Pricing Matrix by my boss and I don't know how to do it as I don't have any clue what it is. Please can anyone help me Making one ASAP!! Thank you
I have been told to create a Pricing Matrix by my boss and I don't know how to do it as I don't have any clue what it is. Please can anyone help me Making one ASAP!! Thank you
Ask your boss to define exactly what is required:
I think contents will include:
Product (Name and/or product number ID)
Prices (Quantity dependent maybe)
Effective dates of prices (for price changes)
Hi mate
It is as follows:
Company: It is the companies that provide us a service.
Service: Type of service they do for us.
Date: Service Date
References
Price: Price of the Services.
Below is the example:
Company Service Date References Total
Brian Yeardleys Export Ashford to Carclo
CSL Transport Swindon to Ashford
SeaLane Delivery
DHL Express Worldwide
DX Courier
The Fuelcard Company Fuel Expenses
Royal Mail Postage
FedEx Delivery
Iveco Maintainence and Repair
Lawerence Container Container Hire
Toyota Car Rental
Stac A Truc Repair
Obviously there are lots of other services but above are the examples of each of the services provided by the companies listed. Please help me mate. Would really appreciate it. Thanks
Company------------------------------Service-------------------------------Date------------------References----------------Total
Brian Yeardleys--------------Export Ashford to Carclo
CSL--------------------------Transport Swindon to Ashford
SeaLane-----------------------------Delivery
DHL-----------------------------Express Worldwide
DX-----------------------------------Courier
The Fuelcard Company----------Fuel Expenses
Royal Mail---------------------------Postage
FedEx--------------------------------Delivery
Iveco------------------------Maintainence and Repair
Lawerence Container----------Container Hire
Toyota-----------------------------Car Rental
Stac A Truc--------------------------Repair
something like this?
Last edited by sandy666; 06-14-2017 at 08:16 AM.
@sandy666 is that even a matrix?
@sandy666 I don't know that's why I am asking for help. There are many forms of matrix online but for the ones that I am after I don't know which one is more suitable. Please Help
You got a simple table with your needs.
More information is appreciated
Show the boss the example and ask if that was the case
@sandy666 I have done the same thing on excel and I showed him weeks ago he didn't think that was what he was looking for. hmmm
Sorry but we are not an angels and don't know what your boss thinking
Hi e.limm,
The word "Matrix" is too general for us to know exactly what your boss is thinking. I once had a boss that I showed our support call volume over time chart. He looked at my graph and his eyes went glassy. I realized he didn't know how to read a graph. He must have missed that part of his education. My chart went into the trash and I realized he was a "Motto" kind of guy. Charts made no sense to him at all.
If I was asked to do a pricing matrix, I'd assume it was an Excel Table that showed (in rows and columns - Matrix?) all the options we had at pricing our product. Something like: If we price it at $100/part we only sell 10 but if we price it at $20/part we sell 1000. We simply don't know what your boss is thinking when he says Matrix.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Maybe something like this one? But no information = no ideas
@MarvinP Hi Mate I did show him the Excel Table which I had made but he didn't think that's what he was after. I think what he wants is that he wants a Matrix which has all the names of the company, the types of services they provide, price, date, references etc.
But you got table. You need change false data to real data . that's all
@sandy666 that looks like a pretty good example however I have just been working for 6 months in the company so I don't think I have enough information's to do yearly ones.
This is example. You can use real dates, real companies, real services , real qty and prices
First you need create table then make Pivot Table from source table.
OK then,
Time to dig into each company and start making rows and columns with company names and services and prices etc. My concern is it is more than a two dimensional matrix. I think you need some examples and quiz the boss a bit more...
https://www.smashingmagazine.com/200...est-practices/
https://docs.infor.com/ln/10.4/en-us...al/000026.html
@MarvinP
I think they looking for bells&whistles first
@e.limm
You can do everything (almost) if you've raw data (source)
see att.
one source - 4 views
You're lookin' for dashboard I suppose
Last edited by sandy666; 06-14-2017 at 09:32 AM.
@MarvinP @Sandy999 Guys this is what I had done and showed him previously which he didn't think that was what he was looking for.
So click on your table, from the ribbon select INSERT - Recommended Pivot Tables and it will show ca. 8 views of your data.
You can choose one or all . It depends on what you want to get / show
see att.
Last edited by sandy666; 06-14-2017 at 10:02 AM.
Perhaps something like:
Company Report Average by Date.xlsx
But it isn't a matrix.
@sandy666 Oh god. I think he meant he wanted all the prices and services that the companies charges us into matrix because I have got a tariffs from different companies and I think he wants me to put that in the matrix. hmm
see attachment in post #21 (Tab PT )
here is what your boss want (I hope ) Dashboard examples
Last edited by sandy666; 06-14-2017 at 10:08 AM.
@sandy666 how did you make that? is that through Insert Pivot Table?
you are right (re-read post #21)
@sandy666 Sorry about that haha. I will try to make another matrix and will get back to you and please do let me know how I have done. Thank you soo much for your help though.
ok, here is another example
Last edited by sandy666; 06-14-2017 at 01:12 PM.
If that takes care of your original question, please Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
@sandy666 please have a look at the attachement. Is that ok to you? He just wanted everything in a table. Please replay ASAP. Thanks
And?
You've all in tables. So what I should say? Ask your boss
@sandy666 I just send this to my boss and he said excellent. hahaha wasn't expecting that. Thank you very much sandy for your help anyway. Much Appreciated.
You are welcome
Here is my point of view
If that takes care of your original question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by sandy666; 06-15-2017 at 10:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks