instructions, Guidelines, and Insights 1. Please do not delete any of the content provided within this project template 2. This week project oves mateial from Chapter 3 and 4 3. Respond to the two inquicies below the Responses plaetition following the second inquiry 4. The best inquies relates to Chapter 3 and the second inquiry pertains to Chapter 4 5. The two inguines se independent; thus, only rely on informations provided in try to respond to inquiry i and only rely on the information provided in Taney 2 tey respond to In qony 3. Da note any infomation provided for Inquiry i to respond to inquiry 2 and toe tetos 6. Save your work using the last name, first name (Project Part 2) format, for example, if John Dos vere a scholar in our class, John's file name would be Doe John (Project Week 2) Then upload the assignment to its Moodle deop-box by its due date and there Scenario doobos Caf, Incorporated, is a specialty coffee shop that sells premium coffee and coffee-related products to coffee connoisseus. While Moosbus had its start as a small local cafe in Mount Olive, North Carolina (USA), the company has experienced substantial angional growth and is soon to embark on a campaign to further grow its business nationally and, if things go well, internationally Inquiries Inquiry 1: Historical demand for Megabux best-selling product to provided in the table below: Units Sold 1,500 Month May June July August September October November 1,400 1,800 1 500 1,900 1,800 222 Forecasting for November, the logisties manager has calculated the simple 4-month moving average (1875 units) and Mean Absolute Deviation (125 units) and (b) a three-month weighted moving average weights:0:50, 0:20, and 0.30) of 1920 units and Mean Absolute Deviation of 247 Dats The plant manager asks for your assistance to make sense of these numbers". In one well- articulated paragraph of 5 to 8 sentences (no more and no lesa), explain to the plant manager how Normal I No Spac. Heading 1 Heading 2 2 N Styles the two forecasts were calculated be sure to include wo). Also, for the plant manager bei include a brief explanation - also po www ws of which of the two font believed to be more reliable Inquaky 2 (independent otiu, not related to - Inquiey 1); Moombox, tee, va consideung the possibility of building an additional factory that we proche mex nadition to its product lines. The company is currently considering two options The best is a small boility that it could build at a cost of $6 million. If demand for products at low, the company expects to receive $9 million in discountere present value of future evremuet) with the small facility. On the other hand, if demand is highly in expects $14 million in discounted revenue using the small facility The second option is to build a large factory at a cost of $8 million Were demand to be low, the company would expect $14 million in discounted revenues with the lange plant to demand is high, the company estimates that the discounted revenues would be $15 million The third caption is Do Nothing (note: "Do Nothing" is always an option) In either case, the probability of demand being high is 0.60, and the probability of it being low is 0:40. Not constructing a new factory would result in no additional severoe being generated because the current faktories cannot produce these new products Noora President send the Net Present Value (NPV) calculations in millions of SU S. to the plant manager, supply chain manager and logistics manager who in teen recoest your insights. NRY Anllions $U.S. 6.0 Small Facility Large Faculity 6.6 Do Nothing 0.0 In one sel-artierulated pangraph of 5 to 8 sentences no less and no more), in your we weris (not those of a textbook or vebsate) explain which of the three mutually exclusive alternative plans should be selected based on Net Present Value Include in your well-articulated paragraph the formulas tut may be used to calculate each plan's NPV. Responses Response 1 Response 2 I w 77% 16 instructions, Guidelines, and Insights 1. Please do not delete any of the content provided within this project template 2. This week project oves mateial from Chapter 3 and 4 3. Respond to the two inquicies below the Responses plaetition following the second inquiry 4. The best inquies relates to Chapter 3 and the second inquiry pertains to Chapter 4 5. The two inguines se independent; thus, only rely on informations provided in try to respond to inquiry i and only rely on the information provided in Taney 2 tey respond to In qony 3. Da note any infomation provided for Inquiry i to respond to inquiry 2 and toe tetos 6. Save your work using the last name, first name (Project Part 2) format, for example, if John Dos vere a scholar in our class, John's file name would be Doe John (Project Week 2) Then upload the assignment to its Moodle deop-box by its due date and there Scenario doobos Caf, Incorporated, is a specialty coffee shop that sells premium coffee and coffee-related products to coffee connoisseus. While Moosbus had its start as a small local cafe in Mount Olive, North Carolina (USA), the company has experienced substantial angional growth and is soon to embark on a campaign to further grow its business nationally and, if things go well, internationally Inquiries Inquiry 1: Historical demand for Megabux best-selling product to provided in the table below: Units Sold 1,500 Month May June July August September October November 1,400 1,800 1 500 1,900 1,800 222 Forecasting for November, the logisties manager has calculated the simple 4-month moving average (1875 units) and Mean Absolute Deviation (125 units) and (b) a three-month weighted moving average weights:0:50, 0:20, and 0.30) of 1920 units and Mean Absolute Deviation of 247 Dats The plant manager asks for your assistance to make sense of these numbers". In one well- articulated paragraph of 5 to 8 sentences (no more and no lesa), explain to the plant manager how Normal I No Spac. Heading 1 Heading 2 2 N Styles the two forecasts were calculated be sure to include wo). Also, for the plant manager bei include a brief explanation - also po www ws of which of the two font believed to be more reliable Inquaky 2 (independent otiu, not related to - Inquiey 1); Moombox, tee, va consideung the possibility of building an additional factory that we proche mex nadition to its product lines. The company is currently considering two options The best is a small boility that it could build at a cost of $6 million. If demand for products at low, the company expects to receive $9 million in discountere present value of future evremuet) with the small facility. On the other hand, if demand is highly in expects $14 million in discounted revenue using the small facility The second option is to build a large factory at a cost of $8 million Were demand to be low, the company would expect $14 million in discounted revenues with the lange plant to demand is high, the company estimates that the discounted revenues would be $15 million The third caption is Do Nothing (note: "Do Nothing" is always an option) In either case, the probability of demand being high is 0.60, and the probability of it being low is 0:40. Not constructing a new factory would result in no additional severoe being generated because the current faktories cannot produce these new products Noora President send the Net Present Value (NPV) calculations in millions of SU S. to the plant manager, supply chain manager and logistics manager who in teen recoest your insights. NRY Anllions $U.S. 6.0 Small Facility Large Faculity 6.6 Do Nothing 0.0 In one sel-artierulated pangraph of 5 to 8 sentences no less and no more), in your we weris (not those of a textbook or vebsate) explain which of the three mutually exclusive alternative plans should be selected based on Net Present Value Include in your well-articulated paragraph the formulas tut may be used to calculate each plan's NPV. Responses Response 1 Response 2 I w 77% 16