Exhibit 6.1 The Following Questions Pertain to the Problem, Formulation, and Spreadsheet

question 59

Short Answer

Exhibit 6.1
The following questions pertain to the problem, formulation, and spreadsheet implementation below.
A research director must pick a subset of research projects to fund over the next five years. He has five candidate projects, not all of which cover the entire five-year period. Although the director has limited funds in each of the next five years, he can carry over unspent research funds into the next year. Additionally, up to $30K can be carried out of the five-year planning period. The following table summarizes the projects and budget available to the research director. The following is the ILP formulation and a spreadsheet model for the problem.
-Refer to Exhibit 6.1. What formula should go in cell D15 of the above Excel spreadsheet?

---

Definitions:

Equivalent Units

A concept used in cost accounting to express the amount of work done by various components of a manufacturing process in terms of fully completed units.

Weighted-Average Method

The weighted-average method is an inventory costing method that assigns the average cost of all similar items in inventory to the cost of goods sold and ending inventory, smoothing out price fluctuations.

Processing Department

A division within a manufacturing facility where a particular type of processing or production occurs.

Ending Inventory

The value of goods available for sale at the end of an accounting period, calculated by adjusting the beginning inventory for purchases and sales during the period.