Set Up and Solve the Following Nonlinear Programming Problem Using

question 35

Essay

Set up and solve the following nonlinear programming problem using Excel:
$$\begin{array} { l } \text { Max: } 10 \mathrm { X } _ { 1 } + 15 \mathrm { X } _ { 2 } + 5 \mathrm { X } _ { 3 } + 2 \mathrm { X } _ { 3 } 3 \\\text { Subject to } \\\mathrm { X } _ { 1 } + \mathrm { X } _ { 2 } + \mathrm { X } _ { 3 } \leq 50 \\2 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \leq 150 \\\mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } , \mathrm { X } _ { 3 } \geq 0\end{array}$$

Evaluate the impact of manufacturing overhead costs on gross margin.

Recognize the role of capacity in determining overhead rates and its impact on product costing.

Apply overhead costs to products under both traditional and activity-based costing systems.

Understand the financial implications of using capacity as a basis for predetermined overhead rate calculation.

---

Definitions:

Other Postretirement Benefits

Benefits, other than pensions, provided to employees after they retire, such as health insurance.

Accrual Basis

An accounting method that records income and expenses when they are earned or incurred, regardless of when cash transactions happen.

Plan Assets

Plan assets refer to the pool of assets that are held by a pension fund or other employee benefit plan to fund the benefits owed to participants.

Discount Rate

The interest rate used in discounted cash flow analysis to determine the present value of future cash flows.