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.
The company has data on demand and factory capacity for the next 4 months as in the table. Unit cost with regular time $ 24, overtime cost $ 28, on subcontract $ 34. Storage costs $ 2 per unit per month; backorders cost $ 5 per unit per month. Initial inventory is as many as 120 units, and it is expected that by the end of July there will be an inventory of 100 units. April May June July Demand 460 450 480 480 Regular Capacity 370 370 380 380 Overtime Capacity 60 60 60 60 Subcontract Capacity 30 30 30 30 Use the transportation method to optimize the aggregate plan. Determine the production cost each month and the total cost for 4 months
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.
i. What is the total cost?
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.
Given the Information in the below table's, calculate the total cost if you choose the: i) Level Strategy with average production per day. ii) Chase strategy for the production. Month Expected Demand Production Days Jan 600 22 Feb 800 18 March 900 21 April 1000 21 Inventory carrying cost $5 per unit per month Subcontracting cost per unit $20 per unit Average Pay rate $10 per hour ($80 per day) Over time Pay rate $17 per hour (above 8 hours) Labour-hours to produce a unit 1.6 hours per unit Cost of increasing daily production rate $300 per unit Cost of decreasing daily production rate $600 per unit

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