A9) (a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of strapsmanufactured, and TP = number of straps purchased. Express time in minutes per unit.)MinCutting constraintMilling constraintShaping constraintFrame constraintSupport constraintStrap constraint.FM, FP, SM, SP, TM, TP ≥ 0How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.)(FM, FP, SM, SP, TM, TP) = ((b) What is the total cost (in $) of the manufacturing and purchasing plan?$(c) How many hours of production time are used each department? (Round your answers to two decimal places.)Cuttinghrshrs.MillingShapinghrs(d) How much (in $) should Frandec be willing to pay for an additional hour of time in the shaping department?$(e) Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this opportunity? Why or why not? (Round your answer to three decimal places.)---Select---indicates that the solution ---Select--- be improved.The reduced cost of A linear programming computer package is needed.Frandec Company manufactures, assembles, and rebuilds material-handling equipment used in warehouses and distribution centers. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec'sproduction schedule calls for 4,500 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing andpurchase costs per unit are shown.ComponentFrameSupportStrapComponentFrameManufacturing Cost Purchase CostSupport$39.00StrapCapacity (hours)$12.50$7.50Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows.Cutting3.51.30.8350Department2.2$52.001.7$16.00Milling Shaping420$8.503.12.61.7680

As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

(a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of straps manufactured, and TP = number of straps purchased. Express time in minutes per unit.) Min Cutting constraint Milling constraint Shaping constraint Frame constraint Support constraint Strap constraint FM, FP, SM, SP, TM, TP ≥ 0 How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.) (FM, FP, SM, SP, TM, TP) = (b) What is the total cost (in $) of the manufacturing and purchasing plan? $ (c) How many hours of production time are used in each department? (Round your answers to two decimal places.) Cutting hrs Milling hrs. Shaping hrs

(a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM = number of frames manufactured, FP = number of frames purchased, SM = number of supports manufactured, SP = number of supports purchased, TM = number of straps manufactured, and TP = number of straps purchased. Express time in minutes per unit.) Min Cutting constraint Milling constraint Shaping constraint Frame constraint Support constraint Strap constraint FM, FP, SM, SP, TM, TP ≥ 0 How many of each component should be manufactured and how many should be purchased? (Round your answers to the nearest whole number.) (FM, FP, SM, SP, TM, TP) = (b) What is the total cost (in $) of the manufacturing and purchasing plan? $ (c) How many hours of production time are used in each department? (Round your answers to two decimal places.) Cutting hrs Milling hrs. Shaping hrs

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

14
Question No. (01) a) ‘Since last few years Sri Lanka is experiencing an economic crisis and at present, the situation has become more severe amidst the influences of the pandemic. From 2020, Sri Lanka has cut down the imports of vehicles and by now, there are import restrictions on farm chemicals, fertilizer, electronic equipment as well as many other products as its foreign exchange reserves diminish. As a result of these import controls, prices of many products including essential consumer goods, fuel, and construction materials are also increasing. On the other hand, the country’s ability to repay its debt is also weakening and the Fitch Ratings has downgraded Sri Lanka to its CCC category, indicating a real possibility of default. Therefore, people of Sri Lanka are passing a very difficult time period and it is expected to continue this situation in coming few years too’. Identify three (03) international/ global players operate in the Sri Lankan market and discuss the influences…
Question 3 Imagine a mining company, Deep Earth Extraction, operates a transportation system to move ore from its remote mine to a processing facility. The transport vehicle has a capacity of 220 tons of ore, and each trip costs the company R70,000 regardless of the amount of ore transported. Additional costs amount to R60 per ton of ore for loading, securement, and tracking expenses. a) If Deep Earth Extraction charges R450 per ton of ore transported, how many tons of ore does it need to transport per trip to break even? b) Surveys have revealed that the transport vehicles are, on average, carrying about 80% of their maximum capacity of ore. Considering this loading level and a rate of R450 per ton, what would be the profit or loss realized on each trip?
Requirement show your working
The goal of EPR (Extended Producer Responsibility) laws is to: Question 43 options: reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs. motivate manufacturers to design products that are more easily repaired, reused, and recycled. Neither reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs nor motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct. Both reduce the amount of potentially dangerous waste in landfills by holding manufacturers accountable for the end-of-life disposal costs & motivate manufacturers to design products that are more easily repaired, reused, and recycled are correct.
Question 2 - Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories e Demand e x-coord- 9,000- y-coorde A- 20e 130e Be 3,000 60- 404 Ce 5,000- 70- 100- De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. e
Q 9. Discuss the importance of search engines.
8
Question 4 Jetair was founded in September 2007 and is one of a growing number of low-cost airlines in the country of Salta. Jetair's strategy is to operate as a low-cost, high-efficiency airline, and it does this by: Operating mostly in secondary cities to reduce landing costs. ● Using only one type of aircraft in order to reduce maintenance and operational costs. These planes are leased rather than bought outright. Having only one category of seat class. Having no pre-allocated seats or in-flight entertainment. Focusing on e-commerce with customers, both booking tickets and checking in for flights online. The airline was given an 'on-time arrival' ranking of seventh best by the country's aviation authority, which ranks all 50 of the country's airlines based on the number of flights which arrive on time at their destinations. 48 Jetair flights were cancelled in 2013 compared to 35 in 2012. This increase was due to an increase in the staff absentee rate at Jetair from 3 days per staff…
QUESTION 2 Molitup Limited (ML) manufactures three products: Product MM, Product LL and Product TT. The contribution per unit of the respective products is as follows: Product MM Product LL Product TT Contribution per unit £600 £500 £800 Three processes are required for the manufacture of these products: Process Alpha, Process Beta and Process Gamma. The processing time (in hours) required for the manufacture of a unit of each product is as follows: Product MM Product LL Product TT Process Alpha Process Beta Process Gamma 20 30 40 80 60 20 50 90 60 The monthly availability of Process Alpha, Process Beta and Process Gamma are limited to 40,000 hours, 80,000 hours and 50,000 hours respectively. The objective of the company is to maximise contribution.
Q2/ A chemical factory produces three types of materials (A, B, C). After reviewing the request, the producer found the need to produce no less than four tons of product (A) and two tons of product (B) and one ton of product (C) per day. These materials are produced from two other components, namely (X, Y), where each ton of (X) gives a quarter of a ton of (A), a quarter of a ton of (B), and (1/12) of (C). Each ton of (7), (1/2) ton of (A), O (1/10) ton of (B), and (1/12) ton of (C). So if component (X) costs (250) dollars per ton and component (7) costs (400) dollars per ton, and the operating cost is (250) dollars per Tons of (X), (200) dollars for each ton of (7). Put the mathematical model for this problem in the form of linear programming?
Q.1. a) Identify the challenges affecting the delivery performance and buffer levels in an in-house material handling system at BRL. (