Problem
Your school has a $5000 software budget. The following request have been
made:
- The math department wants 12 copies of ASPS at $72.95 each
- The English department wants a 14 license for StorySpace at $54.50
- Social Studies wants a new Filemaker database server at $912.30
- Music has requested as many ear training programs at $53.23 each as
the school can afford, up to 20
- Administration want to upgrade to Windows XP and can get it for
$63.56 per license. There are 6 secretaries and 3 administrators who
need it, plus 27 teachers who also must have it
- Tax is 4.5%
Create a spreadsheet that (a) adds all these figures up to see if you
are within budget and (b) allows you to change quantities and find a way
to explore different scenarios to maximize your budget.
Administration's request is set in stone. Find a way to distribute the
four departments requests as equally as possible. Bear in mind that these
are cantankerous people; you will have to show them clearly that they
are getting a fair share of the budget.
Resources
Hints
- Some are convinced by numbers
- Some are convinced by graphs
- Can you provide both on your spreadsheet?
Product
- One completed spreadsheet from each group
- One "rough" spreadsheet from each group member showing parts of the
above assignment worked out. Does not need graphs or any formatting.
Does need data and formulas
return to midterm