Budgeting and Forecasting Project Week 2

User Generated

rfpbcrgn92

Business Finance

Description

Here is what is needed for week 2 of the budgeting and forecasting course project. 

BUSN278 Project Activity Week 2.docx 


Unformatted Attachment Preview

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 20150713030552busn278_project_activity_week_2 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 There is a 5 year sales forecast in the Word document Section 2.1 and the Excel spreadsheet (in sales dollars). 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. The 5-year forecast calculations appear to be correct. Total Points Suggested Points 2 4 4 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 20150713030552busn278_project_activity_week_2 DeVry University Course Project BUSN278 Budgeting and Forecasting END OF WEEK 2 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 3 of 3 20150713030552busn278_project_activity_week_2
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags