An Electronics Manufacturer Makes Video Security Systems for Parking Lots

question 51

Essay

An electronics manufacturer makes video security systems for parking lots. Demand estimates for the next four quarters are 15, 9, 23, and 17 units. Prepare an aggregate plan that uses inventory, regular time, overtime, and back orders. Subcontracting is not allowed. Regular time capacity is 12 units for quarters 1 and 2, 15 units for quarters 3 and 4. Overtime capacity is 6 units per quarter. Regular time cost is $20,000 per system, while overtime cost is $30,000 per unit. Back order cost is $2000 per system per quarter; inventory holding cost is $500 per unit per quarter. Beginning inventory is zero.
Complete the table of data inputs for solving this aggregate planning problem with the transportation method. Specifically, how many sources are there, and how many destinations?
What is the supply from each source, and the demand of each destination?
What is the cost of each source-destination pair?

---

Definitions:

Form View

A mode in database applications that displays a single record at a time for viewing or editing, as opposed to a table view showing multiple records.

Filter

A software feature that allows users to sift through data to display only the information that meets certain criteria.

Unfilter Button

A control in software applications that removes any active filters, returning the view to its original unfiltered state.

New (blank) Record

The addition of an empty entry into a database, ready for new data to be input.