13 Jun GIVEN A DESCRIPTION OF A NEW BUSINESS, NEW PRODUCT, SERVICE OR PROJECT DEVELOP, PRESENT AND DEFEND THE BUDGET.
Briefly introduce the sales forecast section.
2.1 Sales Forecast
Here you should include a simple table showing the years and the total sales for each year, along with a brief explanation of why sales are expected to rise, fall, change, or stay the same in certain years. Provide a brief explanation of the sales forecast, indicating why you expect sales to rise or fall during the planning horizon. Your explanation should be consistent with the trends and changes in sales found in your table. Year 1 Year 2 Year 3 Year 4 Year 5 2.0 Sales Forecast Sales
2.2 Methods and Assumptions
Here you should describe how you arrived at your sales forecast in section 2.1. You should also provide any detailed calculations that led you to the sales forecast values. You should also summarize any research or figures that led you to make this sales forecast.
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.
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
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.