Excel and Powerpoint

Aug 26th, 2014
DreamIt
Category:
Marketing
Price: $25 USD

Question description

Here is what is all expected on it: Part 2: MS Excel - Create a Start up Budget and first 6 months operating expenses for your new Business using MS Excel. The Excel spreadsheet must include at a minimum the specifications listed below: a. Create two worksheets. The first worksheet should contain your expected expenses for start-up cost. The second worksheet what you expect it to cost to run your new business for the first 6 months. b. Name the two worksheets on the tab. The first worksheet should be named "Startup Costs" and the second "6 Month Expenses." c. Include the following information on the first worksheet: o Start up costs you might incur to start your business, such as equipment, supplies, deposits for electric, water, phone, etc. You may make up items and values based on your business. Must have at a minimum 5 items. Example: You need 10 laptops and each cost $1,599. Your total would be $15,990 for the computers. Fees to have water turned on might be $250 for a deposit. o Formulas for totals of the Startup cost. o Appropriate labels to identify all categories, columns, row, totals and other computed values. o A multi-row title section at the top of the first worksheet, merging cells as needed. Title should include a title for the worksheet, your name, course and section, and the date. d. Include the following format for the first worksheet: o Column heading cells should have a background color and the text should be in Arial 12 point and bold. o Totals should be clearly labeled and the values formatted with dollar signs ($). o Title section at top of page should be in Font of choice 14 point, bold and a background color of choice. e. Include the following information on the second worksheet: o Estimated monthly expenses for the first 6 months, such as salaries (don't forget your own salary), electric, water, phone, Internet connection, supplies and anything else you may need. Must have at a minimum 5 expenses. Example: You have talked to other business owners in the area and know they spend approximately $275 per month for electricity except in the winter months when it increases to roughly $350 per month. You need to hire 5 employees and you will start them out with different monthly salaries and they range from $2500 to $4600 per month (remember months with 31 days should be a little higher than those with 30 days). Formulas for totals for each month and categories and an overall total for the 6 months. o Appropriate labels to identify all categories, columns, rows, totals and other computed values. f. Include the following format for the second worksheet o Column heading cells should have a background color and the text should be in Arial 12 point and bold. o Totals should be clearly labeled and the values formatted with dollar signs ($). g. Ensure your workbook has an appropriate layout that reflects the use of Excel concepts and techniques covered in class. h. Ensure all choices made add to the creation of a professional, well-designed document and that spelling and grammar are correct. Part 3: PowerPoint - Create a slide show that includes 8-10 slides, you could use to present your business idea to a bank or other investors using MS PowerPoint. The flyer must include at a minimum the specification listed below. a. Select a Design Theme. A design theme used throughout the slide show makes for a more professional looking presentation. There are many to choose from. b. Include a title slide. Title slide should include an appropriate name for your presentation, your name and the date created. c. Embed your MS Word Flyer on a slide.. It should not be embedded as an Icon, rather it should be embedded directly into your slide. d. Add a slide that highlights your expenses This should include start-up costs and first 6-months operating expenses. e. Embed the Expense workbook on a slide. It should not be embedded as an Icon, rather it should be embedded directly into your slide. f. Add a final slide. The final slide should include contact information, such as your phone number (made up), email address, fax number, etc. g. Add 4-6 additional slides. These slides should describe your business, your vision, a mission statement, slogan, etc. Include a slide explaining how you would promote your business via the internet (through use of a blog, advertisements on Google web searches, or other method) h. Add graphics to at least 3 slides The graphics could be clip art, or pictures. Please make sure you only add .gif or .jpg/jpeg files. i. Add Transitions between the slides. j. Ensure your project is a professional, well designed presentation. Spelling and grammar are correct. Presentation shows that you have a clear understanding of the concepts.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Cornell University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

5 Reviews


Summary
Quality
Communication
On Time
Value
ashleyisgod
Nov 24th, 2016
" Top quality work from this guy! I'll be back! "
Molly_Moon
Nov 2nd, 2016
" AMAZING as always! "
Hemapathy
Oct 10th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Sep 27th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Sep 18th, 2016
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors