excel assignment, due 10 hours later
Sheet1
| Summer Budget and Paper Inventory | ||||||
| June Budget | $1,800.00 | Paper Supply Inventory Orders | ||||
| July Budget | $2,200.00 | Item | Quantity | Price Per Unit | Total Cost | |
| Total Budget | Plastic Silverware (box of 100) | 15 | $8.75 | $131.25 | ||
| Napkins (box of 250) | 18 | $2.59 | ||||
| Paper Plates (box of 50) | 9 | $14.25 | ||||
| Budget Total | $4,000.00 | Cups (box of 75) | 12 | $11.99 | ||
| Inventory Cost | $450.00 | Total | ||||
| Total Remaining | $8.89 |
Sheet2
| Genre | 2008 | 2009 | 2010 | 2011 | 2012 |
| Classics | $18,580 | $49,225 | $16,326 | $10,017 | $26,134 |
| Mystery | $78,970 | $82,262 | $48,640 | $49,985 | $73,428 |
| Romance | $24,236 | $131,390 | $79,022 | $71,009 | $81,474 |
| Sci-Fi & Fantasy | $16,730 | $19,730 | $12,109 | $11,355 | $17,686 |
| Young Adult | $35,358 | $42,685 | $20,893 | $16,065 | $21,388 |