View the step-by-step solution to:

BUSN278 Budgeting and Forecasting Template Instructions Use this spreadsheet structure to lay out the various sections of your project. The purpose...

I have a project due by the end of the week and need to have the following information completed which is 2.0 section all the way to 4.0. I have attached the budget proposal that i have begun and the workbook which i have not started for week 2 and 3 as well as the project description. I definetely need help with the workbook. Due date is this Thursday. Thanks. Stephanie
BUSN278 Budgeting and Forecasting Template Instructions Use this spreadsheet structure to lay out the various sections of your project. The purpose of this spreadsheet is to make it easy for your professor to locate the various sections of your project. Please don't alter the worksheet tabs or titles. After you finish your calculations in this spreadsheet, you will have to create a written report where you take screenshots from this spreadsheet and put them in the Budget Proposal Template, along with necessary explanations. Detailed instructions for how to write the report are found in the Budget Proposal Template, a Word document.
Background image of page 1
Put your sales forecasting calculations here.
Background image of page 2
Show entire document
DeVry University Course Project Description BUSN278 Budgeting and Forecasting BUSN278 Course Project Project Overview This is an individual project where you will be acting as a consultant to an entrepreneur who wants to start a new business. As the consultant, you’ll create a 5-year budget that supports the entrepreneur’s vision and strategy, as well as the needs for equipment, labor, and other start-up costs. You can choose from one of three types of new business start-ups—a landscaping company, a restaurant, or an electronics store that sells portable computing devices. Each business has its own business profile detailed in the sections below. The purpose of the business profile is to guide you in understanding the scope of the business, the entrepreneur’s start-up costs, and financial assumptions. The project requires you to create a written budget proposal, a supporting Excel workbook showing your calculations, and a PowerPoint presentation summarizing the key elements of the budget proposal, which you assume will be presented to a management team. This is an individual project. Each week you will complete a section of the project in draft form. In Week 7, you will submit the final version of the project’s budget proposal, budget workbook, and budget presentation in PowerPoint. Deliverables Schedule and Points Week Deliverable Points 1 Section 1.0 Executive Summary (Draft) 10 2 Section 2.0 Sales Forecast (Draft) 10 3 Section 3.0 Capital Expenditure Budget (Draft) 10 4 Section 4.0 Investment Analysis (Draft) 10 5 Section 5.1 Pro Forma Income Statement and 5.2 Balance Sheet (Draft) 10 6 Section 5.3 Pro Forma Cash Budget (Draft) 10 7 Final Budget Proposal 90 7 Final Presentation with PowerPoint 30 Total project points 180 Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means—graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems—without the prior consent of DeVry Educational Development Corporation. Page 1 of 9 qattachments_03c7658579261c6604e766cab160281d66f6b2cf.docx
Background image of page 1
DeVry University Course Project Description BUSN278 Budgeting and Forecasting Business Profile: Papa Geo’s Restaurant Vision The vision of the entrepreneur is to create a single-location, sit-down Italian restaurant called Papa Geo’s. The goal is to generate an income of $40,000 per year, starting sometime in the second year of operation, as wells as profit that is at least 2% of sales. Strategy a) Market Focus and Analysis The restaurant targets middle- to lower middle-class families with children, as well as adults and seniors, located in Orlando, Florida. The area within 15 minutes of the store has 10,000 families, mostly from lower to middle-class neighborhoods. Average family size is four people per household. There is no direct competition; however, there are fast food restaurants like McDonald’s, Taco Bell, and Wendy’s in the geographical target market. The lower to middle-class population is growing at about 6% per year over the next 5 years in this area. b) Product The product is Italian food served buffet style, in an all-you-can-eat format, with a salad bar, pizza, several different types of pasta with three or four types of sauces, soup, desserts, and a self-serve soda bar. The restaurant is also to have a 500 square foot gaming area that has game machines that children would be interested in using. c) Basis of Competition Customers come to this restaurant because of the good Italian food at a low price —you can get a meal for $7, including drinks. Customers also eat at Papa Geo’s due to the cleanliness of the facility, the speed of getting seated and served, and the game machines that keep the children busy while adults enjoy their meal. Start-Up Requirements* Given Costs Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means—graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems—without the prior consent of DeVry Educational Development Corporation. Page 2 of 9 qattachments_03c7658579261c6604e766cab160281d66f6b2cf.docx
Background image of page 2
Show entire document
Castle’s Family Restaurants Business Plan-Proposal (Stage I) Stephanie Mendiola Human Resources Information Systems Professor: Karen Buchanan November 10, 2013
Background image of page 1
Introduction Maintaining employee information is pertinent and essential for your business, most importantly, when considering all the state, local and federal filing requirements for employee taxes. Otherwise, your business will have a difficult time providing all the necessary information for your employees and your payroll. With a booming business, approximately 300-340 employees, one manager is assigned to maintain employee information while gas prices increase, An HRIS system should be taken into consideration and viewed as a tool that will provide value to the HR function and to your business. We will discuss important core functions that an HRIS system can provide as well as the benefits from this system. As a HR Consulting Firm, it is our duty to ensure the right system that allows your business to be cost efficient and start working more efficiently while better utilizing time and resources. Business Assessment Castle’s Family Restaurants is a growing company with a total of eight restaurants spread out through northern California. With approximately 300-340 employees, 204 are part-time employees and 136 are full-time employees. Jay Morgan, Operations Manager for the business as well as the acting HR Manager with travel requirements to all business locations with each site employing approximately 40-43 employees. Manager’s responsibilities include but not limited to: scheduling, recruiting, hiring, and answering questions for the employees as needed. Also, Mr. Morgan is responsible for payroll using an Excel spreadsheet and has a computer application with the ability to print payroll checks. Assuming each site has shift managers/supervisors following the requirements as stated within Government health inspector’s regulations, EEOC, FLSA and OSHA, certain responsibilities may be delegated to others as Mr.
Background image of page 2
Show entire document
DeVry University Course Project BUSN278 Budgeting and Forecasting Student Project Activity – Week 2 A. Week 2: Budget Proposal Section 2.0 Sales Forecast B. TCOs Addressed: TCO 5: Given a new business startup or new product introduction and the need to make a forecast when historical data is not available, create the forecast for the organization. TCO 10: Given a description of a new business, new product, service or project develop, present and defend the budget . C. Project Activity Overview – Scenario / Summary: Last week, you selected a business for which you’ll make a budget proposal. Your first step is to create a sales forecast (in sales dollars) when no historical data is available. Use methods such as historical analogy, expert judgment, consumer surveys, the Delphi method, or calculations based on population distributions, estimated growth rates, or expected market penetration rates to arrive at reasonable sales figures for your business for the next 5 years. Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx. D. Deliverables: Complete Section 2.0 (including sections 2.1 and 2.2) in the Budget Proposal Template.docx after doing research and performing calculations to arrive at your 5 year forecast. Also, provide calculations in the Budget Proposal Workbook.xlsx. Add section 2.0 to your Budget Proposal Template and save it as YourName_Project_WK2.docx. Save your sales forecast in the worksheet tab labeled Section 2.1 and 2.2 as YourName_Worksheet_WK2.xlsx and upload both files to the Week 2 Project Dropbox. Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation. Page 1 of 3 qattachments_4af5895caff001ec39ce2c4409dd6a4b692c2fc1
Background image of page 1
DeVry University Course Project BUSN278 Budgeting and Forecasting E. Project Tasks: Task 1: Download Budget Proposal Workbook.xlsx from DocSharing. Task 2: Research the area in which your business is located, and do calculations in the Excel workbook which produce a reasonable dollar value forecast based on population size, growth rates, an estimate of the percent of the population expected to purchase your product, and the dollar value of the average sale over the 5 year planning horizon. Do these calculations in the Section 2.1 and 2.2 tab of the Budget Proposal Workbook.xlsx. Also, feel free to use other methods described in this course you feel are appropriate to estimate sales for your new business startup’s first five years. Task 3: Write section 2.1 and 2.2 of the Budget Proposal Template.docx document, summarizing your forecast in a table, and also describing and justifying your methodology for arriving at the sales forecast. Follow the instructions in section 2.0 of the Budget Proposal Template.docx when writing these sections. Also, update your works cited Section 6.0 in the template with any research you did. Task 4: Paste the first paragraph of the 1.0 Executive Summary template into the Budget Proposal Template.docx so your professor is reminded which business you’re doing. Task 5: Save the draft of the Budget Proposal Word document and Budget Proposal Excel calculation and submit it to the Week 2 Project Dropbox. F. Grading Criteria Description Suggested Points There is a 5 year sales forecast in the Word document Section 2.1 and the Excel spreadsheet (in sales dollars). 2 The 5-year forecast appears to be based on research, reasonable assumptions, and methodologies described in the course based on the description in section 2.2 of the template. 4 The 5-year forecast calculations appear to be correct. 4 Total Points 10 points Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means – graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems – without the prior consent of DeVry Educational Development Corporation. Page 2 of 3 qattachments_4af5895caff001ec39ce2c4409dd6a4b692c2fc1
Background image of page 2
Show entire document
DeVry University Course Project BUSN278 Budgeting and Forecasting Student Project Activity—Week 3 A. Week 3: Section 3.0 Capital Expenditure Budget B. TCOs Addressed TCO 4: Given a scenario for a new project or new product, use zero-based budgeting to develop a multi-year capital expenditures and revenues budget. TCO 10: Given a description of a new business, new product, service or project develop, present and defend the budget . C. Project Activity Overview—Scenario/Summary Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop and present a capital expenditure budget for your new business start-up. D. Deliverables Complete Section 3.0: Capital Expenditure Budget in the Budget Proposal Template.docx after doing research about expected capital expenditures. Also, provide calculations in MS Excel template tab 3.0 in the Budget Proposal Workbook.xlsx. Add Section 3.0 to the Budget Proposal Template and save it as YourName_Project_WK3.docx. Add your Capital Expenditure Budget to the worksheet tab labeled Section 3.0 and save as YourName_Worksheet_WK3.xlsx and upload both files to the Week 3 Project Dropbox. E. Project Tasks Task 1 Identify items considered capital expenditures for the new business start- up. Task 2 Do research to estimate costs of these capital expenditure items. Task 3 Create a capital expenditure budget in the Excel Template Tab labeled Section 3.0 Capital Expenditure Budget. Copyright ®© 2010 by DeVry Educational Development Corporation. All rights reserved. No part of this work may be reproduced or used in any form or by any means—graphic, electronic, or mechanical, including photocopying, recording, Web distribution or information storage and retrieval systems— without the prior consent of DeVry Educational Development Corporation. Page 1 of 2 qattachments_9797c883eb02c40242b5071fa219dd2f31a26af8
Background image of page 1
Task 4 Add Section 3.0 of the Budget Proposal Template word document. Make sure the first paragraph of your Executive Summary Section 1.0 and Sales Forecast Section 2.0 are also in the Budget Proposal Template. Also, update your Section 6.0 Works Cited as necessary. Task 5 Save the Excel and Word documents, and submit them to the Week 3 Project Dropbox. F. Grading Criteria Description Suggested Points Capital expenditure items have been correctly identified. 3 Costs of these items appear reasonable and based on primary research. 3 The capital expenditure budget is properly constructed in the Excel template and calculations appear correct. 2 The Capital Expenditure section of the Word template is complete and correctly describes the capital expenditure budget and its underlying assumptions. 2 Total Points 10 points END OF WEEK 3
Background image of page 2
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question