Use excel to solve for the amount of each part that

Assignment Help Mechanical Engineering

Reference no: EM13643864

A manufacturing firm produces four types of automobile parts. Each is first fabricated and then finished. The required worker hours and profit for each part are:

	Part A	Part B	Part C	Part D
Fabrication Time (hr/100 units)	2.5	1.5	2.75	2
Finishing Time (hr/100 units)	3.5	3	3	2
Profit ($ / 100 units)	375	275	475	325

Your (per month) total fabrication time available is 640 hours and the total finishing time is 960 hours.

a) Set up the problem in standard form and write the initial tableau.

b) Use Excel to solve for the amount of each part that maximizes profit.

c) Which would further maximize profit, hiring an extra 40 hours of fabrication time or finishing time?

Reference no: EM13643864

Questions Cloud

Suppose you have a solution that might contain any or all : suppose you have a solution that might contain any or all of the following cations cu2 ag ba2 and mn2. addtion of hcl

Find the global minimum via the golden section search start : 1. consider the functionfx 2x4-14x3-60x270xa find the global minimum analytically. evaluate every critical point.b find

The student body of a large university consists of 30 : the student body of a large university consists of 30 business majors. a random sample of 20 students is selected.a.

A satellite is in a circular orbit about the earth m 598 x : a satellite is in a circular orbit about the earth m 5.98 x 1024 kg. the period of the satellite is 1.38 x 104 s. what

Use excel to solve for the amount of each part that : a manufacturing firm produces four types of automobile parts. each is first fabricated and then finished. the required

Marble chips calcium carbonate caco3 react with : marble chips calcium carbonate caco3 react with hydrochloric acid hcl to produce calcium chloride cacl2 water and

A simple single lens camera biconvex lens is used to : a simple single lens camera biconvex lens is used to photograph a man 1.5 m tall who is standing 5.0 m from the camera.

If i build a regression model with two independent : if i build a regression model with two independent variables that are highly correlated which violation of the

Natural gas can be represented by ch4 methane and gasoline : natural gas can be represented by ch4 methane and gasoline can be represented by c8h18 octane. write the chemical

User Account

All Pages