{"id":33465,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/forecasting-and-inventory-management"},"modified":"2017-08-16T06:19:17","modified_gmt":"2017-08-16T06:19:17","slug":"forecasting-and-inventory-management","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/forecasting-and-inventory-management\/","title":{"rendered":"Forecasting and Inventory Management"},"content":{"rendered":"<div class=\"the_content_wrapper\">\n<p>1) For the following problems, show your work by hand (scan or photo your handwritten work) or by typing out all the values in Microsoft Word. You will use the data in the table below to calculate four separate forecasts for July. Remember that each calculation and answer is separate (i.e., your answer from \u201cpart a\u201d has nothing to do with your calculation for \u201cpart b\u201d, and so on). PROBLEM: Historical demand for electric vehicles is\u2026 MONTH DEMAND January 12 February 11 March 15 April 12 May 16 June 15 a) Using a simple three-month moving average, find the July forecast. b) Using a weighted moving average with weights of .60, .30, and .10, find the July forecast. (NOTE: In your calculations, apply the highest weight to the most recent month and so forth, middle weight to the middle month, and lowest weight to the farthest month back.) c) Using exponential smoothing with \u03b1 = .2 and a June FORECAST equal to 13, find the July forecast. d) Using simple linear regression analysis, calculate the regression equation and the forecast for July. 2) The bookstore orders sunglasses with the school\u2019s mascot on the arms and sells them for $50 each. During a typical month, 900 sunglasses are sold. It costs $25 to place an order and 25 percent to carry sunglasses in inventory for a year. a) How many sunglasses should the bookstore order at one time (i.e., lot size)? b) The supplier would like to deliver sunglasses once a week. How does this compare to the preferred lot size found in part a? Will there be additional costs to the bookstore to comply with the supplier\u2019s request? c) Suppose the sales increase to 1500 sunglasses per month, but the manager decides to keep the lot size the same as in part a. How much will this decision cost the bookstore per year? Compare the TC of this decision to the TC of ordering the EOQ found in part a.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>1) For the following problems, show your work by hand (scan or photo your handwritten work) or by typing out all the values in Microsoft Word. You will use the data in the table below to calculate four separate forecasts <a href=\"https:\/\/www.benedictsol.com\/blogs\/forecasting-and-inventory-management\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-33465","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/33465","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=33465"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/33465\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=33465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=33465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=33465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}