IFSM 201

This is a typical way a spreadsheet is created: you have, or know, or are given, the
"business formulas" and some data and then you turn them into a worksheet.
Typically there is a small amount of data and many formulas; many rows of formulas.
And you won't know what the calculated values are supposed to be,
so you have to ensure you've made the formulas all correctly.

Create the Widgets 'R' Us worksheet using these "business formulas":

  Cost of goods sold is 65% of sales.

  Gross margin = Sales - Cost of goods sold

  Administrative expense is 80% of Net expense.

  Total expenses = Net expenses + Adm Expenses + Misc Expenses

  Average expenses = Total expenses / 3

  Net before tax = Gross margin - Total expenses

  Federal tax = 55% of Net before tax

  Net after tax = Net before tax - Federal tax

*****************************************************************
You can copy and paste this structure into a worksheet:


Widgets 'R' Us
                      Jan     Feb     Mar     Apr     Total

Sales:              $1,750  $1,501  $1,519  $1,430         
Cost of Goods Sold:                                        
  Gross Margin:                                             

Net Expense:            98      93      82     110         
Adm. Expense:                                              
Misc. Expense:          28      45      31      31         
  Total Expenses:                                           
  Average Expenses:                                         

Net Before Tax:                                            
Federal Tax:                                               
  Net After Tax:                                            


Apply some formatting so that the worksheet looks good. 
Make a chart of the Net After Tax of the four months.