Neki Sports Company manufactures treadmills in factories located in Pittsburgh and Kansas City. Theseare shipped to regional distribution centre in Chicago. Ultimately they are delivered to supply houses inNew York and Los Angeles. The available supplies at the factories, demands at the final destinations,and shipping costs are illustrated in the table below.ToFromChicago New York | Los Angeles SupplyPittsburgh$4$81500Kansas City$3$21000Chicago$5$7-Demand1200800This problem will be formulated as a linear program in Excel to determine the optimal shippingschedule.Let (1) = Pittsburgh, (2) = Kansas City,. (3) = Chicago, (4) = New York, and (5)= Los AngelesLet xij = the number of units shipped from location i to location j.The objective function is: Minimise total cost =The number of decision variables in this problem is:The node 1 (Pittsburgh) constaint is:The node 3 (Chicago) constraint is:The non-negativity constraint is written as follows:

Answered: Image /qna-images/answer/60e2e059-e360-4758-bd03-5d626448ef56.jpg

Answered: Neki Sports Company manufactures…

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

need comprehensive and correct answers.This question is about optimization.
please answer this question asap thank you.
A researcher believed that the number of rental cars in service by a car rental company would have an impact on the total annual revenue for that car rental company. Five small car rental companies were surveyed, with the number of Cars in service recorded in units of 1000 (so if a car rental company had 54000 cars in service, a 54 would be recorded) and Annual Revenue measured in millions of dollars (so an Annual Revenue of $10,000,000 would be recorded as 10). The data follows: Cars (1,000s) Annual Revenue ($ millions)11.5 118 10.0 135 9.0 100 5.5 37 3.3 32 Part of the Excel-generated Simple Linear Regression output is provided below: ANOVA df SS MS F Significance F Regression 1 7891.863897 7891.863897 22.91180151 0.017339231 Residual 3 1033.336103 344.4453677 Total 4 8925.2 Coefficients Standard Error t Stat P-value Intercept -19.12490108 23.1658578…
You are thinking of making your home more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs and insulating part or all of your exterior walls. Each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† Your home has 60 light fittings and 1,200 square feet of uninsulated exterior wall. You can spend no more than $1,300 and would like to save as much per year in energy costs as possible. How many compact fluorescent light bulbs and how many square feet of insulation should you purchase? Please don't give handwritten answer..thanku
You are thinking of making your home more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs and insulating part or all of your exterior walls. Each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† Your home has 50 light fittings and 1,200 square feet of uninsulated exterior wall. You can spend no more than $1,300 and would like to save as much per year in energy costs as possible. How many compact fluorescent light bulbs and how many square feet of insulation should you purchase? (If an answer does not exist, enter DNE.) compact fluorescent light bulbs bulbs insulation sq ft How much will you save in energy costs per year?
The new city water company that you have researched charges homeowners based on how much water they use in thousands of gallons. The company progressively charges at a higher rate the more water that is used. Cost of Water Bill (dollars) 240 230 220 210 190 180 170 160 110 Water Usage (in thousands of gallons) 11. Based on the graph above, how much does the city charge when a homeowner uses the following number of gallons of water: a) 1700 gallons of water b) 2000 gallons of water c) 7000 gallons of water 12. Finish filling in the following piece-wise equation below that describes the chart based on the graph 50 if 0 < x <2 5x+50 y = if 6≤x≤8 30x 140

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