Unit 5 Assignment – Variable Sales Forecast Model
\nEstimated time to complete: 10 Hours<\/p>\n
Instructions:<\/p>\n
In this analysis you will be generating multiple sales forecasts based on different modeling assumptions.<\/p>\n
In this scenario you will be working with the 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.<\/p>\n
Begin with the information below for 2017 (download the excel file with the information below here sales_forecast.xlsx Click for more options
\nRequirements:<\/p>\n
1) Using the information from 2017, create a sales and profit forecast based on each of the following three scenarios:<\/p>\n
Scenario 1 (Good Year)
\nSales 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.
\nSales of Service B begin at their January 2017 level but increase at twice the pace of 2017.
\nSales of Service C begin at their January 2017 level and remain constant throughout the year.
\nBeginning in August, prices on all services are raised by 10%
\nMargins on all products are 10% higher than 2017, and beginning in June margins on service B grow at 2% per month
\nScenario 2 (Average Year)
\nProduct sales levels begin at their December 2017 level, and grow or shrink based on their percentage growth or reduction from 2017.
\nAll prices remain the same.
\nMargins on Service A grow by 2%, while margins on Service B shrink by 1%
\nScenario 3 (Poor Year)
\nProduct sales levels begin at their January 2017 level.
\nSales of Service A grow at 10% per month until August, then shrink at 15% per month.
\nAll other sales levels are flat.
\nPrices for Service A and C are reduced 5% in March, the price for Service B is reduced 15% in February.
\nMargins are cut across the board by 5% in September.
\n2) Include a copy of your Microsoft Excel spreadsheet that demonstrates your calculations.<\/p>\n
3) Include a one page description of the overall impacts of each scenario on the business.<\/p>\n","protected":false},"excerpt":{"rendered":"
Unit 5 Assignment – Variable Sales Forecast Model Estimated time to complete: 10 Hours Instructions: In this analysis you will be generating multiple sales forecasts based on different modeling assumptions. In this scenario you will be working with the business Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-427319","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/427319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=427319"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/427319\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=427319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=427319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=427319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}