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.

Assignment Question

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 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 different budgets 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), 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.