Question: PLEASE USE EXCEL WITH FORMULAS************** Problem 2 Each year, Data Corporal produces up to 5000 computers in Boston and up to 3500 computers in Charlotte.

PLEASE USE EXCEL WITH FORMULAS**************

Problem 2 Each year, Data Corporal produces up to 5000 computers in Boston and up to 3500 computers in Charlotte. There are customers in Los Angeles, New York, and Seattle how must receive 2300, 3700, and 1300 computers, respectively. Computers are transported by plane and can be sent through a warehouse in Chicago (See network diagram on the next page) Customers Factories Warehouse 2300 LA 5000 Boston Chicago New York 3700 3500 Charlotte Seattle 1300 Factory Capacities Demands The graph indicates the factory capacities and the demand requirements at the customers. Parts do not stay at the Chicago warehouse; they must move on to the customers. The costs of sending a computer between pairs of cities are shown below: Data General production and shipping Unit shipping costs To From Chicago $40 $45 Los Angeles $80 Boston Charlotte Chicago New York $30 $55 Seattle $75 $85 $75 $65 $45 $60 Use Excel to determine the minimum shipping cost plan. You must indicate how many parts are transported on each selected arrow (arc) and indicate the total shipping cost

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!

Each year, Data Corporal produces up to 5000 computers in Boston and up to 3500 computers in Charlotte. There are customers in Los Angeles, New York, and Seattle who must receive 2300, 3700, and 1300...

Each year, Data Corporal produces up to 5 0 0 0 computers in Boston and up to 3 5 0 0 computersin Charlotte. There are customers in Los Angeles, New York, and Seattle how must receive 2 3 0 0 , 3 7 0...

Each year, Data Corporal produces up to 10,000 computers in Boston and up to 6,000 computers in Charlotte. There are customers in Los Angeles, New York, and Seattle who must receive 5,300, 6,700, and...

5 Homework Each year, Data Corporal produces up to 10,000 computers in Boston and up to 6,000 computers in Charlotte. There are customers in Los Angeles, New York, and Seattle who must receive...

MANAGEMENT SCIENCE QUESTION PLEASE DO IT IN EXCEL. INCLUDE ALL INPUTS AND FORMULAS Each year, Data Corporal produces up to 10,000 computers in Boston and up to 6000 computers in Charlotte. There are...

please solve all parts and show steps Problem 4: Each year, Data Corporal produces as many as 400 computers in Boston and 300 computers in Raleigh. Los Angeles customers must receive 400 computers,...

Question 3 . ( 2 5 points ) : ( MCNFP ) Each year, Data Corporal produces 4 0 0 computers in Boston and 3 0 0 computers in Raleigh. Los Angeles customers must receive 4 0 0 computers, and Austin...

Each year, Data Corporal produces as many as 400 computers in Boston and 300 computers in Raleigh. Los Angeles customers must receive 400 computers, and 300 computers must be supplied to Austin...

TACKLE ALL PARTSP5 Problem 1 The Airfare Problem1. You are trying to get the cheapest airfare that you can. You just called up and found that the ticket home will cost $400, and it cannot be refunded...

A wholesaler has recently developed a computerized sales invoicing system. Prior to implementing this system, a manual system was used. The distribution of the number of errors per invoice for the...

Fred currently earns $9,100 per month. Fred has been offered the chance to transfer for three to five years to an overseas affilliate. His employer is willing to pay Fred $10,100 per month if he...

Your client is considering donating his Whole Life Insurance policy to a Charitable Organization, as he understands there are benefits to this strategy. He is unclear what is the best way to achieve...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...