A Company Is Planning Production for the Next 4 Quarters

question 80

Essay

A company is planning production for the next 4 quarters. They want to minimize the cost of production. The production cost, demand and production capacity vary from quarter to quarter. The maximum amount of inventory which can be held is 100 units and management wants to keep at least 50 units on hand. Quarterly inventory holding cost is 4% of the cost of production. There are currently 50 units in inventory. The company wants to produce at no less than one half of its maximum capacity in any quarter. ​ ​ What formulas are required for cells D3, D6, D8, D15, D17 and D18 in the Excel spreadsheet implementation of the formulation?

---

Definitions:

Payroll Checks

Payroll checks are written by an employer to pay employees for services rendered during a specific time period.

Cost Driver

A cost driver is a factor that causes a change in the cost of an activity. It directly influences the cost of a process, product, or operation.

Support Department

A unit within an organization that provides essential services and support to the core departments, facilitating their operations rather than directly contributing to the production of goods or services.

Number Of Computers

The total count of computing devices within a specific inventory or environment.