Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In todays business environment it is very important that you learn how to use Microsoft Excel to calculate and present accounting information to business partners,

In todays business environment it is very important that you learn how to use Microsoft Excel to calculate and present accounting information to business partners, investors, creditors, other interested parties. The more you learn Microsoft Excel, the more marketable you are in todays job market.

To receive full credit of 50 points, you must build Excel spreadsheets from scratch. In other words, you must start from a blank Excel spreadsheet. You may not use the publishers models or any other spreadsheet, which you did not personally start from a blank worksheet. You need to prepare a manufacturing proposal with related calculations and budgets, on a multi-page, formulated, interconnected Excel worksheets / tabs, including:

  • Calculation of Unit Standard Cost of a New Product or a Service (your dream business idea!),
  • Cost-Volume-Profit Analysis (Break Even Points in Dollars and Units, Required Sales in Dollar and Units, Margin of Safety),
  • Preparation of a partial Master Budget for 4 quarters of 2023, that includes 1) Sales Budget, 2) Production Budget, and 3) Cash Budget.

You can make up costs and quantities for your proposed product or service, and the numbers need not be realistic market prices. However, for example, the 3 budgets, stated above, for your product or service need to be inter-related.

The Excel project needs to be submitted along with a Business Memo (in proper business writing format, using Microsoft Word, 50 Points), directed to the Board of Directors or potential capital investor. In your Business Memo you need to explain your calculations and justify the profitability of your proposed new product or service.

-Can it be something of Real Estate Please thank you!

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

Governmental Accounting Auditing And Financial Reporting

Authors: Michele Mark Levine, Todd Buikema

10th Edition

0891250107, 978-0891250104

More Books

Students also viewed these Accounting questions

Question

Be able to differentiate between arbitration and mediation

Answered: 1 week ago

Question

Understand how arbitrators are credentialed and selected

Answered: 1 week ago

Question

Appreciate the advantages of arbitration

Answered: 1 week ago