Background:
You are in charge of a product launch, your choice, for a company, or for yourself. You can choose any product as long as no one else in your set is launching the same product. Choose a product that you know and/or are interested in, and see if it is a viable idea.
To Do:
This project will ask you to design, build and use a spreadsheet, with multiple worksheets, for a business start-up, or a product launch. You will provide 3 years’ worth of reasonable projections, on a monthly basis. The user should be able to easily understand, and manipulate, your spreadsheet. You will be graded on the use of course concepts, the functionality of your spreadsheet, and the user-friendliness of your design. Below is the general criteria for the project. This is not a laundry list of items to put into your spreadsheet, you will also be graded on the rationale behind your decisions.
Criteria:
Documentation and User-Friendliness
Sources, assumptions, ease of use. You may wish to include such things as pop-up instructions, pictures, and a company logo. This includes a cover page with your purpose statement and some summary data.
Formatting
Use of cell styles, conditional formatting, worksheet names, data validation, locked cells (do not hide formulas and do not use a password), 3D referencing, and the appropriateness of your choices
Formulas
General formulas, correct cell referencing, along with simple functions such as SUM
Advanced formulas such as an IF statement and at least 2 financial functions
Charting
3 charts - based on appropriate messaging to help show summaries and/or conclusions.
What if analysis
Goal seek, one variable, and two variable what if analysis. Reasonableness of your choices and presentation of data is important. This includes your 3 years of projections. Do you expect growth in sales? What about increases in costs such as utilities, salaries, commissions, or variable costs?
Cover and Purpose Statement worksheet
Summary data
Hyperlinks to other sheets
Excel Concepts used worksheet – set this sheet up for easy Filtering of data
Itemized list of concept used (be it course concept from BSYS1000, BSYS2070 or from elsewhere)
Source (BSYS2070, BSYS1000, OTHER)
Criteria section that it applies to (see above)
Rational for use
Where it is in your workbook
Break-even analysis worksheet
Cost breakdown worksheet(s)
Variable costs
Fixed costs
Three separate sheets for 3 years of sales projections (on a monthly bases)
What if analysis worksheet(s)
One variable
Two variable
Goal Seek
Source Page
Provide sources for your information
If in doubt, use APA style
Hi, I am a Chartered Accountant having more than 10 years experience in accounting,finance and costing. Moreover, I'm also an advanced excel expert.
I can work on this project perfectly and delivered to you. Please check my profile for my review and feedback.
Dead line=3 days
$180 CAD v 7 dnech
4,9 (41 recenze)
5,3
5,3
18 freelanceři nabízejí v průměru $175 CAD za tuto práci
Hi there.....
Warm Greetings
We came along with your request for excel and we reviewed your project description. We'd like to help you with confidence and satisfying results...
We have professionals working here with 100% results and more creative and renovative ideas for our clients !
We have worked on several similar projects before!
We are offering our services for more than 5 years in the field of Business Analysis, Data Entry, Data Processing, Excel, Finance
We have worked on 325+ Projects. Please check the profile reviews
Feel free to message us to discuss briefly about your project !
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe.
I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline.
Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me.
Please feel free to contact me so that we can discuss further details.
Thank you for taking the time to read my proposal.I am looking forward to hearing from you.
Kind regards
Hello,
I'm ready to work on product launch excel spreadsheet project.
Relevant Skills
Excel, VBA
Milestones
141 CAD - project requirements done and delivered
141 CAD - last milestone after full checking and testing
I have samples of work very similar to what you are seeking, check my profile please.
Greetings for the day!!
We have experience working on this subject.
We ensure 100% QUALITY with ON-TIME Deliveries.
Please allow us to take this opportunity.
Thanks & Regards,
Team@The24CarrotsInc
VBA/EXCEL
100% Satisfaction Of Deliverable
Dear Sir
I will do your project as per your requirements by applying advanced excel formulas with conditional formatting and graphs and charts as of your requirements.
Best regards
Humayoon
I have a team of 10 people and all Ph.D. holders in Engineering, Computer Science, Humanities like Sociology, Psychology, Physics, Chemistry, Project Management, Information Technology etc.
I offer course work help on blackboard, pearsonlabs, safeassign, turnitin submissions to the students across United States and Australian Universities only.
I can also do Finite Element Analysis in ANSYS, circuit analysis in Multisim and other relevant software’s.
What I can offer;
Essays; Research Papers; Term Papers; Coursework Help on Blackboard; Literature Reviews; Numerical Problems in Science & Engineering etc.
Quality will be absolutely great and free from any plagiarism on Turnitin or safeassign.
Contact me;
Regards
Full Grade Experts
What’s App us: +1 (631) 973 9497
Dear Partner,
I was born and raised in Montreal and I can certainly help you with your Excel project. Until now, I have worked primarily for companies operating in an international context in the field of automotive and building materials and whose activities were located mainly in China, Europe and the USA. Over the years, I have developed strong branding and strategic planning abilities along with multi-channel advertising campaign management skills using a large variety of communication platforms.
Please contact me in private if you wish to validate my experience. I look forward to working with you.
Regards,
David St-Laurent | B.B.A.