sing Excel Solve the following LP Maximize $4x + $5y Subject to 2x + 3y ≤ 20 (labor, in hours) 6x + 6y ≤ 36 (materials, in pounds) 4x + 4y ≤ 40 (storage, in square feet) x, y ≥ 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material? c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor?
Q: b) Closing the Gap: Financing the Region's Transportation Needs c) PROVIDERS Private Investors…
A: The objective of the question is to understand the benefits, key terms, and challenges related to…
Q: Week 5Discussion 1Sustainability is an important ethical and environmental issue in purchasing.…
A: “Since you have posted multiple questions, we will provide the solution only to the first question…
Q: Southern California Edison’s prices, service quality, and investments in new facilities are…
A: Business Law is the aspect of law that deals with the many components of business practices, rules,…
Q: Which three of the logistics activities constitute an average of 80% of the total logistics cost of…
A: The process and coordination of goods, supplies, and services along the supply chain is referred to…
Q: (B) Arrange the example of products based on the classification of production system from low…
A: Production management is the aspect that deals with all the activities and functions of the…
Q: You are part of a management team with responsibility for some key business operations (with a…
A: Learning refers to gaining knowledge or information through study; and developing skills and…
Q: COVID-19 in different hospitals nationwide. Below are the costs of production and demands of the…
A: The question presents a scenario where a manufacturer is producing face masks and PPEs for the…
Q: You have been asked to put together a capacity plan for a critical operation at the Surefoot Sandal…
A: This capacity planning exercise operates within a framework of two 8-hour shifts, a 5-day workweek,…
Q: a) Labor productivity per labor hour for these tires= 2.35 tires/labor hour (round your response to…
A: The total output of tires per day is 1000, The labor hours per day=425
Q: Casper Computer(CC) produces X model of computers of its own brand by assembling computer parts…
A: Linear programming helps us to find the optimal solution/best outcome, given the constraintsWe want…
Q: Can you show where the values go in an excel photo?
A: InvestmentExpected ReturnMaximum AllowedLow-income mortgage loans6.50%20%Conventional mortgage…
Q: Question Content Area Control is the process of choosing goals and deciding how to achieve them.…
A: Management specifically the art of doing things by others Every organization has its management for…
Q: Why are these departments key to the success of the organization?
A: Strategic management is a comprehensive and ongoing process that involves the formulation,…
Q: The Flip Chip Company manufactures nacho chips, potato chips, and related products. There has been a…
A: A bottleneck is a point of congestion in any system that slows things down overall. This could be…
Q: question _. though both incentives and disincentives can be used as motivators, how should their use…
A: Motivation is a crucial aspect of effective management, and managers often employ incentives and…
Q: What order quantity should be used? b. What reorder point should be used? c. What is the total…
A: Daily demand = 4 lures per day Total working days = 350 days Hence, Annual demand (D) Standard…
Q: In your own words, briefly explain the SWOT Analysis as a Management Tool and attempt to use your…
A: SWOT analysis is the aspect of business environment analysis that includes a framework that assists…
Q: Three mutually exclusive alternatives are being considered: Initial cost Benefit at end of the first…
A: In capital budgeting and investment planning, we analyze the profitability of a project. Discount…
Q: Suppose a common resource-wood in a public forest-is being overused because residents consider the…
A: The scenario described involves the overuse of a common resource (wood in a public forest) due to…
Q: H.B. Fuller Corporation illustrates how first-hand information gained through supplier visits plays…
A: Supply chain management is the aspect of management that deals with the flow or movement of…
Q: Problem 12-4 (Algo) A toy manufacturer uses 43,740 rubber wheels per year for Its popular dump truck…
A: Inventory management efficiency is a contributing factor to an enlarging supply chain. It…
Q: If the order quantity doubles but the flow rate remains constant, what happens to the sum of…
A: Ordering cost- The price that is paid every time an order is placed to restock inventory. Costs…
Q: 1- Formulate the following LP problem A company produces both exterior and interior house paints.…
A: Linear programming problems help the organization to optimize some of the processes involved in the…
Q: What is the Market Share of Company A? The industry has 3 competitors with the following sales:…
A: A market specifies a place where the buyers or purchasers and sellers of the goods or product meet…
Q: . We want to test a product that rejects lots with a mean life of 5000 hours (AQL)with a producer's…
A: Producer risk is a component of quality control as improperly tight producer sampling plans that…
Q: 1. _____ refers to providing basic software online free that gives everyone source code, thus…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: a.Discuss a few objectives of facility layout, and why capacity needed to be understood? b.…
A: Facility design refers to the arrangement of physical infrastructure to create an optimal…
Q: a) b) c) Formulate a linear programming model for the above problem. Prepare the first simplex…
A: Let me state the given data, Product XProduct YProduct ZProfit per unit302520ConstraintsProduct…
Q: The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100…
A: Inventory management is the part of production or operation management of an organization including…
Q: In aviation Why it is important to have an effective and proper maintenance program? What is the…
A: Business management is necessary for any organization of any size and nature that sharpen its three…
Q: Video interviews with College of Professional Studies faculty who are also professional…
A: Education is the aspect of society concerned concern with the process or activity of obtaining or…
Q: A manufacturer is producing face masks and PPEs for use by the DOH for its frontliners to be…
A: Find the given details below:Note that, here we did not consider the cost and profit values for the…
Q: The firm makes 10,000 auto part a year and it needs a onetime cost of $ 200,000 to reduce the…
A: The amount of stuff or services made by a company or factory at a certain time is called production…
Q: Activity 4A: I conduct performance ratings for two employees of the same nature of work using the…
A: Performance rating is a tool that measures and judges how well an individual or group has done in…
Q: A political candidate is planning his media budget for an upcoming election. He has $90,500 to…
A: S = Number of small signs placed by the roadsideL = Number of large signs placed by the roadsideB =…
Q: A) Using a hypothetical project in the mentioned company, prepare a Work Breakdown Structure for…
A: Here, the project is about implementing a new customer relationship management system, The final…
Q: To manage transactions with the organizational environment effectively, managers should chart the…
A: Business environment is the aspect that deals with the study of the factors or components that…
Q: What is difference between assembly plant compared to more typical auto assembly plants? - Why do…
A: Production management is the aspect that deals with all the activities and functions of the…
Q: A coach who fails to explain the risk involved with their sport and this results in a catastrophic…
A: The objective of the question is to identify the legal term for the situation where a coach fails to…
Q: How can I be sure that the Improve recommendations I propose to solve my work conflict contain as…
A: Work conflict is a situation where individuals or groups working in an institution are characterized…
Q: Explain how health care robots will integrate into a specific type of organization
A: To integrate healthcare robots into a specific type of organization, we will look at various areas…
Q: What is direct relief organization's board structure
A: The objective of the question is to understand the board structure of the Direct Relief…
Q: Q4) What Is Project Quality Management? Write briefly about the five Cost Categories Related to…
A: Project quality management, which focuses on making sure a project fulfils its criteria and produces…
Q: Create a Decomposition Diagram for the three Solutions 3 Problems seen in the situation of the…
A: The interconnected system of tasks and procedures essential to maintaining and growing the success…
Q: The HERCULES company's Process Manager should decide the location of his company's facilities. He…
A: Cross over point is the sales/production volume at which the two or more alternatives have the…
Q: How might the activities be adjusted for improving the SRH voucher program’s desired results if the…
A: The objective of the question is to identify potential improvements for the Sexual and Reproductive…
Q: Do you think it will ever be possible to develop a motivation framework that is applicable in all…
A: The quest for a universally applicable motivation framework stands as a compelling challenge,…
Q: What types of owners do you believe are best served hiring management companies?
A: Management specifically the art of doing things by others every organization has its management for…
Q: Question 1. The ABG company manufactures machinery used in gardening. It has taken the decision to…
A: Work UnitDescriptionTime (Sec)Prerequisites PapersA Base Construction40NoneB Addition of the…
Q: The distribution manager, Randy Smith, now wants to determine the best plan for how many shipments…
A: Let me state the given data, Plant /Retail…
Using Excel
Solve the following LP
Maximize $4x + $5y
Subject to 2x + 3y ≤ 20 (labor, in hours)
6x + 6y ≤ 36 (materials, in pounds)
4x + 4y ≤ 40 (storage, in square feet)
x, y ≥ 0
- a) Write the original optimal solution and objective function value.
- b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material?
- c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor?
Step by step
Solved in 6 steps with 5 images
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.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?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?