1. Eighty units of end item E are needed at the beginning of week 6

Offered Price: $ 17.99 Posted on: 05/05/2016 01:45 AM Due on: 05/05/2016
Question # 00272753 Subject Accounting Topic Accounting Tutorials: 1
Question Purchase it

1. Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of J have been ordered and one case is scheduled to arrive in week 3, one in week 4 and one in week 5. Note: J must be ordered by the case and B must be produced in multiples of 120units. There are 60 units of B and 20units of J now on hand. Lead times are 2weeks for each of E and B, and one week for J.

Prepare a materials requirement plan for component J

E

B (2)

J (3)

J (4)

F (2)


If you can do this better in Excel, feel free to do so.

Master

Week

Beg Inventory

1

2

3

4

5

6

Schedule

Quantity

E LT = 2

Beg Inv

1

2

3

4

5

6

Gross Requirements

Scheduled Receipts

Projected on hand

Net requirements

Planned order receipts

Planned order releases

B (2) LT =

Beg Inv

1

2

3

4

5

6

Gross Requirements

Scheduled Receipts

Projected on hand

Net requirements

Planned order receipts

Planned order releases

J(4) & J (3) LT =

Beg Inv

1

2

3

4

5

6

Gross Requirements

Scheduled Receipts

Projected on hand

Net requirements

Planned order receipts

Planned order releases

Tutorials for this Question
  1. 1. Eighty units of end item E are needed at the beginning of week 6

    Available for: $ 17.99 Posted on: 05/05/2016 01:46 AM
    Tutorial # 00267985 Puchased By: 0
    Tutorial Preview
    nxxdxd xx thx…
    Attachments
    soln.zip (652.26 KB)
Loading...