X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 4 / 6 o 82.1% 2 do Share Search 'Rotate Page Po Export PDF 11 13 Table Q3(b)-1 12 120 14 Week PQR345 QR432 15 10 70 100 16 40 50 90 60 250 100 150 100 Adobe Export PDF Convert PDF Files to Word or Excel Online Table Q3(b)-2 Item Lead Time (Weeks) On Hand Batch Size Safety Select PDF File Stock CW211.pdf X 1 PQR345 QR432 S590 2 200 200 700 200 300 600 0 150 350 2 Convert to Microsoft Word (.docx) Document Language: English (U.S.) Change [Total 16 marks] Question 4: (a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (1) Three-month simple moving average; [2] (i) Three-month weighted moving average. Use 0.7,0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. [3] (ii) Simple linear regression; [3] (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. [2] Convert Convert and edit PDFs with Acrobat Pro DC Table Q4(a) Marino Company Sales of Swimming pool motors Month Quantity (units) Start Free Trial X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 002)... CW211.pdf ? Sign In 3/6 82.1% 2 do Share Search 'Delete Page P. Export PDF Question 3 (a) KANJAR Company is a manufacturer of light aircraft components in Oman. For the past two years of operation, the company is experiencing production backlog. A number of its customers are complaining for long delays of deliveries. This backlog is hurting the competitive advantage and the profitability of the company. In order to address this issue, the operation manager decides to implement the following possible alternatives, production overtime, subcontracting, and possible hiring of additional workers if necessary. The company always prepares a nine-month aggregate plan to decide the optimum way to determine requirements for planning purposes, although this is modified when the demand requirements change. The estimated demand for a particular unit for the period January through September is given in Table Q3(a). The current workforce is based on the production level in the previous December. Operating data are given in Table Q3(b). Requirement: () Develop an aggregate plan AP based on level capacity strategy specified for the planning period. Subcontract to meet a 100% service level every month and no overtime, no hiring, and no termination. Show graphically the demand forecast, actual production output, and ending inventory in single graph. Determine the total production cost for the specified period. [7] Adobe Export PDF Convert PDF Files to Word or Excel Online Select PDF File CW211.pdf X Convert to Microsoft Word (.docx) (ii) Table Q3(c) shows the demand orders of aircraft component of a local customer from January to September. Develop a master planning schedule MPS, assuming production lot size of 800 units, and beginning inventory intended for the particular customer is 150 units. In your MPS indicate the projected available balance PAB and the MPS per month. [3] TableQ3(a): Veatch Company Estimated demand for a product Feb Mar April May June July August Sep 1,935 2.000 2,250 2,450 2,700 2.250 1,900 Document Language: English (U.S.) Change Jan 2.125 1,650 Table Q3(b): Veatch Company Operating data Convert Items Amount 400 Convert and edit PDFs with Acrobat Pro DC 125 Initial inventory (units) Stockout costs (OMR/unit) Carrying cost, (OMR/unit/month) Hiring cost per unit 30 Start Free Trial 70 X BCW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In [ 3 4 3 / 6 82.1% 2 do Share Search 'Delete Page Jan 1,935 TableQ3(a): Veatch Company Estimated demand for a product Feb Mar April May June July 2.000 2.250 2.125 2.450 2.700 2.250 August 1,900 Sep 1,650 Po Export PDF Table Q3(b): Veatch Company Operating data Items Amount Adobe Export PDF Convert PDF Files to Word or Excel Online 400 Select PDF File 30 CW211.pdf X 70 Convert to Initial inventory (units) Stockout costs (OMR/unit) Carrying cost, (OMR/unit/month) Hiring cost per unit (OMR/unit) Termination cost per unit (OMR/unit) Subcontract cost (OMR/unit) Production units the previous December In-house production cost, (OMR/unit) Labor hours/ unit 85 Microsoft Word (.docx) 85 1,500 Document Language: English (U.S.) Change 75 3.2 Convert Workweek (hours) 40 Weeks/month 4 Convert and edit PDFs with Acrobat Pro DC Start Free Trial Table Q3(c): Veatch Company Operating data Mar April May June Jan Feb July August Sep X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 3/6 o 82.1% DL 2 do Share Workweek (hours) 40 Search 'Delete Page Weeks/month P. Export PDF Table Q3(c): Veatch Company Operating data Mar April May June Jan Feb July August Sep 400 450 450 550 600 650 700 750 800 Adobe Export PDF Convert PDF Files to Word or Excel Online Select PDF File CW211.pdf X (6) Salalah Electro-Mechanical Company manufactures a product PQR345. The product PQR345 consists of two PQ890 assemblies, three QR432 assemblies and one PR678 assembly. The PQ890 assembly consists of one P456, two Q921 and one Q239. The QR432 assembly consists of three P456, one R478 and two S590. (0) Prepare a Bill of Material (BOM) product tree for the product PQR345. [2] (ii) Using Table Q3(b)-1 and Table Q3(b)-2 complete the Material Requirements Planning (MRP) calculations to determine when the Purchase Orders should be placed for item S590. Note: The product PQR345 are being sold complete as well as the spare parts (e.g. items QR432, PQ890, R478 etc) are being sold separately also. Convert to Microsoft Word (.docx) Document Language: English (U.S.) Change Convert Convert and edit PDFs with Acrobat Pro DC Start Free Trial X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 4 / 6 o 82.1% 2 do Share Search 'Rotate Page Po Export PDF 11 13 Table Q3(b)-1 12 120 14 Week PQR345 QR432 15 10 70 100 16 40 50 90 60 250 100 150 100 Adobe Export PDF Convert PDF Files to Word or Excel Online Table Q3(b)-2 Item Lead Time (Weeks) On Hand Batch Size Safety Select PDF File Stock CW211.pdf X 1 PQR345 QR432 S590 2 200 200 700 200 300 600 0 150 350 2 Convert to Microsoft Word (.docx) Document Language: English (U.S.) Change [Total 16 marks] Question 4: (a) The Marino Company in Ventura County, southern California sells swimming pool equipment. The sales for swimming pool motors in southern California over the last 12 months is given in Table Q4(a). Forecast the demand from March to December of the current year using the following forecasting models. Use excel for the tabulation. (1) Three-month simple moving average; [2] (i) Three-month weighted moving average. Use 0.7,0.2, and 0.1 for the weights, with 0.7 for the most recent period, and 0.1 for the oldest period. [3] (ii) Simple linear regression; [3] (iv) Determine the MAD, and SE for all the models, and choose which model is most appropriate. [2] Convert Convert and edit PDFs with Acrobat Pro DC Table Q4(a) Marino Company Sales of Swimming pool motors Month Quantity (units) Start Free Trial X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 002)... CW211.pdf ? Sign In 3/6 82.1% 2 do Share Search 'Delete Page P. Export PDF Question 3 (a) KANJAR Company is a manufacturer of light aircraft components in Oman. For the past two years of operation, the company is experiencing production backlog. A number of its customers are complaining for long delays of deliveries. This backlog is hurting the competitive advantage and the profitability of the company. In order to address this issue, the operation manager decides to implement the following possible alternatives, production overtime, subcontracting, and possible hiring of additional workers if necessary. The company always prepares a nine-month aggregate plan to decide the optimum way to determine requirements for planning purposes, although this is modified when the demand requirements change. The estimated demand for a particular unit for the period January through September is given in Table Q3(a). The current workforce is based on the production level in the previous December. Operating data are given in Table Q3(b). Requirement: () Develop an aggregate plan AP based on level capacity strategy specified for the planning period. Subcontract to meet a 100% service level every month and no overtime, no hiring, and no termination. Show graphically the demand forecast, actual production output, and ending inventory in single graph. Determine the total production cost for the specified period. [7] Adobe Export PDF Convert PDF Files to Word or Excel Online Select PDF File CW211.pdf X Convert to Microsoft Word (.docx) (ii) Table Q3(c) shows the demand orders of aircraft component of a local customer from January to September. Develop a master planning schedule MPS, assuming production lot size of 800 units, and beginning inventory intended for the particular customer is 150 units. In your MPS indicate the projected available balance PAB and the MPS per month. [3] TableQ3(a): Veatch Company Estimated demand for a product Feb Mar April May June July August Sep 1,935 2.000 2,250 2,450 2,700 2.250 1,900 Document Language: English (U.S.) Change Jan 2.125 1,650 Table Q3(b): Veatch Company Operating data Convert Items Amount 400 Convert and edit PDFs with Acrobat Pro DC 125 Initial inventory (units) Stockout costs (OMR/unit) Carrying cost, (OMR/unit/month) Hiring cost per unit 30 Start Free Trial 70 X BCW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In [ 3 4 3 / 6 82.1% 2 do Share Search 'Delete Page Jan 1,935 TableQ3(a): Veatch Company Estimated demand for a product Feb Mar April May June July 2.000 2.250 2.125 2.450 2.700 2.250 August 1,900 Sep 1,650 Po Export PDF Table Q3(b): Veatch Company Operating data Items Amount Adobe Export PDF Convert PDF Files to Word or Excel Online 400 Select PDF File 30 CW211.pdf X 70 Convert to Initial inventory (units) Stockout costs (OMR/unit) Carrying cost, (OMR/unit/month) Hiring cost per unit (OMR/unit) Termination cost per unit (OMR/unit) Subcontract cost (OMR/unit) Production units the previous December In-house production cost, (OMR/unit) Labor hours/ unit 85 Microsoft Word (.docx) 85 1,500 Document Language: English (U.S.) Change 75 3.2 Convert Workweek (hours) 40 Weeks/month 4 Convert and edit PDFs with Acrobat Pro DC Start Free Trial Table Q3(c): Veatch Company Operating data Mar April May June Jan Feb July August Sep X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 3/6 o 82.1% DL 2 do Share Workweek (hours) 40 Search 'Delete Page Weeks/month P. Export PDF Table Q3(c): Veatch Company Operating data Mar April May June Jan Feb July August Sep 400 450 450 550 600 650 700 750 800 Adobe Export PDF Convert PDF Files to Word or Excel Online Select PDF File CW211.pdf X (6) Salalah Electro-Mechanical Company manufactures a product PQR345. The product PQR345 consists of two PQ890 assemblies, three QR432 assemblies and one PR678 assembly. The PQ890 assembly consists of one P456, two Q921 and one Q239. The QR432 assembly consists of three P456, one R478 and two S590. (0) Prepare a Bill of Material (BOM) product tree for the product PQR345. [2] (ii) Using Table Q3(b)-1 and Table Q3(b)-2 complete the Material Requirements Planning (MRP) calculations to determine when the Purchase Orders should be placed for item S590. Note: The product PQR345 are being sold complete as well as the spare parts (e.g. items QR432, PQ890, R478 etc) are being sold separately also. Convert to Microsoft Word (.docx) Document Language: English (U.S.) Change Convert Convert and edit PDFs with Acrobat Pro DC Start Free Trial