Question: Harbert Electronics makes custom electronics components for many different industries. They have manufacturing facilities in Denver and Atlanta. They ship the components to warehouses in

Harbert Electronics makes custom electronics components for many different industries. They have manufacturing facilities in Denver and Atlanta. They ship the components to warehouses in either Kansas City or Louisville. From there the components are shipped to their customers in Detroit, Miami, Dallas, or New Orleans.

The quantities of components shipped per day and the cost per component is on the diagram below.

Find the minimized cost for this scenario.

Use Excel and the solver data tool to complete this question.

Harbert Electronics makes custom electronics components for many different industries. They

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Harbert electronics makes custom electronic components for many different industries they have manufacturing facilities in Denver in Atlanta they ship the components to warehouses in either Kansas...

Harbert Electronics makes custom electronics components for many different industries. They have manufacturing facilities in Denver and Atlanta. They ship the components to warehouses in either...

Harbert electronics makes custom electronic components for many different industries they have manufacturing facilities in Denver and Atlanta they ship the components to warehouses in either Kansas...

For this assignment, you will read the Electrolux and GE Appliances case study, which offers an analysis of the Electrolux?s valuation process during its acquisition of GE Appliances in August of...

The transshipment problem is an extension of the transportation problem in which intermediate nodes, referred to as transshipment nodes, are added to account for locationssuch as warehouses. In this...

Ryan Trucking provides all of the transportation for Spencer Electronics. Spencer Electronics produces components in the Denver and Atlanta Areas. The components produced in either Denver or Atlanta...

If for some reason, the plant in Atlanta can only supply 300, what is the optimal solution? (formulate this problem in two ways) If the plan in Atlanta can only supply 300, and the demand in New...

The pH of a saturated solution of magnesium hydroxide (milk of magnesia) was found to be 10.52. From this, find Ksp for magnesium hydroxide.

Lee Nicholas has been the owner and has operated World.com Advertising since its beginning 10 years ago. The company has prospered. Recently, Nicholas mentioned that he would sell the business for...

After the return has been filed, the taxpayer may find it necessary to file additional information either because income was omitted or refund or credit was not claimed on original return. IRS does...

Free cash flow valuation You are evaluating the potential purchase of a small business with no debt or preferred stock that is currently generating $ 4 2 , 7 0 0 of free cash flow ( F C F 0 = $ 4 2 ,...