This case puts you in the driver's seat (as a production planner). Your job is to prepare a production schedule (considering the constraints and rules of this case in Chp 19), and to determine the operating budget for such a plan.

There are 3 worksheets available to execute this plan - the 1st Aggregate Plan is where you determine your production plan/schedule (by indicating the number of lines and overtime hrs per day), and the budget (costs) associated with your plan - these are the yellow highlighted sections of the worksheet - you need to determine how many production lines to run, how many hours of overtime to work per day, and the corresponding budget line items in the lower highlighted budget section - you can use the defaulted number of production lines and overtime hours as a first try.

the assignment has 3 questions please just answer the question above. Thanks a lot

Bradford Manufacturing - Planning Plant Production 1,000 case units. Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 2.200 2,500 408 1st (1-13) 2,000 338 Forecast Demand Ending Inventory Target 4th (40-52) 2,650 338 385 1st (Next Year) Notes 2,200 Each number is a 13 week forecast. This is calculated based on 6 weeks of future forecast demand. Notes Planning Data Initial number of employees Emplyees per line Standard production rate (each line) Employee pay rate Overtime pay rate Standard hours per shift Maximum overtime per day Inventory carry cost Stockout cost Employee hiring and training cost Employee layoff cost Numbers Units of measure 60 employees 6 450 Cases per hour $20.00 per hour $30.00 per hour 7.5 hours 2 hours $1.00 per case (per year) $2.40 per case $5,000.00 per employee $3,000.00 per employee Profit margin loss Aggregate Plan Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 8 9 1 2 1st (1-13) 10 1 Lines run Overtime hours per day 4th (40-52) 11 1 Notes Construct solution here. Beginning Inventory Production Expected Demand Ending Inventory 200.0 2,486.3 2.000.0 686.3 686.3 1,989.0 2,200.0 475.3 475.3 2,500.9 2,500.0 476.1 476.1 2,734.9 2,650.0 561.0 Deviation from Inventory Target Employees 347.8 60 90.6 48 68.4 54 222.5 66 S624,000 $499,200 $561,600 $686,400 Employees are paid for 8 hrs work per day. Cost of Plan Labor Regular Time Labor Overtime Hiring and Training Layoff Inventory Carry Cost Stockout Cost 60 employees are employeed currently Carrying cost per year,divided by 4, multiplied by 1,000. Basic on negative deviation from target. Quarter Budget $624,000 $499,200 $561,600 $686,400 Total Cost of Plan $2,371,200 Bradford Manufacturing - Planning Plant Production 1,000 case units. Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 2.200 2,500 408 1st (1-13) 2,000 338 Forecast Demand Ending Inventory Target 4th (40-52) 2,650 338 385 1st (Next Year) Notes 2,200 Each number is a 13 week forecast. This is calculated based on 6 weeks of future forecast demand. Notes Planning Data Initial number of employees Emplyees per line Standard production rate (each line) Employee pay rate Overtime pay rate Standard hours per shift Maximum overtime per day Inventory carry cost Stockout cost Employee hiring and training cost Employee layoff cost Numbers Units of measure 60 employees 6 450 Cases per hour $20.00 per hour $30.00 per hour 7.5 hours 2 hours $1.00 per case (per year) $2.40 per case $5,000.00 per employee $3,000.00 per employee Profit margin loss Aggregate Plan Quarter (Week Numbers) 2nd (14-26) 3rd (27-39) 8 9 1 2 1st (1-13) 10 1 Lines run Overtime hours per day 4th (40-52) 11 1 Notes Construct solution here. Beginning Inventory Production Expected Demand Ending Inventory 200.0 2,486.3 2.000.0 686.3 686.3 1,989.0 2,200.0 475.3 475.3 2,500.9 2,500.0 476.1 476.1 2,734.9 2,650.0 561.0 Deviation from Inventory Target Employees 347.8 60 90.6 48 68.4 54 222.5 66 S624,000 $499,200 $561,600 $686,400 Employees are paid for 8 hrs work per day. Cost of Plan Labor Regular Time Labor Overtime Hiring and Training Layoff Inventory Carry Cost Stockout Cost 60 employees are employeed currently Carrying cost per year,divided by 4, multiplied by 1,000. Basic on negative deviation from target. Quarter Budget $624,000 $499,200 $561,600 $686,400 Total Cost of Plan $2,371,200