[Note: you can preview files that are in PDF format by clicking on the file]
Microsoft Excel
in this project, I built two network optimization models for two problem statements. I built the first model to determine how many cars to be shipped from three production plants to two distribution centers to minimize total shipping costs, and I built the second model to determine how many solar powered air conditioning systems should be produced each month to minimize total unit cost. The detailed description of the two problem statements and my solution (that includes six-step model building process) are included in the PDF file, along with my Excel file that shows how I solve the equations of my model with Excel Solver. You can preview screenshot of my two models in Excel file here:
- First model: (https://user-images.githubusercontent.com/92205707/170787509-7759585a-7725-4ad4-8b86-c92c986c42c0.png)
- Second model: (https://user-images.githubusercontent.com/92205707/170787584-b2ede9a7-a5e1-4a6d-99d4-0ea70b270a4e.png)
in this group project, I was in charge of building mixed binary integer programming model to find the optimal plan of study for a graduate student (i.e. how many courses to take for each semester to finalize thesis project), balancing life and school, and creating a thesis project of the highest level. I was also in charge of formatting the written report (that includes my six-step model building process), explained my model to my teammates, and helped my teammates finalize our written report. The detailed description of the problem statement and my solution are included in the PDF file, along with my Excel file that shows how I solve the equations of my model with Excel Solver. You can preview screenshot of my model in Excel file here:
in this group project, I was in charge of building nonlinear optimization model to find the optimal production, inventory, and subcontracting plan (how many solar panels produced per quarter) to satisfy the demand for the next 4 quarters that I predicted in part b of the problem statemment by building a regression model. I was also in charge of explaning my model to my teammates and helping my teammates finalize our written report. The detailed description of the problem statement and my solution (that includes my six-step model building process) are included in the two PDF files, along with my Excel file that shows how I solve the equations of my model with Excel Solver. You can preview screenshot of my model in Excel file here:
in this project, I analyzed the queueing systems of a hospital before COVID, after COVID, and after Mask Mandate by utilizing queueing model (M/M/s model template) to determine how the system performs under the three aforementioned scenarios, and made recommendations that I believe to be the optimal course of actions that meet the criteria. The detailed description of the problem statement along with my solution (which is the analysis of the system performance under three scenarios and recommendations) can be found in the Excel spreadsheet. You can preview screenshot of my solution before COVID in Excel file here:
- (https://user-images.githubusercontent.com/92205707/170788934-28315a9c-b2f7-4a60-8a05-db24e3961f28.png)
- (https://user-images.githubusercontent.com/92205707/170789093-082aa9df-87ae-4cfe-851e-f215986fccaa.png)
- (https://user-images.githubusercontent.com/92205707/170789229-3feee495-ec66-45ce-acc8-51aa51ca3d1a.png)
in this extra credit project, I built three simulation models for three problem statements (Freddie, Maintenance, and Herr Cutter) to analyze system performance under uncertainty and compute the confidence interval to find the range of the measure of performance.
- For the Freddie problem, I simulated the system to find out how the newspaper order quantity will affect the daily profit and what would be the range of profit that Freddie is expected to generate. You can preview the screenshot of my model and my model's range of profit in Excel file here:
- Model: (https://user-images.githubusercontent.com/92205707/170789491-0a8157ef-245b-44ef-88fe-0c9c9da2b9b3.png)
- Range: (https://user-images.githubusercontent.com/92205707/170789540-c24e6b3e-100a-44df-85f5-b68b6c225dc4.png)
- For the Maintenance problem, I simulated the system to find out the average cost per day for two random events (before and after the machine breaks down) and the range of cost that Heavy Duty is expected to incur for replacing the motor. You can preview the screenshot of my model and my model's range of daily average cost in Excel file here:
- Model: (https://user-images.githubusercontent.com/92205707/170789639-46abacf2-1b9c-4e44-8fdf-2139711d83c3.png)
- Range: (https://user-images.githubusercontent.com/92205707/170789664-6fe28ceb-bb1c-41c1-952c-a7657fba5776.png)
- For the Herr Cutter problem, I simulated the system to find out the average waiting time in the queue to get haircut and the range of waiting time in the queue that customers are expected to wait. The two random events in this problem are interarrival and service time. You can preview the screenshot of my model and my model's range of waiting time in Excel file here:
- Model and Range: (https://user-images.githubusercontent.com/92205707/170789878-26541411-09ae-4078-8787-cf589cad3878.png)
The detailed description of the three problem statements along with my solution for the three problems can be found in the Excel spreadsheet.