A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements its fourcustomers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, areshown in the table below:Factory(capacity)A (100)B (75)C (100)D (250)Customer 1(125)$15A. $10,050B. $9,000C. $9,100D. $8,950E. $8,750$20$22$21Customer (requirement)Customer 2 Customer 3(150)$10$12$20$15(175)$20$19$25$28Customer 4(75)$17$20$14$12Note: This question requires Solver.Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customerrequirements?

Formulate the given problem in excel and solve by using excel solver:Formulation:Excel solver input…

Answered: A manufacturing firm has four plants…

Advanced Engineering Mathematics

10th Edition

ISBN:9780470458365

Author:Erwin Kreyszig

Publisher:Erwin Kreyszig

Chapter2: Second-order Linear Odes

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Can you guys help me on this? Thank you!
Example 3. Food I contains 10 units of vitamin A and 12 unit of vitamin R gram and cost 20 paise per gram. Food II contains 7 unit of vitamin A and 15 unis of vitamin B and costs 18 paise per gram. The daily requirement of vitamin A and R are atleast 80 units and 90 units respectively. Formulate the above as an LPP to per minimise the cost. CS Scanned with CamScanner
Trans Global Tractor Trailers has decided to spend up to $2,700,000 on a fleet of new trucks, and it is considering three models: the Gigahaul, which has a capacity of 6,000 cubic feet and is priced at $60,000; the Megahaul, with a capacity of 5,000 cubic feet, priced at $50,000; and the Picohaul, with a capacity of 2,000 cubic feet, priced at $40,000. The anticipated annual revenues are $500,000 for each new truck purchased (regardless of size). Trans Global would like a total capacity of up to 234,000 cubic feet and feels that it cannot provide drivers and maintenance for more than 54 trucks.How many of each should it purchase to maximize annual revenue? (Gigahaul, Megahaul, Picohaul) = trucks What is the largest possible revenue it can make? $
There are three factories located at AR, IN, and TX respectively. From these locations, a certain commodity is to be delivered to each of the two warehouses situated at A and B. The revenue per commodity item is $10. The weekly demand of the warehouse A and B are respectively 50 and 35 units of the commodity while the production capacity of the factories at AR, IN, and TX are respectively 28, 22, and 35 units. The cost of transportation per unit is given as belows. Cost Warehouse A Warehouse B AR 5 3 IN 6 6 TX 2 4 To maintain a good relationship with all the factories, warehouse B requires that it receives at least 40% of its product from factory in TX. Realize that it is making good profit in warehouse A, AR requires that at least 35% of its product shipped to warehouse A. Formulate (without solving) a linear programming problem to maximize the profit.
Terra Mesa Manufacturing uses a job order cost system to account for its production of specialty patio furniture. At the beginning of June, Terra Mesa had one job in Work in Process, job A75. Management has chosen direct labor cost as its activity base. The costs incurred to date on job A75 are as follows: Direct materials $8260 Direct labor 10500 Overhead 13125 During June, Terra Mesa added the following costs for direct materials and direct labor to job A75: Direct materials $2630 Direct labor 4620 Job A75 was competed on June 30. What is the cost of job A75? $26010 $39135 $44910 $42831
Please check my attached case problem.
Need only a handwritten solution only (not a typed one).
A florist provides fresh flowers to shops in Wollongong. At present she has one nursery in Goulburn with capacity 9000 units a year. The florist is considering opening shops in Canberra and Sydney, and has found three potential nursery sites at Wagga, Orange and Bathurst. The transportation tableau below summarises the projected nursery capacities (units), the cost per unit of shipping from each nursery to each destination (dollars), and the demand (units) for the coming year. j=1 j=2 j=3 Sydney Capacities Wollongong Canberral 5 i=1 Goulburn 12 9000 i=2 Wagga 7 10 4000 i=3 Orange 4 7000 i=4 Bathurst 11000 Demand 11000 5000 8000 There are further constraints on how the nurseries can be located: • If a nursery is located in Wagga, another must be located in Bathurst and vice- versa. • One nursery can be located in Orange or Bathurst, but not both. Suppose that the costs of establishing new nurseries are Wagga $180,000 Orange $160,000 Bathurst $270,000 The goal is to develop a 0-1…
A local firm is planning its workforce and production levels over the next year. The firm makes a variety of microprocessors and uses sales dollars as its aggregate production unit. Based on orders received and sales forecasts provided by the marketing department, the estimate of dollar sales for the next year by month is as follows: Month Production Days Predicted Demand(in $10,000) Month Production Days Predicted Demand(in $10,000) January 20 595 July 20 410 February 19 225 August 21 130 March 22 565 September 19 405 April 18 205 October 23 315 May 21 230 November 21 355 June 22 120 December 18 350 Inventory holding costs are based on a 25% annual interest charge. It is anticipated that there will be 675 workers on the payroll at the end of the current year and inventories will amount to $120,000. The firm would like to have at least $100,000 of inventory at the end of December…
TMA manufactures 37-in. high-definition LCD televisions in two separate locations: Location I and Location II. The output at Location I is at most 6500 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of televisions to Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 2600 and 4100 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the two TMA plants to the two Pulsar factories are as follows. To Pulsar Factories From TMA City A City B Location I $7 $4 Location II $8 $8 TMA will ship x televisions from Location I to City A and y televisions from Location I to City B. Find a shipping schedule that meets the requirements of both companies while keeping costs, C (in dollars), to a minimum. Minimize C =…
G.97.
You are proxided with the following information about your city: Total population 2020 = 85,000 Median household income 2020 = € 36,000 Average household income 2020 = € 42,000 Sales of clothes and shoes per square meter in 2020 = € 2,340 Make whatever assumptions areneeded and estimate the total required square meters of clothing and shoe stores in your city in 2021. Show clearly and explain all the formulas and assumptions that you use for your calculations.

Recommended textbooks for you

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Advanced Engineering Mathematics

Advanced Math

ISBN:

9780470458365

Author:

Erwin Kreyszig

Publisher:

Wiley, John & Sons, Incorporated

Numerical Methods for Engineers

Advanced Math

ISBN:

9780073397924

Author:

Steven C. Chapra Dr., Raymond P. Canale

Publisher:

McGraw-Hill Education

Introductory Mathematics for Engineering Applicat…

Advanced Math

ISBN:

9781118141809

Author:

Nathan Klingbeil

Publisher:

WILEY

Mathematics For Machine Technology

Advanced Math

ISBN:

9781337798310

Author:

Peterson, John.

Publisher:

Cengage Learning,

Basic Technical Mathematics

Advanced Math

ISBN:

9780134437705

Author:

Washington

Publisher:

PEARSON

Topology

Advanced Math

ISBN:

9780134689517

Author:

Munkres, James R.

Publisher:

Pearson,

SEE MORE TEXTBOOKS