Answer two questions using Excel What-if-Analysis

Closed Posted Mar 20, 2016 Paid on delivery
Closed Paid on delivery

I am looking for a freelancer that is experience with excel, especially the Data Table and Goal Seeker functions of the What-if-Analysis menu.

Question 1: (using data table)

The annual demand for a product equals 500-3p+10a0.5, where p is the price on the product in dollars and “a” is hundreds of dollars spent on advertising the product. The annual fixed cost of selling the product is $10,000 and the unit variable cost of producing the product is $12. Determine a price (within $10) and amount of advertising (within $100) that maximizes profit.

Question 2: (using goal seek)

At the end of the year for each of the next 40 years, I’m going to put $15,000 in my retirement fund. What rate of return on my investments do I need so that I will have $2 million available for retirement in 40 years?

Excel

Project ID: #9999425

About the project

18 proposals Remote project Active 7 years ago

18 freelancers are bidding on average $30 for this job

cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and its tool for statistics and economics problems. I've done a lot of similar work. I could send More

$30 USD in 1 day
(89 Reviews)
6.4
best4best

I am an Excel expert and can give the answers using Solver/Goal Seek and financial functions. Regards

$30 USD in 1 day
(110 Reviews)
6.1
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliv More

$74 USD in 2 days
(59 Reviews)
5.5
kamrananjum1

Hi, I can help you with this one. I have more than 10 years of professional experience in Microsoft Packages. I have an excellent grip over MS Excel. I have gone through to the requirements and I am confident that I More

$84 USD in 4 days
(16 Reviews)
4.6
vlayausa

Hello, I am proficient with Excel and would love to help you with this task. Please contact me for more information.

$25 USD in 1 day
(29 Reviews)
4.2
gsanggara

Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro I am confident that I will able to complete your project as per timeline and req More

$30 USD in 2 days
(10 Reviews)
3.3
UsmanNasar87

Hello, i am MS excel advance expert. Please contact with me regarding the project detail. Regards & Thanks.

$19 USD in 1 day
(16 Reviews)
3.1
vroux

Hello. I can use the solver and what if analyses to answer your questions. I am an expert with excel and regularly develop spreadsheets for a variety of purposes, including design calculations, cost estimations, KPI da More

$30 USD in 1 day
(2 Reviews)
2.6
johncarteratfl

I understood your requirements clearly. I am a Microsoft Certified Excel Master. I can do these two tasks Optimization problem usin and Goal seek. Provide me an opportunity to help you. Thanks

$30 USD in 1 day
(2 Reviews)
1.5
moryodee

i am seasoned writer with many works credited to my name. i hold a Bcom(finance) degree. i also have experience in many other fields including computers. please award and you won't be disappointed.

$35 USD in 1 day
(0 Reviews)
0.0
vamsismarty

Hi, I am Vamsi, an MBA grad from a top 10 b-school in India and currently working as a Business Analyst in Analytics area for an MNC bank. I am an expert in Excel including VBA. I have read both your questions a More

$15 USD in 1 day
(0 Reviews)
0.0
photography143

Hello Sir, I am writing in response to your advertisement for a Excel assistance. I feel that I am a suitable match for the job. I am an experience engineer based out at Australia. My experience revolves around engine More

$25 USD in 1 day
(0 Reviews)
0.0
msalahyassin

Hello! I work as an infrastructure design engineer for a reputable consultant in the Middle East. I work on MS Excel on a daily basis. I use what if analysis several times during my engineering work. Handling the 2 que More

$30 USD in 1 day
(0 Reviews)
0.0
FahadGulz

What-if Analysis using Goal Seek and Data table are some of the most basic functions of Excel, the project seems to be pretty straight forward. I can do this job as per your requirements.

$15 USD in 1 day
(0 Reviews)
0.0
seanlave

Hi, My name is Sean. I have a Master's in Finance from Johns Hopkins and can get this finished for you in short order. I'll also provide a thorough explanation so that you'll be able to do it yourself for the exam. More

$25 USD in 1 day
(0 Reviews)
0.0
snehamirle

Statistics and data analysis is my passion. I have 11.5 years of Experience in various IT companies. I have already worked both answers partially and have few clarifications Regarding Q1 : Selling price = Expens More

$30 USD in 1 day
(0 Reviews)
0.0
jdiazpupr

I'm an industrial engineer, I used what if analysis every week at my job to model different situations to help management make decisions.

$10 USD in 2 days
(0 Reviews)
0.0