Sigma Electronics produces telephone cameras for cell phone. The production manager would like to create an MRP for their cell phone cameras with a minimum cost possible. The following table show gross requirements of the product. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the MRP.

Period	1	2	3	4	5	6	7	8	9	10	11	12
Gross requirements	30		30		30	60	20		20	70		50

Also, for this plan the Holding

cost=$2.50/unit/period;

setup

cost=$200;

lead

time=1

period; beginning

inventory=40

units.

Use the table below to develop a PPB solution for MRP (enter your responses as whole numbers).

Period

1

2

3

4

5

6

7

8

9

10

11

12

Gross requirements

30

30

30

60

20

20

70

50

On-hand at beginning of period

40

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

On-hand at end of period

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

Order receipt

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

Order release

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

nothing

The total relevant cost is =

$nothing

(enter your response as a whole number).