The work needs to be done in an Excel\u00ae file<\/p>\n
Principles of Supply Chain Management
\nProblem Set 1
\n1.\tBased on the information shown below, develop forecasts for April to October using:
\n(a)\tA 3-period weighted moving average model (w1 = 0.5, w2 = 0.3, and w3 = 0.2).
\n(b)\tAn exponential smoothing model with \u03b1 = 0.35. Assume the forecast for March was 950.<\/p>\n
Month\tActual Demand
\nJan\t1050
\nFeb\t975
\nMar\t1000
\nApr\t870
\nMay\t970
\nJun\t1220
\nJul\t1170
\nAug\t1150
\nSep\t1235
\nOct\t1275<\/p>\n
2.\tBased on the information shown below, calculate MAD, MSE and tracking signal.<\/p>\n
Week\tActual Demand\tForecast
\n1\t750\t770
\n2\t690\t730
\n3\t820\t710
\n4\t850\t790
\n5\t870\t840
\n6\t780\t850
\n7\t915\t890
\n8\t950\t920<\/p>\n
3.\tFor the information given, rank the customers in terms of customer lifetime value.
\nAvg. Annual Sales\tAvg. Profit Margin\tExpected Lifetime
\nCustomer 1: \t\t$3,450\t\t\t17 %\t\t\t8 years
\nCustomer 2:\t\t$2,000\t\t\t13 %\t\t\t6 years
\nCustomer 3:\t\t$1,400\t\t\t32 %\t\t\t10 years<\/p>\n
Use a discount rate of 6 percent and treat the average sales figures as annuities. Should any of these customers be fired?<\/p>\n","protected":false},"excerpt":{"rendered":"
The work needs to be done in an Excel\u00ae file Principles of Supply Chain Management Problem Set 1 1. Based on the information shown below,\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7545,2809,7548,7546,7544,7543,7549,7547],"tags":[7678,8989,8988,7387,633,8991,630,8987,8994,8467,15,8990,7656,7571,8993,66,8992],"class_list":["post-101981","post","type-post","status-publish","format-standard","hentry","category-best-dissertation-services-uk","category-cheap-dissertation-writing-services-uk","category-dissertation-writing-services-cost","category-dissertation-writing-services-uk-reviews","category-master-dissertation-writing-services","category-phd-thesis-writing-services-uk","category-thesis-writing-writing-help-australia","category-top-dissertation-writing-services","tag-best-custom-paper-writing-service","tag-best-online-paper-writing-service","tag-best-paper-writing-service","tag-best-research-paper-writing-services","tag-cheap-research-paper-writing-service","tag-cheapest-paper-writing-service","tag-college-paper-writing-service","tag-free-paper-writing-service","tag-free-term-paper-writing-service","tag-paper-writing-service","tag-paper-writing-service-reddit","tag-professional-paper-writing-service","tag-someone-to-write-my-paper","tag-websites-that-write-papers-for-you","tag-what-is-the-best-paper-writing-service","tag-write-my-paper","tag-write-my-paper-for-me-free"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/101981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=101981"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/101981\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=101981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=101981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=101981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}