{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["LAWNKING","GRAPH2","GRAPH1"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"GRAPH2","index":1,"reason":"not_a_worksheet"},{"sheet":"GRAPH1","index":2,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"LAWNKING","index":0,"n_rows":80,"n_cols":14,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[null,"FILENAME: LAWNKING",null,null,null,null,null,"/PPRA21.G36~GLLRA41.G60~GPRH41.N60~GLLRA68.G80~GPQ"]
[]
[null,"USE THIS PROGRAM TO ASSIST IN YOUR ANALYSIS OF THE "]
[null,"LAWN KING, INC. CASE."]
[]
[null,"THIS SPREADSHEET WILL CALCULATE THE COSTS OF ANY GIVEN"]
[null,"AGGREGATE PLANNING STRATEGY THAT YOU CHOOSE TO INPUT.  YOU "]
[null,"CAN INPUT THE CHASE STRATEGY, LEVEL STRATEGY, ETC.  FIRST,"]
[null,"YOU MUST MAKE A FORECAST OF DEMAND FROM THE CASE.  THEN ENTER"]
[null,"INPUTS FOR PRODUCTION, COSTS, AND OTHER VALUES REQUESTED."]
[null,"THE SPREADSHEET WILL DO THE ARITHMETIC TO CALCULATE THE"]
[null,"TOTAL COSTS OF YOUR STRATEGY."]
[]
[null,"DETERMINE THE FIRST STRATEGY YOU WISH TO ANALYZE, THEN ENTER THE"]
[null,"APPROPRIATE DATA WHEREVER YOU SEE HIGHLIGHTED \"NA\"'s IN THE"]
[null,"WORKSHEET. THEN REPEAT THIS STEP FOR OTHER STRATEGIES AND MODELS."]
[null,"USE THE \"TAB\" KEY TO SEE THE LAST SEVEN MONTHS OF EACH STRATEGY."]
[]
[null,"PRESS \"ALT\" AND \"P\" FOR A PRINTOUT "]
[null,"PRESS \"PgDn\" TO BEGIN."]
[]
[null,"FILENAME:  LAWNKING",null,"NAME:","*"]
[null,null,null,null,"*",null,null,null,"  "]
[null,null,null,"SECTION:","*"]
[null,"BASIC INPUT DATA",null,"DATE:",{"$f":"TRUNC(NOW())","v":"2016-12-04"}]
[null,"="]
[null,"MONTHLY PROD. RATE (UNITS/WORKER/MONTH):",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},"UNITS"]
[null,"BEGINNING INVENTORY (UNITS):",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},"UNITS"]
[null,"BEGINNING NUMBER OF WORKERS:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},"WORKERS"]
[null,"HIRING COST PER WORKER:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"LAYOFF COST PER WORKER:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"INVENTORY HOLDING COST ($ PER UNIT PER MONTH):",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"INVENTORY SHORTAGE COST (COST/UNIT SHORT) :",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"REGULAR HOURLY WAGE RATE:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"OVERTIME HOURLY WAGE RATE:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"HOURS/MONTH:",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[]
[null,"PRESS \"PgDn\" TO VIEW THE AGGREGATE PLANNING WORKSHEET, THEN ENTER DATA"]
[null,"FOR ALL 12 MONTHS IN THE WORKSHEET.  GO TO COLUMN A & PRESS \"PgDn\""]
[null,"AGAIN FOR THE TOTAL COST OF THE STRATEGY YOU ENTERED IN THE WORKSHEET."]
["TA","B FOR       MONTHS:","SEPT.","OCT.","NOV.","DEC.","JAN.","FEB.","MAR.","APR.","MAY","JUNE","JULY","AUG."]
["FE","B THRU AUG","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"Sales Forecast:",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"Units Produced:",{"$f":"C49*$F$27","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Ending Inventory:",{"$f":"F28-C43+C44","v":{"$error":"#N/A"}},{"$f":"C45-D43+D44","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Number of Workers:",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"Overtime Percent:",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Equivalent"]
[null,"number of workers:",{"$f":"C46*(1+C47)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"(# workers + O.T.)"]
[null,"Reg. Labor Costs:",{"$f":"$F$34*$F$36*C46","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"O.T. Labor Costs:",{"$f":"$F$35*$F$36*(C49-C46)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Change in # workers"]
[null,"from last month:",{"$f":"C46-F29","v":{"$error":"#N/A"}},{"$f":"D46-C46","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Hiring Cost:",{"$f":"IF(C54>0,C54*$F$30,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Layoff Cost:",{"$f":"IF(C54<0,ABS(C54*$F$31),0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"End-Inv. Hold. Cost:",{"$f":"IF(C45>0,C45*$F$32,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"End-Inv. Short. Cost:",{"$f":"IF(C45<0,ABS(C45*$F$33),0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"-","-","-","-","-","-","-","-","-","-","-","-"]
[null,"MONTHLY TOTAL COST:",{"$f":"C51+C52+C55+C56+C57+C58","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"IN THE SPACE BELOW, ENTER A DESCRIPTION OF THE STRATEGY YOU USED"]
[null,"IN DEVELOPING THE ABOVE WORKSHEET.  ALSO ENTER WHETHER YOUR DATA"]
[null,"REPRESENTS ALL MODELS OR ONE SPECIFIC MODEL, AND ANY OTHER ASSUMPTIONS"]
[null,"YOU MADE IN DEVELOPING YOUR STRATEGY OR INPUT DATA. THEN PRESS \"ALT\" &"]
[null,"\"P\" AT THE SAME TIME TO GET PRINTED OUTPUT.  THEN GO BACK TO THE"]
[null,"WORKSHEET AND ENTER NEW DATA FOR ANOTHER STRATEGY AND/OR MODEL."]
[]
[null,"STRATEGY DESCRIPTION & ASSUMPTIONS"]
[null,"=","=","="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"SUM(C60:N60)","v":{"$error":"#N/A"}},"TOTAL COST OF THIS STRATEGY"]