Submit homework for the following Problems 2-14, 2-15, 2-18, 2-21, 2-22, 2-41, 2-51, 2-52, 2-53, 2-54 in Excel. Homework instructions:
Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all input cells in blue and all outputs in green. Build all formulas in the Excel worksheet so that all outputs are automatically calculated based on the input variables. Sample problems including correct formatting will be completed in the weekly (online) classroom session. To make the best use of the classroom session you should attempt all the homework problems prior to the classroom session so you can ask very specific questions to help you complete the homework. This homework will address the learning objectives of demonstrating how to solve linear programming problems using Solver in Excel and modeling a wide variety of linear programming problems.