{"id":71859,"date":"2021-11-07T12:54:16","date_gmt":"2021-11-07T12:54:16","guid":{"rendered":"https:\/\/papersspot.com\/blog\/2021\/11\/07\/build-a-spreadsheet-evaluative-model\/"},"modified":"2021-11-07T12:54:16","modified_gmt":"2021-11-07T12:54:16","slug":"build-a-spreadsheet-evaluative-model","status":"publish","type":"post","link":"https:\/\/papersspot.com\/blog\/2021\/11\/07\/build-a-spreadsheet-evaluative-model\/","title":{"rendered":"Build a spreadsheet evaluative model"},"content":{"rendered":"<p>Create an \u201cevaluative model\u201d for the Bloomex case. <\/p>\n<p>Build a spreadsheet evaluative model that you can use to determine if a given shipping plan satisfies Bloomex\u2019s business requirements. Outputs from you model should include: Total boxes shipped from each Supply Point <br \/>Total boxes shipped to each Transshipment Center <br \/>Total boxes shipped from each Transshipment Center <br \/>Total boxes shipped to each Demand Point <br \/>Total cost <\/p>\n<p> Set all Decision Variables (shipment quantities) to 1. (Setting all DVs to 1 is a smart way to check model calculations; it is called \u201cThe Ones Test\u201d.) <\/p>\n<p>Case study and required data attached. Please provide solution in the attached excel file on sheet named &#8220;2A) Bloomex Evaluative Model&#8221; <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create an \u201cevaluative model\u201d for the Bloomex case. Build a spreadsheet evaluative model that you can use to determine if a given shipping plan satisfies Bloomex\u2019s business requirements. Outputs from you model should include: Total boxes shipped from each Supply Point Total boxes shipped to each Transshipment Center Total boxes shipped from each Transshipment Center [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10],"class_list":["post-71859","post","type-post","status-publish","format-standard","hentry","category-research-paper-writing","tag-writing"],"_links":{"self":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/71859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/comments?post=71859"}],"version-history":[{"count":0,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/posts\/71859\/revisions"}],"wp:attachment":[{"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/media?parent=71859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/categories?post=71859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/papersspot.com\/blog\/wp-json\/wp\/v2\/tags?post=71859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}