Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ACCA Financial Accounting Study Text 2022 23

Authors: Emile Woolf International

1st Edition

1848436831, 978-1848436831

More Books

Students also viewed these Accounting questions

Question

Organizing Your Speech Points

Answered: 1 week ago