Question
In this final project, you will create the worksheets described for The City Cafe. You are required to submit only one workbook. Your workbook will
In this final project, you will create the worksheets described for The City Cafe. You are required to submit only one workbook. Your workbook will be comprised of several worksheets. Please refer to the detailed explanation of the City Cafe's business plan and scenarios for each worksheet. If you have trouble starting, refer to the practice instructions to help guide your development. The rubric will be used to grade your submission and will be returned as feedback.
- Comprehensive Final Exam Project Details
The Comprehensive Final Exam Practice Instructions are generic and are not specific to the personalizations you describe in the Planning worksheet. It should be accounted for in the data when you describe it there. You should have at least 20 records or 12 when dealing with monthly information per table when providing data information for the sheets. Here is some sample data to consider:
Date | Category | Item | Units Sold | Unit Price ($) | Total Sales ($) |
---|---|---|---|---|---|
10/1/2023 | Breakfast | Coffee | 50 | 3 | 150 |
10/1/2023 | Breakfast | Tea | 20 | 2.5 | 50 |
10/1/2023 | Breakfast | Bagels | 30 | 2 | 60 |
10/1/2023 | Lunch | Sandwiches | 40 | 6 | 240 |
10/1/2023 | Lunch | Salads | 25 | 7 | 175 |
10/2/2023 | Breakfast | Coffee | 45 | 3 | 135 |
10/2/2023 | Breakfast | Tea | 18 | 2.5 | 45 |
10/2/2023 | Breakfast | Croissants | 25 | 2.5 | 62.5 |
10/2/2023 | Lunch | Soups | 30 | 5 | 150 |
10/2/2023 | Lunch | Burgers | 35 | 8 | 280 |
... | ... | ... | ... | ... | ... |
10/31/2023 | Breakfast | Pancakes | 35 | 5 | 175 |
10/31/2023 | Breakfast | Smoothies | 20 | 4.5 | 90 |
10/31/2023 | Lunch | Burgers | 45 | 8 | 360 |
10/31/2023 | Lunch | Pasta | 30 | 9 | 270 |
10/31/2023 | Lunch | Desserts | 25 | 4 | 100 |
The worksheet will be:
- 1st worksheet - Documentation
- 2nd worksheet - Planning
- 3rd worksheet - Required Funds
- 4th worksheet - Income Worksheet
- 5th worksheet - Expense Worksheet
- 6th worksheet - Loan Feasibility
- 7th worksheet - Investor Graphs
- 8th worksheet - Loan Amortization Worksheet
- 9th worksheet - Sales Summary Report
- 10th worksheet - Individual Sales Records for St. Louis, MO
- 11th worksheet - Individual Sales Records for a Franchised Location
- 12th worksheet - Individual Sales Records for a Franchised Location
Help this to do in excel sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started