Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*.

As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base,

2

springs,

and

3

clamps. The base is assembled from

2

clamps

and

1

housing.

Each clamp has

1

handle and

1

casting.

Each housing has

1

bearing

and

1

shaft.

There is no inventory on hand.

This exercise contains only parts b and c.

Part 2

The product structure is as follows:

Bracket

Base(1)

Clamp(2)

Handle(1)

Casting(1)

Spring(2)

Housing(1)

Shaft(1)

Clamp(3)

Bearing(1)

Handle(1)

Casting(1)

Part 3

b) Determine the gross quantities needed of each item if you are to assemble

150

brackets.

Base:	125125 units (enter your response as a whole number).
Spring:	250250 units (enter your response as a whole number).
Clamp:	625625 units (enter your response as a whole number).
Housing:	125125 units (enter your response as a whole number).
Handle:	250250 units (enter your response as a whole number).
Casting:	250250 units (enter your response as a whole number).
Bearing:	125125 units (enter your response as a whole number).
Shaft:	125125 units (enter your response as a whole number).

Part 4

c) Compute the net quantities needed if there are

25

of the base and

100

of the clamp in stock.

Base:	100100 units (enter your response as a whole number).
Spring:	250250 units (enter your response as a whole number).
Clamp:	enter your response here units (enter your response as a whole number).
Housing:	enter your response here units (enter your response as a whole number).
Handle:	enter your response here units (enter your response as a whole number).
Casting:	enter your response here units (enter your response as a whole number).
Bearing:	enter your response here units (enter your response as a whole number).
Shaft:	enter your response here units (enter your response as a whole number).

*Holding

cost=$1.50/unit/week;

setup

cost=$200;

lead

time=1

week; beginning

inventory=40.

Part 2

Develop a lot-for-lot solution

(enter

your responses as whole

numbers).

Period

1

2

3

4

5

6

7

8

9

10

11

12

Gross requirements

20

40

40

70

30

10

80

60

On-hand at beginning of period

40

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

On-hand at end of period

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

Order receipt

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

Order release

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

Part 3

The total cost is

$enter your response here

(enter

your response as a whole

number).