Excel problem solving and basic skills
Rickross69
excel_-_basic_skills_data.xlsx1. Stock Watcher
| Stock Watcher |
2. Total Mischief
| Regional Sales Summary | |||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Totals | |
| Northeast | $ 119,700.00 | $ 125,100.00 | $ 133,400.00 | $ 139,500.00 | |
| South | $ 48,900.00 | $ 52,000.00 | $ 49,600.00 | $ 54,500.00 | |
| Midwest | $ 34,600.00 | $ 32,200.00 | $ 47,000.00 | $ 45,900.00 | |
| West | $ 56,200.00 | $ 49,000.00 | $ 52,000.00 | $ 51,300.00 | |
| Totals | |||||
3. Recycling Can
| 0.02 James T. Perry: Kelly Allison: Per can value is an approximation. Change it for revenue what-if analysis. | per can | |||||
| Recycling Can Contest | ||||||
| City | Population James T. Perry: Kelly Allison: Population figures obtained from the World Wide Web. | Jan | Feb | Mar | Total | Per Capita |
| Arvada | 15,855 | 10,505 | 24,556 | 12,567 | ||
| Centenntial | 28,951 | 24,567 | 21,777 | 26,719 | ||
| Lakewood | 142,547 | 102,376 | 105,876 | 121,987 | ||
| Highlands Ranch | 2,801,561 | 2,714,664 | 2,503,344 | 1,999,877 | ||
| Parker | 1,689,908 | 1,523,665 | 1,487,660 | 1,002,545 | ||
| Total | - 0 | |||||
| Minimum | ||||||
| Average | ||||||
| Maximum | ||||||
| Potential Revenue | $ - 0 | $ - 0 | $ - 0 |
4. MusicPlayerz Sales
| MusicPlayerz | |||||||
| Sales Forecast | |||||||
| Fruit | Cost | Price | Actual 2007 Sales | Projected 2008 Sales | Gross Sales | Profit | % of Sales |
| Creative Zen Nano | $ 59.00 | $ 69.99 | 121,000 | ||||
| Apple iPod Shuffle 512MB | 52.99 | 69.99 | 159,200 | ||||
| Sandisk e140 Series 1GB | 74.99 | 89.99 | 98,000 | ||||
| Sony Walkman Bean 512MB | 74.99 | 89.99 | 100,700 | ||||
| iRiver Jukebox w/Color Display 512MB | 82.99 | 99.99 | 97,067 | ||||
| Apple iPod nano 1GB | 131.99 | 149.99 | 197,000 | ||||
| Creative Labs Zen Micro 6GB | 177.99 | 189.99 | 101,970 | ||||
| Toshiba Silver 20GB | 181.99 | 199.99 | 92,000 | ||||
| Totals | |||||||
