Acct. 2020

            The objective of this assignment was to prepare and demonstrate a clear understanding of the master budget and supportive budgets on Excel. A master budget is a comprehensive planning document for an entire organization or business. It includes supportive budgets in order to complete a company’s budgeted financial statements. This assignment walked me through the budgets one by one. The budgets completed for this assignment were the sales budget, cash collections budget, production budget, direct materials budget, cash payment for direct material purchases budget, cash payment for direct labor budget, cash payment for manufacturing overhead budget, cash payment for operating expenses budget, combined cash budget, budgeted manufacturing cost per unit, and budgeted income statement. After completing this assignment I got a clear understanding of how companies strive to stay on budget and how they compare results with previous month or periods.


ACCT 2020 Excel Budget Problem_Adam_Martinez