VIEWS: 96 PAGES: 21 CATEGORY: Business POSTED ON: 2/3/2011
Excel Start Up Small Business Budget document sample
Excel Start Up Small Business Budget document sample
By: Mark Chamberlain Introduction Task Process Evaluation Conclusion Teacher Page HURRY, HURRY, HURRY Daily Sunshine Are you ready for an exciting opportunity? We are a thriving community looking for businesses to grow with us. The village of Anywhere U. S. A. is looking to fill a brand new shopping mall with stores. Or are you interested in building your own store, we have vacant lots available that are zoned for commercial use . If interested, please contact the village hall at 555-1234 for further information. You read about a thriving community in the newspaper. They are looking to open a new shopping mall and have lot for sale to build a new store. You are interested. You own just one store, but are looking to expand your business. You call the village hall for more information. You call the village hall and find out that you have a choice of buying space in the mall or building your store. You will work in a team to put together a $500,000.00 budget and present it to the village trustees in a PowerPoint presentation for approval. The Start Your Own Business WebQuest is most successful as a group project. Lessons leading up to the final result should include: 1. Advertising Store Product Employment 2. Type of Store Shopping mall Stand alone 3. Balance a Budget On Budget Over Budget 4. The spreadsheet should include these additional columns: Utilities, inventory, insurance, payroll, and taxes. To achieve these results, use these suggested internet resources: Small Business Administration Chicago Tribune Chicago Sun-Times SouthtownStar Shopping mall list Chicagoland Banks General Contractors Maintaining a spreadsheet with all facts and figures from the beginning of the unit will help the students keep track of expenses. Remember you have a budget of $500,000.00. The student process page introduces the project step-by-step. Students should team up in groups of 4. Before you begin the project, designate each person, by choosing an index card, with the following titles: ACCOUNTANT ADVERTISING EXECUTIVE ARCHITECT BUSINESS MANAGER The ACCOUNTANT is responsible for keeping track of the budget using Microsoft Excel. He will contact the banks if over budget. The budget is $500,000.00. The ADVERTISING EXECUTIVE is responsible for putting ads in the newspapers for the store, product, and employment. The ARCHITECT is responsible for the store layout in the mall or is in charge of building a new store. The BUSINESS MANAGER is responsible for coordinating everyone, as well as, checking with the Small Business Association on the guidelines for setting up a new business. To make this work, everyone must do his/her share. No one is more important than the next. Remember, work as a team. STEP 1 Work in your teams. Decide what type of store to open. Put together an action plan to stay under budget, if possible. STEP 2 The BUSINESS MANAGER checks with the Small Business Administration on the guidelines. The ARCHITECT, depending on the type of store, can either check out the different styles of store layouts in different shopping malls or contact different contractors. The ACCOUNTANT is keeping a running tab of all expenses. The ADVERTISING EXECUTIVE checks the prices of placing ads through the Chicago Tribune, Sun-Times, and the SouthtownStar newspapers. STEP 3 Report back into your groups. The accountant will let everyone know the total amount of the budget. If under budget or on budget, go to STEP5. If over, go to STEP 4. STEP 4 If over budget, then the ACCOUNTANT must get a loan at a bank. STEP5 If under budget, on budget or over budget, make a PowerPoint presentation to present to the village trustees. STEP 6 Repeat steps 1-5 for the other option. STEP 7 Present the best store option to the village trustees. Each member explaining their area of responsibility. This will tell you how well you did in presenting your proposal. Beginning Developing Accomplished Score PowerPoint Presentation 0 points 2 points 4 points No set Some slides Every slide Technical pattern. No follow a follows a set Quality flow to the pattern. pattern. Nice presentation. Choppy flow. easy flow. Hard to Semi-hard to follow. follow. Beginning Developing Accomplished Score 0 points 2 point 4 points The The layout is The layout is background ok. The color easy to read. makes it and type size The color is Aesthetics hard to have some easy on the read. The variations. eyes and the color and type size is type size are used well and poorly used. consistent. Grammar 0 points 1 point 2 points and There are 1-2 No grammar or Spelling more than 3 misspellings spelling misspellings and/or mistakes. and/or grammatical grammatical errors. errors. Collaboration-how well you worked together as a team. Beginning Developing Accomplished Score 0 points 1 point 2 points Everyone Some needed Everyone had a did not extra time to helping hand in Cooperation have all get their bringing this their information. project to life. information in on time. Responsibility 0 points 2 points 4 points No one Some took Everyone took took their their job their job job seriously. seriously. seriously. Compilation-how well you did on your budget (spreadsheet). Beginning Development Accomplished Score 0 points 2 points 4 points Spreadsheet Spreadsheet is Spreadsheet is Selection is messy. Has nice and neat. nice and neat. Criteria quite a few Has 1-2 Has all the (3-4) columns required columns missing. columns. missing. Beginning Development Accomplished Score Organization 0 points 2 points 4 points Over budget Came in on Came in under by budget. budget. $100,000.00 or more. Had to borrow from a bank. Score Total Congratulation! The village trustees have approved both of your plans. They are very anxious to hear from you on whichever plan you choose. In this real world exercise, you learned three things. One, and this is the most important, you learned how to balance a budget and two, how to start up your own business, and three, how to work together as a team. If you have any other ideas other than the two scenarios in this exercise, please let me know at firstname.lastname@example.org. I would appreciate and answer all inquiries. Start Your Own Business A Webquest for 11-12th Grades (math) Designed by Mark Chamberlain email@example.com Content Area and Grade level This lesson is designed for eleventh and twelfth grade statistics. Curriculum Standards The main objective of this lesson is so the student has a clear understanding of how the real world works in regards to business applications. As a result of this WebQuest students will be able to: Standard 10B-…, Design data collection methods, gather and analyze data communicate findings. Preferably 10.b.5-design a statistical experiment to answer a question about a realistic situation, conduct the experiment, use statistics to interpret the data, and communicate the results, individually and as a member of a team. Implementation At the beginning of the scenario, the class should be divided into groups of 4. You should make index cards with the titles of the members of the group, with a description of their responsibilities. You will set a time frame for how long this project will take. Step 1: The class will work in their teams. You set the time limit on how long they have to come up with an action plan. Step 2: In this phase, you should have four computer stations, with at least 2 computers each, designated with each title. Again give them a time limit so others have a chance to research. Step 3: The groups should meet for at least 15 minutes prior to class ending to report back their findings. (You may set a time frame that you feel is appropriate to let the groups meet). Step 4: At this step, give the ACCOUNTANT more time to research the banks. Step 5: Give the students a due date to accomplish this task. Step 6: Give the students a due date to accomplish this task. Step 7: Give the students a time limit to present their study. Evaluation You may use the rubric that is with the lesson or feel free to include your own. Conclusion Feel free to email me with any improvements you feel are necessary or just drop a line on how the lesson played out. I would really like to hear from you.
Pages to are hidden for
"Excel Start Up Small Business Budget"Please download to view full document