How do i solve this? I started to fill out the bottom table and then got confused GreatTech (GT) is a regional company specializing in the manufacturing of smart home devices. The company is well-known for its innovative products, efficient production processes, and exceptional customer service.

The production of a particular smart home device requires various components (e.g., microcontrollers, sensors, actuators). The manager has designated the product X and its components as Items Y, Z, W, V, and U, respectively. Item X is assembled using 1 unit of Item Y, 2 units of Item Z, and 2 units of Item W. Each Item Y consists of 2 units of Item Z and 2 units of Item V. Each Item Z requires 1 unit of Item W, 2 units of Item V, and 1 unit of Item U.

The table below shows the lead times and quantities on hand at week 0 (the current week) for Items X, Y, Z, W, V, and U, respectively. Items X, Y, and Z are produced in-house, while the rest are purchased from suppliers. GT's master production schedule for Item X indicates gross requirements of 50 units, 70 units, and 120 units at weeks 8, 11, and 13, respectively. Assume there are no scheduled receipts (i.e., pending orders to arrive) for any items during next 13 weeks.So, "scheduled receipts" is omitted in the MRP schedule for the purpose of simplicity.

For the following questions Q1 & Q2, present the MRP and lot sizing schedules using the templates provided below for next 13 weeks (~ 3 months). For each item, the schedule indicates the week and quantity that the item should be ready (in the row of "Gross requirement"), and the week and quantity that the assembly or purchase order should be released (in the row of "Order released"). Fill your numbers in the cells within Q1's and Q2's templates. Each incorrect number costs you 0.2 points. If there are 30 or more incorrect numbers together within these two templates, you will receive no points forthis Excel work. Blank cell will be considered as containing 0. No Excel formula is required for this Excel assignment.

Q1: GT uses the lot-for-lot approach for Items X, Y, Z, V and U. However, to lower the number of purchase orderes from the suppliers of item W overseas, GT decides to follow a different approach of lot sizing for purchasing W:

-- Place the purchase order only when necessry to avoid immediate stockouts, OR when the beginning inventory on hand of the week drops to 20 units or lower (i.e., ROP = 20 units);

-- The purchase order quantity should be the multiple of 30 units (e.g., 30, 60, 90, 120, etc.) and this quantity should be kept as low as possible.

Stockouts should not occur at any times

Table
Item	Lead time (weeks)	Quantity on hand at Week 0 (units)
X	1	25
Y	2	5
Z	2	45
W	3	25
V	2	65
U	1	50

Item	Week	1	2	3	4	5	6	7	8	9	10	11	12	13
X	Gross requirement	0	0	0	0	0	0	0	50	0	0	70	0	120
Projected on hand at the beginning	25	25	25	25	25	25	25	0	0	0	0	0	0
Net requirements	0	0	0	0	0	0	0	25	0	0	70	0	120
Planned order receipts
Planned order released	30	0	0	0	0	0	50	0	0	70	0	120	0
Y	Gross requirement	0	0	0	0	0	0	50	0	0	70	0	120	0
Projected on hand at the beginning
Net requirements
Planned order receipts
Planned order released	0	0	0	0	50	0	0	70	0	120	0	0	0
Z	Gross requirement								100			140		240
Projected on hand at the beginning
Net requirements
Planned order receipts
Planned order released	30	0	0	0	0	30	0	0	0	30	0	0	0
W	Gross requirement								100			140		240
Projected on hand at the beginning
Net requirements
Planned order receipts
Planned order released	0	30	0	30	0	0	0	0	120	0	0	0	0
V	Gross requirement								200			280		480
Projected on hand at the beginning
Net requirements
Planned order receipts
Planned order released	0	30	0	0	0	0	30	0	0	0	30	0	0
U	Gross requirement								100			140		240
Projected on hand at the beginning
Net requirements
Planned order receipts
Planned order released	30	0	0	0	0	30	30	0	0	0	0	0	30