- Convert to SmartArt - 3 Font Allange Quick - Styles Shape Effects Paragraph Drawing (Part 1) Amade Aggregae Planning Amade, Inc., is a global supplier of innovative Storage Area Network (SAN) products with corporate headquarters located in Fremont, California. It has led the industry in market "firsts and continues to drive the Storage Area Network (SAN) edge market with innovative Fiber Channel switching technology. The company has consistently delivered a time to market advantage to major OEM (original equipment manufacturer) customers enabling them to create clear business value for their customer base. The company is in the process of developing a six-month aggregate plan for 2012. The demand forecast for the first six months of 2012 is presented below: Aggregate Planning Input Demand forecast July 6950 August Septemeber October November December 7900 82008350 79008050 Cost, labor and Inventory data are presented on the next page. Questions (please provide your answer) Using the aggregate planning templates, define and prepare FIVE alternative aggregate plans. Explain what are the pros and cons of each aggregate plan. Identify the aggregate plan you prefer the most and explain why. Note: Please prepare Excel printout with each plan's calculations and write up describing your plans and solutions. Correction: On the second page, make subcontracting cost greater than material cost. (51150/unit) Notes Comments TR I ENG US e Aggregate Planning (Continued) Costs Materials, $/unit Inventory holding cost, $/unit/month Cost of stockout, $/unit/month Cost of subcontracting, $/unit/month Hiring and training cost, $lemp. Lay off cost, $lemp. Labor hours required per unit (Lead time) Regular time cost, $/hour Overtime cost per hour, $/hour Inventory Beginning inventory, units Safety stock (if applied), % of monthly demand Labor Initial number of employees Work hours per day 1074.00 165.00 2855.00 890.00 840.00 1550.00 1.50 28.25 36.50 340.00 0.06 40 30 Other requirements Available overtime, % of regular time Available subcontract per month in units, up to Backlog per month no more than, units 1000 100 14AAAEEEE I US abc Av - Aa- A - zxFRE Sesoleimany Arez Il Text Direction - Align Text Convert to SmartArt B 0 1 00 OAZZ.-> n Font 7S Paragraph Arrange Quick Styles Drawing Amade Aggregate Planning (Continued) Costs Materials, Slunit Inventory holding cost, $/unit/month Cost of stockout, Slunit month Cost of subcontracting. Slunit/month Hiring and training cost, Slemp. Layoff cost, Slemp. Labor hours required per unit (Lead time) Regular time cost, S/hour Overtime cost per hour, S/hour Inventory Beginning inventory, units Safety stock (if applied), % of monthly demand Labor Initial number of employees Work hours per day 1074.00 165.00 2855.00 890.00 840.00 1550.00 1.50 28.25 36.50 340.00 0.06 Other requirements Available overtime, % of regular time Available subcontract per month in units, up to Backlog per month no more than, units JO 1000 100 NotestComments F L Tu as Cell Insert Delete Format Fill 21 Sort & Find & Assignment 2 Question Part 1 (Aggregate Plan... Drawi. - D X le Insert Design Transition: Animatior Slide Show Review View Format Tell m zxFRE Sesoleima... & Share - Times New Ro - 20 D A D BI U Sabe AV ETT AND Shapes Arrange Quick Editing ide- A Aa A A A Paragraph Drawing Cost, labor and inventory data are presented on the next page. New Slides Font Styles Questions (please provide your answer) Using the aggregate planning templates, define and prepare FIVE alternative aggregate plans. For lie 1 I have 4 aggregate plans (Chase-level - subcontractor-overtime) just need the 5th one with data Explain what are the pros and cons of each aggregate plan. Identify the aggregate plan you prefer the most and explain why. Note: Please prepare Excel printout with each plan's calculations and write-up describing your plans and solutions. Correction: On the second page, make subcontracting cost greater than material cost. (S1150/unit + 70% 8 -- E Comments P N English (United States) Notes - Convert to SmartArt - 3 Font Allange Quick - Styles Shape Effects Paragraph Drawing (Part 1) Amade Aggregae Planning Amade, Inc., is a global supplier of innovative Storage Area Network (SAN) products with corporate headquarters located in Fremont, California. It has led the industry in market "firsts and continues to drive the Storage Area Network (SAN) edge market with innovative Fiber Channel switching technology. The company has consistently delivered a time to market advantage to major OEM (original equipment manufacturer) customers enabling them to create clear business value for their customer base. The company is in the process of developing a six-month aggregate plan for 2012. The demand forecast for the first six months of 2012 is presented below: Aggregate Planning Input Demand forecast July 6950 August Septemeber October November December 7900 82008350 79008050 Cost, labor and Inventory data are presented on the next page. Questions (please provide your answer) Using the aggregate planning templates, define and prepare FIVE alternative aggregate plans. Explain what are the pros and cons of each aggregate plan. Identify the aggregate plan you prefer the most and explain why. Note: Please prepare Excel printout with each plan's calculations and write up describing your plans and solutions. Correction: On the second page, make subcontracting cost greater than material cost. (51150/unit) Notes Comments TR I ENG US e Aggregate Planning (Continued) Costs Materials, $/unit Inventory holding cost, $/unit/month Cost of stockout, $/unit/month Cost of subcontracting, $/unit/month Hiring and training cost, $lemp. Lay off cost, $lemp. Labor hours required per unit (Lead time) Regular time cost, $/hour Overtime cost per hour, $/hour Inventory Beginning inventory, units Safety stock (if applied), % of monthly demand Labor Initial number of employees Work hours per day 1074.00 165.00 2855.00 890.00 840.00 1550.00 1.50 28.25 36.50 340.00 0.06 40 30 Other requirements Available overtime, % of regular time Available subcontract per month in units, up to Backlog per month no more than, units 1000 100 14AAAEEEE I US abc Av - Aa- A - zxFRE Sesoleimany Arez Il Text Direction - Align Text Convert to SmartArt B 0 1 00 OAZZ.-> n Font 7S Paragraph Arrange Quick Styles Drawing Amade Aggregate Planning (Continued) Costs Materials, Slunit Inventory holding cost, $/unit/month Cost of stockout, Slunit month Cost of subcontracting. Slunit/month Hiring and training cost, Slemp. Layoff cost, Slemp. Labor hours required per unit (Lead time) Regular time cost, S/hour Overtime cost per hour, S/hour Inventory Beginning inventory, units Safety stock (if applied), % of monthly demand Labor Initial number of employees Work hours per day 1074.00 165.00 2855.00 890.00 840.00 1550.00 1.50 28.25 36.50 340.00 0.06 Other requirements Available overtime, % of regular time Available subcontract per month in units, up to Backlog per month no more than, units JO 1000 100 NotestComments F L Tu as Cell Insert Delete Format Fill 21 Sort & Find & Assignment 2 Question Part 1 (Aggregate Plan... Drawi. - D X le Insert Design Transition: Animatior Slide Show Review View Format Tell m zxFRE Sesoleima... & Share - Times New Ro - 20 D A D BI U Sabe AV ETT AND Shapes Arrange Quick Editing ide- A Aa A A A Paragraph Drawing Cost, labor and inventory data are presented on the next page. New Slides Font Styles Questions (please provide your answer) Using the aggregate planning templates, define and prepare FIVE alternative aggregate plans. For lie 1 I have 4 aggregate plans (Chase-level - subcontractor-overtime) just need the 5th one with data Explain what are the pros and cons of each aggregate plan. Identify the aggregate plan you prefer the most and explain why. Note: Please prepare Excel printout with each plan's calculations and write-up describing your plans and solutions. Correction: On the second page, make subcontracting cost greater than material cost. (S1150/unit + 70% 8 -- E Comments P N English (United States) Notes