MASTER BUDGET & CAPITAL CAPITAL BUDGETING TEMPLATE TEMPLATE Instructions: (1) (2) (3) ()
(!)
(")
Working with your group group select the name of your company and place It on all the schedules As a group decide on what product you will be producing for the year. year. (in order to employ all schedules you must manufacture a product.) You You may or may not wish to amend your beginning balance balance sheet in order to t t the scope of planned operations. Members of your group may take the remaining schedules and complete them indiidually. indiidually. !oweer it would be well to complete the "ales and #roduction "chedule "chedule rst as a group in order to hae a better idea of the scale needed for the remaining schedules. $nce that the other schedules are completed% make sure that they c ome together and represent a cohesie nancial plan for the year that would be receied with faor by the &ompany's oard of irectors. &ome prepared with your completed plan on a *ashdrie to make your presentation to your peers who will take a critical look at your oerall plan.
E#L$n E%ctronics S$%s Bu't (in units) or t* +u$rtr En'' M$rc* 31, 2-1.
/ast Year's "ales in 0nits 78pected Increase in "ales udgeted "ales in 0nits "elling #rice per 0nit =otal =otal "ales : of "ales &ollected in the #eriod of the "ale : of "ales &ollected in the #eriod After the "ale
Accounts ?eceiable eginning alance -anuary "ales ebruary "ales March "ales =otal =otal &ash &olletions
-anuary 122%222 , 9: 1;2%222 <;4.22 <4%652%222 6 9: 1 1:
Month ebruary ebruary March +uarter , 134%222 152%222 624%222 , 9: , 9: , 9: ; 2 4 %1 2 2 1 6 3 %2 2 2 4,5%122 < ; 4 .2 2 < ; 4 .2 2 <;4.22 <,,%6,,%322 <,2%544%222 <;2%>;>%322 iscount 0ncollectable
1: ;:
Sc*'u% o/ E0ct' C$s* Co%%ctions <,%>42%222 <,%>42%222 <3%51;%>22 <,%>11%422 <4%;53%622 <4%324%213 <1%963%991 < <, ,,%,45%964 <6%624%342 <6 <6%624%342 <4%52;%>22 <,2%9;2%413 <,2%149%1;1 <1>%1,>%>94
E#L$n E%ctronics Pro'uction Bu't (in c$ss) or t* +u$rtr En'' M$rc* 31, 2-1.
udgeted "ales in &ases Add esired 7nding Inentory of insihed @oods =otal =otal eeds /ess eginning Inentory of inished @oods ?eBuired #roduction
Month -anuary ebruary 1 ; 2 %2 2 2 ;24%122 ; 2 %4 1 2 16%322 132%412 ;;9%422 1 ; %2 22 ;2%412 1 ; 6 %4 1 2 ;25%>42
March +uarter , 163%222 4,5%122 15%,92 15%,92 ;22%,92 4;4%;92 16%322 1;%222 161%992 4,9%;92
E#L$n E%ctronics Dirct M$tri$%s Bu't (in c$ss) or t* +u$rtr En'' M$rc* 31, 2-1.
?eBuired #roduction in &ases (#rod. udget) ?aw materials eeded per &ase #roduction eeded Add esired 7nding Inentory of ?aw Materials (,) =otal eeds /ess eginning Inentory of ?aw Materials ?aw Materials to be #urchased &ost of ?aw Materials &ost of ?aw materials to be #urchased
Month -anuary ebruary ebruary March +uar @iCmo lobs @iCmo lobs @iCmo lobs @iCmo 1 ;6 % 412 1 ; 6 %4 1 2 ; 2 5 %> 4 2 ;2 5 % >4 2 1 61% 992 1 6 1 %9 9 2 4 ,9 % ;9 2 , ; , ; , ; , 1 ; 6 % 4 12 6 , ; %5 3 2 ; 2 5 %> 4 2 > , 5 %> 5 2 1 61 % 99 2 4 , 6 %3 9 2 4 , 9 %; 9 2 > , %5 > 5 1 6 5 %5 4 1 4 ,%6 3 9 1 5 9 %1 > 9 6; % , 52 1 , > %5 1 2 6 ; %, 5 2 ;1>%;,5 >46%>51 ;43%659 ,%,32%1;9 ;59%3>2 ,%2;6%262 444%5>2 6 , %; 5 3 1 , 5 %2 ; 4 > , %5 > 5 1 6 5 %5 4 1 4, % 63 9 1 5 9 %1 > 9 6 , %; 5 3 1 9 6 % >3 4 6 6 ; %> 2 5 1 > 9 %1 9 , 4 4 9 %6 9 ; 1 3; % >19 6 > , %6 6 9 4 , 6 %, 5 5 < 6 .2 2 < 1 .9 2 < 6 .2 2 < 1 . 92 < 6 .2 2 < 1.92 < 6 .2 2 < , % 4 2 9 % 6 6 3 < , % > ; 5 % 6 3 2 < 1 %2 3 3 %6 9 6 < 1 % 1 , 5 % ; 4 ; < , % 4 5 6 %5 6 9 < , %> 6 > %5 ; 4 < 9 % 6 1 2 % 2 2 4
=otal #er Month Month
<;%652%9;3
: of #urchases #aid for in the #eriod of the #urchase : of #urchases #aid for in the #eriod After the #urchase
Accounts #ayable eginning alance -anuary "ales "ales ebruary "ales March "ales =otal &ash &olletions &olletions
riect Materials &ost per 0nit
<5%14,%,52
<;%413%>,;
<,,%4
62 : ;2 :
Sc*'u% o/ E0ct' C$s* Disursnts /or R$4 M$tri$%s < , % 3 5 2 %2 2 2 <1%3,4%;69.12 <,%,11%,32.42 < 1 %> > 3 % 6 > 6 . 3 9 <5%194%;69
<
, 5 .9 2
<5%,,4%>94
< , % 1 4 5 % ; 5 , .4 9 < 1 % 3 6 4 %4 ; 4 .6 9 <;%>3;%,4,
< , %3 5 2 % 2 2 2 <;%652%9;3 < 5%1 4 ,% , 5 2 < 1 %3 6 4 % 4 ; > <,1%;52%9,5
E#L$n E%ctronics Dirct L$or Bu't (in c$ss) or t* +u$rtr En'' M$rc* 31, 2-1.
?eBuired #roduction in &ases (#roduction udget) irect /abor !ours per &ase =otal =otal irect /abor /abor !ours eeded irect /abor &ost #er !our =otal =otal irect /abor /abor &ost (,) irect /abor 0nit &ost
-anuary 1;6%412 2.42 ,>2%193 <,4.22 <;%515%324
Month ebruary ebruary March +uarter , ;25%>42 161%992 4,9%;92 2.42 2.42 2.42 15;%>45 1,4%252 391%142 <,4.22 <,4.22 <,4.22 <5%;>,%6,1 <;%>15%612 <,,%65,%252 <,5.52
E#L$n E%ctronics M$nu/$cturin 56r*$' Bu't or t* +u$rtr En'' M$rc* 31, 2-1.
0nits to be #roduced Dariable &osts E Indirect Materials Darialble E Indirect /abor $ther Deriable &osts =otal =otal Monthly Derialbe Derialbe &osts i8ed &osts E "alaries i8ed &osts E ?ent i8ed &ost E epreciation =otal =otal Monthly i8ed i8ed &osts =otal =otal manufacturing manufacturing $erhead $erhead /essG epreciation &ash &ash isb isbur urse seme ment nts s for for Manu Manufa fact ctur urin ing g $er $erhe head ad =otal =otal manufacturing manufacturing $erhead $erhead (a) udgeted irect /abor !ours (b) #redetermined $erhead ?ate for the Year H (a)(b)
-anuary 1;6%412 < 2.;4 < ,.12 < ,.,1 < 351%,,5 < 1,1%222 < ,3%222 < 16%222 < 199%222 < 4>6%,,5 < 16%222 < 462% 462%,, ,,5 5
Month ebruary ebruary ;25%>42 < 2.;4 < ,.12 < ,.,1 < 41;%553 < 1,1%222 < ,3%222 < 16%222 < 199%222 < ,%264%553 < 16%222 < ,%29 ,%29,% ,%55 553 3
<
< < <
March 161%992 FFF FFF FFF 6;9%449 FFF FFF FFF 199%222 >>2%449 FFF >3;% >3;%44 449 9
+uarter , 4,9%;92 < 2.;4 < ,.12 < ,.,1 < 1%12,%559 < 3;3%222 < 54%222 < 4,%222 < 639%222 < 1%>33%559 < 4,%222 < 1%44 1%449% 9%55 559 9 < 1%>33%559 < 4,9%;92 < ;.35
E#L$n E%ctronics En'in inis*' Goo's In6ntor7 Bu't ($sortion costin $sis) or t* +u$rtr En'' M$rc* 31, 2-1. I t
Binnin In6ntor7
Pro'uction Cost r C$s irect Materials @iCmos lobs =otal =otal irect Materials irect /abor Manufacturing $erhead 0nit #roduct &ost Bu't' inis*' Goo's In6ntor7: 0nits in 7nding Inentory
En'in In6ntor7
Tot
%$+u$ntit7 Cost8Unit <2.22 , < ; <
6.22 1.92 <,5.92 <,5.52 <;.35 <;1.95
15%,92
15%,92 <;1.95 <649%6>4.36
E#L$n E%ctronics S%%in & A'inistr$ti6 E0ns Bu't or t* +u$rtr En'' M$rc* 31, 2-1.
udgeted "ales in 0nits ("ales udget) Dariable 78pense per 0nit E "ales &ommission =otal =otal "ales &ommission 78pense ad ebt 78pense (;: of "ales) Dariable "elling J Administratie 78pense i8ed i8ed "elling J Administratie 78pensesG "alaries ?ent Adertising $ther epreciation =otal =otal i8ed i8ed "elling J Administratie Administratie 78penses =otal =otal "elling J Administratie Administratie 78penses /essG e epreciation 78pense and ad ebt 78pense &ash isbursements for "elling J Administratie 78penses
-anuary 1;2%222 <,.92 <;59%222 <131%122 <326%122
Month ebruary ;24%122 <,.92 <531%;22 <;9,%;54 <4,;%354
March 163%222 <,.92 <5,5%222 <;,5%352 <614%352
+uarter , 4,5%122 <,.92 <,%11,%;22 <>14%,44 <1%,5>%544
<,9%222 <,6%222 <41%222 <3%622 <,4%922 <,;>%122 <653%522 <142%622 <539%622
<,9%222 <,6%222 <41%222 <3%622 <,4%922 <,;>%122 <>91%454 <;3>%454 <94;%222
<,9%222 <,6%222 <41%222 <3%622 <,4%922 <,;>%122 <436%452 <;;;%,52 <9;5%622
<59%222 <9,%222 <153%222 <12%,22 <99%922 <5,6%322 <1%936%244 <>4;%344 <,%94;%522
E#L$n E%ctronics C$it$% E0n'iturs Bu't or t* +u$rtr En'' M$rc* 31, 2-1.
-anuary #urchase of "elling J Administratie 7Buipment #urchase of #roduction 7Buipment Dariable "elling J Administratie 78pense
et #lant J 7Buipment as of ,1;,12,3 /essG epreciation E Manufacturing $erhead udget /essG epreciation E "elling J Administration udget et #lant J 7Buipment ook Dalue pm eginning alances AddG ew 7Buipment #urchases urring +uarter et #lant J 7Buipment as of ,1;,12,6
<2
Month ebruary
March , 4 2 %2 2 2 ; %, 2 2 %2 2 2 < ; % 1 4 2 %2 2 2
<2
< 6 %4 2 2 %2 2 2 < 4, % 22 2 < 99 % 92 2 <
6 % 3 3 ; %9 2 2 < ; % 1 4 2 %2 2 2 < , 2 %> 5 ; %9 2 2
+uarter , , 4 2 %2 2 2 ; %, 2 2 %2 2 2 < ; %1 4 2 %2 2 2
E#L$n E%ctronics C$s* Bu't or t* +u$rtr En'' M$rc* 31, 2-1.
"chedule &ash alance% eginning Add ?eceiptsG &ollections from &ustomers =otal =otal &ash Aaialable /ess isbursementsG irect irect Materials Materials irect /abor Manufacturing $erhead "elling J Administratie 7Buipment #urchases =otal =otal isbursements 78cess (eciency) of &ash Aailable oer isbursements inancingG orrowings (at the eginnings of +uarters) ?epayments (at the 7nd of the Year) Interest =otal =otal inancing inancing Kept &ash alance% 7nding
"ales
ir. ir. Mat. ir. /ab. Mfg. $h. "JA
9$nu$r7 < 92%222 < <
Mont* ru$r7 ru$r7 < 92%222
4%52;%>22 < 4%59;%>22 <
<
,2%9;2%413 < ,2%942%413 <
< 5%194%;69 5%194%;69 < < ;%515%324 < < 462%,,5 < < 539%622 < < <
5%,,4%>94 5%,,4%>94 < 5%;>,%6,1 < ,%29,%553 < 94;%222 < < >%2,4%6>6 < ,2%,59%,,3 < (935%4>6) < 5;9%62> <
<
3, 3 ,,%166
< < <
< ;%312 < 3,5%4>6 < 92%222 <
< (;>9%9,5) >%429 < (;49%62>) < 92%222 <
M$rc* 9 2 %2 2 2
<
+u$rtr 1 9 2 %2 2 2
,2%149%1;1 < ,2%;;9%1;1 <
1>%1,>%>94 1>%13>%>94
;%>3;%,4, ;%>3;%,4, ; %> 1 5 % 6 1 2 >3;%449 9;5%622 ; %1 4 2 % 2 2 2 ,1%333%543 (1%;;,%19;)
< < < < < < <
,1%;52%9,5 ,1%;52%9,5 ,,%65,%252 1%449%559 ,%94;%522 ;%142%222 ;,%4;2%;>> (1%932%55,)
1% 1 % ; 6 9 %1 2 6 < E < 3 %2 5 3 < 1%;4,%19; < 9 2 %2 2 2 <
1% 1 %>43%545 (;>9%9,5) , > %5 6 , 1%3,2%55, 9 2 %2 2 2
E#L$n E%ctronics Bu't' Inco St$tnt Bu't or t* +u$rtr En'' M$rc* 31, 2-1.
"ales &ost of @oods "old @ross Margin "elling J Administratie 78penses et $perating Income Interest 78pense et Income
Sc*'u%s "ales "ales% 7@I "JA &ash
<;2%>;>%322 <13%5>1%35, <5%553%>9> <1%936%244 <,%46>%46, (<,>%56,) <,%432%522
Bu't' B$%$nc S*t 31#M$r#1. Assets Current Assets: &a &ash Accounts ?eceiable ?aw Materials Inentory inished @oods Inentory =otal =otal &urrent Assets Assets et #lant and 7Buipment =otal =otal Assets
< 9 2 %2 2 2 <1%;26%;32 <,%232%9;2 < 6 4 9 %6 > > <5%12;%34> <,2%>5;%922 <,9%,56%,4>
Liabilities and Stockholders Equity &urrent /iabilities Accounts #ayable (?aw Materials) /ine of &redit =otal =otal &urrent /iabilities "tockholders' 7Buity &ommon "tock ?etained 7arnings et Income =otal =otal "tockholder's 7Buity =otal =otal /iabilities and "tockholders 7Buity
<,%,54%265 <1%>>,%>,1 <5%,;>%>43 <,%122%222 <6%>53%42; <,%432%522 <,,%226%12; <,9%,56%,4>
Co Cor r* *ns nsi6 i6 Pro Pro% % E6$% E6$%u$ u$ti tio o =eam =eam Member ame
Inoled
&ontribution
#lease ealuate your performance and the perfomance of the other members on a scale of , to ,2 for each of the aboe categories
=hese to be submitted submitted to Instructor Instructor separately separately by each team member
or =otal =otal &ontribution &ontribution
of your team