{"id":146853,"date":"2022-03-15T21:13:08","date_gmt":"2022-03-15T21:13:08","guid":{"rendered":"https:\/\/academicwritersbay.com\/answers\/chapter_6_da_exercise_1-42fe1-xlsx\/"},"modified":"2022-03-15T21:13:08","modified_gmt":"2022-03-15T21:13:08","slug":"chapter_6_da_exercise_1-42fe1-xlsx","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/answers\/chapter_6_da_exercise_1-42fe1-xlsx\/","title":{"rendered":"Chapter_6_DA_Exercise_1-42fe1.xlsx"},"content":{"rendered":"<p>15Mar 2022 by<br \/>\nSales and Inventory<br \/>\nWeekly Sales and Inventory Data by Store<br \/>\nCompany Results<br \/>\nRegion NumberRegionStore NumberStateCitySize (square feet)Inventory ValueSales Last YearSales This YearPercent of Total CompanyChange in SalesWeeks of SupplyGrowth StoresShip StatusInventory StatusPriority<br \/>\n1<br \/>\n3284NJ<br \/>\n10,000$   2,464,100$   821,000$   919,520<br \/>\n12.00%2.68<br \/>\n2<br \/>\n3255MD<br \/>\n25,000$   4,106,200$   684,167$   732,058<br \/>\n7.00%5.61<br \/>\n1<br \/>\n3216NY<br \/>\n10,000$   3,613,700$   722,480$   852,526<br \/>\n18.00%4.24<br \/>\n1<br \/>\n3412NJ<br \/>\n10,000$   2,053,900$   228,056$   216,653<br \/>\n-5.00%9.47<br \/>\n1<br \/>\n3582PA<br \/>\n20,000$   3,942,300$   562,971$   608,009<br \/>\n8.00%6.48<br \/>\n3<br \/>\n3766OH<br \/>\n25,000$   4,517,100$   564,438$   615,237<br \/>\n9.00%7.34<br \/>\n1<br \/>\n3637NJ<br \/>\n15,000$   3,573,050$   396,817$   420,626<br \/>\n6.00%8.49<br \/>\n2<br \/>\n3744FL<br \/>\n10,000$   5,748,800$   478,917$   517,230<br \/>\n8.00%11.11<br \/>\n2<br \/>\n3638GA<br \/>\n20,000$   3,696,400$   369,450$   362,061<br \/>\n-2.00%10.20<br \/>\n3<br \/>\n3911OH<br \/>\n15,000$   3,286,000$   410,500$   410,500<br \/>\n0.00%8.00<br \/>\n1<br \/>\n4100MA<br \/>\n10,000$   2,793,500$   232,617$   223,312<br \/>\n-4.00%12.50<br \/>\n1<br \/>\n3816NJ<br \/>\n25,000$   3,696,700$   461,813$   489,521<br \/>\n6.00%7.55<br \/>\n1<br \/>\n4310RI<br \/>\n10,000$   2,793,700$   279,140$   273,557<br \/>\n-2.00%10.20<br \/>\n4<br \/>\n4474CA<br \/>\n10,000$   4,517,700$   301,033$   273,940<br \/>\n-9.00%16.48<br \/>\n3<br \/>\n4085PA<br \/>\n25,000$   5,543,850$   791,679$   839,179<br \/>\n6.00%6.60<br \/>\n4<br \/>\n4366CA<br \/>\n25,000$   4,189,100$   465,233$   451,276<br \/>\n-3.00%9.28<br \/>\n1<br \/>\n4160PA<br \/>\n10,000$   2,957,500$   328,400$   328,400<br \/>\n0.00%9.00<br \/>\n2<br \/>\n4077MD<br \/>\n15,000$   2,629,000$   525,440$   556,966<br \/>\n6.00%4.72<br \/>\n3<br \/>\n4555IL<br \/>\n10,000$   3,039,400$   253,142$   240,485<br \/>\n-5.00%12.63<br \/>\n4<br \/>\n4709TX<br \/>\n20,000$   3,285,600$   252,615$   229,880<br \/>\n-9.00%14.29<br \/>\n1<br \/>\n4072NY<br \/>\n15,000$   2,464,500$   615,750$   665,010<br \/>\n8.00%3.70<br \/>\n3<br \/>\n4521OH<br \/>\n10,000$   1,643,400$   547,333$   613,013<br \/>\n12.00%2.68<br \/>\n3<br \/>\n4655MI<br \/>\n20,000$   4,598,900$   328,400$   302,128<br \/>\n-8.00%15.22<br \/>\n4<br \/>\n4750WA<br \/>\n15,000$   2,864,200$   318,111$   318,111<br \/>\n0.00%9.00<br \/>\n2<br \/>\nRegion Plan<br \/>\nSales Plan by Region<br \/>\nRegion Number1234<br \/>\nRegion NameNortheastSouthMidwestWest<br \/>\nTotal Gross Sales$   132,000,000$   55,000,000$   50,000,000$   45,000,000<br \/>\nGrowth Target10.00%3.00%0.00%2.00%<br \/>\nStore Details<br \/>\nStore Information<br \/>\nStore NumberRegion NumberRegion NameStateCitySize<br \/>\n32841NortheastNJPrinceton10,000<br \/>\n32552SouthMDFrederick25,000<br \/>\n32161NortheastNYQueens10,000<br \/>\n34121NortheastNJRoselle Park10,000<br \/>\n35821NortheastPABethlehem20,000<br \/>\n37663MidwestOHColumbus25,000<br \/>\n36371NortheastNJHackettstown15,000<br \/>\n37442SouthFLMiami10,000<br \/>\n36382SouthGAAtlanta20,000<br \/>\n39113MidwestOHYoungstown20,000<br \/>\n41001NortheastMABoston10,000<br \/>\n38161NortheastNJNew Brunswick25,000<br \/>\n43101NortheastRIProvidence10,000<br \/>\n44744WestCASan Francisco10,000<br \/>\n40853MidwestPAPittsburgh25,000<br \/>\n43664WestCALos Angeles15,000<br \/>\n41601NortheastPAPhiladelphia10,000<br \/>\n40772SouthMDBaltimore15,000<br \/>\n45553MidwestILChicago10,000<br \/>\n47094WestTXDallas20,000<br \/>\n40721NortheastNYAlbany15,000<br \/>\n45213MidwestOHCincinnati10,000<br \/>\n46553MidwestMIDetroit20,000<br \/>\n47504WestWASeatle15,000<\/p>\n","protected":false},"excerpt":{"rendered":"<p>15Mar 2022 by Sales and Inventory Weekly Sales and Inventory Data by Store Company Results Region NumberRegionStore NumberStateCitySize (square feet)Inventory ValueSales Last YearSales This YearPercent&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-146853","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/146853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/comments?post=146853"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/posts\/146853\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/media?parent=146853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/categories?post=146853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/answers\/wp-json\/wp\/v2\/tags?post=146853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}