6-2 Discussion: Peer Review of Presentation
d_bang
IT100SpreadSheet1.xlsxCURRENT YEAR
| Total current sale 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | ||||||||
| Office supplies | $150,000.00 | $180,000.00 | $216,000.00 | $259,200.00 | $311,040.00 | $373,248.00 | |||||||
| Office equipment | $300,000.00 | $360,000.00 | $432,000.00 | $518,400.00 | $622,080.00 | $746,496.00 | |||||||
| Printing | $50,000.00 | $60,000.00 | $72,000.00 | $86,400.00 | $103,680.00 | $124,416.00 | |||||||
| Total | $500,000.00 | $600,000.00 | $720,000.00 | $864,000.00 | $1,036,800.00 | $1,244,160.00 | |||||||
| 120 |
Current year
Total current sale 2016 Office supplies Office equipment Printing Total 150000 300000 50000 500000 Office supplies Office equipment Printing Total
projected sales
| Total current sale 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | ||
| Office supplies | $150,000.00 | $180,000.00 | $216,000.00 | $259,200.00 | $311,040.00 | $373,248.00 | |
| Office equipment | $300,000.00 | $360,000.00 | $432,000.00 | $518,400.00 | $622,080.00 | $746,496.00 | |
| Printing | $50,000.00 | $60,000.00 | $72,000.00 | $86,400.00 | $103,680.00 | $124,416.00 | |
| Total | $500,000.00 | $600,000.00 | $720,000.00 | $864,000.00 | $1,036,800.00 | $1,244,160.00 | |
Projected sales growth
Office supplies Total current sale 2016 2017 2018 2019 2020 2021 150000 180000 216000 259200 311040 373248 Office equipment Total current sale 2016 2017 2018 2019 2020 2021 300000 360000 432000 518400 622080 746496 Printing Total current sale 2016 2017 2018 2019 2020 2021 50000 60000 72000 86400 103680 124416 Total Total current sale 2016 2017 2018 2019 2020 2021 500000 600000 720000 864000 1036800 1244160
projected sales growth
Office supplies Total current sale 2016 2017 2018 2019 2020 2021 150000 180000 216000 259200 311040 373248 Office equipment Total current sale 2016 2017 2018 2019 2020 2021 300000 360000 432000 518400 622080 746496 Printing Total current sale 2016 2017 2018 2019 2020 2021 50000 60000 72000 86400 103680 124416 Total Total current sale 2016 2017 2018 2019 2020 2021 500000 600000 720000 864000 1036800 1244160
