{"id":130334,"date":"2022-10-20T00:00:00","date_gmt":"2022-10-20T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/10\/20\/suppose-that-coca-cola-bottling-plants-are-currently-experiencing-a-situation-in-which-capacity-exceeds-demand-2\/"},"modified":"2022-10-20T00:00:00","modified_gmt":"2022-10-20T00:00:00","slug":"suppose-that-coca-cola-bottling-plants-are-currently-experiencing-a-situation-in-which-capacity-exceeds-demand-2","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/suppose-that-coca-cola-bottling-plants-are-currently-experiencing-a-situation-in-which-capacity-exceeds-demand-2\/","title":{"rendered":"Suppose that Coca Cola bottling plants are currently experiencing a situation in which capacity exceeds demand"},"content":{"rendered":"<div>\n<div>\n<pre><fieldset><legend>Question<\/legend>\n\t<pstyle rgb font-size:=\"\">[8 points] Suppose that Coca Cola bottling plants are currently experiencing a situation in which capacity exceeds demand. List and briefly describe two capacity based and two demand based options for Coca-Cola to address this problem<p><\/p><p>Capacity 1\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026.\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p><br>Capacity 2\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..\u2026\u2026\u2026\u2026\u2026\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p><br>Demand 1\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..\u2026\u2026\u2026\u2026<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p><br>Demand 2 \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026...\u2026\u2026\u2026..<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026..<\/p><p><br>Gall\u2019s firm has the following supply, demand, cost, and inventory data. Allocate production capacity to meet demand at a minimum cost.<\/p><p>Month Forecast Demand Regular Time<br>Capacity Overtime Capacity Subcontract<br>Capacity<br>February 500 400 80 100<br>March 650 400 80 100<br>April 700 500 100 100<br>May 450 500 100 100<\/p><p>Beginning Inventory (BI) = 200 units, held at zero cost.<br>Regular Time (RT) cost = $1 per unit.<br>Overtime (OT) cost =$1.50 per unit.<br>Subcontract (SC) cost = $2 per unit.<br>Back-order cost = 50 cents per unit per month.<br>Holding cost = 20 cents per unit per month.<\/p><p>Find the optimal plan and place it in the diagram on the next page? (12 points) <br>?<br>Requested in Month<br>Supplied<br>from February<br>March<br>April<br>May<br>Unused Capacity<br>Left Total Capacity Available<br># $ # $ # $ # $ <br>B. I. <br>RT Feb <br>OT Feb <br>SC Feb <br>RT Mar <br>OT Mar <br>SC Mar <br>RT Apr <br>OT Apr <br>SC Apr <br>RT May <br>OT May <br>SC May <br>Demand <br><br><br><br><br><\/p><p>Find the total cost in $s? [3 points]<\/p><p><br>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026\u2026\u2026\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<\/p><p><br>[16 points] Consider the following Bill of Materials and MPS for the assembly of Item Cart. <br><br>Part Projected Inventory Units On Hand Lead Time (days) Made of items Lot Size<br>Cart 0 2 Axle + Box LFL<br>Axle 10 1 2 Wheels LFL<br>Box 5 2 Axle + Frame LFL<br>Wheel 70 3 bought 100<br>Frame 5 4 bought 20<\/p><p>There are no Scheduled Receipts.<br>Note: not all items are Lot-for-Lot. (LFL)<\/p><p>MPS: You have received only one order to deliver 15 finished carts from your factory on Day 10. <br><br>Draw the Bill of Materials below (1 point)<\/p><p><br><\/p><p><br><\/p><p><br><\/p><p><br><\/p><p><br><\/p><p><br>Please complete the following Gross Materials Requirements Plan (MRP) tables on the next page. (15 points \u2013 3 per sheet)<\/p><p>Abbreviations<br>GR = Gross Requirements<br>POH = Projected On Hand<br>NR = Net Requirements<br>POR = Planned Order Requirements<br>POR = Planned Order Release?<br>Part Day1 Day2 Day3 Day4 Day5 Day6 Day7 Day8 Day9 Day10<br>Cart GR <br>POH <br>NR <br>POR <br>POR <br>Axle GR <br>POH <br>NR <br>POR <br>POR <br>Box GR <br>POH <br>NR <br>POR <br>POR <br>Wheel GR <br>POH <br>NR <br>POR <br>POR <br>Frame GR <br>POH <br>NR <br>POR <br>POR <br>Huckaby Motor Services, Inc. rebuilds small electrical items such as motors, alternators, and transformers, all using a certain type of copper wire. The firm's demand for this wire is approximately normal, averaging 20 spools per week, with a standard deviation of 6 spools per week. The purchase cost per spool is $24; ordering costs are $25 per order; inventory holding cost is $4.00 per spool per year. Acquisition lead time is four weeks. The company works 50 weeks per year, each week has 5 working days.<br>What is the EOQ for the spools in units<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.<\/p><p>What are the safety stock and reorder point if the desired service level is 90%?<\/p><p>Safety Stock = \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<\/p><p><br>ROP = \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<br><br>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..\u2026\u2026\u2026..\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026.\u2026<\/p><p>What are the total overall costs for the year?<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..\u2026\u2026\u2026..\u2026\u2026\u2026\u2026<\/p><p>What is the company\u2019s annual inventory turnover?<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<\/p><p>How would the reorder point change if a higher service level is desired? (<\/p><p>\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.\u2026\u2026\u2026\u2026.<\/p><p>Why?<\/p><p><br>Formulae<br>Inventory for Fixed Quantity Inventory Systems with Continuous Monitoring: <br>EOQ = ?((2*D*S)\/H) Note: use the same units of time in all equations<\/p><p>Where D is the annual demand, S is the ordering cost per order, and H is the annual holding per unit.<\/p><p>Orders per year = N = D\/EOQ;<\/p><p>Time between orders = T = 250\/N where there are 250 working days in a year.<\/p><p>Safety Stock (SS) = Z * ?((LT*?_d^2+d^2*?_LT^2))<br>Where LT is the average lead time, d is the average demand, ?_d^ is the standard deviation of demand, and ?_LT^ is the standard deviation of lead time.<\/p><p>Reorder Point (ROP) = d * LT + SS<\/p><p>Average Inventory level = EOQ\/2 + SS<\/p><p>Inventory Turnover = (Annual Demand)\/(Average Inventory)<\/p><p>Annual Ordering Cost = N * S<\/p><p>Annual Holding Cost = Average Inventory Level * H<\/p><p>Total Annual Inventory Cost = Annual Ordering Cost + Annual Holding Cost<\/p><p>Total Annual Cost = Annual Ordering Cost + Annual Holding Cost + (Unit purchase cost) * D<\/p><p>Z Factors for Specified Service Levels (% certainty of not running out of inventory):<\/p><p>Service Level Z Factor<br>50% 0.000<br>80% 0.842 <br>85% 1.036 <br>90% 1.282 <br>95% 1.645 <br>99% 2.326<\/p><\/pstyle>\t<\/fieldset><\/pre>\n<div>Buy Answer<\/div>\n<\/p><\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Question [8 points] Suppose that Coca Cola bottling plants are currently experiencing a situation in which capacity exceeds demand. List and briefly describe two capacity\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8827,10099,10540,10536,10892,10538,10539,10537,10891],"tags":[10549,10616,10615,7687,10627,8857,10552,10295,10548,10622,8907],"class_list":["post-130334","post","type-post","status-publish","format-standard","hentry","category-australia-essays","category-buy-essay","category-cheap-essay-writers","category-get-assignments-done","category-page-paper","category-phd-essay-writers","category-research-paper-writing-service-for-any-topic","category-study-bay-essay","category-write-my-assignment-ireland","tag-ai-plagiarism-free-essay-writing-tool","tag-australian-best-tutors","tag-best-trans-tutors","tag-buy-essay-uk","tag-cheap-dissertation-writer","tag-help-with-writing-an-essay","tag-help-write-my-paper-ai-free","tag-homework-for-you","tag-online-essay-writers","tag-phd-essays","tag-write-my-essay-for-me"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/130334","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=130334"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/130334\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=130334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=130334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=130334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}