Identify the decision variables, objective function, and constraints in simple verbal statements. Mathematically formulate a linear optimization model. Please show Step 2 in Excel
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Trend analysis is an analytical tool that is used by the organization to identify the trend as well…
Q: Chris Suit is administrator for Lowell Hospital. She is trying to determine whether to build a large…
A: Based on the given data, we first prepare a summary table as shown below:
Q: Despite of the price increase A Diesel engine uses the following: Type A filter and high-grade…
A: For type A filterCost of filter = P 150Cost of oil per liter = P 10.50 (high-grade lubricating…
Q: 9. The Canine Gourmet Company produces delicious dog treats for canines with discriminating tastes.…
A: Find the given details below:
Q: New England Cheese Company produces two cheese spreads by blending mild cheddar cheese with extra…
A: The Regular blend contains 80% mild cheddar and 20% extra sharp, and the Zesty blend contains 60%…
Q: Consider the following linear program and answer the following questions. Max 3A + 4B s.t.
A:
Q: Using the following table, perform ALL FIVE of the techniques for decision-making under Uncertainty:…
A: Mathematic models of decision-making help businesses make the correct decisions for their…
Q: Farmer John sells fruit and vegetables at a farmer’s market in the middle of a city. He is bringing…
A: Find the Given details below:
Q: ould you use
A: Metaphors draw our attention, establish connections with others, and demystify difficult…
Q: Show the WBS and Gantt Chart for the activities. Show the critical path of the project (in months).…
A: Here, each activity is given with the time data and immediate predecessor data, I will prepare the…
Q: Borges Machine Shop, Inc. has a 1-year contract for the production of 200,000 gear housings for a…
A: Given, The cost of general-purpose equipment is as follows,Annual contracted unit = 200,000Annual…
Q: Identify 5 potential time wasters in your daily schedule. What steps can you take to better manage…
A: Here, I will answer this question in a generalized way, I will identify the five potential time…
Q: As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient…
A: Find the given details below: Year123456Payment170210250310340500Develop plan:SecurityCurrent…
Q: Potential locations A and B have the cost structure shown below for manufacturing a product expected…
A: LocationFixed Cost($)Variable Cost($/unit)A012/7 B12003/8 Selling Price = $7 per unitx = number of…
Q: From the following information, develop an AON project network. Complete the forward and backward…
A: A network diagram is a graphical representation of a project that helps to identify the activity…
Q: Maximize Z-$46X1 + $69X2 Subject to: 4X1+6X2 ≤ 84 (Time in department 1) 2X1+1 X2 2 20 (Time in…
A:
Q: Explain the concept of safety integrity levels (SILs) in the context of functional safety standards.…
A: Safety Integrity Levels (SILs) are an important component of functional safety requirements,…
Q: he following limits-500 hours for pro 50 hours for shipping. The times requir ng table. ion Hours…
A: Preapare the Grid :
Q: American Red Cross wants to determine the least expensive way to transport available blood donations…
A: The shortest path algorithm is a type of algorithm used to find the shortest path between two nodes…
Q: 1 O A (3) 0 ES FF Activity (Duration) LS TF LF EF 4 4 11 FF 5 4 0 B (3) 7 14 5 14 E (4) 1. What is…
A: We completed the project network diagram as shown below:The above network diagram in the form of…
Q: a. The total function point count is: Total function point count b. Calculate the estimated project…
A: The complexity weighing scheme plays an important role in managing a project. It helps in evaluating…
Q: The flow rate through a process is 0.5 flow units per minute. The number waiting for the process is…
A: Find the given details below: Given details:Flow rate0.5minutesNumber of waiting for the…
Q: Dave Fletcher was able to determine the activity times for constructing his laser scanning machine.…
A: Projection completion time is the expected duration that is required by an organization to finish a…
Q: A wave soldering machine failures follow 3-parameter Weibull distribution with ß= 1.6, n = 800 hours…
A: According to the question given data,ẞ= 1.6η= 800 hours y = 500 hoursThe cost of one PM is $ 6000the…
Q: The manager of Perrotti's Pizza is attempting to understand the root causes of late pizza delivery…
A: The fishbone diagram, also known as Ishikawa or, the cause-and-effect diagram is a graphical…
Q: a. Create a network model in the form of Activity and Arrow (AoA) and Activity on Node (AoN) for the…
A: A network diagram shows the link of each task with the duration taken by each activity with respect…
Q: The owner of Firewood To Go is considering buying a hydraulic wood splitter which sells for $50,000.…
A: Find the Given details below:
Q: Given the following information, assign tasks to work stations using the most followers rule. Assume…
A: Project schedule assists in having accurate values for the production cycle as its time, completion…
Q: Consider the following activity description with associated cost data shown in Table 1. The cost…
A: Given,ActivityImmediate PredecessorNormal Duration (days)Normal Cost ($)Crash Duration (days)Crash…
Q: Based on Gauteng Province International Festival 2024: 20 - 31 July Please draw a WBS (Work…
A: In project management, a WBS, or Work Breakdown Structure, is a hierarchical organisation of tasks…
Q: The Demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…
A: Here we find a forecast line that best fits the data points representing the actual. Best fit means…
Q: The manager of a crew that installs carpeting has tracked the crew's output over the past several…
A: Labor productivity helps the organization in determining the efficiency of the production activity…
Q: Explain the concept of contingency planning. Why is it important for organizations to have…
A: Having a contingency plan set up is pivotal for some organizations to be more effective and steady…
Q: What is the crossover point in miles between the hybrid vehicle and the alternative vehicle from a…
A: Purchase Cost = 18000
Q: Explain the value chain and highlight its importance. Identify its components and explain how they…
A: The value chain is a concept introduced by Michael Porter in 1985 to describe the various activities…
Q: Shirley Thomas is a real estate agent for Bungalow Realty. She is responsible for managing potential…
A: The following information about the bungalows and the trips is…
Q: Given the following information, assign tasks to work stations using the most followers rule. Assume…
A: TaskPredecessorTask time (sec.)A-35D-50BA20CB10ED25FC,E40Cycle time = 60 secondsMinimum number of…
Q: The following table shows the activities, times, and activity sequences required for a large…
A: Project crashing is a process that helps to reduce the total duration of additional costs. A…
Q: A production process at South Plains Manufacturing is shown below. The drilling operation occurs…
A: Working days per month = 20Hours worked per day = 8
Q: Assuming the following deseasonalized demand, what would your Level and Trend FORECAST factors be…
A: Demand & Deseasonalised Demand for 20 periods is provided below:Deseasonalised demand refers to…
Q: a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the…
A: Forecasting is knowing the outcome of future events by making predictions and estimates based on…
Q: A Mercedes dealer purchases vehicles for $20,000. The annual holding cost is estimated to be 25% of…
A:
Q: Define virtualization and explain its key benefits in terms of resource utilization and management.
A: Virtualization is the approach that helps multiple virtual models or environments run on a single…
Q: a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the…
A: Forecasting is predicting the uncertainty of the future. This can be in the context of sales or…
Q: Assignee ABCD А с 1 867 6 2 6 5 8 7 Task 3 5 S345 3 5 4 9466 7
A: Assignee Task1234A8657B6534C7846D6756
Q: A real estate agent is considering changing her land line phone plan. There are three plans to…
A: A real estate agent has 3 plans to choose from - Plan A, B and C:
Q: Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and…
A: Multifactor productivity is the proportion between total output values and two or more input values.…
Q: The quality journey provides a framework for project quality management. Its seven steps prescribe…
A: Project managers and team members can utilize the quality journey, an outline for project quality…
Q: Question 2. Consider the process for a store below. a. What is the bottleneck? Alice A 3 min/cust…
A: Find the Given details below:
Q: a. What is the process capacity (bottles/hour) for the machine-paced line? b. What is the bottleneck…
A: Note: Since you have posted a question with multiple sub parts, we will provide the solution only to…
The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below:
Material (measured in square inches) |
Model 1 |
Model 2 |
Model 3 |
Material Available |
---|---|---|---|---|
Cardstock |
12 |
10 |
14 |
1,200 |
Satin |
24 |
20 |
15 |
2,000 |
Plain fabric |
40 |
40 |
30 |
7,500 |
Leather |
11 |
11 |
10 |
1,000 |
Profit per model |
$50 |
$44 |
$40 |
-
Identify the decision variables, objective function, and constraints in simple verbal statements.
-
Mathematically formulate a linear optimization model.
-
Please show Step 2 in Excel
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.
Step by step
Solved in 5 steps with 9 images
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1,200 Satin 24 20 15 2,000 Plain fabric 40 40 30 7,500 Leather 11 11 10 1,000 Profit per model $50 $44 $40 Identify the decision variables, objective function, and constraints in simple verbal statements. Mathematically formulate a linear optimization model.The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnas-tics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/ model are shown below
- The Morton Supply Company Produces clothing, footwear, and accessories for dancing andgymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of theirtoes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The numberof square inches of each type of material used in each model of shoe, the amount of material available,and the profit/model are shown below.Material(measured inSquareinches)Model1Model2Model3MaterialavailableCardstock 12 10 14 1200Satin 24 20 15 2000Plain Fabric 40 40 30 7500Leather 11 11 10 1000Profit permodel$50 $44 $40a. Identify the decision variables, objective function, and constraints in simple verbal statements.b. Mathematically formulate a linear optimization model.Implement the linear optimization model that you developed for the Morton Supply Company inProblem #1 on a spreadsheet and use Excel Solver to find an optimal solution. Interpret the Excel SolverAnswer Report and identify the…The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24 hours per day and are scheduled for 30 days in the coming month. The mill will produce only Fabric 1 and Fabric 2 during the coming month. Each dobby loom can turn out 4.62 yards of either fabric per hour. Assume that there is a monthly demand of 16,000 yards of Fabric 1 and 12,000 yards of Fabric 2. Profits are calculated as 33¢ per yard for each fabric produced on the dobby looms. (a) Will it be possible to satisfy total demand? (b) In the event that total demand is not satisfied, the Scottsville Textile Mill will need to purchase the fabrics from another mill to make up the shortfall. Its profits on resold fabrics ordered from another mill amount to 20¢ per yard for Fabric 1 and 16¢ per yard for Fabric 2. How many yards of each fabric should it produce to maximize profits? (Round your answers to one decimal place. If total demand is satisfied, enter NONE.)The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24 hours per day and are scheduled for 30 days in the coming month. The mill will produce only Fabric 1 and Fabric 2 during the coming month. Each dobby loom can turn out 4.65 yards of either fabric per hour. Assume that there is a monthly demand of 16,000 yards of Fabric 1 and 12,000 yards of Fabric 2. Profits are calculated as 33¢ per yard for each fabric produced on the dobby looms. Will it be possible to satisfy total demand? (a)Yes, the mill can produce enough to meet the demand. (b)No, the mill can not produce enough to meet the demand. In the event that total demand is not satisfied, the Scottsville Textile Mill will need to purchase the fabrics from another mill to make up the shortfall. Its profits on resold fabrics ordered from another mill amount to 20¢ per yard for Fabric 1 and 16¢ per yard for Fabric 2. How many yards of each fabric should it produce to maximize…
- 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 suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $12 $12 $15 2 $11 $10 $12 Each 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: Supplier 1 2 3 Capacity 575 950 800 If the Edwards production plan for the next period includes 1050 units of component 1 and 775 units of component 2, what purchases do you recommend? That is, how many units of each component should be…Fertilizing the Lawn. The facilities manager at Oxbridge University is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table: Mineral Minimum Weight (lb) Nitrogen 12 Phosphorus 14 Potash 18 Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. There is virtually unlimited supply of each kind of fertilizer. Fertilizer Nitrogen Content (lb) Phosphorus Content (lb) Potash Content (lb) Price ($) A 20 10 5 10 B 10 5 15 8 C 15 10 5 7 How much of each fertilizer should be purchased to satisfy the requirements at minimum costThe Gulf Coast Foundry is developing a long-range strategic plan for buying scrap metal for its foundry operations. The foundry can buy scrap metal in unlimited quantities from two sources, Atlanta (A) and Birmingham (B), and it receives the scrap daily in railroad cars. The scrap is melted down, and lead and copper are extracted for use in the foundry processes. Each railroad car of scrap from source A yields 1 ton of copper and 1 ton of lead and costs $10,000. Each railroad car of scrap from source B yields 1 ton of copper and 2 tons of lead and costs $15,000. If the foundry needs at least 21/2 tons of copper and at least 4 tons of lead per day for the foreseeable future, how many railroad cars of scrap should be purchased per day from Source A and Source B to minimize the long-range scrap metal cost?