You are planning the materials for the baking operations. (Planning the decorati
ID: 452200 • Letter: Y
Question
You are planning the materials for the baking operations. (Planning the decorating & packing materials are handled by others.) Record the Master Schedule on the respective grids, Explode the Gross requirements by time period for the components (Boxes, Eggs, & Oil), plot on the correct grid; then calculate Net requirements, Planned Order Receipts, Planned Order Releases and show in the correct time periods in the respective grid.
There is No Inventory On Hand and No items on order. Use underlined Letters as PART # as shown on the grids.
Orders (quantity & period): Show the MPS on the appropriately MRP GRID)
Yellow Cake (YC) = 2/5, 3/7, 2/8; Brownies = 3/ 4, 3/6, 4/8; Devil’s Food Cake (DFC) = 4/3, 1/5, 1/6, 2/8;
BOMs: (Not all ingredients shown): Yellow Cake: YC Carton (1), Oil (1/3 cup), eggs (3);
Brownies: B Carton (1), Oil (1/2 cup), Eggs (2); Devil’s Food Cake: DFC Carton (1), Oil (1/3 cup), Eggs (3);
Item Master: (Show calculated answers on MRP GRID)
Eggs – Unit of measure-- each; Order Quantity – 12; Lead time –1 period;
Carton --Unit of measure-- each; Order Quantity – L4L; Lead time –1 period;
Veg. Oil -- Unit of measure—oz.; Order Quantity – 40 or 48 oz.; Lead time –1 period;
Conversion: 1 cup = 8oz.; 1/3cup = 3oz.
PERIODS
1
2
3
4
5
6
7
8
Gross Requirements
2
3
2
Scheduled Receipts
Projected Available
--
Net Requirements
Y
Planned Order Receipts
Planned Order Releases
PERIODS
1
2
3
4
5
6
7
8
Gross Requirements
Scheduled Receipts
Projected Available
--
Net Requirements
B
Planned Order Receipts
Planned Order Releases
PERIODS
Yellow cakes1
2
3
4
5
6
7
8
Gross Requirements
2
3
2
Scheduled Receipts
Projected Available
--
Net Requirements
Y
Planned Order Receipts
Planned Order Releases
Explanation / Answer
PERIODS
Yellow cakes
1
2
3
4
5
6
7
8
Gross Requirements
2
3
2
Scheduled Receipts
Projected Available
0
0
0
0
0
0
0
0
0
--
Net Requirements
2
3
2
Y
Planned Order Receipts
2
3
2
Planned Order Releases
2
3
2
PERIODS
Brownies
1
2
3
4
5
6
7
8
Gross Requirements
3
3
4
Scheduled Receipts
Projected Available
0
0
0
0
0
0
0
0
0
--
Net Requirements
3
3
4
B
Planned Order Receipts
3
3
4
Planned Order Releases
3
3
4
PERIODS
Yellow cakes
1
2
3
4
5
6
7
8
Gross Requirements
2
3
2
Scheduled Receipts
Projected Available
0
0
0
0
0
0
0
0
0
--
Net Requirements
2
3
2
Y
Planned Order Receipts
2
3
2
Planned Order Releases
2
3
2
PERIODS
Brownies
1
2
3
4
5
6
7
8
Gross Requirements
3
3
4
Scheduled Receipts
Projected Available
0
0
0
0
0
0
0
0
0
--
Net Requirements
3
3
4
B
Planned Order Receipts
3
3
4
Planned Order Releases
3
3
4
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.