Master Budget Formulas
Uploaded by
ScribdTranslationsMaster Budget Formulas
Uploaded by
ScribdTranslationsMASTER BUDGET
1) Sales Budget (3)
Units
Unit sale value
Total
2) Production Budget
( 5)
Sales in units
IF desired PT
Total needs
II PT
Total to produce
3) Direct Materials Budget
Consumption budget of MD
U308A (5)
Production in units
Number of MD units per product
MD to be used
Unit Cost
Used MD cost
MD purchasing budget
U308A (7)
MD to be used
IF desired MD
Total need
II MD
MD to be bought
Unit Cost
Cost of purchased MD
4) MOD Budget (5)
Production in units
HMOD per unit
Required HMOD
Unit Cost
Costo MOD
CIF Budget
Indirect materials var.
Fixed indirect materials
Indirect labor cost
Direct labor cost
Insurance for property, machinery, and equipment.
Depreciations
Office materials and supplies
Electricity
Water
Phone
Internet
Other fixed CIF
Total
Monthly indirect personnel cost
Production Manager (100%)
Employees and supervisors (2)
Monthly cost
Indirect costs of workers
live
Total cost per worker/month
Number of workers
Total cost of workers
Cost to MOD
CIF cost
6) Budget of Expenses
Administrative
Personal cost
Depreciations
Third party services
Office materials and supplies
Electricity
Water
Phone
Internet
Other fixed expenses
Total
Personnel cost
General Manager
Manager of Administration and Finance
Administration Employees (2)
Monthly cost
7) Expense Budget of
Sales
Fixed personnel cost
Variable personal cost
Depreciations
Advertising in media
Office materials and supplies
Advertising materials
Mobility
Vehicle gasoline
Electricity
Water
Phone
Internet
Miscellaneous expenses
Total
Fixed personnel cost
Sales Manager
Sales Employees (2)
Fixed monthly sellers (3)
Monthly cost
Variable personal cost
Sales commissions
8) Inventory Budget
End of Products
Finished
Unit Cost
MD U308A
MD J107B
MOD
CIF January
CIF February
CIF March
Total unit cost
IF PT Cost
Units
Unit cost
Total
Production Cost Budget
and Sales
MD U308A
MD J107B
MOD
CIF
Production cost allocated.
II PT
PT available for sale
IF PT
Cost of sales accounted.
Cash Flow Budget
Initial Balance
More: cash income
Total cash available
Less: cash outflows
Direct materials
Direct labor
CIF
Administrative
Sales
Payment of VAT
Dividend payment
Purchase of equipment
Total cash outflows
Excess (def) ing vs egr
Financing:
Loan
Amortizations
Interests
Total financing
Final cash balance
Cash Income Budget
Collections in the month (60%)
Collections in the next month (40%)
Total revenue
Budget for Accounts Receivable
Uncollected sales in the month
Cash Expenditure Budget for
MD
Payments in month (50%)
Payments in the next month (50%)
Total expenses
Budget of accounts payable
Unpaid purchases for the month
Cash Expenditure Budget for
CIF
Total budgeted CIF
Less: depreciation
Total effective expenditure
Cash Expenditure Budget for
GA
Total GA budgeted
Less: depreciation
Total effective expense
Cash Expenditure Budget for
GV
Total GV budgeted
Less: depreciation
Total effective expense
Budget of Income Statement
For the month ended on
Sales
Cost of Sales
Gross Profit
Administrative Expenses
Sales Expenses
Operating Utility
Income Tax
Net Utility
State of Situation Budget
Financial
As of 31 of
Box
Accounts receivable
MD Inventory
PT Inventory
Real estate, machinery, and equipment
Total de Activos
Taxes payable
Accounts payable
Social capital
Retained earnings
Total Liabilities and Equity
Final inventory of MD
MD U308A
Quantity
Unit cost
Sub Total
MD J107B
Quantity
Unit cost
Sub Total
Total
Real estate, machinery and equipment
Initial balance
More: Purchases
Less: depreciations
Production
Administration
Sales
Net balance
IGV
IGV to be paid initial month
More: Sales VAT
Less: VAT on purchases and expenses
Less payment of VAT
Final IGV to be paid
Taxes Payable - Tax Provision
to the Income
Initial provision balance
Taxes of the month
Final provision balance
Retained earnings
Initial balance
More: Utilities
Less: dividends
Final balance
