Q1.1. Formulate the LP problem in a mathematical model. Q1.2. Minimum is obtained at what coordinates P optimal (X1,X2) with Z min of ......? ( Q1.3. Suppose the costs of the two feeds could vary. If I were to increase the objective coefficient of X1 by 10 cents then what would happen to the optimal solution? Please explain
Q: A company finds its actual sales during the first, second, and third quarters to be 183.5, 162.3,…
A: Formulae used: F(t+1) = At×α + (1-α )Ft where, F(t+1)= Forecast for the period (t+1) At = Actual…
Q: Solve the following linear programming problem graphically: Maximize Z=3X+5Y Subject to: 4X+4Y…
A: Given data is Objective function Z=3X+5Y Subject to constraints C1.) 4X+4Y≤48C2.) 1X+2Y≤20C3.)…
Q: You have recently been appointed as the executive director responsible for the purchasing function…
A: There are six criteria that you need to consider when selecting fruit and vegetable suppliers. These…
Q: (1) An architect firm uses an average of 60 boxes of copier paper a day. The firm operates 280 days…
A: Given that the average number of boxes of copier papers a day=60, The total days a year=280 The…
Q: Many of a bank’s customers use its automatic teller machine to transact business after normal…
A: Given- Arrival rate (λ) = 1 customer every 2 minutes =30 customer per hourService rate (μ) =…
Q: Quantitative Methods 1.The minimum expected opportunity loss ____________________. a.) is equal to…
A: 1. An expected opportunity loss quantifies the potential loss of making an incorrect choice in the…
Q: After reading the stem et provided: Create a flowchart of the passenger arriving at an airport for…
A: Steps involved Passengers without masks get an exit Passengers with masks check in to obtain…
Q: Activity Predecessor Duration A - 6 B A 8 C A 6 D C 4 E B 6 F b.d 7 G C 5 H…
A: Activity Immediate Predecessors Duration A - 6 B A 8 C A 6 D C 4 E B 6 F B,D 7 G C 5…
Q: (a) Formulate a linear programming model for maximizing total profit contribution. (Let Pi = units…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: GameStop has maintained 75% service level for inventory of PlayStation 5. Mean demand during lead…
A: Initial Service level = 75% Mean demand during lead time = dL = 166 Std. deviation during lead time…
Q: A project manager is in charge of 3 ongoing projects, A, B, and C. Due to recent reorganization, the…
A: Let, A = Number of employees assigned to Project A B = Number of employees assigned to project B C =…
Q: Based on your understanding of the case study and further readings, do you think Tiger Brands made…
A: SCM is a strategic approach to integrating supply and demand in the market. It involves several…
Q: A manufacturer of office furniture has recently received a number of inquiries about its interest in…
A:
Q: study a company to understand thedetails about the culture and structure of the organization.
A: The internal communications of personnel as well as how an organization functions are both impacted…
Q: Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of…
A: Given data is Ingredient Calories from fat Total Calories Vitamin content Thickeners Cost…
Q: Maximize Z = x₁ + x₂, subject to X1X₂ ≤-3 2x₁ + 7x₂ ≤ 4 and x₁ ≥ 0, X₂ ≥ 0.
A: As no particular method has been mentioned I am solving in simplex method: Max Z = x1 +…
Q: What is the orrect graph that shows the feasible region for the problem. b. What are the extreme…
A: Linear programming is a type of mathematical optimization problem. Linear programming problems are…
Q: A Lady (L) bought an item of Rs 100 from the Shopkeeper (C). She paid him through a 500 Rs Note.…
A: Given scenario-A lady has given the shopkeeper (c) = Rs 500 (to return back Rs 100)Shopkeeper (c)…
Q: RE-THINKING OPERATIONS IN THE NEXT NORMAL Operations functions—including procurement, supply chain,…
A: Manufacturing operations are described as a means through which equipment, processes, and workers…
Q: The Svelte Glove Company manufactures and sells two products: work gloves and driving gloves. The…
A: Decision Variables: Suppose-W be the no. of work gloves to be manufacturedD be the no. of driving…
Q: Niue Vanilla has had two successive years in which the Vanilla bean harvest has stretched the firm’s…
A: The expected value of perfect information is the probability that the decision-maker would choose a…
Q: Use the following Excel output to answer the following questions. a) Write only the objective…
A: Sensitivity report is a tabular representation of results derived from sensitivity analysis. Report…
Q: Each day, a FedEx competitor processes approximately 50,000 shipments. Suppose that they use the…
A:
Q: A coffee manufacturer blends four component coffee beans into three final blends of coffee. The…
A:
Q: Is cooperation or information sharing more important for businesses involved in a supply chain?
A: Sharing information is a crucial strategy for business sustainability and enables supply chain…
Q: Boston Electric Generators has been getting many complaints from its major customer, Home Station,…
A: I Have entered all the data as shown in the question. And calculated the sum from week 1 to week 8.
Q: What is the break-even point for option B?
A: Break-even point = fixed cost /(selling price-variable cost)
Q: Food Goblin Supermarkets use both cashiers and baggers to serve customers at check out. During the…
A: Time required for cashier per customer = Tr = 6 minutes Time available for each cashier per hour =…
Q: Explain each point from 1 until 4 in a simple way
A: Logistics strategy is a business strategy that consists of the steps that a company takes in order…
Q: Discuss the three system aspects and or terminology of the MRP system.
A: Manufacturing resource planning (MRP) is a system that helps companies manage their finances and…
Q: Calculate the reorder level b) Calculate the maximum level of inventory c) Calculate the minimum…
A: Given: Average usage 800 minimum usage 540 maximum usage 1260 minimum lead time 16…
Q: Problem 2 MC Electronics supplies electronic chips to a company that incorporates the chips into…
A: Given data is Monthly demand = 25 units Annual demand(D) = 25×12=300 units Carrying cost(H) = OMR…
Q: How many hours should Mary work in each place per week? State verbally the objective, constraints…
A: Steps to solve the graphical problem:- Equalize each constraint and determine the values of x1 and…
Q: List and briefly describe five approaches for creating work breakdown structures
A: A project is visually, hierarchically, and deliverable-focused disassembled using a work breakdown…
Q: A restaurant manager tracks complaints from the diner satisfaction cards that are turned in at each…
A: A pareto analysis state that the 80% of results will come out from 20% of the attributes.…
Q: Problem 4: A canoe manufacturer employs 120 men, each of whom works for up to thirty hours per week.…
A: Decision Variable: Suppose-S be the no. of standard canoeD be the no. of deluxe canoe
Q: Is employee turnover good orbad for an organization?
A: Employee turnover is bad for the Organization. The total number of employees that leave a firm over…
Q: Asia Furnishing is a retailer of modular toilet products. Currently, the lead time for one of the…
A: Lead time for 1st supplier = L1 = 5 weeks Average demand = d = 200 per week Std. Deviation of demand…
Q: A toy manufacturer makes its own wind-up motors, which are then put into different types of toys.…
A: Given data: Annual demand (D) = 62500 unitsCarrying cost (Ch) = $11.5 /unit per year. Set up cost…
Q: Suppose the distances (in kilometers) that a pharmaceutical representative, Tracy Ross, travels…
A: Find the given details below: Given details: From To 1 2 3 4 5 6 7 8 1 0 27 57 51 49 4 12…
Q: Why should a business successfully integrate its outside suppliers?
A: Any supply chain must include external suppliers since they are an essential component. In the…
Q: Short-term scheduling is important to efficiency and to cost reduction, but its impact is not of…
A: In the past, scheduling was done on a long-term basis. This meant that companies had to make…
Q: Question Sarah and Jennifer have just graduated from college at the University of Washington in…
A: The network optimization model is a concept used in supply chain management where the executives…
Q: Please advise whether the below topic can be use for DBA ( Doctorate of Business Administration)…
A: A Doctorate of Business Administration is a type of professional degree designed for individuals who…
Q: With the aid of a well-labelled diagram, explain the transformation process in a hotel .
A: The hotel industry is one of the most lucrative ones. However, in order to stay ahead of their…
Q: Identify the several kinds of real-time scheduling techniques that are accessible to the project…
A: A project team of an organization is a different type of team compared to a regular business team.…
Q: Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile…
A: Decision Variables:Suppose-x4 = No. of 4-cylinder connecting rods produced next weekx6 = No. of…
Q: You have a used CD store. At an estate sale, you can purchase 260 compact discs for $400. You…
A: Net Benefit means subtracting the all sost of a project from total revenue. Formula for calculating…
Q: Daphne Hudson works for a company with a semi-monthly pay cycle. She earns $100,000 per year and…
A: Earning per year $100,000 Work week (hrs.) 40 Parking allowance per month $100 On-call…
Q: Describe what panel data is and the reasons for using it
A: Since you have posted a question with multiple questions, we will solve the first question for you.…
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?This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.
- 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?Only Construct Linear Programming Model for the following Problemb; An individual wishes to invest $9000 over the next year in two typar of inventrent linvestment A yinlds 5% and invertment � yields 8%. Market retearch rocotnenends an allocs tion of at least 25% in A and at most 30% in �. Motsover, investment in A should be at least ball the invertmeut in �. How should the fund be allocated to the two imetrinents?Given this linear programming model, solve the model and then answer the questions that follow.Maximize Z = 12x1 + 18x2 + 15x3 where x1 = the quantity of product 1 to make, etc.Subject toMachine 5x1 + 4x2 + 3x3 ≤ 160 minutes Labor 4x1 + 10x2 + 4x3 ≤ 288 hoursMaterials 2x1 + 2x2 + 4x3 ≤ 200 poundsProduct 2 x2 ≤ 16 units x1, x2, x3 ≥ 0 a. Are any constraints binding? If so, which one(s)?
- Chapter 6. Solve the following Linear Program using the Solver method and answer the questions given below (round to two decimal places): Maximize 12A + 15B s.t. 3A + 7B <= 250 5A + 2B <= 200 B <= 25 A, B >= 0 a. The optimal value of A is 31.03 and the optimal value of B is 22.41. b. The maximized function yields a solution of 708.62. Chapter 7. For the problem you solved in Q1, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions: The range for Variable A is from ????? to ????? The range for Variable B is from ????? to ????? The range for Constraint 1 is from ????? to ????? The range for Constraint 2 is from ????? to ????? The range for Constraint 3 is from ????? to ?????The second-largest public utility in the nation is the sole provider of elasticity in 32 counties of southern Florida. To meet the monthly demand for electricity in these counties, which is given by the inverse demand function P = 1,200 – 4Q, the utility company has set two electric generating facilities: Q1 kilowatts are produced at facility 1 and Q2 kilowatts are produced at facility 2 (so Q = Q1 + Q2). The costs of producing electricity at each facility are given by C1(Q1) = 8,000 + 6Q12 and C2(Q2) = 6,000 + 3Q22 , respectively. Determine the profit-maximizing amounts of electricity to produce at the two facilities, the optimal price, and the utility company’s profits.Identify if the given linear programming problem is a standard maximization problem. If it is a standard maximization problem, then express the constraints as slack variable equations, write the objective function in standard form, and set up the initial simplex tableau. If it is not a standard maximization problem, then explain all the reasons why it is not and type NA (or Not Applicable) in the remaining boxes. Maximize: P= 3x+7y subject to: 2x-6y≤9 x+5y≤-14 Standard Max Answer Here, Yes or No with reasons (Keyboard only): Slack Variable Equations Here: (enter NA if it is not a standard maximization problem) Objective Function in Standard Form Here: (enter NA if it is not a standard maximization problem) Initial Simplex Tableau Here: (enter NA if it is not a standard maximization problem)