Question
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
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