Confederated Pulp & Paper
Executive Summary
The problem is to determine the optimal wood pile size to minimize costs for CPP. The key issue is that the number of days the river is frozen varies each year, and thus the amount of wood that will be needed in the stockpile for the winter will also vary. The solution is the optimal amount of wood that should be stockpiled in order to minimize the costs associated with both purchasing additional wood later and holding wood over to the next year.
Model
Decision: Pile size, and thus number of days of available wood, to stockpile.
Objective: Optimize pile size to minimize costs associated with providing wood, given that the number of days the river is frozen is random.
Constraints: Weekly demand is 4800.
Assumptions:
- The $2 stockpiling fee is paid at the same time that the $8 shipping fee and $23 variable cost are incurred.
-All logs cut have to go to stockpile, can’t send directly to mill
-Stockpiling fees given include time value of money
- Given relatively few historical data points, normal distribution is the most accurate way to estimate the number of days needed.
- Costs remain the same at different volume levels
- Cost of capital remains constant at 20%
Analysis
Using the provided data, we started by calculating the average and standard deviation of the number of days the river freezes.
Using these figures, we created a normal distribution and then calculated the number of days frozen in our simulation, using the random number generator.
We then multiplied the number of days frozen by the demand per day to calculate the number of cunits of wood needed in that year.
Next, using our decision variable of “Cunits of wood” produced, we multiplied the variable costs per unit (cutting + shipping + stockpiling fee) by the amount produced to determine the costs associated with producing this amount of wood.
Next, using the amount of leftover wood, or amount of extra wood needed, we calculated the costs associated
The problem is to determine the optimal wood pile size to minimize costs for CPP. The key issue is that the number of days the river is frozen varies each year, and thus the amount of wood that will be needed in the stockpile for the winter will also vary. The solution is the optimal amount of wood that should be stockpiled in order to minimize the costs associated with both purchasing additional wood later and holding wood over to the next year.
Model
Decision: Pile size, and thus number of days of available wood, to stockpile.
Objective: Optimize pile size to minimize costs associated with providing wood, given that the number of days the river is frozen is random.
Constraints: Weekly demand is 4800.
Assumptions:
- The $2 stockpiling fee is paid at the same time that the $8 shipping fee and $23 variable cost are incurred.
-All logs cut have to go to stockpile, can’t send directly to mill
-Stockpiling fees given include time value of money
- Given relatively few historical data points, normal distribution is the most accurate way to estimate the number of days needed.
- Costs remain the same at different volume levels
- Cost of capital remains constant at 20%
Analysis
Using the provided data, we started by calculating the average and standard deviation of the number of days the river freezes.
Using these figures, we created a normal distribution and then calculated the number of days frozen in our simulation, using the random number generator.
We then multiplied the number of days frozen by the demand per day to calculate the number of cunits of wood needed in that year.
Next, using our decision variable of “Cunits of wood” produced, we multiplied the variable costs per unit (cutting + shipping + stockpiling fee) by the amount produced to determine the costs associated with producing this amount of wood.
Next, using the amount of leftover wood, or amount of extra wood needed, we calculated the costs associated