We need to find which month had the highest percentage increase compared to the previous month.
Percentage increase formula:
Old ValueNew Value−Old Value×100
From the chart, we have most monthly sales figures. We need to find the missing values for 2016.
For Q2 2016 (Apr, May, Jun): Forms arithmetic progression with Jun =500 and quarter total =1440
Let Apr =a, May =a+d, Jun =a+2d=500
Sum: 3a+3d=1440, so a+d=480
Since a+2d=500, we get d=20
Therefore: Apr =460, May =480, Jun =500
For Q4 2016 (Oct, Nov, Dec): Forms arithmetic progression with Dec =840 and quarter total =2280
Let Oct =b, Nov =b+e, Dec =b+2e=840
Sum: 3b+3e=2280, so b+e=760
Since b+2e=840, we get e=80
Therefore: Oct =680, Nov =760, Dec =840
Calculating percentage increases for each month:
2016:
• Feb: 240320−240×100=33.33%
• Mar: 320360−320×100=12.50%
• Apr: 360460−360×100=27.78%
• May: 460480−460×100=4.35%
• Jun: 480500−480×100=4.17%
• Jul: 500600−500×100=20.00%
• Aug: 600680−600×100=13.33%
• Sep: 680720−680×100=5.88%
• Oct: 720680−720×100=−5.56% (decrease)
• Nov: 680760−680×100=11.76%
• Dec: 760840−760×100=10.53%
2017:
• Jan: 840900−840×100=7.14%
• Feb: 900960−900×100=6.67%
• Mar: 9601020−960×100=6.25%
• Apr: 10201080−1020×100=5.88%
• May: 10801140−1080×100=5.56%
• Jun: 11401200−1140×100=5.26%
• Jul: 12001320−1200×100=10.00%
• Aug: 13201400−1320×100=6.06%
• Sep: 14001480−1400×100=5.71%
• Oct: 14801560−1480×100=5.41%
• Nov: 15601620−1560×100=3.85%
• Dec: 16201680−1620×100=3.70%
The highest percentage increase is 33.33% in February 2016.
Therefore, February 2016 had the highest percentage increase in sales from the previous month.