In-program SAS competition for BAIMer at Purdue University.
Building T is the corporate headquarters of the XYZ Corporation. The water used in Building T comes from two sources. The first source is through The Water Co., where like other businesses in the area, the XYZ Corporations has a contract in place with The Water Co. to provide water to their Building T at a contracted price per gallon.
The second source is through XYZ’s own Water Storage Tank. Precipitation is collected, treated, stored, and used to supply water to Building T, and there is a per-gallon cost associated with this process.
XYZ Corporation has hired your team of consultants to provide solutions to water allocation at Building T.
SAS Studio
- Mua-Hua Hsu
- Yi-Hsuan Hsu
- Su-Tien Lee
- Li-Ci Chuang
- Objective 1 - Forecasting
- How many total gallons of water is Building T expected to use in each of the next four weeks?
- Objective 2 - Optimization
- How many gallons will XYZ buy from The Water Co. each week?
- How many gallons will XYZ use from their Water Storage Tank each week?
- What is XYZ’s projected total water cost at the end of the next four weeks?
- What is XYZ’s projected ending Water Storage Tank inventory at the end of each week?
- How much money will XYZ save by choosing the recommended contract over the alternative contract?
- How many more/less gallons will be in the Water Storage Tank at the end of the four-week period compared to if the alternative contract was chosen?
- Objective 1 - Forecasting
- SAS: Additive Season
- SAS: Additive Winter Excel
- SAS: Random Walk
- Minitab
- Excel
- Python: ARIMA
- Python: SARIMAX
- Python: Holt-Winters
- Objective 2 - Optimization
- Identify model objectives and constraints
- Turn into mathematical formulas
- Set up on SAS
- Run the solution on SAS
- Alternative set
- Conclusion and suggestion