Implement the linear optimization model and find an optimal solution. Interpret the optimal solution. The optimal solution is to produce LaserStop models and SpeedBuster models. This solution gives the possible profit, which is $. (Type integers or decimals rounded to two decimal places as needed.)
Q: Problem 13-2 (Algo) A metal fabricator produces connecting rods with an outer diameter that has a 1…
A: Process capability index is a statistical measure of process capability. It is measure the ability…
Q: a) Construct a project network. b) Determine the expected times and variances for each activity. c)…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: ombro Industries is in the process of automating one of its plants and developing a flexible…
A: Given data: Month 1 2 3 4 Wait time /order before - start of production 9 10.9 12 14…
Q: What do you understand by capacity planning? Explain the decision tree modeling for capacity…
A: During a capacity planning process, the amount of production capacity needed to satisfy shifting…
Q: a. Draw the AOA network. b. Calculate the Early Event Time and Late Event Time for every node in the…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: A key factor for success for a retailer is a phenomenal forecasting process and resources (Jack…
A: Inventory cost refers to the costs associated with the inventory. It includes the costs related to…
Q: Please define automation as it relates to the business world.
A: Automation - In general, it is signified as the replacement of manual operations with electronics…
Q: Answer each of the following two problems (1) using regression analysis (easiest way is using the…
A: Given data is
Q: a) What is its weeks of supply? weeks (round your response to two decimal places). b) What…
A: Given, Arrow Distributing Corp. Net Revenue $15,630 Cost of sales $12,190…
Q: What do you think are the most common mistakes people may do while analyzing data?
A: Finding insights into data is the process of data analysis. Although it has many different tactics…
Q: A sample of twenty automobiles was taken, and the miles per gallon (MPG), horsepower, and total…
A: Sample No MPG Horsepower Weight 1 44 67 1,844 2 44 50 1,998 3 40 62…
Q: Task A. High Level Analysis B. Selection of Hardware Platform C. Installation and Commissioning of…
A: AON Diagram:
Q: 20 30 Jefferson City Omaha Jefferson City Omaha Demand Omaha Jefferson City 14 10 Supplies Demands…
A: Given data is Des Moines Kansas city St. Louis Supply Jefferson city 14 16 7 20 Omaha 8 10…
Q: Can I have more details on where does numbers in a) come from: 0.30 × $1.75 - 0.70×$0.5
A: It is mentioned in part (a) of the question that the Empire News is considering to purchase 200…
Q: A company makes beaded necklaces and spends $75,000 per year to hold beads in inventory and $55,000…
A: Economic order quantity = sqrt(2DS/H) where, D = Annual demand S = ordering cost H = Holding…
Q: Ten samples of 15 parts each were taken from an ongoing process to establish a p-chart for control.…
A: Firstly calculating: Sample n No.of defectives Proportion of defects 1 15 1 0.067 2 15 3…
Q: Instructions - Outline the components of Total Quality Management [TQM] programs that have been…
A: Total quality management (TQM) is a corporate strategy that aims to meet and exceed customer…
Q: Identify the objectives of Nike
A: Nike Inc. fights against competition while pursuing global market supremacy. Competitive rivalry…
Q: 6. A personal computer manufacturer plans to locate its as- sembly plant in Taiwan and to ship its…
A: Given data is
Q: Describe. the history and purpose of the balanced scorecard
A: An indicator of managerial performance is a balanced scorecard. It is employed to ascertain the…
Q: Problem 15-5 (Algo) A manufacturer has decided to locate a new factory in northwestern United States…
A: Given-
Q: Tourism
A: Although a considerable lot of us have been "tourists" eventually in our lives, characterizing what…
Q: Deb Bishop Health and Beauty Products has developed a new shampoo and you need to develop its…
A: Given- Previous quarter's output = 1,600 unitsBeginning inventory = 0 unitsStockout cost for…
Q: What are the constraints
A: This is a transportation problem. As from the excel image, let's consider each decision variable as…
Q: Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements…
A: Find the Calculation methods below: Project on hand = Project on hand - Gross requirementsNet…
Q: A well-known coffee shop sells about 300 gallons of its most popular product each week. The…
A: The (s, Q) policy is a continuous review system in which the order is placed when the inventory…
Q: The arrival rate of patients at a hospital counter follows Poisson distribution with a mean of 25…
A: Queuing theory is the study of waiting for lines/queues. This model helps to determine the length…
Q: Run and Shine, a manufacturer, purchases 2750 units of a certain component for his annual usage. The…
A: Find the Calculation Methods below: Exonomix Order Quantity = 2DSHD - Annual DemandS - Ordering…
Q: 5.Which of the following involves granting a foreign entity the right to produce and sell the firm's…
A: Ans) Outsourcing means not producing parts by own , but giving orders to external suppliers and buy…
Q: Rocky Mountain Tire Center sells 13,000 go-cart tires per year. The ordering cost for each order is…
A: Optimal order quantity is the economic order quantity . It is allow the firm to optimize the…
Q: Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less,…
A: The maximum payoff for the basic model is $155,000 and the minimum payoff is $90,000 The maximum…
Q: b) What is the average completion (flow) time? The average completion (flow) time is days (round…
A: a) Sequence of job according to Earliest Due Date(EDD): Job B D E A C Due Date 4 5 2 11 18
Q: Shown below is a partially completed MPS record for ball bearings. Part 2 a. Develop the MPS for…
A: MPS is an acronym for Master Production Schedule. This schedule is prepared to understand, monitor,…
Q: An ?̅ control chart with three-sigma control limits has UCL = 48.75 and LCL = 42.71. Suppose that…
A: Given that: UCL = 48.75 LCL = 42.71 Standard deviation = 2.25 Remember the formula: UCL = μ + (3*…
Q: The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three…
A: Gross requirements are the entire amount of a good or service required to satisfy customer demand.…
Q: Gregory has started a small agricultural business that specialises in maize and sunflower seeds in…
A: MRP systems A material resource planning system is a computer-based information system that helps in…
Q: In order to build large production units and expedite certain routine government actions related to…
A: Ans) Bribes are illegal money or gifts given for some favours.This is illegal Speed money is given…
Q: Describe the difference between organizational risk and project risk. Give an example of each.
A: A risk is a potential future occurrence that may or might not occur but would have an impact on the…
Q: 120 Lot Size: 0 Allocated: Safety Stock: 10 Lead Time: 3 Gross Requirements Scheduled Receipts…
A: Ans) When demand is changed to 10. There is enough on hand that all future demands can be satisfied,…
Q: which of the following modes of entry into foreign markets does a firm agree to set up an operating…
A: The franchise agreement is a binding legal document, laying forth the guidelines for the franchising…
Q: The demand for screens for a computer manufacturer is 10,000 per week. The lead time is 5 days, and…
A:
Q: a. Complete the analysis, determining the optimal solution for shipping at the Mosier Clothing…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: What is the assembly-line efficiency? Round your answer to one decimal place. %
A: Project schedule helps in calculating different values all related to the production cycle like the…
Q: Hart Manufacturing makes three products. Each product requires manufacturing operations in three…
A: Decision Variables: Suppose-P1 = Units of Product 1 to be producedP2 = Units of Product 2 to be…
Q: Why would this cause a procurement professional to integrate with trucking or train companies more…
A: Land transportation falls under the middle mode as compared to air and sea transportation because of…
Q: A key factor for success for a retailer is a phenomenal forecasting process and resources (Jack…
A: Forecast accuracy refers to the extent the forecast is near the actual demand/sales. If the forecast…
Q: Which of the following aspects of supply chain management have strong connections? (Check all that…
A:
Q: f feasibility study
A: A feasibility study examines a proposed project in-depth and takes into account all factors that are…
Q: a. Let X, number of skirts produced, X₂= number of dresses produced, X₂ = number of sport coats…
A: The objective is to maximize the total profit. Profit per unit of X1 = $ 10 Profit per unit of X2…
Q: If D = 8,500 per month, S = $46 per order, and H = $2.00 per unit per month, Part 2 a)…
A: EOQ considers the cost of placing an order, the cost of storing goods, and the time of restocking.…
Step by step
Solved in 2 steps with 4 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?Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
- 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?
- Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?Based on the following sensitivity analysis, which of the following products would be considered most sensitive to changes or errors in the objective function coefficient? Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient AllowableIncrease AllowableDecrease $B$2 Product_1 0 −2 25 11 4 $B$3 Product_2 175 0 25 12 14 $B$4 Product_3 0 −1.5 25 8 5 Constraints Cell Name Final Value Shadow Price Constraint R.H.Side AllowableIncrease AllowableDecrease $H$9 Resource_A 0 0 100 1E+30 100 $H$10 Resource_B 525 0 800 1E+30 275 $H$11 Resource_C 700 1.75 700 366.6666667 700 multiple choice Product_1 Product_2 Product_3