I’m stuck on a Supply Chain question and need an explanation.

Need help as soon as possible, will provide all information below! Please read the question before accepting! If you can do the work, I can extend it for five more hours.

a) You must use information and data provided in the problem statements below as the starting point for your

solutions. If you use information and data that is not in the problem statements (for example, if the numbers

you use in Problem 3 are different from the numbers that are provided in the problem statement), then we

would regard this as “irregular” behavior and give you “0” for the exam score, and request that you meet

with us to clarify the irregularity.

b) You are required to create and implement a project plan for completing the midterm. Keep track of your

progress and draw conclusions on how well you are able to follow your project plan. Include your project

plan as part of your midterm solution.

c) Create your own “template” for the structured Problem-Solving Process. Then use this Structured Problem Solving Process for solving all problems on the Midterm.

d) As part of your problem-solving approach, make appropriate assumptions when necessary, and clearly

state the assumptions you make. Be sure to revisit these assumptions when drawing conclusions.

e) Be sure to explain everything all your work. To improve readability of your explanations, structure your

work with appropriate captions/headings.

f) In addition to headings, all explanatory text must be accompanied by clearly labeled figures, tables, and

diagrams as necessary. Also, key points, results, and conclusions should be clearly marked (e.g.,

highlighted, underlined, etc.)

g) All results, recommendations, and conclusions must be supported by facts (evidence) and/or analysis. To

improve readability, include appendices at the end of each problem to show relevant details.

h) Cite all relevant sources of information, including the case study handed out as part of this midterm.

Note: The Case Study (required for Problem 2 below) is available on Canvas.

READING (0.5 HOURS)

First read the Specialty Packaging Corporation (SPC) Case Study (provided on the following two

pages.)

PROBLEM 1: PLANNING

Create a plan and time-schedule for on the problems below. Also, using an appropriate table (see

Problem 6 below), track how well you execute your schedule, and make notes on obstacles and

problems that prevent effective execution.

PROBLEM 2: SUPPLY CHAIN STRATEGY FOR SPC

What should SPC’s competitive strategy be? What should SPC’s supply chain strategy be to align

with its competitive strategy? Where does SPC lie in the zone of strategic fit between IDU and

responsiveness? What should SPC’s high-level SC strategy be for each of the supply chain drivers?

PROBLEM 3: DEMAND FORECASTING FOR SPC

Use the structured systematic problem-solving approach on this problem, and make sure to provide

clear reasoning and explanations to support “everything” you do. Depending on the number of

smoothing constants in your forecasting method use one or all of the following smoothing constants:

alpha=0.06, beta=0.06, gamma=0.06.

First, form a hypothesis (conjecture) as to which forecasting method Julie Williams should use for

clear plastic, and be sure to explain the basis (rationale) for your hypothesis. Then, test your

hypothesis by implementing all five forecasting techniques that you’ve learned. Which technique

should Julie Williams use for forecasting the demand for clear plastic based on the results of your

implementation of the five forecasting techniques? Was your hypothesis correct?

Page 2 of 2

What is the demand forecast for clear plastic for each of the four quarters of the year 2007? What is

the annual demand for the year 2007? You will need this information for the next task below.

(Important Note: to get credit for this problem, you should work with clear plastic demand data only)

PROBLEM 4: CYCLE INVENTORY FOR POLYSTYRENE AT SPC

Why should SPC have a cycle inventory? SPC buys polystyrene resin from a supplier in 1000-pound

units, and each unit costs $30.00, and the percent holding cost is 12%. The fixed shipping cost per

order is $250. If we assume that 1000 pounds of resin yields 1000 pounds of clear plastic, what are

the following values for clear plastic:

a) Lot size per shipment to minimize total cost

b) Economic order quantity (EOQ)

c) Number of shipments/year for polystyrene resin in order to meet the forecasted demand for

clear plastic in 2007

d) Cycle inventory

e) Cycle inventory holding cost

f) Replenishment cycle time

g) Average flow time

Use a diagram showing clear plastic inventory as a function of time to illustrate these values.

Read the section in the SCM text on Short-Term Discounting (SCM, Third Edition, Section 10.4 or

Fourth Edition, Section 10.5), and then answer the following question. If the supplier offers a

promotional discount of 30% per unit at the beginning of the year, what is the optimal order quantity,

and how much should the forward buy on polystyrene be? (Be sure to carefully check your answer).

PROBLEM 5: SAFETY INVENTORY FOR POLYSTYRENE RESIN AT SPC

(Note: This problem does not require any knowledge of safety inventory theory, which we will study

later in the course.) Should SPC have a safety inventory? Why? Formulate a simple and rational

approach for specifying how much safety inventory SPC should hold. Based on this approach, how

much safety inventory should SPC hold?

PROBLEM 6: EXECUTION OF YOUR PLAN

Using a table compare your plan from Problem 1 (column 1) with its execution (column 2). Indicate

the reasons for the difference between the plan and its execution (column 3). Add at least one more

column. What should column 4 contain?

Requirements: multiple pages