Manufacturing Budget

A guided, step-by-step Excel assignment in which students build a manufacturing budget using real-world cost data.

This assignment covers approximately 25% of the material tested on the Microsoft Office Specialist Excel Certification exam.

This Manufacturing Budget assignment is a step-by-step Excel exercise designed for Introduction to Managerial (Principles II) accounting courses. It functions as a guided, hands-on activity in which students work through 40 PowerPoint slides with individually numbered steps, each corresponding to a specific task used to build, analyze, and present a comprehensive manufacturing budget. The assignment emphasizes Excel tools commonly used in managerial accounting and budgeting, including worksheet organization, formulas and functions, interdependent schedule linking, and professional presentation features.

Workbook Setup and Data Preparation
- Saving and organizing Excel workbooks
- Using Page Break Preview and Zoom for worksheet review
- Converting data ranges to Excel Tables and removing table styles
- Managing print areas and adding draft watermarks
- Naming cells for use in formulas

Text and Data-Cleaning Functions
- FIND
- LEFT
- RIGHT
- MID
- LEN
- TRIM
- SUBSTITUTE
- UPPER
- LOWER
- CONCAT

Core Budgeting and Accounting Calculations
- Sales budget preparation
- Budgeted cash collections percentages
- Accounts receivable calculations
- Production budget development
- Direct materials, direct labor, and manufacturing overhead budgets
- Cost of Goods Manufactured (COGM)
- Finished goods inventory budget
- Cost of Goods Sold (COGS)
- Selling and administrative expense budgets
- Cash budget calculations
- Pro forma income statement and balance sheet preparation

Mathematical, Financial, and Logical Functions
- SUM
- SUMIF
- IF
- SLN (straight-line depreciation)
- Basic arithmetic operators (+, −, ×, ÷)
- Relative, absolute, and mixed cell references
- Order of operations in financial statements

Lookup and Reference Tools
- VLOOKUP
- Linking data across worksheets using named cells and references

Formatting, Organization, and Presentation
- Applying cell styles
- Adjusting and AutoFitting column widths
- Grouping rows and sections for readability
- Creating hyperlinks for navigation
- Preparing worksheets for professional presentation and printing

Step 1: Record your 4-digit Spreadsheet ID

The Spreadsheet ID is used throughout the assignment to help ensure each student submits unique work.

Students: Your Spreadsheet ID appears on your dashboard.
Faculty/Teaching Assistants: You may use any 4-digit number as your Spreadsheet ID.

Step 2: Download the assignment files

If you already downloaded the exercise files from your dashboard, you may skip this step.

↓ Download the Excel Template (.xltx) ↓ Download the Watermark Image (draft.jpg)

If the image opens in your browser, right-click and choose Save Image As…

Step 3: Complete the assignment alongside the instructional video

Choose the tutorial that matches your Excel environment:

Watch the 1 hour, 59 minute step-by-step tutorial
If the video doesn’t play, you can watch the MP4 backup version

Watch the 2 hours, 20 minute step-by-step tutorial
If the video doesn’t play, you can watch the MP4 backup version

View background on why this assignment requires Excel for Windows or Mac.

Step 4: Submit your completed spreadsheet via your dashboard

return to your dashboard

Keep these tips in mind to ensure clean submission of your work:

Double-check that your workbook is not an .XLTX workbook.
Close Excel completely before attempting to upload your work.
Make use of the alternate submission methods if needed.

How This Assignment Is Graded

An automated tool is used to grade your work based on completion and accuracy, including partial points for incorrect steps. Your instructor determines how scores are applied toward course credit.

Need help?

FAQs

Click here to access of list of frequently asked questions about this assignment.

Learn More

Support

Support is email-based. In rare instances Zoom meetings are available when issues cannot be resolved otherwise.

Get Support

Manufacturing Budget Assignment