Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to create a sales forecast with no historical data, I need help coming to conclusions Week 2 Project Activity: Sales Forecast (Draft) This

I need to create a sales forecast with no historical data, I need help coming to conclusions

Week 2 Project Activity: Sales Forecast (Draft)

This week, you will start working on Project Activity 2.

In Week 1, you selected a business for which you'll make a budget proposal. Your first step is to make

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.

You will be graded on correct analysis, proper use of spreadsheet technology, and business-like presentation of the information.

Grading Rubric

Section 2.0 Sales Forecast (Draft) DeliverablePointsThere is a 5-year sales forecast in the Word document Section 2.1 and the Excel spreadsheet (in sales dollars).3The 5-year forecast appears to be based on research, reasonable assumptions, and the methodologies described in the course based on the description in section 2.2 of the template.4The 5-year forecast calculations appear to be correct.3Total Points10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Derivatives Markets

Authors: Robert McDonald

3rd Edition

978-9332536746, 9789332536746

More Books

Students also viewed these Finance questions

Question

How have psychologists and others confounded sex and gender?

Answered: 1 week ago