Inventory Proposal

1254 Words6 Pages
Inventory Proposal Learning Team C was tasked with preparing a project proposal that would analyze and present data on an inventory management problem that Amazon Incorporated (Amazon) could face. The Summer Historical Inventory Data shown below was used in the calculations: Month Year 1 Year 2 Year 3 Year 4 1 18,000 45,100 59,800 35,500 2 19,800 46,530 30,740 51,250 3 15,700 22,100 47,800 34,400 4 53,600 41,350 73,890 68,000 5 83,200 46,000 60,200 68,100 6 72,900 41,800 55,200 61,100 7 55,200 39,800 32,180 62,300 8 57,350 64,100 38,600 66,500 9 15,400 47,600 25,020 31,400 10 27,700 43,050 51,300 36,500 11 21,400 39,300 31,790 16,800 12 17,100 10,300 31,100 18,900 The following proposal includes a short description of…show more content…
Over all, benefits are to Amazon as a well as the global consumer. Monthly Indexes Monthly Index using Year 1 Month 1 as a Base Histogram Four Year Highlights Busiest Months by Year Year 2 December 57 Year 1 September 86 Year 4 November 93 Year 3 September 139 Slowest Months by Year Year 1 May 462 Year 3 April 411 Year 4 May 378 Year 2 August 356 The busiest time of the four years was December of Year 2 and the slowest time was May of Year 1. Quarterly Indexes Quarter Value Indices Y1Q1 17,833 100 Y1Q2 69,900 392 Y1Q3 42,650 239 Y1Q4 22,067 124 Y2Q1 37,910 213 Y2Q2 43,050 241 Y2Q3 50,500 283 Y2Q4 30,883 173 Y3Q1 46,113 259 Y3Q2 63,097 354 Y3Q3 31,933 179 Y3Q4 38,063 213 Y4Q1 43,248 243 Y4Q2 64,415 361 Y4Q3 42,667 239 Y4Q4 31,065 174 Year 1 Quarter 1 was used as the base of 17,833 for index 100. The resulting histogram establishing the 4-year indices table as shown above: Histogram Four Year Highlights Busiest Quarters by Year Year 1 Quarter 1 100 Year 2 Quarter 4 173 Year 4 Quarter 4 174 Year 3 Quarter 3 179 Slowest Quarters by Year Year 1 Quarter 2 392 Year 4 Quarter 2 361 Year 3 Quarter 2 354 Year 2 Quarter 3 283 Annual Indexes Year Value Indices Y1 38,113 214 Y2 40,586 228 Y3 44,802 251 Y4 45,896 257 Histogram Four Year Highlights The busy and slow months in each of the four years
Open Document