Excel File Edit View Insert Format Tools Data Window Help Q Wed Dec 7 8:12 AM AutoSave OFF ... 3Chap 14.xisx - Read-Only Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Arial 10 AA ab v General Conditional Formatting Insert v EV AY- O. Format as Table Delete v Paste BIUV MVA v % " $68 08 Sort & Find & Analyze Sensitivity iCell Styles v Create and Share Format v Filter Select Data Adobe PDF Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G85 fx B C D E F G H K M N O P Q R S T U V W X Y Z Class Exercise 1- MRP The following is a Bill of Material (BOM) of Product A. Each component appears only once, except items H, I. NOUAW In questions a-e, there is no inventory of any item in the warehouse Product C G a. We need to build 10 units of Product A, list the quantities we require of each components. Quantity 26 Component Required 27 A 28 29 30 D 31 32 TIM 33 34 H Sheet1 Sheet2 Sheet3 + Ready &Accessibility: Investigate - + 100% DEC 7 Pr PrExcel File Edit View Insert Format Tools Data Window Help Q Wed Dec 7 8:13 AM AutoSave OFF ... 3Chap 14.xisx - Read-Only Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Arial 10 AA ab v General Conditional Formatting Insert v EV AY- O. Format as Table Delete v Paste B MVA v % " $08 08 Sort & iCell Styles v Find & Analyze Sensitivity Create and Share Format v Filter Select Data Adobe PDF Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G85 fx B C D E F G H K M N O P Q R S T U V W X Y z 20 29 a. We need to build 10 units of Product A, list the quantities we require of each components. Quantity 26 Component Required 27 A 28 29 O 30 31 m 32 33 34 H 35 b. List the components that are sub-assemblies in Product A: c. List the components that are individual (Not sub-assemblies) in Product A: d. What is the level of Component B? Component C? Component E? Component H? e. We got an order from Canadian Tire to build 20 units of Product A, but we have components in inventory. Calculate the net requirement for each component of Product A and insert in the following table: 45 We have initial inventory of items (Not like in questions a-e). Gross Net 46 Component required Inventory Required 47 5 48 B w 49 IN W 50 51 E Sheet1 Sheet2 Sheet3 + Ready &Accessibility: Investigate - + 100% DEC 7 tv Pr PrExcel File Edit View Insert Format Tools Data Window Help Q Wed Dec 7 8:13 AM AutoSave OFF ... 3Chap 14.xisx - Read-Only Q Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me Share Comments Arial 10 AA ab v General Conditional Formatting Insert v EV AY- O. Format as Table Delete v Paste BIUV MVA v % " $68 08 Sort & Find & Analyze Sensitivity Create and Share iCell Styles v Format v Filter Select Data Adobe PDF Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No G85 fx B C D E F G H K M N O P Q R S T U V W X Y Z 45 We have initial inventory of items (Not like in questions a-e). Gross Net 46 Component required Inventory Required 47 A 5 48 w w 49 50 51 52 53 N 56 57 58 f. The lead time for each component (Buy it or make it) is the following: 59 Lead 60 Component Time * 61 A 2 days The order to Canadian Tire should be delivered on Nov/30/2006 at 62 B 5 days 5:00 PM 63 C 5 days Final assembly of Product A should start on 64 D 5 days 65 E 3 Days Assembly B should start on 66 F 3 Days 67 G 3 Days Sub-assembly E should start on 68 H 2 Days 69 2 Days Component I should start on 70 72 * Note: The lead times are in working days (Monday to Friday) Sheet1 Sheet2 Sheet3 + Ready Accessibility: Investigate - 2 DEC 7 Pr Pr