Foolish Manufacturing Has Three Factories (1, 2, and 3)and Three

question 45

Essay

Foolish Manufacturing has three factories (1, 2, and 3)and three warehouses (A, B, and C).The table below shows the shipping costs between each factory (in dollars)and warehouse, the factory manufacturing capabilities (in 1000s), and the warehouse capacities (in 1000s).Solve this problem using Excel's Solver routine.

---

Definitions:

Physical Contact

The situation or condition where two or more objects are touching each other or connected in a way that allows for the transfer of electricity, heat, or mechanical forces.

Capacitance

Capacitance is the ability of a system or component to store an electrical charge, measured in Farads, which is a key parameter in designing and understanding electrical and electronic circuits.

Motor Starter Coil

An electromechanical component in a motor starter that creates the magnetic field needed to operate the starter contacts.