Question: Based on this information can you provide a PURE CHASE and HYBRID strategy on EXCEL. PLEASE SHOW ALL WORK THANKS. 2013 Production and Employment Month
Based on this information can you provide a PURE CHASE and HYBRID strategy on EXCEL. PLEASE SHOW ALL WORK THANKS.
2013 Production and Employment Month 60 2014 Production Requirement Estimates Demand Cumulative Demand Peak Product Workers Needed 60,000 60,000 60000 60,000 120,000 60000 60,000 180,000 60000 80,000 260,000 65000 65 130,000 390,000 78000 78 200.000 590,000 98333 98 250,000 840,000 120000 120 280,000 1,120,000 140000 240,000 1,360,000 151111 151 170,000 1,530,000 153000 153 150.000 1,680,000 152727 153 120,000 1,800,000 150000 150 Beginning Workforce Overtime Capacity per Worker Production Rate per Worker Regular Wage Rate Overtime Wage Rate Cost of Storing 1000 Pounds of Product Minimum Inventory Level Hiring Cost Firing Cost Base wage including Severance Base wage hourly 120 Production Employees Month 55,000 57,000 63,000 75,000 121,000 187,000 234,000 263,000 222,000 250 10 148,000 130 11 120,000 130 12 107.000 100 100 200 Units per Month 1000 Units per Month $10 per Hour $15 per Hour $120 per month 10,000 $175 $900 $1,800 per month $1,600 140 11 12 153000 2014 Annual Production Peak Production Capacity per month with 100 Workers 1,800,000 153,000 100000 2013 Production and Employment Month 60 2014 Production Requirement Estimates Demand Cumulative Demand Peak Product Workers Needed 60,000 60,000 60000 60,000 120,000 60000 60,000 180,000 60000 80,000 260,000 65000 65 130,000 390,000 78000 78 200.000 590,000 98333 98 250,000 840,000 120000 120 280,000 1,120,000 140000 240,000 1,360,000 151111 151 170,000 1,530,000 153000 153 150.000 1,680,000 152727 153 120,000 1,800,000 150000 150 Beginning Workforce Overtime Capacity per Worker Production Rate per Worker Regular Wage Rate Overtime Wage Rate Cost of Storing 1000 Pounds of Product Minimum Inventory Level Hiring Cost Firing Cost Base wage including Severance Base wage hourly 120 Production Employees Month 55,000 57,000 63,000 75,000 121,000 187,000 234,000 263,000 222,000 250 10 148,000 130 11 120,000 130 12 107.000 100 100 200 Units per Month 1000 Units per Month $10 per Hour $15 per Hour $120 per month 10,000 $175 $900 $1,800 per month $1,600 140 11 12 153000 2014 Annual Production Peak Production Capacity per month with 100 Workers 1,800,000 153,000 100000
