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

Related questions

Q: Question 1 Rangaswamy owns 50 acres of land in the Hassan district of Karnataka on which he grows…

A: From the given data, the following excel model can be formulated. Excel model:

Q: Meaning of ABC analysis?

A: ABC stands for Always Better Control analysis. It is one of the most commonly used inventory…

Q: Question 8 Part G A large company is planning to purchase equipment costing $220,000 and will…

Q: How does Southwest Airlines know they are achieving their goals? Explain comprehensively

A: The process of managing a team's efforts to meet all project objectives while staying within budget…

Q: TB 7.87 If the state of Louisiana has minimum auto liability limits of 25/100/20, what does the 100…

A: Corporate law, also known as business law or company law, is a legal discipline that governs the…

Q: Market planning, Inc. a marketing research firm, has obtained the prescription sales data for 20…

A: While choosing a regression model, it is important to assess how well the autonomous factors…

Q: Question 3 (Module 2): In the past, Arup Mukherjee's tire dealership in Sudbury sold an average of…

A: Project management is the practice of planning, organizing, as well as executing tasks and resources…

Q: Question 2 Alpha Electronics (AE) is a large manufacturer of electronics products. The company sells…

A: (a)

Q: LM.97 Each week the ABC Company, from Albuquerque, NM receives 89 separate parcel shipments from a…

A: Given data: No. of separate parcel shipments = 89 Each parcel shipment from Dallas to Albuquerque…

Q: (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock…

A: Mathematic models of decision-making help businesses make the correct decisions for their…

Q: Question 5: A Mechanical Design Company produces an innovative design of Batttery used for electric…

A: Variance is a comparison between actual and standard usage or price of the material in production…

Q: Question 2: From studying the local real estate market in the past few years, you observe that on…

A: The local real estate market is a key indicator of economic activity in a particular area, and…

Q: Question 3 Best Technology (BT) is a leading manufacturer of adhesives used in a variety of…

A: Inventory optimization refers to the strategic management and control of a company's inventory to…

Q: Cost-benefit-tradeoff problems are linear programming problems involving the allocation of limited…

A: Cost-benefit tradeoff problems are those linear programming problems that involve making decisions…

Q: Q.2. Discuss the implication of strategic supplier management strategies in enhancing supply chain…

A: The objective of this question is to understand the impact of strategic supplier management…

Question

100%

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 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 each department? (Round your answers to two decimal places.)
Cutting
hrs
hrs.
Milling
Shaping
hrs
(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's
production 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 and
purchase costs per unit are shown.
Component
Frame
Support
Strap
Component
Frame
Manufacturing Cost Purchase Cost
Support
$39.00
Strap
Capacity (hours)
$12.50
$7.50
Three 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.
Cutting
3.5
1.3
0.8
350
Department
2.2
$52.00
1.7
$16.00
Milling Shaping
420
$8.50
3.1
2.6
1.7
680

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 Introduction:-

Step 2 Forming LP:-

Step 3 Solving LP:-

Step 4 ANSWERS:-

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

14
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.
Q 9. Discuss the importance of search engines.
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…
Q.1. a) Identify the challenges affecting the delivery performance and buffer levels in an in-house material handling system at BRL. (
15.1.1b see picture to solve
QUESTION 12 (Using the same problem) A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the answer using the criterion of minimax regret? Alternatives Large Inventory Small Inventory Probability O A) -$2,000 O B) $130,000 O C) $0 O D) $20,000 O E) $153,400 Large Crowd $220,000 $90,000 .20 PROFIT ($) Average Crowd $50,000 $70,000 .50 Small Crowd -$2,000 -$5,000 .30
Q. Hotel California has 160 rooms. The hotel has an ample low-fare demand at the room rate of $200 per night, but the demand from the high-fare class which pays $450 per night on average, is uncertain. Table below shows the number of high-fare rooms that were booked during the past 30 days. How many rooms should Hotel California protect for high-fare customers to maximize its expected revenue? Number of high-fare rooms Frequency 0 5 1 3 2 6 3 8 4 4 5 1 6 1 7 2 Total=30
1. Explain (2) possible risks of working at a fuel supply plant 2. Explain The important of training for those working at a fuel supply plant.
Question 39
Q.1. Discuss the implication of strategic supplier management strategies in enhancing supply chain resilience and competitiveness.
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…