master budget

Budget

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

MOH - Fixed

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

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

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

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

DL

MOH

Cost per Unit

Income Statement

2019

Balance Sheet

Dec. 2019

Dec. 2018

Y/Y Change

Sales

Cash

2,000,000

Cogs

Accounts Rec

162,300

Gross Margin

RM Inventory

62,160

FG Inventory

67,839.14

S&A

Land

4,000,000

Bad Debt

Equipment

6,000,000

Operating Profit

Acc. Dep'n

- 2,240,000

Total Assets

10,052,299

Interest Exp

Net Income

Accounts Pay

25,200

Wages Pay

12,075

Bank Line of Credit

- 0

Total Liabilities

37,275

Common Shares

5,000,000

Retained Earnings

5,015,024

Total Equity

10,015,024

Total Liab & Equity

10,052,299

Check

Sheet2

Enable Macros above and click here to open the assignment. Enjoy!

Balancer

2019 Check

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Enable Macros above and click here

to open the assignment.

Enjoy!