Help for Budgeting for Managers BT 221 For this week you are only creating a template, it will not have any numbers. If you refer to the back of the chapter you will find examples of the full master budget. It will contain the sales budget, COGS budget, merchandise purchases budget or manufacturing budgets, cash budgets and eventually budgeted financial statements. Please set up an excel workbook. On the first tab you can create a data sheet that contains important inputs for the budget. Then create various tabs for the various budgets. Finally, create the column and row headings for each budget. We will go on to use this template the following three week and then for the final project. This is the point where we are leaving the "open" and "creative" thinking about budgets and moving back into the world of structure.