Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 50,000 70,000 60,000 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary 100,000 100,000 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT Boulder NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS 7 11 8 13 Macon 20 Gary 8 17 18 12 13 10 16 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. From/To Boulder New York City Fort Worth San Diego Minneapolis Supply Macon Gary Requirements b. Find the optimal solution using Microsoft Excel. (Note: Due to existing transportation contracts, Macon must ship 50,000 motors to Fort Worth and O motors to San Diego. These requirements are already shown in the Candidate Solution below.) Note: Leave the cells blank, whenever zero (0) is required. Candidate Solution New York City Fort Worth San Diego Minneapolis Total Shipped Boulder Macon 50,000 Gary Total supplied 0 50,000 0 0 0 50,000 0 50,000 Profit New York City Fort Worth San Diego Minneapolis Boulder Macon Gary Total profit 0 Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort Worth, San Diego, and Minneapolis. Plans call for the following numbers of washing machines to be produced at each location: New York City Fort Worth San Diego Minneapolis 50,000 70,000 60,000 80,000 Bindley has three plants that can produce the motors. The plants and production capacities are Boulder Macon Gary 100,000 100,000 150,000 Due to varying production and transportation costs, the profit Bindley earns on each 1,000 units depends on where they were produced and where they were shipped. The following table gives the accounting department estimates of the dollar profit per unit. (Shipment will be made in lots of 1,000.) SHIPPED TO PRODUCED AT Boulder NEW YORK CITY FORT WORTH SAN DIEGO MINNEAPOLIS 7 11 8 13 Macon 20 Gary 8 17 18 12 13 10 16 Given profit maximization as a criterion, Bindley would like to determine how many motors should be produced at each plant and how many motors should be shipped from each plant to each destination. a. Develop a transportation grid for this problem. From/To Boulder New York City Fort Worth San Diego Minneapolis Supply Macon Gary Requirements b. Find the optimal solution using Microsoft Excel. (Note: Due to existing transportation contracts, Macon must ship 50,000 motors to Fort Worth and O motors to San Diego. These requirements are already shown in the Candidate Solution below.) Note: Leave the cells blank, whenever zero (0) is required. Candidate Solution New York City Fort Worth San Diego Minneapolis Total Shipped Boulder Macon 50,000 Gary Total supplied 0 50,000 0 0 0 50,000 0 50,000 Profit New York City Fort Worth San Diego Minneapolis Boulder Macon Gary Total profit 0
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Bindley Corporation has a one- year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York, Fort...
-
Describe Cisco's supply base complexity using TWO key points from Malone's "Chain Reaction" as a primer for your arguments. and briefly explain ONE way in which this company mitigates their supply...
-
Bindley Corporation has a one-year contract to supply motors for all washing machines produced by Rinso Ltd. Rinso manufactures the washers at four locations around the country: New York City, Fort...
-
Write a BST client that uses the data file ip-tocountry.csv found on the booksite to determine the source country of a given IP address. The data file has five fields: beginning of IP address range,...
-
Permanent disability can be a more expensive peril than death. Explain why this is so.
-
The times interest earned ratio for Burlington Perfumes Inc. is 3.0, but the current ratio is only 1.2. Discuss future prospects for Burlington, given that the industry average for these ratios is...
-
Subject to what conditions is it possible to compare EPS before and after a deal?
-
Following is the unadjusted trial balance for Alcorn Institute as of December 31, 2011, which initially records prepaid expenses and unearned revenues in balance sheet accounts. The Institute...
-
Opening Activity day 15 The two-way table shows the results of a survey of what people were wearing on a fall day. Match each outfit combination with its probability to the nearest tenth of a...
-
Jack Tasker opened his Auto Repair Shop in November 2023. The balance sheet at November 30, 2023, prepared by an inexperienced part-time bookkeeper, is shown below. Required Prepare a correct balance...
-
1.Connors Construction needs a piece of equipment that can be leased or purchased. The equipment costs $100. One option is to borrow $100 from the local bank and use the money to buy the equipment....
-
Distinguish between a master file and a transaction file in an EDP system and indicate the counterpart of each in a manual system.
-
How does the external legal environment affect the role of sales management?
-
a. Why is documentation important to (1) management and (2) the auditor? b. Distinguish between a computer run and a run manual.
-
Distinguish between computer hardware and software.
-
Explain the importance of the following principles when running parallel search methods: task distribution load balancing tree ordering
-
1-) Why is budgeting critical for the success in any business venture? 2-) Why is it important to have regular audits and if a 'discrepancy' is found , what would you do as the manager.
-
Perform the indicated operations. In designing a cam for a fire engine pump, the expression is used. Simplify this expression. (3) (3 4 32
-
What are some of the major reasons why a business or accounting student should be interested in international business?
-
Why are Japanese companies among the largest in the world?
-
What are some of the different ways in which a firm can get involved in international business?
Study smarter with the SolutionInn App