Material Requirements Plan

User Generated

anapl0212

Business Finance

Description

Please see attached document for requirements. Need excel and powerpoint slides. NO PLAGIARISM PLEASE

Unformatted Attachment Preview

Purpose of Assignment The purpose of this assignment is for students to learn how to design a Material Requirements Plan (MRP). Assignment Steps Resources: Microsoft® Excel® Select a business from the internet or other sources which manufactures it products internally. Identify all the suppliers for the all the components including raw material for a product. Develop a Material Requirements Plan (MRP) using Microsoft® Excel®. • • • • Identify what are components needed to develop the product ( show a hierarchy chart). Show lead time for each component. Find the demand for each component when the business manufactures the product. Develop a MRP using Microsoft® Excel® Develop a Power Point presentation (3 to 5 slides) in which you describe details of all the assignment steps including hierarchy chart, lead time, demand and MRP. Format your assignment consistent with APA guidelines. Click the Assignment Files tab to submit your assignment.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello,The attachment below are the answers for excel and power point together with their similarity index,Thank you please

lead time and each component

A

B
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

C

MPS
MPS: X

D

0
10

E

1

F

2
40

G

3

H

4

I

5
300

J

6
200

ITEM: X

Gross Reqmts.
Beging. Inv
Receipts Scheduled
End Inv (with no P.Rct)
Net Requimts.
Receipts Planned
ReleasePlanned

PAST
DUE
10
60
50
0
0
0

1
0
50
20
70
0
0
0

0
0
0

0
0
0

Components
A
B
C

Gross Reqmts.
Beginning Inv
Receipts Scheduled
End Inv (with no P.Rct)
Net Reqmnts
Receipts Planned
ReleasePlanned

0
20

1
0
20

20
0
0
0

20
0
0
240

Components
None

0

Gross Reqmts.
Beginning Inv
Receipts Scheduled
End Inv (with no P.Rct)
Net Requmnts.

1
0
20

20
0

20
0

LEAD OF TIME:
LOT IN SIZE:
SAFETY OF STK:
7
8
0
0
10
10

4
0
30

5
300
30

6
200
10

30
0
0
0

30
0
0
0

30
0
0
280

-270
280
280
200

-190
200
200
0

10
0
0
0

10
0
0
0

0
0
0

0
0
0

0
0
0

Gross Reqmnts. for Components
0
0
280
200
0
0
560
400
0
0
840
600

2
0
20
40
60
0
0
200

2
0
20
40
60
0

Page 1

LEAD TIME:
LOT SIZE:
SAFETY STK:
7
8
0
0
20
20

3
0
60

4
280
60

5
200
20

6
0
20

60
0
0
0

-220
240
240
0

-180
200
200
0

20
0
0
120

20
0
0
0

20
0
0
0

0

0

0

Gross Reqmnts for Components
0
0
0
0
0

0
20

8

3
0
30

ITEM: B
PAST
DUE

7

2
40
70

ITEM: A
PAST
DUE

K

3
0
60

4
560
60

5
400
20

6
0
20

LEAD TIME:
LOT SIZE:
SAFETY STK:
7
8
0
0
20
20

60
0

-500
520

-380
400

20
0

20
0

20
0

lead time and each component

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

Receipts Planned
Release Planned

0
0

0
520

Components
C

0

520

Gross Reqts for C
Parent: X
Parent: B
Total Reqts for C

0
0
0
0

1
0
520
520

0
400

0
200

0
0

0
0

Gross Requirements for Components
400
0
0
0
200

0

0

7
0
0
0

8
0
0
0

2
0
400
400

0
0

3
0
0
0

520
0

4
840
0
840

400
0

5
600
0
600

6
0
200
200

ITEM: C
PAST
DUE
Gross Reqmnts
Beging. Inv
Receipts Scheduled
End Inv (with no P.Rct)
Net Reqmnts
Receipts Planned
Release Planned

0
20

1
520
20

20
0
0
700

-500
510
600
800

Components
None

0

0

2
400
100
300
0
10
100
600

3
0
100

4
840
100

5
600
60

6
200
60

100
0
0
200

-740
750
800
0

-540
550
600
0

-140
150
200
300

60
0
0
0

60
0
0
0

0

0

0

Gross Reqmnts. for Components
0
0
0
0

Page 2

LEAD TIME:
LOT SIZE:
SAFETY STK:
7
8
0
0
60
60

lead time and each component

L

M

9

N

O

P

Q

10
0
0
100

-90
100
100
0

100
200
300

0
0
0

LEAD TIME:
LOT SIZE:
SAFETY STK:
9
100
20

3
40
20
10
0
40

-80
100
120
0

40
0
0
0

S

A(1)

B(2)

C(1)

Qty/EI
1
2
3

C(3)

NOTE: The PAST DUE section
abridges all exercises that ought to
have occured in a past periods, yet
did not. The figurings expect this
exercise...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags