SavedEnabled: Chapter 8 Non-Linear Programming E..A firm offers three different prices on Its products, depending upon the quantity purchased. Since available resources are limited, thefirm would lke to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $15 each for the first75 units, $14 each for units 76-150, and $13 for each unit over 150. Product 2's profitability is $15 each for the first 50 units, $14 eachfor units 51-100, and $13 each for each unit over 100. The products each require 3 raw materials to produce (see table below forusages and available quantities).Product 1 usage (poundsper unit)Product 2 usage (poundsper unit)Available Quantity(pounds)Raw MaterialA.4.4.2,3002,3001,7001010Use separable programming to find the optimal production plan.(Leave no cells blank - be certain to enter "O" wherever required. Round the first two answers (units of Product 1 and 2) to thenearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.)units of Product 1 andunits of Product2The total profit from this plan will be

Objective Functions and Constraints: Based on the given details, we found the…

Answered: A firm offers three different prices on…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A publisher for a promising new novel figures fixed costs (overhead, advances, promotion, copy editing, typesetting, and so on) at $63,000 and variable costs (printing, paper, binding, shipping) $1.30 for each book produced. If the book is sold to distrubutors for $18 each, how many must be produced and sold for the publisher to break even? The publisher must produce and sell ____ books to break even.? Round to the nearest integer as needed. Thanks!@@##
At a small but growing airport, the local airline company is purchasing a new tractor for a tractor-trailer train to bring luggage to and from the airplanes. A new mechanized luggage system will be installed in 3 years, so the tractor will not be needed after that. However, because it will receive heavy use, so that the running and maintenance costs will increase rapidly as the tractor ages, it may still be more economical to replace the tractor after 1 or 2 years. The following table gives the total net discounted cost associated with purchasing a tractor (purchase price minus trade-in allowance, plus running and maintenance costs) at the end of year i and trading it in at the end of year j (where year O is now). i 012 1 $13,000 j 2 $28,000 $17,000 3 $48,000 $33,000 $20,000 The problem is to determine at what times (if any) the tractor should be replaced to minimize the total cost for the tractors over 3 years. (a) Formulate this problem as a minimum cost flow problem by showing the…
Operations planner Bradley is developing a sales and operations plan that involves back orders. The company’s demand and production rates for the next four periods are as follows
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
Palmer Jam Company is a small manufacturer of several different jam products. One product is an organic jam that has no preservatives, sold to retail outlets. Susan Palmer must decide how many cases of jam to manufacture each month. The probability that demand will be 5 cases is 0.10, for 6 cases it is 0.25, for 7 cases it is 0.50, and for 8 cases it is 0.15 The cost of every case is $45, and the price Susan gets for each case is $90. Unfortunately, any cases not sold by the end of the month are of no value as a result of spoilage. Based on the given information, Susan's conditional profits table for jam is: Demand 5 cases 6 cases 7 cases 8 cases Produce =0.10 0.25 0.50 0.15 5 cases Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply a national retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. Your answer will be the production hours needed to execute a production plan that minimizes costs-rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this chapter) Use Scenario 2 Pneum. Cost Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Cost Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 2 52 0.2 0.3 0.1 22,000 67 0.3 0.4 0.1 15,500 10,000 15.000 4.800 Scenario 2 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 15,500 20,000 18,000 4,200 Scenario 3 38.50 0.25 0.4 0.1 18.000 44 0.4 0.4 0.2 14,000 20,000 18,000…
please do not give solution in image format thanku
Lake Stevens Marina has estimated that fixed costs per month are $350,000 and variable cost per dollar of sales is $0.30 . The selling price per dollar of sales is: $1.00 Determine the effect on the break-even point in sales dollars considering each of the following independently. 1. Total fixed costs increase to $365,000. Break-even point = ÷ = 2. Variable costs decline to $0.25 per sales dollar. Break-even point = ÷ = 3. The anticipated sales volume increases to $1,100,000. Break-even point = ÷ = Comment on the BEPs from the above analyses in questions 1,2,3.
I am not sure why i got it marked incorrect
A plant operation has fixed cost of $2,000,000 per year, and its output capacity is 100,000 electrical appliances per year. The variable cost is $70 per unit, and the product sells for $120 per unit. a) What is the annual break even volume of this product? b) Compare annual profit when the plant is operating at 90% capacity with the plant operation at 100% capacity. Assume that the first 90% of capacity output is sold at $120 per unit and that the remaining 10% of production is sold at $100 per unit. Show handwritten solutions
According to the latest unemployment report, American manufacturing added 24,000 jobs last month but in Skowhegan Maine more than 300 manufacturing jobs at a New Balance shoes plant could be on the line in the face of new competition overseas. Employees at the plant, like Skip Bowman, know that his company would make more money if it would shut down the plant and move his job oversees. He says that every day he walks through the doors; he is part of the effort to keep the factory going. New Balance is the last major brand to produce athletic shoes in the U.S. About 25% of its manufacturing is still in New England where it has operated for nearly a 100 years. The privately owned company says it is committed to its American workers. In discussions with Pat Welch, plant manager for New Balance, he says that if they were thinking about the bottom line and only the bottom line, New Balance wouldn’t be here (Skowhegan Maine). In the backdrop of plant operations, Welch interacts with workers…
You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model and a cordless model. You have contracted to supply a national retail chain with both pneumatic nailers and cordless nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. Your answer will be the production hours needed to execute a production plan that minimizes costs - rounded to the nearest whole hour. (The number of nailers may not be a whole number, which is acceptable in this chapter.) Use Scenario 2 Pneum. Cost Pneum. Prod Hrs Pneum. Test Hrs Pneum. Pkg Hrs Pneum. Sales Cordless Cost Cordless Prod Hrs Cordless Test Hrs Cordless Pkg Hrs Cordless Sales Prod Hrs max Testing Hrs max Pkg Hrs max Scenario 1 Scenario 2 Scenario 3 52 0.2 0.3 0.1 22,000 67 0.3 0.4 0.1 15,500 10,000 15,000 4,800 55.50 0.4 0.3 0.1 24,500 69.75 0.3 0.5 0.1 15,500 20,000 18,000 4,200 38.50 0.25 0.4 0.1 18,000 44 0.4 0.4 0.2 14,000 20,000 18,000…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS