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 addition, the supplierscharge different prices for the components. Component price data (in price per unit) are as follows.SupplierComponent11$13 $14 $152$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 to component 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.Supplier1 2 3Capacity 500 900 700If 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 each component should beordered from each supplier?Component 1, Supplier 1unitsunitsComponent 1, Supplier 2Component 1, Supplier 3.unitsComponent 2, Supplier 1unitsComponent 2, Supplier 2unitsComponent 2, Supplier 3unitsWhat is the total purchase cost (in $) for the components?$

The transportation model is used to calculate the minimum cost of the route by selecting different…

Answered: If t f the Edwards production plan for…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.43 Annual Supplier Bradley Alexander Administrative Cost $15,000 $10.000 10.000 25,000 50,000 (p) $7. 15 (wks) $40,000 $30,000 $26,000 $18.000 $25,000 $17,000 $7,15 $1.43 6 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using Alexander and a…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Annual Supplier Bradley Alexander 50.000 $18,000 $17.000 Cost/Unit (H) $1.43 $1.43 10,000 25,000 (p) $7.15 (wks) Administrative Cost $40,000 $30,000 $26.000 $25.000 $15,000 S7.15 6 $10.000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using and a shipping quantity…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.43 $1.43 Annual Supplier Bradley 10,000 $40,000 50,000 $18,000 $25,000 $17,000 25,000 (p) S7.15 (wks) Administrative Cost $26.000 5 $15,000 Alexander $30,000 S7.15 $10.000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using Alexander and a…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Annual Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) $1.83 $1.83 50,000 Supplier Bradley Alexander 10,000 25,000 $28.000 (wks) (p) $9.15 $9.15 Administrative Cost $40,000 $35,000 $18,000 $17,000 $10,000 $15,000 $26,000 7 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using and a shipping quantity…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Cost/Unit (H) Annual Supplier Bradley Alexander 10,000 $35,000 25,000 $27,000 $40,000 $28,000 $18,000 50,000 $17,000 (p) (wks) Administrative Cost $8.10 $8.10 $1.62 $1.62 $15,000 $10,000 6 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using V and a shipping…
Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Price/Unit Holding Cost/Unit Lead Time (L) (p) (wks) Supplier 10,000 25,000 50,000 Bradley $40,000 $26,000 $19,000 Alexander $30,000 $28,000 $17,000 $7.15 $7.15 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? and a shipping quantity of Using Annual Freight Costs Shipping Quantity (Q) -w an example Get more help. (H) $1.43 $1.43 6 4 Annual…
Cryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…
The following table contains figures on the annual usage and unit costs for a random sample of 12 items. Develop and A-B-C classification for these items: Item Name Annual Usage (No of Items) Unit Cost 1 500 TK 4300 2 3000 720 3 1900 500 4 1000 710 5 4500 250 6 2500 192 7 400 200 8 500 190 9 200 210 10 1000 35 11 3000 10 12 19000 3 Brown and Brown Electronics manufacture a line of digital audiotape (DAT) players. While there are differences among the various products, there are a number of common parts within each player. The bill materials showing the number of each item required, lead times and the current inventory on hand for the parts and components, follows: Demand of products A & B and demand of spares components are shown below: Item Demand on 5th week Demand on 7th Week On-Hand Lead Time (Weeks) A 700 ------ 30 1 B 1200 ------ 50…
A company that manufactures cars would use about 50,000 steering wheels per year Such steering wheel is being ordered from a supplier that would cost the company P1.250.00 per order it would also costs 40% of the steering wheel's cost to keep it annually. The steering wheel costs P7,500.00 each How many steering wheels should be ordered at one time? ** Need as soon as possible pls.
Inventory Management You are the store manager at a local branch of DigiLife, a large electronics retail chain. A new version of a popular consumer electronics device called the Amulet is coming out this year. It is your job to sell as many Amulets as you can while minimizing your costs in order to maximize your store's profits. Your Goal Earn $1,000,000 in net profits of Amulet sales.
Green Gardens' owner has asked your advice about a possible problem at his business. Over the last 6 months the large-sized lawn and garden inventory (ie, tables, chairs, planters, etc.) has appeared to be short. The inventory records that employees use to determine what is on hand show that more inventory is available than can actually be located. This has cause frustration and mis-trust in the inventory records for the sales employees. The owner realizes that the problem is bigger than just frustrated employees. He is afraid that inventory is being stolen, a problem he didn't think possible given that these are large items that are not easily moved. Requirements: Provide the owner with two internal controls that he could implement to reduce the likelihood of theft of the lawn and garden inventory.
“oh fada” receives supplies from a wide range of suppliers directly and adds value by breaking down bulk, customising certain items, and holding stocks until customers require them. The number of inflows of various ranges of goods serving the same purpose has begun to increase with several large amounts laying ideal in warehouse and threatening to become obsolete and also adding up unnecessary cost. The coding system does not allow for ease of identification of the products and wrong item are often picked as the difference between the right and wrong item can be just one digit. Orders are received by telephone and there is no provision for electronic ordering. The stock coding system is a sequential one and has contributed to several issues including inaccurate order entry as it is not possible to find the product details from the codes in use. The products for the orders are manually picked by a team, stock records is done manually with a lot of errors and does not update stock…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS