How should garcia assign the new products to the plants

Assignment Help Operation Management

Reference no: EM131894998

The Patricia Garcia company is currently producing seven new medical products. Each of Garcia's eight plants can add one more product to its current line of medical devices. The unit manufacturing costs for producing the different parts at the eight plants are shown below.

How should Garcia assign the new products to the plants in order to minimize manufacturing costs?

Please show each and every step in excel solver. Please show how to calculate each formula on each step in solver.

You need to know the table is ready for solver and then each step when preparing solver for the solution.

	P1	P2	P3	P4	P5	P6	P7	P8
C53	.1	.12	.13	.11	.1	.06	.16	.12
C81	.05	.06	.04	.08	.04	.09	.06	.06
D5	.32	.4	.31	.3	.42	.35	.36	.49
D44	.17	.14	.19	.15	.1	.16	.19	.12
E2	.06	.07	.1	.05	.08	.1	.11	.05
E35	.08	.1	.12	.08	.09	.1	.09	.06
G99	.55	.62	.61	.7	.62	.63	.65	.59

Reference no: EM131894998

Questions Cloud

Discuss about the tax deduction received by the doners : Some people argue that donors should receive a more generous tax deduction for gifts to organizations that serve the poor, such as homeless shelters.

How specific language can impact an organization : How people address each other, what metaphors they use (sports, military, family), jargon, levels of formality, is integral in the formation of communication.

How can performance monitoring and improve : How can performance monitoring and evaluation improve your performance and ability to manage the performance of others?

How would you forecast requirements and availabilities : How would you forecast requirements and availabilities . How would you create a more diverse workforce based on the current regional demographics?

How should garcia assign the new products to the plants : How should Garcia assign the new products to the plants in order to minimize manufacturing costs?

Determine the net income or net loss for january : Prepare an unadjusted trial balance for Manis Architects as of January 31, 2016. Determine the net income or net loss for January.

How you might use them in making future ethical decisions : Can you see how many of them may have positively impacted your action or actions, or how you might use them in making future ethical decisions?

Calculate the required eps figures : Calculate the required EPS figures for 2005. Calculate the required EPS figures for 2005 assuming that the options were issued on April 1, 2005.

Determine the success of a project : Discuss whether or not you have seen healthcare projects be short lived, because of the impatience of leadership to see results.

User Account

All Pages