Press "Enter" to skip to content

Posts published in “QNT 5160”

QNT 5160 Team Optimization Project

QNT 5160 Team Optimization Project Read the case study “Hawley Lighting Company”. Download the Hawley Data Models V5.xlsx file and complete the following embedding your answers in one final report and submitting the Excel file with your calculations. Part A. Optimal Solution (4 points). Complete and analyze the model in the first Excel Tab titled Optimal Solution: Use Excel to calculate Unit Profit for each product (in cells B8:I8) and Total Profit (in cell B19). Use Excel Solver to estimate the optimal production plan and create the first sensitivity report. Analyze the tactical and strategic information provided by the optimal…