Deliverable - Please work individually on this assignment - Submit a MS Word or document file that includes your answers to each question. - Keep answers concise but be sure to provide enough detail to convey understanding. 1. Give either a market scenario or your personal experience with the impact of competitive advantage using network-based strategies. We covered a few examples in class, so please provide a unique scenario. 2. In the context of a break-even analysis and Porter's competitive forces, provide your observations for the following caselet: I believe that high-speed electric motors are the next greatest thing for boating. I estimate that initial fixed cost for rotor casting and assembly, the frame manufacturing, and process control system will cost $3,500,000. Each unit requires two electric motors, two counterrotating propellers, rod assembly and casing, as well as other overhead, which I estimate will cost $32,500. Order fulfillment for each motor will cost $3,250. I will be first-to-market, so I think I can sell it for at least $42,000 each! For each prospective product: a. Given the values above, how many should I sell at minimum and why? Use the formula provided in Lecture 01 to show your work. b. Comment on one competitive force from Porter's that is relevant. Be sure to note if its high/low. 3. Recall our Lecture 02 discussion: provide a few sentences on your personal interaction as a consumer with a business process. Be sure to share some insight on one other "aspect" of this interaction as discussed in class. 4. Regarding Supply chain awareness: provide an outcome that could result from push-based supply chain model (i.e. build-to-stock)? Provide one improvement that is offered by a pullbased supply chain model (i.e. demand-driven)? You must prepare an analysis of how each customer's monthly charges will change under the updated cost and price. Ideally, profitability will remain the same. Create a spreadsheet that shows the monthly charges under the current monthly cost and price, the updated monthly cost and price, the euro amount of change with the updated pricing, and the percent of change with the updated pricing. Use the data in the spreadsheet. Be sure to follow the spreadsheet guidance provided in the last two lectures. a) Please complete the template using "VLOOKUP" formulas for the current monthly cost, current monthly price, and updated monthly cost, with reference to values (ie. not embedding static numbers) b) Please complete the template using an "IF" formula for updated monthly price with reference to values (ie. not embedding static numbers). c) Create a graph to compare the percent change for each customer. It will provide Crepitas LNG Distribution (CGD) a good visual indicator of how much the updated cost and pricing will impact each customer. Use customers as the X axis (horizontal) and percentages as the Y axis (vertical). d) Interpret the results. Does this make sense for Crepitas LNG Distribution (CGD)? Why or why not? Explore what you know from class. Layout for your Reference (i.e. graph uses example data; it does NOT provide the answer) Deliverable - Please work individually on this assignment - Submit a MS Word or document file that includes your answers to each question. - Keep answers concise but be sure to provide enough detail to convey understanding. 1. Give either a market scenario or your personal experience with the impact of competitive advantage using network-based strategies. We covered a few examples in class, so please provide a unique scenario. 2. In the context of a break-even analysis and Porter's competitive forces, provide your observations for the following caselet: I believe that high-speed electric motors are the next greatest thing for boating. I estimate that initial fixed cost for rotor casting and assembly, the frame manufacturing, and process control system will cost $3,500,000. Each unit requires two electric motors, two counterrotating propellers, rod assembly and casing, as well as other overhead, which I estimate will cost $32,500. Order fulfillment for each motor will cost $3,250. I will be first-to-market, so I think I can sell it for at least $42,000 each! For each prospective product: a. Given the values above, how many should I sell at minimum and why? Use the formula provided in Lecture 01 to show your work. b. Comment on one competitive force from Porter's that is relevant. Be sure to note if its high/low. 3. Recall our Lecture 02 discussion: provide a few sentences on your personal interaction as a consumer with a business process. Be sure to share some insight on one other "aspect" of this interaction as discussed in class. 4. Regarding Supply chain awareness: provide an outcome that could result from push-based supply chain model (i.e. build-to-stock)? Provide one improvement that is offered by a pullbased supply chain model (i.e. demand-driven)? You must prepare an analysis of how each customer's monthly charges will change under the updated cost and price. Ideally, profitability will remain the same. Create a spreadsheet that shows the monthly charges under the current monthly cost and price, the updated monthly cost and price, the euro amount of change with the updated pricing, and the percent of change with the updated pricing. Use the data in the spreadsheet. Be sure to follow the spreadsheet guidance provided in the last two lectures. a) Please complete the template using "VLOOKUP" formulas for the current monthly cost, current monthly price, and updated monthly cost, with reference to values (ie. not embedding static numbers) b) Please complete the template using an "IF" formula for updated monthly price with reference to values (ie. not embedding static numbers). c) Create a graph to compare the percent change for each customer. It will provide Crepitas LNG Distribution (CGD) a good visual indicator of how much the updated cost and pricing will impact each customer. Use customers as the X axis (horizontal) and percentages as the Y axis (vertical). d) Interpret the results. Does this make sense for Crepitas LNG Distribution (CGD)? Why or why not? Explore what you know from class. Layout for your Reference (i.e. graph uses example data; it does NOT provide the answer)