1 Problem Data for Problems 1-7 2 3 4 Cost Data 5 6 7 8 9 10 11 12 13 358838 14 15 Labor standard per unit [hours) 16 Regular time available per period [hours) 17 Overtime available per period (hours) 18 19 Subcontracting maximum per period [units] Subcontracting minimum per period [units] 20 Demand Data (units) 21 22 23 24 30 26 27 Total Number of Periods 28 29 31 Regular time labor cost per hour Overtime labor cost per hour Subcontracting cost per unit (labor only) Holding cost per unit period Back-order cost per unit period 32 Hiring cost per employee Firing cost per employee Capacity Data 34 Beginning workforce (employees) Beginning inventory (units) Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 B $10.00 $15.00 $84.00 $10.00 $20.00 $600 00 $450.00 280 400 8 16:0 32 1000 500 5000 4300 7840 5700 6560 4600 6 C D Units per Employee per Period Workers needed Level Aggregate Plan, Using Inventories and Backorders Compute Level Production Rate Total Demand Less Beginning Inventory Total Net Demand Average Demand Per Period Compute Vorkforce Needed Number to Hire Number to Fire Detailed Plan Computations Demand (units) (net of beg Inventory) Period production (units) Ending Inventory (units) Backorders (units] Cost Calculations for Plan A Regular time labor cost Inventory holding cost Back order cost Complete the spreadsheets in the homework workbook by manually calculating the required numerical values. The yellow colored spreadsheet cells contain the problem data. Fill in the light blue colored cells in order to complete the spreadsheets Hiring cost Firing cost Total Cost 34000 G H $0

Problem Data for Problems 1.7 Cost Data Demasd Date (unas) \begin{tabular}{|c|c|} \hline Punot 1 & cos0 \\ \hline Proulz & 48 \\ \hline Pnot) & 700 \\ \hline Perode & 60 \\ \hline Penods & c(4) \\ \hline Penos 6 . & 1000 \\ \hline \end{tabular} Detaited Pian Computations \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & teo = & 4>00 & rese & & ses & 4500 & \begin{tabular}{l} Cotain. \\ 32500 \end{tabular} \\ \hline & & & & & -2 & & a \\ \hline Cneng hverucyinei) & += & E & & & E & & o. \\ \hline & - & & & & & & 0 \\ \hline \end{tabular} Total Number of Peilods Cost Calealuioes for Plae A Pegulat ime lapor codr hiverect bolfing cost Buik enstr cont colored calla horse to tomplete me agreasherti Hingeon limgrom Toulcor 16