Formulas 2

Question 1

sales budget

Answer 1

expected sales x exp SP

Question 2

Production budget

Answer 2

exp unit sales 
add desired ending fg units
total required sales 
less beg fg units
required production units

Question 3

DM Budget

Answer 3

Units to be produced
dm per unit
total amount needed for  production
add: desired ending dm
total materials required
less beg dm
direct material purchases
cost per unit
total cost of material purchases

Question 4

DL budget

Answer 4

Units to be produced
DL (hours per unit) 
total required DL hours
DL cost per hour
Total DL cost

Question 5

MOH Budget

Answer 5

Variable costs
- list
total variable costs
fixed csots
total fixed costs
total manu oh 
DL hours
man overhead rate/ dl hours

Question 6

Selling and admin budget

Answer 6

expected sales in units
variable expenses
sales commission ($x/unit)
freight out ($x/unit) 
total variable expenses
fixed expenses
advertising 
sales 
office salaries
depreciation 
property taxes and insurance
total fixed expenses
total selling and admin expenses

Question 7

Cash budget

Answer 7

Opening Cash balance 
add: cash receipts
collection from customers
sales of marketable securtites
total receipts
total cash available 
less: disbursements
DM
DL
MOH
Selling and admin
total disbursements
excess (deficiency) of avaialbe cash
financing 
borrowing 
repayment 
interest
total financing 
ending cash balance