Want create site? With Free visual composer you can do it easy.

Using the information from 2017 create a sales and profit forecast Discussion

Using the information from 2017 create a sales and profit forecast Discussion

In this scenario, you will be working with a business that offers three types of services to the public. You will be evaluating the effects of different assumptions related to sales level, sales price, and service mix.

Begin with the information below for 2017 (download the excel file with the information below here sales_forecast [Excel file]):

Unit 5 assignment image.JPG
Requirements:

1) Using the information from 2017, create a sales and profit forecast based on each of the following three scenarios:

Scenario 1 (Good Year)
Sales of Service A begin at their December 2017 levels, and increase as they did in 2017, but there is no seasonality decrease beginning in August, the climb continues through the end of the year.
Sales of Service B begin at their January 2017 level but increase at twice the pace of 2017.
Sales of Service C begin at their January 2017 level and remain constant throughout the year.
Beginning in August, prices on all services are raised by 10%
Margins on all products are 10% higher than 2017, and beginning in June margins on service B grow at 2% per month
Scenario 2 (Average Year)
Product sales levels begin at their December 2017 level, and grow or shrink based on their percentage growth or reduction from 2017.
All prices remain the same.
Margins on Service A grow by 2%, while margins on Service B shrink by 1%
Scenario 3 (Poor Year)
Product sales levels begin at their January 2017 level.
Sales of Service A grow at 10% per month until August, then shrink at 15% per month.
All other sales levels are flat.

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS:Using the information from 2017 create a sales and profit forecast Discussion

Prices for Service A and C are reduced 5% in March, the price for Service B is reduced 15% in February.
Margins are cut across the board by 5% in September.
Include a copy of your Microsoft Excel spreadsheet that demonstrates your calculations.

Include a one-page description of the overall impacts of each scenario on the busines

You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.

Did you find apk for android? You can find new Free Android Games and apps.