Use excel solver to answer the following question a corrupt, Ask an Expert

Management Studies

Use Excel solver to answer the following question: A corrupt shipping concern wishes to maximize the revenue they make from an analytics-bereft manufacturing concern, which has 4 factories and 3 warehouses. Factory 1 supplies 1000 units per week and is charged $5, $3, and $4 to ship each unit to Warehouses 1, 2, and 3 respectively. Factory 2 supplies 1200 units each week and is charged $4, $3, and $3 to ship to Warehouses 1, 2, and 3. Factory 3 supplies 1500 units and is charged $6, $2, and $5 to ship to the three warehouses. Factory 4 supplies 1800 units and is charged $6, $2, and $4.

If Warehouse 1 requires 3000 units per week, Warehouse 2 demands 1000, and Warehouse 3 demands 1500, what is the maximum it would cost them in shipping to fulfill each warehouse's demand?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M93114579

Have any Question?Write your Review or question?

Related Questions in Operation Management

1 what are the reasons for the success of the zero email

1. What are the reasons for the success of the zero email initiative? 2. What are "changes" needed to succeed in the social collaboration transformation? [PLEASE NOTE: answer Q2 given here above, NOT Q2 in the case study ...

Identify a business scenario where a specific structure you

Identify a business scenario where a specific structure you select might be a good fit. Also include in this response a comprehensive discussion why this scenario is a good fit? (Maximum points will given for responses t ...

1 when using a level capacity strategy or ldquolevel

1. When using a "level capacity strategy" or “level production strategy” in aggregate planning, variations in demand are met by using which of the following options? I. varying output during regular time without changing ...

1 explain how and why the determinants dimensions and costs

1. Explain how and why the determinants, dimensions and costs of quality can contribute to one or multiple system design (long term) or system operation (short term) decision making in an organization. 2. List the five p ...

Conflict stylesresearch an organization of your choice

Conflict Styles Research an organization of your choice. Create specific examples of how a manager in that organization could use each of the Conflict Management Strategies of avoiding, competing, compromising, collabora ...

Regression and correlationmultiple regression analysis is

Regression and Correlation Multiple regression analysis is widely used in business research in order to forecast and predict purposes. It is also used to determine what independent variables have an influence on dependen ...

1 what would a mcdonalds restaurant stock performance look

1. What would a McDonald's restaurant stock performance look like, internationally and domestically? 2. Should performance appraisals be limited to certain categories of staff? 3. In 200 words or more, recommend steps th ...

Organization can use regression analysis correlations and

Organization can use regression analysis, correlations, and estimating. Managers can use the fix cost to determine profits for producing a particular product. We can gather the raw materials and resource costs to help fi ...

Livingston tools a manufacturer of battery-operated

Livingston Tools, a manufacturer of battery-operated, hand-held power tools for consumer markets, has a problem. Its two biggest customers are “big box” discounters. Because the customers are fiercely price competitive, ...

The united states is home to some of the worlds leading

The United States is home to some of the world's leading computer software companies, most of which commonly outsource software development to other countries, including Egypt, India, Ireland, Israel, Malaysia, Hungary, ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert