create a column with the numbers 1-48 titled "Time", and a column wirh the months January through December for four years, titled "month". Copy the data into three columns, Sales, inventory, requests, each wjth 48 values for the 48 months.

3 Month 3 4 5 6 5 1 2. 3 4 7 8 9 10 11 5 6 Shipments Year 3 40,000 40,000 35,000 20,000 15,000 15,000 20,000 30,000 35,000 40,000 40,000 40,000 370,000 3 Year 1 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000 1 Year 2 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 384,000 2 1 1 3 7 Average 36,750 35,500 33,000 26,750 24,250 24,250 25,500 31,750 33,000 35,500 36,750 36,750 379,750 Year 4 45,000 40,000 35,000 25,000 20,000 20,000 20,000 35,000 35,000 40,000 45,000 45,000 405,000 4 % 9.68% 9.35% 8.69% 7.04% 6.39% 6.39% 6.71% 8.36% 8.69% 9.35% 9.68% 9.68% 100.00% 12 8 9 10 13 14 15 16 17 11 12 Total 18 19 Month 2 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 6 7 8 9 Year 1 32,000 30,000 18,362 25,429 22,322 14,617 15,534 15,108 15,408 53,918 83,188 36,114 362,000 1 Year 2 32,000 32,000 19,756 25,975 23,720 13,376 16,609 18,359 18,124 56,279 83,298 44,504 384,000 2 Sales Year 3 40,000 40,000 23,249 27,083 19,668 15,000 14,807 18,969 20,202 56,149 54,873 40,000 370,000 3 Year 4 45,000 40,000 23,278 26,150 27,445 16,579 18,261 18,627 22,084 56,868 65,708 45,000 405,000 Average 37,250 35,500 21,161 26,159 23,289 14,893 16,303 17,766 18,955 55,804 71,767 41,405 380,250 % 9.80% 9.34% 5.57% 6.88% 6.12% 3.92% 4.29% 4.67% 4.98% 14.68% 18.87% 10.89% 100.00% 10 11 12 Total 4 37 38 39 Month Beginning Inventory Year 1 Year 2 Year 3 2,000 0 0 0 0 Year 4 40 41 1 0 2 0 3 0 0 4 5 6 11,751 4,668 0 7 8 42 43 44 45 46 47 48 49 50 51 52 53 11,638 16,209 23,887 39,270 53,736 68,628 83,220 59,302 6,114 364,004 12,244 18,269 26,549 45,173 60,564 74,205 88,081 63,802 12,504 401,391 11,722 10,572 3,127 6,548 8,287 24,660 37,576 20,708 9 10 11 5,193 16,224 31,022 14,873 12 0 Average 83,731 123,200 54 54 55 Month 56 57 Year 4 58 2 Requests Year 2 52,978 58,145 19,756 13,731 5,451 Year 1 52,525 58,142 18,362 13,791 6,113 0 59 60 61 62 4 5 51,141 62,647 23,278 14,428 16,873 13,452 11,713 10,340 6 Year 3 52,066 61,921 23,249 15,332 20,404 15,598 14,807 13,776 3,978 25,127 67,303 75,539 389,100 63 7. 0 0 8 0 0 9 0 0 10 0 0 64 65 66 67 68 69 70 71 11 12 Total 23,886 66,799 239,618 19,496 61,690 231,247 19,292 63,356 76,531 363,051 3 Month 3 4 5 6 5 1 2. 3 4 7 8 9 10 11 5 6 Shipments Year 3 40,000 40,000 35,000 20,000 15,000 15,000 20,000 30,000 35,000 40,000 40,000 40,000 370,000 3 Year 1 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000 1 Year 2 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 384,000 2 1 1 3 7 Average 36,750 35,500 33,000 26,750 24,250 24,250 25,500 31,750 33,000 35,500 36,750 36,750 379,750 Year 4 45,000 40,000 35,000 25,000 20,000 20,000 20,000 35,000 35,000 40,000 45,000 45,000 405,000 4 % 9.68% 9.35% 8.69% 7.04% 6.39% 6.39% 6.71% 8.36% 8.69% 9.35% 9.68% 9.68% 100.00% 12 8 9 10 13 14 15 16 17 11 12 Total 18 19 Month 2 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 6 7 8 9 Year 1 32,000 30,000 18,362 25,429 22,322 14,617 15,534 15,108 15,408 53,918 83,188 36,114 362,000 1 Year 2 32,000 32,000 19,756 25,975 23,720 13,376 16,609 18,359 18,124 56,279 83,298 44,504 384,000 2 Sales Year 3 40,000 40,000 23,249 27,083 19,668 15,000 14,807 18,969 20,202 56,149 54,873 40,000 370,000 3 Year 4 45,000 40,000 23,278 26,150 27,445 16,579 18,261 18,627 22,084 56,868 65,708 45,000 405,000 Average 37,250 35,500 21,161 26,159 23,289 14,893 16,303 17,766 18,955 55,804 71,767 41,405 380,250 % 9.80% 9.34% 5.57% 6.88% 6.12% 3.92% 4.29% 4.67% 4.98% 14.68% 18.87% 10.89% 100.00% 10 11 12 Total 4 37 38 39 Month Beginning Inventory Year 1 Year 2 Year 3 2,000 0 0 0 0 Year 4 40 41 1 0 2 0 3 0 0 4 5 6 11,751 4,668 0 7 8 42 43 44 45 46 47 48 49 50 51 52 53 11,638 16,209 23,887 39,270 53,736 68,628 83,220 59,302 6,114 364,004 12,244 18,269 26,549 45,173 60,564 74,205 88,081 63,802 12,504 401,391 11,722 10,572 3,127 6,548 8,287 24,660 37,576 20,708 9 10 11 5,193 16,224 31,022 14,873 12 0 Average 83,731 123,200 54 54 55 Month 56 57 Year 4 58 2 Requests Year 2 52,978 58,145 19,756 13,731 5,451 Year 1 52,525 58,142 18,362 13,791 6,113 0 59 60 61 62 4 5 51,141 62,647 23,278 14,428 16,873 13,452 11,713 10,340 6 Year 3 52,066 61,921 23,249 15,332 20,404 15,598 14,807 13,776 3,978 25,127 67,303 75,539 389,100 63 7. 0 0 8 0 0 9 0 0 10 0 0 64 65 66 67 68 69 70 71 11 12 Total 23,886 66,799 239,618 19,496 61,690 231,247 19,292 63,356 76,531 363,051