SharePrint

# What Excel features and functions are needed for a pricing analyst?

## I was wondering what excel features and functions one needs as a pricing analyst. I am doing a report on employment caracteristics for a school project and know that excel is an important tool for this field. Any additional info anyone may have on this field will also be helpful. Thanks.

Asked By: paola c - 7/22/2008
I used to work as a pricing analyst. Pricing calculations in spreadsheets are known as price models. Price models are data models i.e. calculations that take inputs, perform some mathematical operations, and then output a result. Factors such as revenue, fixed costs(overheads), variable costs, semi-variable costs, units of product, discount margins, price etc can be either inputs or outputs, depending on what you want to model. For example, if you want to know what your profit contribution will be for a given set of costs, sales volume and price, then the inputs will be costs, sales volume and price and the output will be profit contribution. Alternatively, if you know your costs, sales volume and the profit contribution you want, you can work out the price that you would have to charge to achieve this, so inputs are costs, sales volume and profit contribution with price being the output. So data models are simply sets of algebraic equations where you solve for the required variable based on the values of the other variables, which you do know.

In terms of Excel, one of the most useful tools is Goal Seek. This can be used to solve for any output you want without having to go into the model and change the algebraic structure of the model or the inputs. It is basically an equation solver. So if your price model is set up where (1) Revenue = Units Sold x Price (2) Total Costs = Units Sold x Cost Per Unit + Fixed Costs (3) Profit Contribution = Revenue - Total Costs, and you link these equations in your model, Goal Seek will model your price for you based on whatever costs, profit contribution and/or units sold that you enter into the model. You could also, for example, enter price, profit contribution, cost per unit and fixed costs as inputs into the model and use Goal Seek to output the number of units you would need to sell in order to achieve the profit that you entered.

Other Excel functions that are useful include the Scenario tool (Tools>Scenario). This allows you to easily compare the effects of different inputs on your model. These can be used with pivot table reports to display the results of more than one scenario on the same page. Pivot tables are a powerful tool to summarise and display data.

Finally, the VBA programming tool is very useful in price modelling. VBA is embedded (included) in Excel and can be used for complex modelling calculations which would be too complex to perform using in-cell formulas. You can also use it to create user defined functions, which add calculation functionality. For example, Excel aready has a function called SUM. To use it, you would just write +SUM(1,2,3) and Excel will sum whatever is in the parentheses, in this case 1,2 and 3. You could create for example a function called DISCOUNT, which you could program to discount the number in the parenthesis by a given percentage, say 20?To use it you would then enter for example +DISCOUNT(100) in the cell and the number displayed would be 80 (100*0.8). So user defined functions can be used as shortcuts for calculations that you perform frequently.

Other info on price modelling... to do this job it helps to have a degree in business or other mathematical degree. It is also very helpful to have a background or training in IT, especially in Excel and databases. It is common for accountants to specialise in pricing, although you do not need to be a qualified accountant to do the job, just background knowledge of accounting principles.

In terms of where pricing analysts are positioned within a business, they are part of the finance function, which works closely with the marketing function of businesses to set prices for products and services. The pricing function is internally focussed in that it defines the prices at which a company would like to sell products or services whereas marketing is externally focussed in that it investigates the market for the product/service and feeds back information to finance on the effect that prices will have on the volumes of product/service that the company can sell. For example, if pricing analysts calculate that a product would be profitable if it were to sell 500,000 units at \$10 per unit but marketing believes through its market research that the market would only buy the required volume of product at a price of \$8, then the company's managment could decide to attempt to cut its costs, or to redevelop or reposition the product, or abandon the product. Conversely, if marketing believes that the company would sell an acceptable quantity of units at \$15, then management could decide to charge a price closer to the \$10 to achieve more market share or charge a price closer to \$15 to increase the product's contribution to company profit. This is where things start to get complicated, as you get into concepts such as price elasticity of demand curves to predict how sales volumes and therefore profitability will change at differing price levels.

Hope this helps - if you need any other info on price modelling let me know!
Answered By: The Irreverent - 7/24/2008
 Sponsored resultsKangaroo Express - ApplyFound: Hiring Positions Near You. \$10.50 - \$83.75/hr. Apply Online.HiringJobs.WorkGrabber.netWork From Home JobMake Money 15 mins from now and Get A Chance to Earn \$67/h - start Now!www.The-BinaryCode.usJob At HotelFind Expert Information. Job At Hotel on About.com.About.com/Job At HotelEarn \$25-\$75 Per SurveyLegitimate Surveys for Cash. Earn Cash in Your Spare Time, Free!www.SurveySheep.com

# Other Career Questions

 What is the best place to look for Technology jobs?I want to find a technology job as a Network Administrator, and I was wondering what the best job board was for this search. I do not want to trust monster.com, and I know there has to be others besides freelancer.com and dice.com. What other freelance job boards for computer programmers are there today? Thank you. 4 answers - Asked By: Robert - 5/31/2012 What is the highest paying job in the IT industry?Information Technology jobs are scarce where I live. That's what im going to school for, however. Im really interested in this field and i was wondering what was the highest paying job in the industry? Oh and if you can tell me where Bill Gates started out, and how he became the most richest man in the world. whaddya mean by Sales? do you mean like a pitch man? Or like a commercial designer? "Sales" is also a very broad term too. 6 answers - Asked By: Zoo3y - 7/10/2009 How difficult is it to find a computer programming job in New Zealand?I'm from USA, and I received a working holiday visa to visit NZ. I am a web programmer, and I am wondering what the job situation is like in New Zealand. I have noticed that on the NZ job websites, technology jobs usually have the MOST openings.... what does this mean? Is there a shortage of IT professionals in NZ? 1 answer - Asked By: mons - 1/27/2009
 Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo! Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.

## Is this normal for an interviewer to do this?

So today I went in for an interview and I was going in for the 2nd interview by the head chief executive. now this is where it got weird, so she asked me about my previous jobs and said how much she liked that product over that product. then she started talking about her daughter? an her divorce ...then how she didn't finish college because she was making more money doing what she did for this company ... then she talked about how her teenage daughter is a handful... I just played it cool thinking she was using some sort of psychology thing to trick me into saying something stupid. the interview ended and she seemed happy an I was escorted to the door... now I'm freaking confused? is this normal behavior for an executive? like it felt like she was going to burst into tears at one point and tell me her life problems... is this normal? was she trying to see how I react or something?

## What do you say when they ask what you want to be paid? ?

Wen you apply at a job and they ask how mch you want as a salary what do you say?

## How do I get a job with Dodgy work history and no experience?

Basically- no degree, although I have tried completing one in the past and stopped because of physical and mental health issues which were overwhelming to deal with along with going to classes full time. I'm not stupid and I am quite articulate. I am 23 and have only worked for about two years retail in high school and stopped working to go to university. I worked a few months in 2010 retail after I dropped out but it was only a seasonal position, and the only reason why I have not been able to constantly work is because of mental health issues. I had also tried going back to community college during my free time since i left university in 2008/9 and I had panic attacks while in community college, which made my anxiety worse from then on. Well recently I met a good doctor and he prescribed me some meds that are stabilizing my moods and I feel the best I've felt in years, and I'm ready to work. Thing is, I don't know how to get a job now since I've spent literally years being depressed and anxious doing nothing. I don't really have anything to put on my resume, and I never finished my AA degree either. All I've done is cashiering and although I do the job well and I get promoted easily when I do these jobs because I'm a hard worker and I try to go above and beyond what they ask of me,which is the attitude I have no matter what kind of work I'm doing as long as I'm getting paid. But I hate cashiering because it's too easy and I want a job that is more interesting. Any suggestions for me on how to get a job that is NOT Retail with the type of background I have right now? I also realize I have to go to college to get certain types of jobs, I am talking about what I can do right here right now.

## Why honesty, hard work and dedication have no place at work?

Recently I have overlooked for a project at work and I am unable to accept it why? I am hard working, dedicated, maintain a very professional decorum, very cordial with my colleagues and bosses, give respect to one and all. Still people who take the p***, argue with managers, gossip mongers have been selected for some very responsible positions at work. I seriously can't get my head around it why, why unprofessional people who have no work ethics being selected over me, whereas I have a track record of excellent performance and never shy away from any work my manager ask me to do? I am at my lowest point and not getting hold of my manager to ask the question why not me, why them who can't even bother? I am feeling like a complete loser, giving years to this place, building my performance, trust and this is how I get rewarded. Why my life is so shit, anything I wish for turns to dust?

## I have applied for over 100 jobs I have gotten no calls for a job interview, what can i do?

As stated in my question I've applied for multiple jobs and gotten no job interview, you name a place I've applied there. I've said i will work ridiculous hours from like 12am to 5am and nothing. I've said I am willing to work weekends public holidays everything and I have gotten nothing back I am so desperate for money it's not funny.

## What to wear to a job interview VS a career fair?

So I have a nice white button up shirt, business skirt and pants, and a suit jacket. I'm applying for a software development job and I'm very short and can look young so I'm trying to look adult, yet professional. I'm also attractive so I'm trying not to look too sexy. For the career fair I'm thinking of wearing just my nice shirt and a skirt with low heels. My reasoning being it's approachable and attractive without going overboard since the career fair hosts are mostly younger male recent grads. I want to be remembered but not intimidating. For my interviews I was thinking pants, suit jacket (power suit). My reasoning being it'll be older execs and HR people (mostly women) so less sexy with the pants but more powerful with the suit jacket. What do you think?!

## What career or jobs can i get after graduating Information Technology?

I am currently a 1st year irregular college student taking I.T. I transferred schools and my majors never got credited. But it's okay because i am slowly getting the logics in programming in Java. This next semester i am taking a System Analysis and Design(SADSIGN) and i am getting nervous because even though i am pretty good at logics, i am not that good at coding. But since it is a case study, we will be on group, we will be four i think. Project manager, Analyst, Documentation, and the programmer. I am asking what jobs i can get after graduating I.T. because what if i graduated I.T. and still not that good at coding, i am hoping that there will be a jobs that will require less programming. Like Database manager or in Multimedia or in charge of Network. So is there jobs that doesn't require hardcore programming skills?

## Which of these careers would I not have a problem getting a job in?

Account Executive Hospitality Manager Sales Representative Editorial Assistant Advertising Manager Hotel Manager Personnel Specialist Writer/Author Association Administrator Presenter Special Events Coordinator Political Aide Promotions Manager Speech Writer Consumer Affairs Specialist Sportscaster Public Information Officer Communications Director Public Relations Specialist Radio/TV Announcer Technical Writer Telemarketing Specialist Customer Service Rep. Fund Raiser Training & Development Specialist Events Planner Flight Attendant Youth Worker Media Manager Recruiter Market Research Analyst Community Action Director Recreation/Attractions Manager Restaurant Manager Campaign Manager Development Director Script Writer Photojournalist Advertising Copywriter Museum Director Greeting Card Writer Production Assistant Actor, Mime Narrator Stage Manager Director Impersonator Make-up Artist Stunt Coordinator Booking Agent Talent Scout Drama Coach Stand-in Playwright Stage Manager Movie Theater Manager

## What's the difference between computer science and computer engineering majors?

Can someone tell me te difference between computer science and a computer engineering major. Is it the same?

## What jobs can you get from going to an engineering school?

The question explains it, i am thinking of going to an engineering high school but of course it will focus on other stuff too but still. What kind of jobs can you get because i dont want to be a mechanic(no offence to any) but please help me!

## How can l find a job in the pharmacitical field as a sales and marketing manager,in south africa?

L want to study medicine and work as a doctor but l am limited due to luck of required monyes. however l swtched on to anther career but still within my career interests as a care giver, but this is somthing to do with sales and marketing in the pharmcitical industry.

## What is the difference between a nurse practitioner and an ARNP?

Is there any difference between a "nurse practitioner" and an "advanced registered nurse practitioner"?

## What can you do with a graduate degree in communications?

And a BA in criminology?

## Job description of supply and logistics manager?

I am applying for a job of supply and logistics manager so I need to know more about the this job

## I want to become an Escrow Officer, does anyone know how to go about it? What kind of training will I need?

I know that Escrow is within Title industry in Texas. What would be the best way to get my foot in the door. I am assuming I will have to start as an Escrow assistant and work my way up, but I would really like to find out more about this career path. How does an officer usually get licensed? Are there classes we need to take and exam to take? Any response is appreciated.

## How could I better prepare myself for a second interview?

My second interview is on Monday and I want to be prepared. It's for an assistant controller position. I've already met with the controller and the hr manager. Monday I will be meeting with the president of the company. How could I prepare myself for Monday's interview? Thanks! Any comments would be great!

## If someone has a bachelors degree in computer information system, what types of jobs are available for them?

What kind of jobs can they look for if they receive "B Grade" in C++ & Java? Also, if no jobs for them are available in the Computer field, can they look for jobs elsewhere? If so, what types of jobs? Lastly, can they become Math Teachers at a High School or teach basic Math or Programming courses in College?
 Search Career Snapshots Career Benchmarking Career Advice Skills Analysis & Training Questions & Answers SEARCH

## Popular Job Searches

Explore Jobs and Career Opportunities

## Popular Program Searches

Further Your Career With A Degree

## Popular Articles

Browse Articles Related To Careers
2013 Marketing Jobs Outlook
The US may be facing another year of anemic hiring overall, but that won't be the case in the high-orbit world of multichannel, digital media marketing.
2013 Engineering Jobs Outlook
Engineers will find job opportunities in select disciplines in 2013, with candidates who are all-around, client-oriented businesspeople in demand.
Best-Paying Jobs by Major
What could you earn with a particular four-year degree? Find out by checking out this list of the top-paying jobs for 20 of the most common majors.
Eight High-Paying, Secure Jobs
Want to earn a good salary and enjoy a measure of job security as well? Check out these well-paying jobs on tap for fast growth in the coming years.
2013 Finance Jobs Outlook
Three things predict whether your finance job search will fly or flop in 2013: your skills, your industry knowledge and (surprise!) the federal budget.

## Monster Communities

Teaching Community
Where teachers meet and learn.
ArtBistro
Create and connect.
Excelle
Networking for the career-minded woman.
Where nurses call the shots.
More Monster Communities

## Monster Partners

Scholarships
Scholarships, financial aid and more ways to pay for school.
Education.org
Find top campus and online degree programs.
Military.com
Military portal for the US Army, Navy, Air Force, Marine Corps and Coast Guard.
Financial Aid
Scholarships & financial aid.
Staffing for Government Jobs
Staffing and hiring solutions for federal government agency jobs.
More Monster Partners

## Job Hunt Strategy

If you want to blow your chances with recruiters -- and, by extension, with the companies they work for -- here are six perfect ways to do so.

## Resumes & Cover Letters

Hoping to relocate? Get the ball rolling on landing the right job in the right location with these expert resume and cover letter tips.

## Interviewing

Interview questions can run the gamut. You probably won't face all 100 of these, but you should still be prepared to answer at least some of them.

## Salary & Benefits

Most of us aren't natural negotiators, but asking these 10 questions during salary negotiations can help you get everything you deserve.

## Attracting Candidates

Recruiting? Go where the talent is. See why recruiters have befriended social networks.

## Employee Sourcing

November Monster Employment Index Grows 13% Year-Over-Year, Tenth Consecutive Month of Positive Annual Growth.

## Interviewing Candidates

What’s the key to a great interview? According to experts: Practice, practice, practice.

## Workforce Planning

Social media. It’s everywhere. But how can it help you? Learn how to utilize social media even monetize it.

## For Seekers

Campus and Online Degrees
Free Salary Wizard
What are you worth? Find out and negotiate a better salary.
Research Careers
Get information on jobs and career paths to help guide your choices
Resume Distribution Service
Our distribution service puts your resume right in the hands of recruiters.
Resume Writing Services
Our experts will craft a keyword-rich resume that stands out in the crowd.
More Career Resources

## For Employers

Target your job posting to more candidates on thousands of websites.
Hire Right Background Checks
Explore our background check packages to improve the quality of your hires.
Job Postings
Find the right solution for your hiring needs. Starting at \$99.
Power Resume Search
Monster's new search technology precisely matches people with your jobs.
Resource Center
Find staffing insights, labor trends, HR best practices and more.
Target Post
Connect with skilled, hourly and administrative candidates for only \$99.

## Social Media

Find jobs in your area and industry.
Monster Careers
Tune into our career advice and discussions tackling a wide range of topics and industries.
Monster Corporate & PR
Stay up-to-date on the latest news. Get the 'Who', 'What', 'When', and 'Why' on all things Monster related.
Monster Customer Service
Got a Monster question? We've got the answer. Whether you're a job seeker or employer, we can help you find the answers you need.
Monster for Employers
Check out our many pages and stay connected with the latest industry news, events, career advice and job openings.

Tap into Monster's online career forums and share advice with experts.
Monster Company Profiles
Explore companies and get information to guide your career decisions.
Compare Salaries