PM Computers assembles its own brand of personal computers from component

parts it purchases overseas and domestically. PM sells most of its computers locally to different

departments at State University as well as to individuals and businesses in the immediate

geographic region. PM has enough regular production capacity to produce $160$ computers per

week. It can produce an additional $50$ computers with overtime. The cost of assembling,

inspecting, and packaging a computer during regular time is $$190.$ Overtime production of a

computer costs $$260.$ Furthermore, it costs $$10$ per computer per week to hold a computer in

inventory for future delivery. PM wants to meet all customer orders, with no shortages, to

provide quality service. PM$$s order schedule for the next $6$ weeks is as follows:

Production Capacity: $160$ computers per week

$50$ more computers with overtime

Assembly Costs: $$190$ per computer regular time.

$$260$ per computer overtime

Inventory Holding Cost: $10$ per computer per week.

Inventory Holding Cost:

Week Computer Orders

$1105$

$2170$

$3230$

$4180$

$5150$

$6250.$

solve using excel solver