master budget

profileHarith Al Azzawi
MasterBudgetTemplate.xlsx
Home>Business & Finance homework help>Accounting homework help>master budget

Sheet1

Metal Parts Inc. Master Budget Student Name:
Stundet Number:
Data Input Area
Selling Price per Unit
DLH per Unit
% of next months sales for FG Inventory
Pounds of Metal per Unit
Cost of one pound of Metal
Cost per DLR
Variable MOH per unit
MOH - Fixed per month
Variable S/A per unit
Fixed S/A per month
Minimum Cash Balance
Interest Rate on Line of Credit
Monthly Depreciation
Month of Next month Month After
Accounts Payable payment pattern
Wages payable payment pattern
Customer collections payment pattern
Sales
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total Jan Feb Mar
Sales (Units)
Selling Price per Unit
Sales
Production Budget
Sales (Units)
Desired Ending Inventory
Less: Beginning Inventory
Production Requirements
Schedule of Cash Collections Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
Month of Sale
Prior Month
Two Months prior
Total Collections
DM Requirements Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
Production Requirements (Units)
Pounds Required
Add desired Ending Inventory
Total Required
Less Beginning
DM to be purchased
Cash Payments budget for RM
DM to be purchased
Cost per pound
Total Cost of DM
Payments in month of purchase
Month after month of purchase
Total Payments on DM
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
DL Requirements
Production requirements (units)
DLH per unit
DLH required
Cash Payments budget for DL
DLH Required
Cost per DLH
Total Cost
Amount paid in month earned
Amount paid in next month
Total Cash disbursement for DL
MOH Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
DLH
Var MOH per DLH
Varialbe MOH
Fixed MOH
Total MOH Expense
Less: Depreciation
Cash expenditure of MOH
Sales and Administration Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
Sales (Units)
S/A per unit sold
Variable S/A
Fixed S/A
Total S/A
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2019 Total
Cash Budget
Beginning Balance
Collections
Total Available
Disbursements
DM
DL
MOH
S/A
Capital
Dividends
Total Disbursements
Balance before financing
Borrowing
Repayments
Loan Balance Total
Interest
Ending Balance
PDOH
Cost per Unit of production Quantity Price Total Units Cost per Unit Total
DM Finished Goods
DL COGS
MOH
Cost per Unit - 0
Income Statement 2019 Balance Sheet Dec. 2019 Dec. 2018 Y/Y Change
Sales - 0 Cash 2,000,000 - 2,000,000
Cogs - 0 Accounts Rec 162,300 - 162,300
Gross Margin - 0 RM Inventory 62,160 - 62,160
FG Inventory 67,839.14 - 67,839.14
S&A - 0 Land 4,000,000 - 4,000,000
Bad Debt - 0 Equipment 6,000,000 - 6,000,000
Operating Profit - 0 Acc. Dep'n - 2,240,000 2,240,000
Total Assets - 0 10,052,299 - 10,052,299
Interest Exp - 0 - 0
Net Income - 0 - 0
Accounts Pay 25,200 - 25,200
Wages Pay 12,075 - 12,075
Bank Line of Credit - 0 - 0
Total Liabilities - 0 37,275 - 37,275
- 0
Common Shares 5,000,000 - 5,000,000
Retained Earnings 5,015,024 - 5,015,024
Total Equity - 0 10,015,024 - 10,015,024
- 0
Total Liab & Equity - 0 10,052,299 - 10,052,299
Check

Sheet2

Balancer

2019 Check