Ex-2: Reddy mikks produces both interior and exterior paints from tow raw materials M1 and M2 the following table providers the basic data of the problem Exterior Interior point point M1 6. 4. 24 M2 1 6. Profit 4 A market survey indicates that the daily demand for interior point cannot exceed that for exterior point by more than 1 ton. Also the max daily demand for interior point is 2 ton. Reddy mikks wants to determine the best produced mix of interior and exterior points that maximize total daily profit A
Q: GNPC has three refineries that produce gasoline, which is then distributed to four large storage…
A: Find the Given details below: Given details: Refinery To Accra Kumasi Bawku Afloa Refinery…
Q: IAN Ltd produces both interior and exterior paints from two raw materials, X and Y. The following…
A: Based on the given details, the objective functions and constraints are Objective Function: Max Z…
Q: Company Dragon has decided to produce two kinds of new food made from Flour and chili, that is A and…
A: Here, one can think of maximizing revenue but for any business maximizing revenue is not the primary…
Q: Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens…
A: Given Information:
Q: Two plants supply three customers with medical supplies. The unit costs of shipping from the plants…
A: TOTAL number of supply plant: 2TOTAL number of demanded customer: 3 The given problem table is:- As…
Q: Four qualified postgraduate students are to be allocated to four professors. The preference given by…
A:
Q: For the linear program Max 2A + 3B s.t. 1A + 2B = 0 find the optimal solution…
A:
Q: Problem 3 Florida Generation owns two generating units with the following cost curve: C, -15+1.4P,…
A: Given, C =15+14P, +0.04P/ Sh. 505P, S150 C, = 25 +16P, +0.02P; /h. 2005 P, S 500
Q: 4. "Inside Edge," a sports equipment manufacturing company, plans to advertise its products and to…
A: Decision Variables: Suppose, No. of Television ads = x1 No. of Radio ads = x2 No. of Newspaper ads =…
Q: PROBLEM 7 Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to…
A:
Q: Note: Provide the complete Linear Programming Model. Show solutions (i.e. decision variables,…
A: Decision variable: Suppose-T = No. of monthy TV spotsN = No. of monthy daily newspaper (full-page…
Q: Given the linear program Max 3x+4y S.T. -x+2y/=0 A. Write the…
A:
Q: 1. Discuss the positive impact of ICT in education and Business 2. Highlight the negative impact of…
A: Note: - Since we answer only 3 questions, your question has got subparts in question number 3. So we…
Q: Ex-2: Reddy mikks produces both interior and exterior paints from tow raw materials Ml and M2 the…
A: Given information, Exterior Point Interior Point M1 6 4 24 M2 1 3 6 Profit 5 4…
Q: Company Z is contemplating a product development program encompassing 6 major projects. The company…
A: Here, there are six projects, let's say project 1 would be selected then, Project 1=1, If project 1…
Q: Problem 2. A company that produces instant mashed potatoes must meet demand for the next four months…
A: Month 1 Month 2 Month 3 Month 4Demand dlbs…
Q: Bob Jones is the production manager for a furniture manufacturing company. The company produces…
A: The question is related to linear Programming and is the problem of maximization. In this profit…
Q: facilities for drone production. The table below shows the potential profits/losses for each…
A: Ans15(18) Decision under equally likely rule--- States of nature Excellent Good Fair Poor Average…
Q: Consider the following linear program: Max 3A + 3B S.t. 2A + 4B 0 Find the Optimal Solution using…
A: Point X coordinate (A) Y coordinate (B) Value of the objective function (Z) O 0 0 0 A 0 3 9 C…
Q: 3.4-11. Larry Edison is the director of the Computer Center for Buckly College. He now needs to…
A: Find the Given details below: Time Periods covered by shifts - Full Time Time of day…
Q: Use the information below to answer the following question. Maximize: 2X, + 3X2 Subject X2 1. to: 2.…
A: First let me formulate the LP programming Maximize Z=2*X1+3*X2 Constraints are X1 + X2=<6…
Q: Plant Electronics Limited is considering producing three new computer boards on a daily basis. Each…
A: Given Information:
Q: The ABC Company manufactures three products A, B, and C. Following table lists the labor and…
A: The question is to find out the number of units that should be produced to maximize profit. Let A=…
Q: A firm offers three different prices on its products, depending upon the quantity purchased. Since…
A: Let; x11=Units produced of Product 1 with a profit of $16 x12=Units produced of Product 1 with a…
Q: The International Chef, Inc., markets three blends of oriental tea: premium, Duke Grey, and…
A: Let, x1 be the number of pounds of premium tea x2 be the number of pounds of Duke grey tea x3 be the…
Q: Road Runner Co is a Pakistani manufacturer making Bicycles. It exports to two markets, Bangladesh…
A:
Q: Determine the distribution for the company so as to minimize the cost of transportation using least…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: 5. George Johnson recently inherited a large sum of money; he wants to use a portion of this money…
A: given, 6% for the bond fund 10% stock fund The total return of at least 7.5%
Q: BP Cola must decide how much money to allocate for new soda and traditional soda advertising over…
A: Use the maximization function here to find the maximum profit gained.
Q: A company wants to hire 4 vendors for the sale of 4 products, they could only sell one type of…
A: Find the Given details below: Given details: Seller Product 1 2 3 4 1 14 5 8 7 2 2 12 6 5…
Q: The following table shows the amount spent by four U.S. airlines to fly one available seat 1 mile in…
A:
Q: An investment advisor at RMC Financial Services wants to develop a model that can be used to…
A: x1 ,x2,x3 and x4 are corresponding ratio of stocks ,bonds, mutual funds and cash- x1+x2+x3+x4 = 1 x1…
Q: 1. Sporting Goods Product Mix. Kelson Sporting Equipment, Inc. makes two types of baseball gloves: a…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Problem 2 Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed…
A: Note: I have answered for sub-parts (1) and (2). Kindly post the remaining sub-parts separately.
Q: 3.4-17. Joyce and Marvin run a day care for preschoolers. They are trying to decide what to feed the…
A: Consider the provided details to solve the subparts. Below are the following decision variables…
Q: Consider the following linear program. 1A-28 15 (a) Graph the feasible region for the problem. B 10…
A: Given LP: Max Z = A - 2BSubject to-Constraint (1):-4A + 3B≤3Constraint (2): A - B≤5Non-negativity…
Q: Aggie Power Generation supplies electrical power to residential customers for many U.S. cities. Its…
A:
Q: Salvador Apparel Company in Barcelona, Spain, has three production departments and two service…
A: The step-down allocation is as follows:
Q: A local television station plans to drop three Friday evening programs at the end of the season.…
A: Find the Given details below: Given details: 5-6 PM 6-7 PM 7-8 PM Home Improvement $…
Q: ILP Case: Please provide a mathematical formulation for each of the constraints (appearing on…
A: Given data: Car model Manufacture Category Retail price 1 A Sedan 17 2 A Sedan 24 3 A…
Q: PROBLEM A Kelson Sporting Equipment, Inc. makes two different types of baseball gloves: a regular…
A: This question is related to the topic Decision making and this topic falls under Operations…
Q: Based on the following sensitivity analysis, which of the following products would be considered…
A:
Q: Three electricity generating firms are competing in the market with the inverse demand given by P[Q)…
A: SOLUTION:
Q: This question is based on the following table, which shows some parameters of various weapons used…
A: Weapon Denoted by Axe (Throwing) A Javelin J Longsword L Mace (Light) M Spear S
Q: 1) The Texas Consolidated Electronics Company is contemplating a research and development (R&D)…
A: Given data is Project Expense Scientists required Profit 1 $60,000 7 $3,60,000 2 $1,10,000 9…
Q: Case Problem: Textbook Publishing ASW Publishing, Inc., a small publisher of college textbooks,…
A: Sales forecasting is the most common way of assessing future income by anticipating how many items…
Q: PROBLEM 7 Eyewitness News is shown on channel 5 Monday through Friday evenings from 5:00 P.M. to…
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Problem 5. Formulate the following situation as a linear optimization problem. Your company makes…
A: The above-given problem is of Liner optimization. Linear programming (LP, likewise called linear…
Q: Tuesday Wednesday 8. 14 Thursday 7 Friday 15 Saturday Sunday 18 The manager is considering several…
A: In the given question we are provided with the data of a famous Restaurant . In this question…
Step by step
Solved in 3 steps
- 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%.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.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?