{"id":32203,"date":"2026-06-19T03:00:12","date_gmt":"2026-06-19T03:00:12","guid":{"rendered":"https:\/\/academicwritersbay.com\/solutions\/msda-628-provide-chain-enterprise-analytics-module-1-project-frequent-requirement-be-particular-that-every-advise-sub-advise-is-on-its-occupy-worksheet-you\/"},"modified":"2026-06-19T03:00:12","modified_gmt":"2026-06-19T03:00:12","slug":"msda-628-provide-chain-enterprise-analytics-module-1-project-frequent-requirement-be-particular-that-every-advise-sub-advise-is-on-its-occupy-worksheet-you","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/solutions\/msda-628-provide-chain-enterprise-analytics-module-1-project-frequent-requirement-be-particular-that-every-advise-sub-advise-is-on-its-occupy-worksheet-you\/","title":{"rendered":"MSDA 628 Provide Chain Enterprise Analytics\u00a0 Module 1 Project\u00a0 Frequent requirement\u00a0 \u2022 Be particular that every advise\/sub-advise is on its occupy worksheet.\u00a0 \u2022 Your Excel mannequin desire to be executable. In case your excel mannequin is ran"},"content":{"rendered":"

MSDA 628 Provide Chain Enterprise Analytics <\/strong><\/p>\n

Module 1 Project <\/strong><\/p>\n

Frequent requirement<\/u> <\/strong><\/p>\n

\u2022 Be particular that every advise\/sub-advise is on its occupy worksheet. <\/p>\n

\u2022 Your Excel mannequin desire to be executable. In case your excel mannequin is ran, it could well restful generate the\u00a0 identical outcomes you put up. That potential the spreadsheet has criminal embedded formulae and\u00a0 Solver dialog containers occupy your complete inputs. If \u2018Solve\u2019 is clicked and your spreadsheet does no longer\u00a0 impact the reported outcomes, a 0 find will probably be assigned to that advise. <\/p>\n

\u2022 It’s probably you’ll per chance occupy to restful use lecture examples as templates to resolve the project considerations. <\/strong>\u2022 Title the Excel file as \u201cHomework 1_Last Title.xlsx\u201d. <\/p>\n

\u2022 Please contact the teacher if it’s probably you’ll per chance occupy any questions referring to the project. <\/p>\n

Advise 1 <\/strong><\/p>\n

The Weinberger Electronics Company manufactures four extremely technical merchandise that it\u00a0 gives to aerospace companies that take care of NASA contracts. Every of the merchandise need to trudge by the\u00a0 following departments forward of being shipped: wiring, drilling, assembly, and inspection. The time\u00a0 requirement in hours for every unit produced and its corresponding profit label are summarized in\u00a0 the next desk: <\/p>\n

PRODUCT <\/strong><\/p>\n

DEPARTMENT XJ201 XM897 TR29 BR788 <\/strong><\/p>\n

Wiring <\/strong>0.5 1.5 1.5 1.0 <\/p>\n

Drilling <\/strong>0.3 1.0 2.0 3.0 <\/p>\n

Meeting <\/strong>0.2 4.0 1.0 2.0 <\/p>\n

Inspection <\/u><\/strong>0.5 1.0 0.5 0.5 <\/p>\n

Unit Profit ($) <\/strong>8.0 10.0 11.0 9.0 <\/p>\n

The manufacturing on hand in every department every month and the minimal monthly manufacturing\u00a0 requirement to satisfy contracts are as follows: <\/p>\n

DEPARTMENT <\/sub>CAPACITY <\/strong><\/p>\n

(HOURS) <\/sub>PRODUCT <\/strong><\/p>\n

MINIMUM \u00a0PRODUCTION \u00a0LEVEL <\/strong><\/p>\n

Wiring <\/strong>16,000 XJ201 <\/strong>5000 Drilling <\/strong>17,500 XM897 <\/strong>3000 Meeting <\/strong>27,000 TR29 <\/strong>2000 Inspection <\/strong>10,000 BR788 <\/strong>500<\/p>\n

1 <\/p>\n

The manufacturing supervisor has the accountability of specifying manufacturing ranges for every product for\u00a0 the arrival month. Exhaust Excel spreadsheet to resolve Weinberger\u2019s profit-maximization advise\u00a0 the use of LP. <\/p>\n

Advise 2 <\/strong><\/p>\n

A surprising compose bigger in the demand for smoke detectors has left Hanson Alarms with insufficient\u00a0 ability to meet demand. The firm has considered its monthly demand for digital and battery powered smoke detectors rise to 25,000 and 12,500, respectively. Tommy Hanson, the CEO of\u00a0 Hanson Alarms, has urged his COO Julia Hanson that the firm need to constantly meet demand for\u00a0 its merchandise. Hanson\u2019s manufacturing route of involves three departments: fabrication, assembly, and\u00a0 shipping. The ideas for manufacturing and costs is summarized below. <\/p>\n

Hours required to blueprint 1 unit <\/strong><\/p>\n

DEPARTMENT Electronic powered Battery powered <\/sub>Month-to-month Hours \u00a0Readily available <\/strong><\/p>\n

Fabrication 0.25 0.15 3,000 Meeting 0.30 0.25 4,500 Birth 0.18 0.20 3,200 Variable cost\/unit <\/strong>$18.00 $15.80 <\/p>\n

Retail label <\/strong>$29.50 $27.50 <\/p>\n

The firm also has the blueprint to occupy additional devices from a subcontractor, The ChrisJones\u00a0 Company, who has provided to provide up to 21,000 devices monthly in any combination of digital\u00a0 and battery-powered devices, at a price of $21.5 per unit. For this label, ChrisJones will assembly,\u00a0 check, and ship its devices at as soon as to the distributors without the use of Hanson\u2019s manufacturing route of.\u00a0 Exhaust Excel spreadsheet to discover the optimum portions to compose and\/or aquire that will maximize\u00a0 profit. <\/p>\n

(Hint<\/strong>: For making or buying for a product, Unit profit = Unit retail label \u2013 Unit Price)<\/p>\n

2 <\/p>\n","protected":false},"excerpt":{"rendered":"

MSDA 628 Provide Chain Enterprise Analytics Module 1 Project Frequent requirement \u2022 Be particular that every advise\/sub-advise is on its occupy worksheet. \u2022 Your Excel mannequin desire to be executable. In case your excel mannequin is ran, it could well restful generate the\u00a0 identical outcomes you put up. That potential the spreadsheet has criminal embedded […]<\/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-32203","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=32203"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/32203\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=32203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=32203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=32203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}