NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in...

Transcribed Image Text:

NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12 NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12 NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12 NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12 NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12 NBC manufactures several types of bikes. They just received orders to deliver 90 S-Tiger bikes in week 12, and 90 Tiger bikes in week 9. The model, Tiger, is similar to S-Tiger but with fewer features. The production of S-Tiger and Tiger involves different kinds of parts items, where some items can be made at the plant and the others are purchased from vendors. S-Tiger and Tiger are labeled as Item A and Item B. The other types of parts items were labeled as Items C, D, E, and F. Item A is made by assembling 1 item B, 2 items C, and 2 items D. Each B includes 2 items C and 2 items E. Each C is made of 1 item D, 1 item E and 1 item F. The table below shows the lead times and quantities on hand right now (i.e. week 0) for items A, B, C, D, E and F, respectively that are available for the production of the above additional orders. Due to limited storage space for accommodating the inventory items A, B, C, D, and F, unnecessary inventory holding should be avoided at any time and the manager decides to use lot-for-lot approach for the these items. However, for item E, the manager uses a different lot sizing approach: -- The order should be released only as necessry to avoid stockouts and stockouts should not occur at any times; --The order quantity for each order is fixed to the same number and this number should be made minimum. Prepare the MRP schedule using the template below for next 12 weeks (~ 3 months). List the items in the column of "Item". 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 light yellow area within the template. Each incorrect number costs you 0.5 points. If there are 40 or more incorrect numbers, no points will be given to your template. Blank cell will be considered as containing 0. Table Lead time Quantity Item (week) on hand in 3 F 10 20 140 80 60 180 Template for the net MRP schedule Item A B C D E F Week Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released. Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released Gross requirement Projected on hand at the beginning Net requirements Planned order receipts Planned order released 2 8 9 10 11 12

Answer rating: 100% (QA)

To prepare the MRP schedule for the next 12 weeks we will start by calculating the gross requirements projected on hand net requirements planned order receipts and planned order released for each item ... View the full answer