Answer two questions using Excel What-if-Analysis
$10-30 USD
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?
Project ID: #9999425
About the project
18 freelancers are bidding on average $30 for this job
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
I am an Excel expert and can give the answers using Solver/Goal Seek and financial functions. Regards
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
Hello, I am proficient with Excel and would love to help you with this task. Please contact me for more information.
Hello, i am MS excel advance expert. Please contact with me regarding the project detail. Regards & Thanks.
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
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.
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
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
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
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.
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
I'm an industrial engineer, I used what if analysis every week at my job to model different situations to help management make decisions.