An electronics manufacturer is producing and selling the following products:
1- ipods
2- dvd players
3- calculators
4- cameras
5- watches
In addition to individual sales of each product, the company is also selling a bundle of an ipod and a watch.
The products are commonly using the following resources:
|
|
Ipod
|
DVD
|
CAL
|
CAM
|
WATCH
|
|
electronic components
|
3
|
6
|
5
|
7
|
2
|
|
non-electronic components
|
2
|
10
|
3
|
12
|
4
|
|
assembly labor (minutes)
|
25
|
60
|
18
|
48
|
72
|
|
inspection labor (minutes)
|
14
|
21
|
20
|
32
|
18
|
For the next ten weeks:
- demand of each product and the ipod+watch bundle,
- available electronics components,
- available non-electronics components,
- available assembly labor hours,
- available inspection labor hours, and
- unit production costs
are provided in the excel table.
Demand of each week must be satisfied within the week. The total worth of inventories at the end of each week should not exceed $120,000. The worth of inventory at the end of each week is computed by multiplying the amount of inventory by its production cost that week.
Prepare a minimum cost production plan for the company for the next 10 weeks.
Attachment:- Electronics_Manufacturers_Data.xlsx