Biz Start Up Project

 

 

Before starting this project, you will need to place the format cells icon on the toolbar. (page 189)

 

Click on tools then click on customize

Click on the Commands tab

On the left side, you will see the heading “categories”

Under this heading, click on “format”

To the right and near the top, you will see the word “cells” with an icon beside it.

Click on the cell icon and hold down the mouse button then drag and drop the icon onto the toolbar to the left of the fill colour icon.  Now you have the icon handy when you need to format cells.

 

Note: Hyperlinks are a key part of this Excel application - do them last after all revisions. Hyperlinks (page 131)

 

 

For the Biz-Start Up Project you will need to select a Business

: 

Sample Business Plans - http://www.bplans.com/sp/businessplans.cfm

 

NOTE: The example for this project is based on the Salsa Manufacturer Business

 

10 Suggested samples to choose from:

 

·                    Artificial Flowers Import

·                    Auto Parts

·                    Bed and Breakfast

·                    Car Wash

·                    Hair and Beauty Salon

·                    Inline Skating Products

·                    Internet Cafe

·                    Nightclub

·                    Organic Restaurant

·                    Pet Photography

Getting started on the Biz Start Up Project Worksheets

 

1. Table of Contents

 

Set up the Sheet (page 228)

Open a new Excel worksheet file

TO set up the page, click file, page setup and portrait (if not already selected)

Click OK

Click in Cell A1, hold the shift key and click in cell I 1

Release the shift key

Click on the Merge and Centre Icon (page 161)

Type the title, Biz Start Up and tap “enter”

Bold and underline the title.

 

Set up the Row Height and Column Width for Table of Contents (page 126 and 113)

You will have two columns on this page, one will be wide and the other will not be as wide. Click on the line between heading "A" and heading "B" and drag that line over to the line between "G" and "H" and drop it there. This will move the entire column heading letters over and expand column A to the width you need.

 

Now take the line between B and C and drag it over two columns and drop it.

Your column widths are now set up.

Next is to change the height of the rows. Click on "1" (row identifier), hold the shift key and click on "8" row identifier" Release the shift key. Click "Format" then click "Row" then click "Height" (page 126) a dialog box will appear. Click inside the dialog box and type 35. Click OK.

 

Next is fill and text for the title row

Click in cell A1, hold the shift key and click in cell B1. Click on the "Merge and Centre" icon (page 161).

 Type "TABLE OF CONTENTS - BIZ STARTUP. To vertically centre the title, click in cellA1, right click in the same cell and click on "Format Cells." Click on the "Alignment" tab (page 152). Under the text alignment heading, click on the down arrow beside "vertical" and click on centre.

Choose the colours you would like to use and click on the text colour and fill colour icons to create the title heading.

 

Click in cell B2 hold the shift key and click in cell B8

Release the shift key and click on the Merge and Centre Icon

In the newly merged cell, type “Click on Hyperlinks to go to the Plan Sections”.

To centre and wrap this text, right click in this cell and click “format cells”

Click on the alignment tab (page 152)

Under the text alignment click on the down arrow under the vertical subheading

Click on centre and under the text control heading click to put a check mark in “wrap text”.

 

Type the Biz Plan topics in Rows 2-7 according to the example.

 

Following the example merge cells  (page 161) to set up the section of the table of contents that tells readers “Click on the Hyperlinks to go to the Plan Sections.”

 

Make sure you have enough worksheets in your Excel workbook for this project.

You will need 8 worksheets for the Biz Start-up Project.  To add worksheets to your workbook, click insert and click worksheet.

 

Title and colour the tabs (page 135) according to the example:

·        TOC

·        Product

·        Need

·        Market

·        Cost & Price

·        Day 1

·        Day 1 charts

·        Forecast

 

Now that you have all of the topics and tabs done, pick colours for text and fill for the rest of this table of contents (see example).

 

2. Product / Services Worksheet

 

Click on the tab called “Product” (or “Service”)

Set up this worksheet the same way you did the Table of Contents worksheet by adjusting the height and width of the rows and columns (match the example).

Don’t worry about the Contents button – we’ll get to that later).

Type the description of your product or service inn Cell A3

Click and hold on the line just under the 3 (Row 3) and drag it down to provide enough room to type your text. (See example)

Click in this cell again and click the format cells icon on your toolbar.

Click on the alignment tab (page 152)

Then look to the left and you will see the text alignment heading

Click on the horizontal arrow and click on “left”

Click on the vertical arrow and click on “top”

Just underneath these you will see a heading “text control”

Be sure you have a tick mark to make the text wrap automatically.

Click “OK.”

 

3. Product Need Worksheet

 

Follow the same instructions in the Product /Services worksheet to set up the “Product Need” worksheet. Write your description for the need for the product and why the timing is right for this business.

 

4. Market Analysis, Our Edge and the Competition Worksheet

 

Set up this worksheet to match the example. You will need to:

  1. Adjust column widths
  2. Adjust row heights
  3. Use a multiplication formula to determine total sales in dollars by multiplying revenue per customer times potential customers (page 150)
  4. Put borders and cells (page 183)
  5. Format cells for numbers and % (page 186)
  6. Put titles on the columns and rows
  7. Using the percentage of market share you have defined you will need a multiplication formula to determine your total sales in dollars for years one, two and five.  (page 150)
  8. Following the example, after you have completed all of your calculations, write up a short paragraph telling what your competitive edge is for this business and place in the area called “Our Edge”.

 

5. Our Cost and Pricing Worksheet

 

Follow the same instructions in the Product /Services worksheet to set up the “Cost and Pricing” worksheet. Put in your cost figures. These may include labour costs if you are manufacturing or wholesale costs if you are a retailer. Also provide your sales price(s).

 

Set up this worksheet to match the example. You will need to:

  1. Adjust column widths
  2. Adjust row heights
  3. Put borders and cells (page 183)
  4. Format cells for numbers (page 186)
  5. Put titles on the columns and rows
  6. Use the Auto Sum icon (page 157) or an addition formula if your cost has more than one component (page 150)

 

 

 

 

 

 

 

 

6. Forecast of Day One Worksheet

 

Follow the same instructions in the previous worksheets to set up the “Day One” worksheet. Put in the figures (see example) that you expect to have on the first day you start your business.

Set up this worksheet to match the example. You will need to:

  1. Adjust column widths
  2. Adjust row heights
  3. Put borders and cells (page 183)
  4. Format cells for numbers (page 186)
  5. Put titles on the columns and name the items in the rows
  6. Use the Auto Sum icon or an addition formula for calculating the total of your expenditures on “Day One.”
  7. Calculate percentage of total (page 201)

 

7. Day One Charts

Now that you have your dollar and percentage data, you will need to create two charts. (page 162 - 171)

  1. Pie chart showing the percentage make up of total expenditures by item
  2. Bar chart showing the dollars for each expenditure.

 

Important Note: When you are near the completion of each chart, the Chart Wizard will present you with a dialog box where you are asked if you want the chart in the “Same (Day One) worksheet” or in a separate worksheet.

1.      For the first chart, choose “separate.”

2.      Name this worksheet (on the tab at the bottom) “Day One Charts.”

3.      On your second chart also choose separate

4.      Your second chart needs to be cut and pasted into the “Day One Charts” worksheet

5.       You now need to delete the worksheet where the second chart appeared (but was cut and pasted)

6.      Click on the worksheet tab where the second chart was

7.      Click Edit then click delete sheet

Choose and click on the button to create each chart in a new / separate worksheet. 

 

8. Breakeven Analysis

Follow the same instructions in the previous worksheets to set up the “Breakeven Analysis” worksheet. Put in the figures (see example) for the costs and sales price from the cost and price worksheet.

You will need to:

1.      Adjust column widths

2.      Adjust row heights

3.      Put borders and cells (page 183)

4.      Format cells for numbers (page 186)

Breakeven Analysis Continued

5.      Put titles on the columns and name the items in the rows

6.      Use the Auto Sum icon or an addition formula for calculating the total of your costs.

7.      Use the divide formula (page 150) to divide fixed costs by the gross profit on one item or service sold.

8.      Use rounding in the formula to determine the total number of items or services in one month required to break even.  (page 136)

 

9. Hyperlinks: Table of Contents and Back Buttons (page 131)

The first process is to link the table of contents to each worksheet.

Click on the Table of Contents tab to open this worksheet.
You must know where you will arrive (for example cell B6). In this project you will always want to arrive in cell A1 for each tab / worksheet described in the table of contents. Here is how to do the first one:
Click in cell A2 “Product / Service Description.”

From the toolbar menu click Insert and then click Hyperlink – you will see this:
 

 

Look to the left under the heading “Link to” and click on “Place in this document.”
When you do this all the tabs that you have named will appear in the centre window.
Click on Product or Service, depending on your business.

The cell reference defaults to A1 and that is ok for this project.

Click on the “Screen tip” button here:

 

 

 

 

 

 

 

Hyperlink Buttons Continued

 

You will see this:

 

Type your screen tip, such as “Click here to go to product description,” and click OK for the screen tip Click OK for the hyperlink

You will probably have to change the font size and bold it after the hyperlink has been inserted.
Follow the same steps to create hyperlinks for all the items in the table of contents.

 

HYPERLINK THE BUTTONS (page 131)

 

The next process is to hyperlink buttons which you will be placing in all the worksheets referred to in the table of contents so that you can get back to the table of contents from any worksheet.

 

You can copy and past these buttons into your project as shown in the example. You will need the table of contents button on each page. Tip: hyperlink the table of contents button first, then copy and paste it in each worksheet.

Follow the same steps to hyperlink the buttons (click on the button, then click on insert then click on hyperlink)

 

10. Putting it All Together: Presenting the Project

 

Using the information and charts from this Excel workbook  create a PowerPoint presentation with 8 to 10 slides to present your business start up project to the class.

 

 

 

 

 

 

 

LEARNING OUTCOMES

 

1)       Set up “Format Cells” icon (button on the Toolbar) – page 189

2)       Set up worksheet for Portrait / Landscape via Page Setup – page 228

3)       Merge and Centre Cells – page 161

4)       Setup row height and column width – page 126 & 113

5)       Format Cells Alignment tab – page 152

6)       Title and colour the tabs – page 135

7)       Multiplication and addition formulas – page 150

8)       Format cells for numbers and % – page 186

9)       Put borders on cells – page 183

10)   Use Auto Sum icon – page 157

11)   Calculate % – page 201

12)   Create pie and bar charts – page 162 to 171

13)   Use “Rounding” – page 136

14)   Hyperlinks – page 131