Excel Project
Yesha Rao
SalesVA.xlsxLookup Table
| Menu Items | Price |
| Ancho Lime Swordfish | |
| Cajun Chicken | |
| Chicken Caliente | |
| Chicken Fajitas | |
| Chicken Wrap | |
| Crab Cakes | |
| Fried Catfish | |
| Grilled Shrimp | |
| Gumbo | |
| Mesquite Chicken | |
| Pasta with Chicken | |
| Prime Rib | |
| Ribeye | |
| Salad with Ahi Tuna | |
| Southwest Ribs |
ChickenSales
| Chicken Sales Analysis | |||||||||||
| Date: | 7/18/20 | ||||||||||
| Menu Item | Total Qty Projected | Total Qty Sold | Avg Monthly Qty Sold | Price | Total Revenue | % of Projection | Top Performer | Next On Sale | Sale Details | ||
| Chicken Wrap | Sale Threshold | 95% | |||||||||
| Cajun Chicken | Start Sale | 11/1/16 | |||||||||
| Chicken Caliente | End Sale | 12/20/16 | |||||||||
| Chicken Fajitas | Days on Sale | ||||||||||
| Mesquite Chicken | |||||||||||
| Pasta with Chicken | |||||||||||
| Actual Sales Quantities | |||||||||||
| Menu Item | Month 1 | Month 2 | Month 3 | Month 4 | Performance | ||||||
| Chicken Wrap | 230 | 326 | 391 | 331 | |||||||
| Cajun Chicken | 276 | 308 | 386 | 285 | |||||||
| Chicken Caliente | 207 | 156 | 165 | 124 | |||||||
| Chicken Fajitas | 552 | 529 | 667 | 556 | |||||||
| Mesquite Chicken | 391 | 377 | 455 | 386 | |||||||
| Pasta with Chicken | 460 | 423 | 395 | 441 | |||||||
| Projected Sales Quantities | |||||||||||
| Menu Item | Month 1 | Month 2 | Month 3 | Month 4 | |||||||
| Chicken Wrap | 400 | 322 | 345 | 322 | |||||||
| Cajun Chicken | 299 | 340 | 349 | 299 | |||||||
| Chicken Caliente | 216 | 138 | 188 | 96 | |||||||
| Chicken Fajitas | 464 | 524 | 653 | 584 | |||||||
| Mesquite Chicken | 358 | 363 | 409 | 400 | |||||||
| Pasta with Chicken | 469 | 418 | 460 | 414 | |||||||
PoultryLoan
| Poultry Refrigeration Loan | ||||
| Loan Amount | $15,000 | |||
| Quarterly Payment Options | ||||
| Term in Years | ||||
| 1 | 2 | 3 | ||
| Annual Rate | 3.50% | |||
| 4.00% | ||||
| 4.50% |
