EMBRY RIDDLE LGMT683 ALL ASSIGNMENTS

Submit your answers to the following textbook discussion questions:

Chapter 1: Questions 2 and 6.

Submit your answers to the following textbook discussion questions:

• Chapter 2: Question 6
• Chapter 3: Questions 5 and 7

Submit your answers to the following textbook discussion questions:

• Chapter 4: Questions 4, 5, and 6
• Chapter 5: Questions 6 and 7

Chapter 5: Network Design in the Supply Chain

Right click and save the Sun Oil Exceldemo to your hard drive.

If the demand in Asia doubles, what happens to the total cost and what is the best configuration of plants for Sun Oil under these conditions? Note: Use the “Solver” capability under the ”Tools” menu (but you need to change the demand for Asia in cell E9 from 16 to 32 prior to running “Solver”).

*Note on using the “Solver" Add-In:The Solver Add-in is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. Instructions for doing so were included within the module.

Submit your answers to the following textbook discussion questions:

• Chapter 6 - Question 1
• Chapter 7 - Question 2

Submit your answers to these additional textbook exercises:

• Chapter 6:Exercise 2
• Chapter 7: Exercise 2

Submit your answers to the following textbook discussion questions:

• Chapter 8 - Question 3
• Chapter 9 - Questions 1, 2 and 4.

Chapter 8: Aggregate Planning in a Supply Chain

1. Right click and save the Red Tomato Demo to your hard drive.

Using the original data in the file, what happened to inventory and stockouts over the six periods of the planning horizon?

2. Right click and save the Red Tomato Demo for Example 1 to your hard drive.

What happened to stockouts as demand fluctuation increased? What happened to profits? What did you learn from this exercise?

3. Right click and save the Red Tomato Demo for Example 2 to your hard drive.

What happened to the use of subcontractors as holding costs increased? What happened to profits? What did you learn from this exercise?

Submit your answers to the following textbook discussion questions:

• Chapter 11 - question 7
• Chapter 12- question 1,3, and 5

Chapter 12: Managing Uncertainty in a Supply Chain: Safety Inventory

1. Using the Wal-Mart Demo for Example 4, what happens to the Required Safety Stock inventory when the Desired Customer Service level is increased to 95%? What happens to the Required Safety Stock inventory when the Desired Customer Service level is decreased to 80%? What about 70%? What did you learn from this exercise?

Note: This is not a “Solver” problem. Just change the service level directly in Excel from .90 to .80 and .70 to see the impact on safety inventory.

2. Using the Wal-Mart Demo, what happens to the Required Safety Stock inventory when the periodic review interval is changed to quarterly, i.e., 12 weeks versus 4 weeks? What happens when it is changed to weekly, i.e., 1 week versus 4 weeks? What did you learn from this exercise?

Note: This is not a “Solver” problem. Just change the Review Interval directly in Excel from 4 weeks to 12 weeks to 1 week, respectively.

Submit your answers to the following textbook discussion questions:

• Chapter 13 - Questions 4 and 7
• Chapter 14 - Questions 3 and 4

Submit your answers to the additional Homework exercises for Chapter 13.

Chapter 13: Determining the Optimum Level of Product Availability

Using the Sportmart Demo, the manager decided to conduct market research and, based on the additional information she obtained from the research, she believes that the standard deviation of demand can be reduced to 50 instead of 100. What is the impact of profitability? What happens to profitability if the standard deviation of demand increases to 150? What did you learn from this exercise?

Submit your answers to the following textbook discussion questions:

• Chapter 15 - Questions 5 and 8
• Chapter 16 - Question 5
• Chapter 17 - Questions 2 and 4

Submit your answers to the additional Homework exercises for Chapters 15 and 16.

Chapter 15: Sourcing Decisions in a Supply Chain

1. After reviewing the last three lines of Table 15-4 in your text, as the buy-back price for each disc increases from $0 to $6 while the wholesale price is held constant at $7, what happens to profits for the music store (the retailer) and the supplier (the manufacturer)? What about overall supply chain profitability? What is the lesson to be learned from this exercise?

The information presented in Table 15-4 assumes that there are no costs associated with returning the “buy-back” products to the supplier. As the transportation costs to return the goods being bought back increases, what happens to the profitability of the supply chain?

Chapter 16: Pricing and Revenue Management in a Supply Chain

2. Right click and download the Pricing to Multiple Segments data to your hard drive. What happens to prices and profitability when the sensitivity for customers that are willing to wait (i.e., segment 2) increases from 40p1 to 80p1? What did you learn from this exercise?

Note: Use the “Solver” capability under the ”Tools” menu (but you must set sensitivity in cell C6 to desired level before you run “Solver”).

3. Right click and download the Dynamic Pricing Data to your hard drive. What happens to the quantity purchased and profitability if the price sensitivity increases to from 1.8p3 to 1.9p3 in the third period? What did you learn from this exercise?

Note: Use the “Solver” capability under the ”Tools” menu (but you must set sensitivity in cell C8 to desired level before you run “Solver”).

*Note on using the “Solver" Add-In:The Solver Add-in is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. You should have completed doing so in Module 3.

Submit your answers to the following textbook discussion questions:

Chapter 18: Questions 3 and 6.