{"id":10443,"date":"2021-10-22T11:49:41","date_gmt":"2021-10-22T11:49:41","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/complete-problem-2-12-from-your-text-on-page-51-using-the\/"},"modified":"2021-10-22T11:49:41","modified_gmt":"2021-10-22T11:49:41","slug":"complete-problem-2-12-from-your-text-on-page-51-using-the","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/complete-problem-2-12-from-your-text-on-page-51-using-the\/","title":{"rendered":"Complete problem 2-12 from your text on page 51 using the"},"content":{"rendered":"<div>\n<p>Complete Problem 2-12 from your text on page 51 using the newsvendor.xls file from Book Examples. \u00a0Disregard the instruction to keep the sample value at 150, the news vendor sample size is 30 so leave it at that. \u00a0Your objective is to hone in on the optimal value of of q using trial and error and the news vendor spread sheet. \u00a0Modify the spreadsheet until you are satisfied with your q value and submit it.<\/p>\n<p>\u00a0<\/p>\n<p>2. Complete Problem 2-15 also on page 51 of the text.<\/p>\n<p>\u00a0<\/p>\n<p>NOTE: \u00a0There are 3 challenges to the problem:<\/p>\n<p>\u00a0<\/p>\n<p>1. Designing a spreadsheet from scratch that models the structure (flow) of the system. (you must derive an equation that represents the word problem)<\/p>\n<p>\u00a0<\/p>\n<p>2. Designing the spreadsheet to model stochastic behavior of the system (randomness)<\/p>\n<p>\u00a0<\/p>\n<p>3. Designing the spreadsheet to model 30 iterations of the equation resulting in a 30 row simulation.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Complete Problem 2-12 from your text on page 51 using the newsvendor.xls file from Book Examples. \u00a0Disregard the instruction to keep the sample value at 150, the news vendor sample size is 30 so leave it at that. \u00a0Your objective is to hone in on the optimal value of of q using trial and error [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-10443","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/10443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=10443"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/10443\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=10443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=10443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=10443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}