1 . Create a simple plan ( in sketch form ) for a working spreadsheet using this information a . Sales report for the month of July indicating red wine sales for Jack's Wine Store b . Wine names should be input to Column A , with Weeks 1 - 4 also in columns C . Include a total column and row for each wine and each week Red wines available at Jack's Wine Store Browns 2009 Cabernet Sauvignon Penfolds 2012 Merlot Hunter Valley 2005 Reserve Shiraz Taylors 2009 Shiraz Yalumba 2008 Cabernet Sauvignon Clare Valley 2011 Pinot Noir Templeton 2013 Rose Hardys 2007 Merlot