Purchase Solution

Excel Solver: Toy Manufacturing Company

Not what you're looking for?

Ask Custom Question

A toy manufacturing company currently maintains plants in Atlanta and Tulsa that supply to retail centers in Los Angeles and New York. Because of expanding demand, the company has decided to build a third plant and has narrowed the choice to one of two cities, Seattle or Baltimore. The distribution costs, as well as plant capacity and retailer demand, are shown in the table:

Retail Stores Manufacturing Plant Demand
Atlanta Tulsa Seattle Baltimore
Los Angeles $ 8.00 $ 4.00 $ 5.00 $ 4.00 800
New York $ 5.00 $ 7.00 $ 6.00 $ 6.00 1200
Capacity 600 900 500 500

Solve the given problem scenario for the toy manufacturer by recommending the most suited new location to establish the plant. Formulate and set up the problem using the most appropriate technique in Excel Solver.

The Excel set-up should provide clearly labeled values used for the decision variables, constraints, and objective function.

Purchase this Solution

Solution Summary

This solution shows step-by-step calculations to determine which new potential location should be selected for new plant development. Factors that are considered are retailer demand and minimization of distribution cost. Toy manufacturing company wants to decide which of the new potential locations should be selected for a new plant to satisfy retailer demand and minimize distribution cost. The problem is formulated and solved using integer programming with binary variables. The solve process is demonstrated using Excel solver.

Solution Preview

Please find attached response to your posting. There are two tabs 1) Both ...

Purchase this Solution


Free BrainMass Quizzes
Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.