Your model was implemented in Excel with the output given in Figure 2. Use it toanswer the questions that follow.Figure 2: Output from Attah & Sons DataEFGH1Banuro & Sons ProblemSupply/DemanFroCos NodeNet2 ShipToFlowSekon3.2000016 di6.530000 -30,000141000017 Kumasi40000 -40,0007.52Sekon400006 di7325000 -25,00067 Kumasi835000 -35,0004Sekon8.2736 di33000 -33,0007.28250007 Kumasi56 Sekondi60000 60,000Tamal6.78e7 Kumasi6300070,0007.71047 Kumasi8 Tamale4000040,000Tamal113500047Total12280007 Kumasi7.5CostTamal6.7135000b) Determine the optimal solution to the Attah & Sons problem,5752.

As per the given excel output, the total optimal cost is 1155000 Optimal shipment schedule…

Answered: Your model was implemented in Excel…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter7: Nonlinear Optimization Models

Section: Chapter Questions

Problem 49P: If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60...

See similar textbooks

Similar questions

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%.
Use the simplex method to solve the following LP Max z = 2x1 + 3x2 s.t. x1 + 2x2 <= 6 2x1 + x2 <= 8 END LP Please use tableau like the one in the attached image, thanks
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. City wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Pool Attendance Temperature (°F) Weather Condition 150 89 Sunny 100 82 Rainy 125 81 Cloudy 130 86 Cloudy 155 93 Cloudy 170 98 Sunny 200 99 Sunny 180 87 Sunny 190 88 Sunny 140 83 Sunny 120 82 Cloudy 90 81 Rainy 130 87 Rainy 120 93 Rainy Should you keep weather condition in the model?
Can you show how to put it in Excel? XYZ store sells regular and premium nut mixes. Premium mix contains three quarters pound of cashews and one quarter of peanuts, and the regular mix has half pound of cashews and half pound peanuts per bag. The shop has 200 pounds of cashews and 300 pounds of peanuts to work with. Cashews cost $1.50 per pound, and peanuts cost 60 cents per pound. Premium mix will sell for $2.90 per pound, and the standard mix will sell for $2.55 per pound. The owner esimtes that no more than 200 bags of one types can be sold. What is the best combinations of products that maximizes profits? Make sure to create a feasible solution with countable number of products (no partials)
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 ?????
Please give step by step solution is MS Excel using Solver or SolverTable The Pine Valley Board of Education must hire teachers for the coming school year. The types of teachers and the salaries that must be paid are file attached Q.pnng For example, 20 teachers who are qualified to teach history and science have applied for jobs, and each of these teachers must be paid an annual salary of $21; 000. Each teacher who is hired teaches the two subjects he or she is qualified to teach. Pine Valley needs to hire 35 teachers qualified to teach history, 30 teachers qualified to teach science, 40 teachers qualified to teach math, and 32 teachers qualified to teach English. File attached Q_ The board has $1.4 million to spend on teachers’ salaries. A penalty cost of $1 is incurred for each dollar the board goes over budget. For each teacher by which Pine Valley’s goals are unmet, the following costs are incurred (because of the lower quality of education): science, $30; 000; math, $28; 000;…
Could anyone answer this problem? We have four products: Scones ($1 revenue) Bagels ($2 revenue) Donuts($0.25 revenue) Cookies ($0.75 revenue) You have 130 lbs of butter. You have 300 lbs of flour. You have 180 eggs. You have 160 lbs of sugar. You have 100 gallons of milk. A scone requires 0.05 lbs butter, 0.2 lbs flour, 0.25 eggs, 0.1 lbs sugar, and 0.02 gallons of milk. A bagel requires 0.15 lbs butter, 0.25 lbs flour, 0.1 eggs, 0.05 lbs sugar, and 0.01 gallons of milk. A donut requires 0.05 lbs butter, 0.08 lbs flour, 0.2 eggs, 0.15 lbs sugar, and 0.15 gallons of milk. A cookie requires 0.15 lbs butter, 0.3 lbs flour, 0.05 eggs, 0.12 lbs sugar, and 0.05 gallons of milk. To have enough items on display and to keep the bakers busy, you must produce at least 100 of each. However, since these are perishable goods, we seldom manage to sell more than 500 of each before the remainder go bad, so don’t make more than 500 of any item. Because of past demand patterns,…
Based on Brams and Taylor (2000). Suppose that EliLilly and Pfizer are going to merge. Merger negotiations must settle the following issues: ■ What will the name of the merged corporation be?■ Will corporate headquarters be in Indianapolis(Lilly wants this) or New York (Pfizer wants this)?■ Which company’s chairperson will be chairperson of the merged corporation?■ Which company gets to choose the CEO?■ On the issue of layoffs, what percentage of each company’s view will prevail?Brams developed a remarkably simple method for the two adversaries to settle their differences. (This same method could be used to settle differences between other adversaries, such as a husband and wife in a divorce, Arab and Israel in Middle East, and so on.) Each adversary allocates 100 points between all of the issues. These allocations are listed in the file P04_84.xlsx. For example, Lilly believes headquarters is worth 30 points, whereas Pfizer thinks headquarters is worth only 15 points. Layoffs may be…
MaximizationProblems and Minimization problems ***When using the simplex method, what is the difference between maximizing and minimizing?
Shoemakers of America forecasts the following demandfor each of the next six months: month 1—5,000 pairs;month 2—6,000 pairs; month 3—5,000 pairs; month 4—9,000 pairs; month 5—6,000 pairs; month 6—5,000 pairs. Ittakes a shoemaker 15 minutes to produce a pair of shoes.Each shoemaker works 150 hours per month plus up to 40hours per month of overtime. A shoemaker is paid a regularsalary of $2,000 per month plus $50 per hour for overtime.At the beginning of each month, Shoemakers can either hireor fire workers. It costs the company $1,500 to hire a workerand $1,900 to fire a worker. The monthly holding cost perpair of shoes is 3% of the cost of producing a pair of shoeswith regular-time labor. (The raw materials in a pair of shoescost $10.) Formulate an LP that minimizes the cost ofmeeting (on time) the demands of the next six months. Atthe beginning of month 1, Shoemakers has 13 workers
Shoemakers of America forecasts the following demandfor each of the next six months: month 1—5,000 pairs;month 2—6,000 pairs; month 3—5,000 pairs; month 4—9,000 pairs; month 5—6,000 pairs; month 6—5,000 pairs. Ittakes a shoemaker 15 minutes to produce a pair of shoes.Each shoemaker works 150 hours per month plus up to 40hours per month of overtime. A shoemaker is paid a regularsalary of $2,000 per month plus $50 per hour for overtime.At the beginning of each month, Shoemakers can either hireor fire workers. It costs the company $1,500 to hire a workerand $1,900 to fire a worker. The monthly holding cost perpair of shoes is 3% of the cost of producing a pair of shoeswith regular-time labor. (The raw materials in a pair of shoescost $10.) Formulate an LP that minimizes the cost of At the conclusion of the season, this method has beenused to determine ratings for college football and collegebasketball. What problems could be foreseen if this methodwere used to rate teams early in the…
WHAT IS THE NEW TOTAL VALUE? A garden store prepares various grades of pine bark for mulch: nuggets (x1), mini-nuggets (x2), and chips (x3). The process requires pine bark, machine time, labor time, and storage space. The following model has been developed. Maximize 9x1 + 9x2+ 6x3 (profit) Subject to Bark 5x1 + 6x2 + 3x3 ≤ 600 pounds Machine 2x1 + 4x2 + 5x3 ≤ 600 minutes Labor 2x1 + 4x2 + 3x3 ≤ 480 hours Storage 1x1 + 1x2 + 1x3 ≤ 150 bags x1, x2, x3 ≥ 0 What is the new value of the objective function, if the profit on chips increases from $6 per bag to $7 per bag? The New Value Is=

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS