How get the calculation for labor regular time cost of $624,000?

DU Arial -110 26 Wrap Text Currency Xcut Da Copy - Paste Format Painter Clipboard - A A DA. Bad BIU- Good Noutal Merge & Center - S 8. Normal Conditional Format as Check Cell Formatting Table Explanatory Input Linked Cell Note Fans Alignment Number Studes 333 X f $624,000 ? A 1 1.000 case units. F G H 1 J K L M N 4th (4052) 1st (Next Year) Notes 2,650 2.200 Each number is a 13 week forecast. 338 This is calculated based on 6 weeks of future forecast demand. Forecast Demand by Quarter (1,000 Case Units) 3,000 2500 2,000 1,500 1.000 500 0 1st (1-13) 2nd (1426) 3d (27393 h (40.5 Next Year 4th (40-52) 10 Notes Construct solution here R Quarter (Week Numbers) 1st (1-13) Forecast Demand 2nd (14-26) 3rd (27-39) 2,000 2,200 2,500 Ending Inventory Target 338 385 408 6 Planning Data Numbers Units measure Notes 7 Initial number of employees 60 employees 8 Emplyees per line 6 9 Standard production rate (each line) 450 Cases per hour 10 Employee pay rate 520.00 per hour 11 Overtime pay rate $30.00 per hour 12 Standard hours per shift 7.5 hours 13 Maximum overtime per day 2 hours 14 Inventory carry cost 51.00 per case (per year) 15 Stockout cost 52.40 per case 16 Employee hiring and training cost $5,000.00 per employee 17 Employee layoff cost $3,000 00 per employee 1B 19 Aggregate Plan Quarter (Week Numbers) 20 1st (1-13) 2nd (14.26) 3rd (2739) 21 Lines run 10 10 10 22 Overtime hours per day 0 0 23 24 Beginning Inventory 2000 3875 25 Production 2,193 8 2,193 B 2,1938 26 Expected Demand 2,0000 2 200 0 2,500.0 393.8 27 Ending Inventory 3875 81.3 28 29 553 -3264 29 Deviation from Inventory Target 60 60 30 Employees 31 32 Cost of Plan 33 Labor Regular Time 5624 000 34 Labor Overtime 35 Hiring and Training 36 Layoff 37 Inventory Carry Cost 38 Stockout Cost 50 SO 50 Quarter Budget 39 40 Total Cost of Plan 41 42 43 44 45 Aggregate Plan 3938 81.3 2,193.8 2,650.0 -3750 -7135 60 Employees are paid for his work per day 60 employees are employeed currently Carrying cost per year divided by multiplied by 1000 Based on negative deviation from target $0 .. 50 W o DU Arial -110 26 Wrap Text Currency Xcut Da Copy - Paste Format Painter Clipboard - A A DA. Bad BIU- Good Noutal Merge & Center - S 8. Normal Conditional Format as Check Cell Formatting Table Explanatory Input Linked Cell Note Fans Alignment Number Studes 333 X f $624,000 ? A 1 1.000 case units. F G H 1 J K L M N 4th (4052) 1st (Next Year) Notes 2,650 2.200 Each number is a 13 week forecast. 338 This is calculated based on 6 weeks of future forecast demand. Forecast Demand by Quarter (1,000 Case Units) 3,000 2500 2,000 1,500 1.000 500 0 1st (1-13) 2nd (1426) 3d (27393 h (40.5 Next Year 4th (40-52) 10 Notes Construct solution here R Quarter (Week Numbers) 1st (1-13) Forecast Demand 2nd (14-26) 3rd (27-39) 2,000 2,200 2,500 Ending Inventory Target 338 385 408 6 Planning Data Numbers Units measure Notes 7 Initial number of employees 60 employees 8 Emplyees per line 6 9 Standard production rate (each line) 450 Cases per hour 10 Employee pay rate 520.00 per hour 11 Overtime pay rate $30.00 per hour 12 Standard hours per shift 7.5 hours 13 Maximum overtime per day 2 hours 14 Inventory carry cost 51.00 per case (per year) 15 Stockout cost 52.40 per case 16 Employee hiring and training cost $5,000.00 per employee 17 Employee layoff cost $3,000 00 per employee 1B 19 Aggregate Plan Quarter (Week Numbers) 20 1st (1-13) 2nd (14.26) 3rd (2739) 21 Lines run 10 10 10 22 Overtime hours per day 0 0 23 24 Beginning Inventory 2000 3875 25 Production 2,193 8 2,193 B 2,1938 26 Expected Demand 2,0000 2 200 0 2,500.0 393.8 27 Ending Inventory 3875 81.3 28 29 553 -3264 29 Deviation from Inventory Target 60 60 30 Employees 31 32 Cost of Plan 33 Labor Regular Time 5624 000 34 Labor Overtime 35 Hiring and Training 36 Layoff 37 Inventory Carry Cost 38 Stockout Cost 50 SO 50 Quarter Budget 39 40 Total Cost of Plan 41 42 43 44 45 Aggregate Plan 3938 81.3 2,193.8 2,650.0 -3750 -7135 60 Employees are paid for his work per day 60 employees are employeed currently Carrying cost per year divided by multiplied by 1000 Based on negative deviation from target $0 .. 50 W o