Consider the Following Data That Illustrates Demand,production Costs,and Expected Capacity

question 24

Essay

Consider the following data that illustrates demand,production costs,and expected capacity for a given product.

$\begin{array}{lllll} &&\text { Month }\\& 1 &2 &3&4 \\\text { Demand (units) } & 100 & 125 & 200 & 175 \\\text { Production cost/Unit } & \$ 20 & \$ 25 & \$ 30 & \$ 35 \\\text { Production Capacity (units) } & 150 & 150 & 150 & 150\end{array}$ .

Inventory carrying costs are estimated at $4 per unit per month.The firm wants to produce at least 50 units per month to uniformly utilize its existing resources.Assume that beginning inventory is zero.Use Excel to formulate and solve this problem to determine how many units of the product should be produced monthly to meet the expected demand at minimal cost.

---

Definitions:

Run Macros

The process of executing a pre-defined set of instructions or actions in software to automate tasks.

Animations

Visual effects added to elements in presentations or web design to create movement or interaction.

SmartArt

A feature in Microsoft Office programs that provides a variety of graphic options, including diagrams and lists, to visually represent information.

Hyperlinks

Elements in electronic documents that link to other sections of the document or to external resources when clicked.