Solution-Formulation of lp or ilp model

Formulation of lp or ilp model

Assignment Help Engineering Mathematics

Reference no: EM13961878

Instructions: Each of the following problems is to be solved using Solver in Excel. In order to receive proper and maximum credit, your spreadsheet(s) should show the formulation of your LP or ILP model, your assumptions, and the implementation of your model. Label appropriately. Use cell notes if needed.

1. A company needs to hire workers to cover a 7 day work week. Employees work 5 consecutive days with 2 days off. The demand for workers by day of the week and the weekly wages for the employees are:

Days of Week	Workers Required	Shift	Days off	Wage
Sunday	54	1	Sun & Mon	900
Monday	50	2	Mon & Tue	1000
Tuesday	36	3	Tue & Wed	1000
Wednesday	38	4	Wed & Thu	1000
Thursday	42	5	Thu & Fri	1000
Friday	40	6	Fri & Sat	900
Saturday	48	7	Sat & Sun	850

The company wishes to determine the number of employees to have on each shift such that the operating costs are minimized

a) Formulate the model for this problem.

b) What is the optimal solution?

Reference no: EM13961878

Questions Cloud

Determine the total charge of the insulating shell. : This conducting shell has a charge of +q on its outer surface. A larger insulating shell, inner radius d and outer radius e, has a uniform charge density -a throughout its volume.

Find the optimal solution using excel solver : Set up this problem in excel; find the optimal solution using excel solver, and the solution's sensitivity report. What are your solution and your objective function value? For each constraint: what is its shadow price, what is its slack (or, you ..

Find the distance x, from the front wheel to the cg : Find the maximum slope angle P, for which the truck with only front wheel drive can move up the plane. Find the maximum slope angle Q, for which the truck with only rear wheel drive can move up the plane.

Country that pursues a policy of import substitution : High-altitude plateau lands between the eastern and western Sierra Madres dominate northern:

Formulation of lp or ilp model : Instructions: Each of the following problems is to be solved using Solver in Excel. In order to receive proper and maximum credit, your spreadsheet(s) should show the formulation of your LP or ILP model, your assumptions, and the implementation of..

Find potential at the point of the negative charge : Positive charge Q is distributed evenly on y axis between y = 0 and y = a. A negative charge -Q is located at a distance x from the rod on the x-axis.

How should it be given-publicly or privately : Should this be an individual-based incentive, a team-based incentive, or a combination? How would you design it? When should the incentive/reward be given-monthly, quarterly or annually? How should it be given-publicly or privately

Find the potential energy of the system of 3 charges. : Find the potential energy of the system of 3 charges.

Problem regarding objective function and constraints : You can elect to carry any portion of each cargo, and cargoes can be mixed together in the various holds. How many tons of each cargo should you carry to maximize the total revenue for the voyage?

User Account

All Pages

Formulation of lp or ilp model

Reference no: EM13961878

Reference no: EM13961878

Questions Cloud

Reviews

Write a Review

Engineering Mathematics Questions & Answers

Prime number theorem

Proof of bolzano-weierstrass to prove the intermediate value

Antisymmetric relations

Distributed random variables

Prepare a system of equations

Managing ashland multicomm services

Skew-symmetric matrices

Type of taxes and rates in spokane wa

Stratified random sample

Find the probability density function

Develop a new linear programming for an aggregate production

Discrete-time model for an economy

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT