Orange Inc, Has a single factory in which it makes two types of products, A and B. Bills of Materials (BOM) for products are shown below. Parts will be same letter are identical.

Bill of Materials for A
Level	Part	Description	Quantity Required
0	A	End Item	1
1	C	Sub-assembly Component	3
2	F	Component	2
2	G	Component	1
1	D		1
Bill of Materials for B
Level	Part	Description	Quantity Required
0	B	End Item	1
1	C	Sub-assembly Component	4
2	F	Component	2
2	G	Component	1
1	E		1
Part	Lead Time (in weeks)	Sceduled receipts	Sceduled Receipts
C	3	3000	1400 in week 1
D	2	4500	None
E	1	5200	None
F	2	2000	3800 in week 1
G	1	3950	None

The Indentation in the above tables indicates which parts are used to make a higher-level part. For example, product A is made from 3 Cs and 1 D. C is made from 2 Fs and 1 G. Information on lead times, starting inventories and scheduled receipts are given below. A lot for lot policy us used for all parts. The planned order releases for end items A and B are given on the following page.

Planned orders	1	2	3	4	5	6	7
Planned order releases for A	200	300	100	100	0	300	400
Planned order releases for B	100	500	0	400	100	300	200

Please fill out the MRP schedule for parts C and F only.

MAKE SURE TO USE EXCEL AND SHOW THE FORMULAS USED IN EXCEL BY ADDING SCREENSHOTS.