I need the following two attached problems done in excel using the built in excel solver. For these problems we need to formulate our own constraints. For some reason I am getting negative numbers, which is obviously not right. I would appreciate it if someone could formulate the right constraints and solve these problems 100% correctly using excel.
Please see the attached file for the fully formatted problems.
1. On your construction site next week's work schedule requires the number of laborers per day show in the table below. Each laborer receives $800 per week. A labor requirement must be met that employees work a five consecutive day work week followed by two days off. Allowable shifts are Monday through Friday, Tuesday through Saturday, Wednesday through Sunday, etc. The objective is to cover labor needs with five shifts at a minimum weekly payroll. Formulate this problem in a linear programming format. Determine the dollar value of the minimum program using two of the methods discussed in class.
Day: Mon Tue Wed Thur Fri Sat Sun
Workers: 180 160 150 160 190 140 120
3. The graph below represents possible freeway routes from a city A to an airport F. Each segment of the graph has its carrying capacity indicated in cars per minute. Determine the total capacity (maximum) between A and E of the freeway system (assume only flow in one direction). Note that the rate of flow along each freeway section has to be determined in order to obtain maximum capacity. This is important to regulate traffic during peak hours. Use linear programming.
Linear programming using Excel Solvers are determined. The constraint formulates are analyzed.