A Manufacturing Firm Has Four Plants and Wants to Find

question 70

Multiple Choice

A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below:
$$\text{Customer (requirement) }\\\begin{array} { l c c c c } &&Customer ~2 &Customer ~3& Customer ~4\\\text { Factory (capacity) }&\text{ Customer } 1 ( 125 ) & ( 150 ) & ( 175 ) & ( 75 ) \\ A ( 100 ) & \$ 15 & \$ 10 & \$ 20 & \$ 17 \\ \mathrm {~B} ( 75 ) & \$ 20 & \$ 12 & \$ 19 & \$ 20 \\ \mathrm { C } ( 100 ) & \$ 22 & \$ 20 & \$ 25 & \$ 14 \\ \mathrm { D } ( 250 ) & \$ 21 & \$ 15 & \$ 28 & \$ 12 \end{array}$$
Note: This question requires Solver.
Formulate the problem in Solver and find the optimal solution. What is the minimum total cost to meet all customer requirements?

• A) $8,750
• B) $8,950
• C) $9,000
• D) $9,100
• E) $10,050

---

Definitions:

Regression Method

A statistical process for estimating the relationships among variables, often used for prediction and forecasting.

MSE

Stands for Mean Squared Error, a measure used to gauge the average of the squares of the errors or deviations; essentially, the average squared difference between estimated values and the actual value.

Industrial Lathe Sales

Revenue generated from selling industrial lathes, which are machines used to shape metal, wood, or other materials by rotating the workpiece against a cutting tool.