A linear programming computer package is needed.Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company's needs. In additithe suppliers charge different prices for the components. Component price data (in price per unit) are as follows.Component121SupplierNeed Help? Read It2$13 $14 $15$11 $12 $11Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity tcomponent 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows.Supplier 1Capacity 500 900 7002Show My Work (Optional) ?33(a) If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many units of eachcomponent should be ordered from each supplier?unitsComponent 1, Supplier 1Component 1, Supplier 2unitsComponent 1, Supplier 3unitsComponent 2, Supplier 1unitsComponent 2, Supplier 2unitsComponent 2, Supplier 3units(b) What is the total purchase cost (in $) for the components?

we use the given data apply the linear (simplex LP)programming using excel step1 ; enter the data in…

Answered: (a) If the Edwards production plan for…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Consider the following table.
Consider the following table.
From the data given compute the sales price for each product T and O. From the data given compute variable cost per unit for each product T and O. Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 50,000 units of each product. Sales and costs for each product follow.
Hospital Beds. The number of hospital beds available in community hospitals is decreasing. Through advancement in care and technology, hospitals are getting more efficient. However, the aging and increasingly obese and diabetic population intensifies the need. The American Hospital Association Annual Survey, published by the American Hospital Association (AHA), gave the number of hospital beds available per 1000 people for each of the 50 states plus the District of Columbia for 2010. Following is a stem-and-leaf diagram of the data. The stems represent units and the leaves tenths (e.g., the first entry is 1.7). How many states (including the District of Columbia) had a. at least three but less than four hospital beds per 1000 people available? b. at least four and a half hospital beds per 1000 people available?
You are the VP, Advertising for “Yo’ Mama” brand, a fashion label that caters to the young, trendy crowd with an urban, hip-hop image. While your customer base has traditionally been largely African-American, you have recognized a tremendous influx of Hispanic consumers into your market. You are preparing for next week’s annual budget meetings and you have decided to recommend an Hispanic-focused advertising campaign if the average monthly per store sales to Hispanic customers are at least the same as the average monthly per store sales to African-American customers in a sample of typical stores (sales data given below). Using an alpha of .05 and the 5-step hypothesis testing process, what will you recommend? Hint: Think about how many data points you actually have.
A local firm is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production unit. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Month Production Days Predicted Demand(in $10,000) Month Production Days Predicted Demand(in $10,000) January 20 595 July 20 410 February 19 225 August 21 130 March 22 565 September 19 405 April 18 205 October 23 315 May 21 230 November 21 355 June 22 120 December 18 350 Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December…
G.97.

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS