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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!