Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help! In today's business environment it is very important that you learn how to use Microsoft Excel to calculate and present accounting information.

i need help!
image text in transcribed
In today's business environment it is very important that you learn how to use Microsoft Excel to calculate and present accounting information. The more you learn Microsoft Excel, the more marketable you are in today's job market. In order to receive full credit, you must build Excel spreadsheets from scratch. In other words, you must start from a blank. Excel spreadsheet. You may not use the publisher's models or any other Spreadsheet, which you did not personally start from a blank worksheet. You will 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 ideay). - 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 different budgets for your product or service need to be inter-related. The Excel project needs to be sulmitted along with a Business Memo (in proper business writing format, using Microsoft Word), directed to the Board of Directors. In your Business Memo you need to explain your calculations and justify the profitability of your proposed new product or service. Sample files are posted on Camvas under 'Announcements' heading for reference. Both the Excel spreadsheet file and Word document file are due 9:00 PM, on Tuesday, May 16, 2023; via Canvas submission. Partial credit will be awarded for Excel Project and Business Memo assignment but no late submission is allowed

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

Beyond Agile Auditing Three Core Components To Revolutionize Your Internal Audit Practices

Authors: Clarissa Lucas

1st Edition

1950508676, 978-1950508679

More Books

Students also viewed these Accounting questions