Answer two questions using Excel What-if-Analysis

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 you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/

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

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 deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

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 am the right person for this job. Please share some more details for quality work. Please also consider this bid as provisional one as it can be negotiated depending upon the details. Thank you. Usman Saeed Team Spectrum

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

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 requirement. Appreciate if we can talk thought pm before project awarded. Looking forward to hearing good news from you. Thanks & Regards, GS-Anggara

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

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 dashboards, and more. I am an engineer so you can expect nothing less than detail oriented, meticulous, professional grade work, and an impeccable final product. Please send me a message to discuss additional details and I can confirm my commitment.

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 and can solve them instantaneously. In fact, for your second question, I have 2 approaches - one approach using what-if and the other using formula for rate. Looking forward to hearing from you. Regards, Vamsi

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 engineering along with data analysis and management in excel. I believe I am well qualified to undertake the task at hand and would love to further discuss this project and your exact requirements. I am confident I can provide you with top notch product that fit your needs. I pride my work on being professional, of the highest quality and always delivered on time. Sincerely, P. Shrestha

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 questions would be very simple for me. Looking forward to discuss more details as soon as possible.

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.

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. Sean

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 = Expenses + Profit = (Fixed Price + Variable Price X no of units sold) + Profit If Selling price is even 10$ and no of units sold is say X then 10X =10000 + 12X + Profit Solving profit in the above equation will always give a negative number. Selling price has to be atleast 13$ per unit to get a profit. If we consider the annual demand equation alone then definitely price can be less than 10$. I have used solver instead of what if analysis. I hope that is fine. Regarding Q2 : Is there any assumption you would like to make on the inflation rate year on year ? Usually, it is assumed around 7% in India for calculation.

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