Exhibit 3.5 The Following Questions Are Based on This Problem and Accompanying

question 51

Multiple Choice

Exhibit 3.5
The following questions are based on this problem and accompanying Excel windows.
A company is planning production for the next 4 quarters. They want to minimize the cost of production. The production cost is stable but demand and production capacity vary from quarter to quarter. The maximum amount of inventory which can be held is 12,000 units and management wants to keep at least 3,000 units on hand. Quarterly inventory holding cost is 3% of the cost of production. The company estimates the number of units carried in inventory each month by averaging the beginning and ending inventory for each month. There are currently 5,000 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter.
-Refer to Exhibit 3.5. What formula should be entered in cell C18 in the accompanying Excel spreadsheet to compute the quarterly carrying costs?

• A) =C15*C3+C6
• B) =C15*(C3+C6)
• C) =C15*C3/2
• D) =C15*(C3+C6)/2

Recognize the importance of environmental factors and community infrastructure in disease prevention.

Understand the historical development of public health initiatives and their impact on community health.

Analyze the role of government and non-governmental organizations in the advancement of public health.

Identify key figures and their contributions to public health and nursing.

---

Definitions:

Payback

A method of investment appraisal that calculates the time needed for an investment to generate cash flows sufficient to recover the initial outlay.

Four Year Payback

A capital budgeting method that calculates the time required to recoup the initial investment in a project, specifically over a period of four years.

Payback Period

The payback period is the length of time required to recover the cost of an investment, calculated by dividing the initial investment by the annual cash inflow.