{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Moving Averages Template","2.1 Answers","Single Channel Template","14.1 Answers"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"Moving Averages Template","index":0,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,0,2,2]]}
["Moving Average"]
[]
["Periods of Moving Average =",null,null,3]
[]
["MAD = ",3174.333333333333]
["MAPE =",0.27369661435879744]
[]
["Period","Actual","Forecast","Error","Tracking Signal"]
[1,15908,"","",""]
[2,15504,"","",""]
[3,14272,"","",""]
[4,13174,15228,-2054,-1]
[5,10022,14316.666666666666,-4294.6666666666661,-2]
[6,null,12489.333333333334,"",""]
[7,null,"","",""]
[8,null,"","",""]
[9,null,"","",""]
[10,null,"","",""]
[11,null,"","",""]
[12,null,"","",""]
[13,null,"","",""]
[14,null,"","",""]
[15,null,"","",""]
[16,null,"","",""]
[17,null,"","",""]
[18,null,"","",""]
[19,null,"","",""]
[20,null,"","",""]
[21,null,"","",""]
[22,null,"","",""]
[23,null,"","",""]
[24,null,"","",""]
[25,null,"","",""]
[26,null,"","",""]
[27,null,"","",""]
[28,null,"","",""]
[29,null,"","",""]
[30,null,"","",""]
[31,null,"","",""]
[32,null,"","",""]
[33,null,"","",""]
[34,null,"","",""]
[35,null,"","",""]
[36,null,"","",""]
[37,null,"","",""]
[38,null,"","",""]
[39,null,"","",""]
[40,null,"","",""]
[41,null,"","",""]
[42,null,"","",""]
[43,null,"","",""]
[44,null,"","",""]
[45,null,"","",""]
[46,null,"","",""]
[47,null,"","",""]
[48,null,"","",""]
[49,null,"","",""]
[50,null,"","",""]
[51,null,"","",""]
[52,null,"","",""]
[53,null,"","",""]
[54,null,"","",""]
[55,null,"","",""]
[56,null,"","",""]
[57,null,"","",""]
[58,null,"","",""]
[59,null,"","",""]
[60,null,"","",""]

{"sheet":"2.1 Answers","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["EX2.1"]
[]
["Months","Visits","Naïve","3-MA","4-MA"]
["July",2160]
["August",2186]
["September",2246]
["October",2251]
["November",2243]
["December",2162]
["January"]
[]
[null,"Answers"]
["a.",null,null,"January forecast"]
[]
["b.",null,null,"January forecast using 3-MA"]
[]
["c.",null,null,"January forecast using 4-MA"]
[]
[null,"In 1-2 sentences, explain which you explain which of the three results you have the most confidence in projecting accurately and why that is.  "]
["d. "]

{"sheet":"Single Channel Template","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Single Channel, Poisson Arrival, and Exponential Service Time (M/M/1)"]
[]
[]
["Arrival rate","λ",4]
["Service rate","μ",5]
["Average Number of customers waiting for service","Lq",{"$f":"LqSingle(C4,C5)","v":{"$error":"#NAME?"}}]
["Average Number of customers in the system (waiting or being served)","L",{"$f":"LTotal(C4,C5,C6)","v":{"$error":"#NAME?"}}]
["Average time customers wait in line","Wq",{"$f":"Wq(C4,C6)","v":{"$error":"#NAME?"}}]
["Average time customers spend in the system","W",{"$f":"W(C5,C8)","v":{"$error":"#NAME?"}}]
["System utilization","ρ",{"$f":"C4/C5","v":0.8}]
["Service time","1/μ",{"$f":"1/C5","v":0.2}]
["Probability of zero units in system","P0",{"$f":"P0Single(C4,C5)","v":{"$error":"#NAME?"}}]
[null,"n",3]
[{"$f":"\"Probability of \" &C13&\" units in system\"","v":"Probability of 3 units in system"},{"$f":"\"P\"&C13","v":"P3"},{"$f":"PWSingle(C4,C5,C13,C12)","v":{"$error":"#NAME?"}}]

{"sheet":"14.1 Answers","index":3,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"EX14.1","Answers"]
[]
[]
[]
[]
[]
[]
["A.","System Utilization"]
[]
[]
[]
[]
["B.","Average Number in Line"]
[]
[]
[]
[]
["C.","Average Time in Line"]
[]
[]
[]
[]
[]
["D.","Average Time in the System"]