OM_ASSIGNMENT_28SEPT.xlsx - One Year Two Year Year Three...

This preview shows page 1 - 3 out of 5 pages.

One YearDay4-6 AM6-8 AM8-10 AM10-noonnoon-2 PM2-4 PM4-6 PM12400270032001400170018001600219002500310016001800200018003230031002500150015001800190042200320031002200190024002100524003300340017002200210020006260028003500150017001900150071900280031001200150020001400820002700250015002000230019009240032003600160021002500180010260033003100200250026002400Two Year113100390041002200260023002500122800340039001900210025002000132700380043002100240024002400142400350041002400300032002600153300370040002600260027002900163500400038002300270031003000172900410039002400300032002500183400380042002000250030002200193600360040002300260028002600203700370040002200260027002400Year Three214400440045002600330034003000224200450043002500340036003100234500450047002700340035002900244600460046002500320035002800254500430044002900330033003300264200430045003000400034003000274500450051003300400037003100284300420043002800350040003300294900410042003100360039003400304700450041003000400037003400TOTAL9890011100011610065200807008530074800INDEX0.1460.1640.1710.0960.1190.1260.110FORECAST314135464148542726337435673128
alpha0.3slope519Intercept14535Forecasted ValuesERROR6-8 PM8-10 PMTotalExp SmoothingTrend3MA80020015800158001505307479003001590015800155721003281100200159001583016091701911200400187001585116609158672849209128331000600187001670617128168331994157218671100300169001730417646177674047468679004001520017183181651810019832965290010002001610016588186841693348825848331400200188001644219202160672358402273311004001820017149197211670010511521150011003002210017464202401770046361860440012003002010018855207581970012456584001200400217001922921277201332471423156712007002310019970217952130031301305180010003002310020909223142163321917861467900200235002156622833226331934667867

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture