Exhibit 6-2
Sinclair Plastics Operates Two Chemical Plants Which Produce

question 25

Essay

Exhibit 6-2
Sinclair Plastics operates two chemical plants which produce polyethylene; the Ohio Valley plant which can produce up to 10,000 tons per month and the Lakeview plant which can produce up to 7,000 tons per month. Sinclair sells its polyethylene to three different auto manufacturing plants, Grand Rapids (demand = 3000 tons per month), Blue Ridge (demand = 5000 tons per month), and Sunset (demand = 4000 tons per month). The variable unit cost of shipping a ton is $1 per mile. The number of miles between the respective plants is shown in the table below:
In addition to the variable unit costs of shipping, Sinclair incurs a fixed handling cost (of pickup and delivery) for any shipping routes it uses. These costs are discounted for longer routes, as shown below:
$$\begin{array} { | l | l | l | l | } \hline & \text { Grand Rapids } & \text { Blue Ridge } & \text { Sunset } \\\hline \text { Ohio Valley } & 50 & 40 & 100 \\\hline \text { Lakeview } & 60 & 50 & 75 \\\hline\end{array}$$
$\begin{array}{c}\text { Fixed Cost Levels }\\\begin{array}{lll}\text { Distance (mi)}&\text { Fixed Cost } \\<=25 & \$ 100,000 \\<=50 & \$ 60,000 \\<=75 & \$ 20,000 \\<=100 & \$ 0\end{array}\end{array}$

-Refer to Exhibit 6-2.What problem will occur if we use an IF statement to model the fixed handling costs

---

Definitions:

Ending Inventory

The total value of goods available for sale at the end of an accounting period.

Master Budget

An all-encompassing financial plan for an organization, covering all of its operations and financial activities within a specific period.

Operating

A term relating to the daily activities of a business that are necessary for it to run and make a profit.

Financing

The process of providing or obtaining funds for business activities, making purchases, or investing.