Chapter 10 formulas Flashcards
what is the sales budget formula
multiply expected sales volume in units for each product by its anticipated selling price per unit
Ex. for sales budget
3,000 units in the first quarter with 500 unit increments in each quarter after that. show by quarter. Selling price is $60 per unit.
Company Name
Sales budget
for the year ending December 31, 2012
Quarter
1 2 3 4
Expected unit sales 3,000 3,500 4,000 15,000
Unit selling price x$60 x$60 x$60 x$60
Total Sales $180,000 $210,000 $240,000
What is the formula for the production budget
Budgeted Sales units + Desired Ending FG Units - Beg FG Units = Required production units
What is the formula for DM budget
(Units to produce x raw materials per unit) + desired ending inventory - beginning inventory = raw materials to purchase
What is the formula for DL budget
Units to produce x direct labour time per unit x DL cost per hour = total direct labour cost
what is the formula for Man OH budget
(DL hours x Variable OH rate) + FMOH - depreciation = cash disbursements for overhead
What is the formula for ending FG inventory budget
(DM cost per unit + DL cost per unit + MOH per unit) x ending FG inventory in units = ending FG inventory
What is the formula for selling and admin expense budget
(unit sales x V Sell & Adm per unit) + F Sell & Adm exp. = total selling and admin expenses