IFSM 300

Make a spreadsheet for:


           Beans 'n Books' Growth Prediction

                 July       August     September     October    November     December    Total
Gross Coffee $10,581.40
Gross Book    $9,456.60
Less Returns
Net Sales
Less cost of goods sold
Gross profit on Sales

Expenses
Salaries        $2,500.00   $2,500.00   $2,500.00    $2,500.00   $2,500.00   $2,500.00
Rent            $2,400.00   $2,400.00   $2,400.00    $2,400.00   $2,400.00   $2,400.00
Advertising     $200.00     $200.00     $200.00       $200.00      $200.00     $200.00     
Operating costs $300.00     $300.00     $300.00       $300.00      $300.00     $300.00     
Total expenses

Net Income


They predict that each month's Gross Coffee will increase 10% over the
 previous month (i.e. each month will be 110% of the previous month's Gross Coffee).
For Gross Books a 5% month on month increase is predicted.
Less Returns is 3% of the sum of the two grosses for the month.
Net Sales is the sum of the two grosses minus the less returns.
Less cost of Goods Sold is 60% of the sum of the grosses.
Gross Profit on Sales is the Net Sales - Less Cost of Goods Sold.
Total Expenses is the sum of the four expenses.
Net Income is the Gross Profit on Sales - Total Expenses.

Apply some formatting to improve the appearance of the spreadsheet.

Add a chart that displays a line chart of the predictions of gross
coffee sales, gross book sales, and net income for the six months.