After you\'ve completed the first month (January) of the second worksheet, compl
ID: 2332666 • Letter: A
Question
After you've completed the first month (January) of the second worksheet, complete the full year of numbers using the following adjustments for all line items:
Feb - Apr: decreases by 10% per month
May - June: increase by 5%per month
July - Sept: decreases by 7% per month
Oct - Dec: Increases by 20% per month.
Be sure to include an annual total for each of the line items as well as the full year.
Henson Health Center- Office Suppli (Tab/Worksheet 1) OrderDate Location Units UnitCost Total 1/6/2015 East 1.99189.05**Usc a formula to calculatc 19.99999.5 the total' columm. 1/23/201 Central 2/9/201 Central 2/26/2015 Central 3/15/2015 West Jardine 4.99 179.64 19.99 539.73 2.99 167.44 4/1/2015 418/2015 Central 5/5/2015Central 1.99 149.25 Pencil 5/22/2015West Thompson 6/8/201 6/25/2015 Ccntral 7/12/201 7/29/2015 8/15/2015 East East East 19.99 1,619.19 4.99 174.65 9/1/2015 Central 15.99255.84 8.99 251.72 8.99575.36 19.99 299.85 4.99 479.04 10/5/2015 Central 1022/2015 Morgan 118/2015 11/25/2015 Central 12/12/2015 Central 12/29/2015 Pencil 15.99 1,183.26 8.99 413.54 15 1,305.00 19.99139.93 249.5 199 131.34 /15/2016 Ccntral 2/1/2016 Ccntral 2/18/2016 East 3/7/2016 Wcst 3/24/2016 Central 410/2016 Central 4/27/2016 5/14/2016 Central 5/31/2016 Central 6/17/201 Central Jardinc Andrews 4.99 479.04 4.99 309.38 12.49 686.95 23.95 1,005.90 7/4/2016 7/21/2016 Central 8/7/2016 Central 824/2016 West 910/2016 Central 9:27/2016 10/14/2016 1.99 51.24 19.991,139.43 Thompson Binder 1031/2016 Central 11/17/2016 Central 12/4/201 Central 12/21/2016 Central Andrews Jardine Jardine 19.99 1,879.06 4.99 139.72 Grand Total Use a Formula HereExplanation / Answer
Order date
Health Health Center- Income Statement:
Order date
Location Rep Item Units Unit cost Total l/6/2015 East Pencil 95 1.99 189.05 11/23/2015 Central Binder 50 19.99 999.5 2/9/2015 Central Pencil 50 4.99 179.64 2/26/2015 Central Pen 27 19.99 539.73 3/ 15/2015 West Pencil 56 2.99 167.44 4/1/2015 East Binder 60 4.99 299.4 4/18/2015 Central Pencil 75 1.99 149.25 5/5/2015 Central Pencil 90 4.99 449.1 5/22/2015 West Pencil 32 1.99 63.68 6/8/2015 East Binder 60 8.99 539.4 6/25/2015 Central Pencil 90 4.99 449.1 7/12/2015 East Binder 29 1.99 63.68 7/29/2015 East Binder 81 19.99 1619.19 8/ 15/2015 East Pencil 35 4.99 174.65 9/ 1/2015 Central Desk 2 125 250 9./18/2015 East Pen Set 16 15.99 255.84 10/5/2015 Central Binder 28 8.99 251.72 10/22/2015 East Pen 64 8.99 575.36 11/8/2015 East Pen 15 19.99 299.85 11 /25/2015 Central Pen Set 96 4.99 479.04 12/12/2015 Central Pencil 67 1.29 86.43 12/29/2015 East Pen Set 74 15.99 1.183.26 1/15/2016 Central Binder 46 8.99 413.54 2/ 1/2016 Central Binder 87 15 1305 2/18/2016 East Binder 4 4.99 19.96 3/7/2016 West Binder 7 19.99 139.93 3/24/2016 Central Pen Set 50 4.99 249.5 4/ 10/2016 Central Pencil 66 1.99 131.34 4/27/2016 East Pen 96 4.99 479.04 5/ 14/2016 Central Pencil 53 1.29 68.37 5/31/2016 Central Binder 80 8.99 719.2 6./17/2016 Central Desk 5 125 625 7/4/2016 East Pen Set 62 4.99 309.38 7/21/2016 Central Pen Set 55 12.49 686.95 8/7./2016 Central Pen Set 42 23.95 1,005.90 8/24/2016 West Desk 3 275 825 9/10/2016 Central Pencil 7 1.29 9.03 9/27/2016 West Pen 76 1.99 151.24 10/14/2016 West Binder 57 19.99 1.139.43 10/31/2016 Central Pencil 14 1.29 18.06 11/ 17/2016 Central Binder 11 4.99 54.89 12/4/2016 Central Binder 94 19.99 1,879.06 12/21/2016 Central Binder 28 4.99 139.72 GRAND TOTAL 19627.78