monthly cost analysis - 30062012 consolidated

Upload: arif-khan

Post on 13-Feb-2018

219 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    1/16

    INVENTORY REPORT FOR MONTH OF JUNE-2012

    DATE

    OTHER DEPARTMENT

    INDIAN CHINESE MOGHLAI KABAB CHI.BIRYAN

    6/1/2012 91.00 69!.00 2"#2!.00 0.00 116.00

    6/2/2012 $00.00 1"69#.00 $"9$0.00 1"1#.00 0.00

    6/$/2012 0.00 1"0#$.00 $"1!.00 #.00 0.00

    6//2012 0.00 1"$6.00 $"%$2.00 1"$00.00 #"160.00

    6/%/2012 $#0.00 %"1#6.00 "12.00 $0.00 0.00

    6/6/2012 0.00 900.00 %61.00 1%.00 0.00

    6/!/2012 2"$9!.00 !90.00 1"$!.00 990.00 6"2##.00

    6/#/2012 0.00 %9.00 2"61#.00 %"#9$.00 0.006/9/2012 110.00 %1.00 "$!1.00 2"120.00 $"100.00

    6/10/2012 $"600.00 1"#!9.00 %"69%.00 1.00 0.00

    6/11/2012 $9$.00 120.00 91.00 %#.00 0.00

    6/12/2012 2"600.00 2%0.00 $"!6.00 "661.00 !2.00

    6/1$/2012 1!.00 1"060.00 2"066.00 #"%$#.00 0.00

    6/1/2012 !9$.00 2"1$%.00 1$"$29.00 1"62.00 0.00

    6/1%/2012 0.00 200.00 1$"#$%.00 0.00 9%2.00

    6/16/2012 0.00 !%0.00 !"0$.00 2"011.00 1"0%2.00

    6/1!/2012 $"62.00 %0.00 "##!.00 2"960.00 0.00

    6/1#/2012 220.00 1"%20.00 2"!%0.00 "%$0.00 0.00

    6/19/2012 2"29$.00 1"$1$.00 %"6#.00 1"9!0.00 0.00

    6/20/2012 0.00 $"!10.00 "26%.00 1$0.00 6#.00

    6/21/2012 0.00 60.00 9%.00 2"690.00 0.00

    6/22/2012 "$90.00 920.00 2"!19.00 1"122.00 0.00

    6/2$/2012 1"690.00 991.00 11.00 "9#6.00 6#.00

    6/2/2012 1"20!.00 $"!90.00 "$1#.00 1"%.00 0.00

    6/2%/2012 !!0.00 !20.00 $"$%.00 $$0.00 $%2.00

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    2/16

    GRAND TOTAL 29,179.00 38,071.00 110,363.00 58,470.00 2

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    3/16

    RYANI DEPARTMENT

    TOTALMTN.BIRYANI REG.BIRYANI

    "6%%.!0 1"##$.00 11"%$2.!0

    1"1$.00 0.00 #"210.00

    $"$1$.#0 0.00 !"61#.#0

    2"$#1.0 #$.%0 1!"6%2.90

    !2.%0 0.00 10"!!2.%0

    2"#!.60 0.00 "!2$.60

    0.00 0.00 11"#$9.00

    0.00 1"00.00 10"60.00

    91.0 %#.%0 10"!01.90

    2"9#6.20 2"9#%.%0 1!"1%9.!0

    1"6$#.00 1"2!0.%0 "96.%0

    0.00 91.%0 12"2##.%0

    0.00 1"6#$.%0 1$"%21.%0

    %"$61.$0 0.00 2$"0#0.$0

    0.00 69.00 1%"%6.00

    0.00 220.%0 11"0!6.%0

    $"112.20 0.00 1%"12$.20

    1"#0#.10 !!!.00 11"60%.10

    0.00 $"%#!.%0 1"6$1.%0

    9%!.60 0.00 9"1$0.60

    1"#!!.0 21.00 %"1$.0

    1"21%.90 $60.%0 10"!2!.0

    #19.00 %0.00 9"#69.00

    1"0%2.10 0.00 11"#12.10

    %10.$0 0.00 6"11!.$0

    1"0$9.%0 2%2.00 %"1#6.%0

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    4/16

    42,814.30 23,257.00 330,138.30

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    5/16

    Daily Cost Report

    Parti!larsR"# $%&ia% 'a(a( C)i%ese *irya%i

    +ales %%#"0.00 %9"9%.00 $%2"9!1.00 2"#92"21.00

    2$#"9%2.00 261"00.60 1#1"9#6.00 1"12"29.00

    M&'()*&+, - O(* 0.00 1%"62#.00 0 20"12.00

    $D"T 238,952.00 308,942.00 181,986.00 1,441,316.00

    M&'()*&+ R((*( 0.00 0.00 0.00

    M&'()*&+ I,,3( 0.00 2"22.00 0.0 $#"%#6.00

    M&'()*&+ C+4,* 0.00 21"$1.0 0.00 10"%60.00

    CO+T O# #OOD 43- 57- 52- 49-#!el Ratio

    T4'&+ F3(+ 5 $!1"!#.00 $!1"!#.00 $!1"!#.00 $!1"!#.00

    T4'&+ S&+(, %"22$"1#$.00 %"22$"1#$.00 %"22$"1#$.00 %"22$"1#$.00

    #!le Ratio 11- 9- 7- 55-

    #!el Ao!%t $9"!6.9! $2"!06.66 2%"12.$$ 20%"#6#.%2

    #!el Cost 7- 7- 7- 7-

    /e%eral Cost +ta +toreParel 12"%6#.00 1%"%!1.00 1%"%!1.00 1%"%!1.00 1%"%!1.00

    C)are& "!aly $ 2 1

    Pro&!t Cost 53- 66- 63- 56-

    ote O%ly t)e C)i%ese Costi% is otio%al (ea!se t)ere is %o Ope%i% a%& Closi% *ala%e

    Daily Cost Report

    Parti!larsR"# $%&ia% 'a(a( C)i%ese *irya%i

    +ales %0$"1#2.00 !"11$.00 $1#"1%9.00 2"6%%"0%!.00

    21#"2$!.00 20"0#.0 1!$"920.00 1"2%%"1$1.00

    Cost o aterials ett Co%s!ptio% :

    Cost o aterials ett Co%s!ptio% :

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    6/16

    M&'()*&+, - O(* 0.00 21"$1.0 0 11"#.00

    $D"T 218,237.00 275,823.00 173,920.00 1,320,603.00

    M&'()*&+ R((*( 0.00 0.00 0.00

    M&'()*&+ I,,3( 0.00 6"%%#.00 0.0 62"#20.00

    M&'()*&+ C+4,* 0.00 6"%%#.00 0.00 1"96.00

    CO+T O# #OOD 43- 43- 55- 47-#!el Ratio

    T4'&+ F3(+ 5 6#"#2!.00 6#"#2!.00 6#"#2!.00 6#"#2!.00

    T4'&+ S&+(, "#92"9.00 "#92"9.00 "#92"9.00 "#92"9.00

    #!le Ratio 10- 10- 7- 54-

    #!el Ao!%t #"21!.#0 %"$2.2 $0"#!.#$ 2%"22.##

    #!el Cost 10- 10- 10- 10-

    /e%eral Cost +ta +toreParel 106"0#0.00 1$"260.00 1$"260.00 1$"260.00 1$"260.00

    C)are& "!aly $ 2 0

    Pro&!t Cost 56- 55- 68- 57-

    o%t)ly Cost Report ; At!Parti!lars

    R"# $%&ia% 'a(a( C)i%ese *irya%i

    +ales 1"061"%#6.00 9$$"60#.00 6!1"1$0.00 %"%!"29#.00

    %!"1#9.00 6%"0%$.00 $%%"906.00 2"666"11.00

    M&'()*&+, - O(* 0.00 1%"62#.00 0 20"12.00

    $D"T 457,189.00 584,765.00 355,906.00 2,761,919.00

    M&'()*&+ R((*( 0.00 0.00 0.00

    M&'()*&+ I,,3( 0.00 ##"!#2.00 0.0 101"06.00M&'()*&+ C+4,* 0.00 6"%%#.00 0.00 1"96.00

    CO+T O# #OOD 43- 50- 53- 48-

    Cost o aterials ett Co%s!ptio% :

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    7/16

    #!el Ratio

    T4'&+ F3(+ 5 #0"611.00 #0"611.00 #0"611.00 #0"611.00

    T4'&+ S&+(, 10"11%"6!!.00 10"11%"6!!.00 10"11%"6!!.00 10"11%"6!!.00

    #!le Ratio 10- 9- 7- 55-

    #!el Ao!%t ##"21!.61 !!"%#2.66 %%"!!0.!9 60"9!9.%0

    #!el Cost 8- 8- 8- 8-

    /e%eral Cost +ta +toreParel 2$0"6#.00 2#"#$1.00 2#"#$1.00 2#"#$1.00 2#"#$1.00

    C)are& "!aly $ 2 1

    Pro&!t Cost 54- 60- 66- 57-

    OT

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    8/16

    M&'()*&+ R((*( 0.00 0.00 0.00

    M&'()*&+ I,,3( 0.00 ##"!#2.00 0.0 101"06.00

    M&'()*&+ C+4,* 0.00 6"%%#.00 0.00 1"96.00

    CO+T O# #OOD 41- 29- 49- 45-

    #!el RatioT4'&+ F3(+ 5 6#"#2!.0$ 6#"#2!.0$ 6#"#2!.0$ 6#"#2!.0$

    T4'&+ S&+(, %"222"6$2.$0 %"222"6$2.$0 %"222"6$2.$0 %"222"6$2.$0

    #!le Ratio 10- 10- 7- 53-

    #!el Ao!%t !"!#9.16 !"#09.09 $1"9!#.1# 26"!#$.2

    #!el Cost 9- 9- 9- 9-

    /e%eral Cost +ta +toreParel 106"0#0.00 1$"260.00 1$"260.00 1$"260.00 1$"260.00

    C)are& "!aly 2 2 0

    Pro&!t Cost 52- 40- 62- 54-

    OT

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    9/16

    15.06.2012Roti Desert O

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    10/16

    79,640.00 287,845.00 0.00 37,502.00 137,478.00 44,474.00 59,537.00

    29- 43- D$B0 27- 77- 46- 3- 8-

    6#"#2!.00 6#"#2!.00 0.00 0.00 0.00

    "#92"9.00 "#92"9.00 0.00 0.00 0.00

    6- 14- 0- 0 0 100-

    26"%62.#1 6$"!0$. 0.00 6#"#2!.00

    10- 10- 0-

    1$"260.00 1$"260.00 0.00 1$"260.00 1$"260.00 106"0#0.00% 2 0 9 !

    2"96#"!0#.0

    43- 55- D$B0 36- 84- 57-

    l Cost 01.06.2012 to 30.06.2012Roti Desert O

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    11/16

    #0"611.00 #0"611.00 0.00 0.00 0.00

    10"11%"6!!.00 10"11%"6!!.00 0.00 0.00 0.00

    6- 13- 0- 0 0 100-

    !"9.92 110"610.%2 0.00 #0"611.00

    8- 8- 0-

    2#"#$1.00 2#"#$1.00 0.00 2#"#$1.00 2#"#$1.00 2$0"6#.00

    % 2 0 10 #

    6"10$"0$9.00

    43- 54- D$B0 36- 82- 57-

    RT+*""# *$R=A$ /""RAL PARC"L

    ; "?ess ; : 30.06.2012 4- 5-

    43- 54- 0- 36- 82- 57-

    al Cost 01.06.2012 to 30.06.2012Roti Desert O

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    12/16

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    13/16

    D"L>E

    $1!"2$.00 1"669"011.00

    1#"#.00 $"9$0.00

    18,448.00 43,930.00

    Petrol

    0.00

    6- 3-

    D"L>E

    $12"$%0.00 1"%"26%.00

    1$"#9.00 "%.00

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    14/16

    13,849.00 44,445.00

    Petrol

    0.00

    4- 3-

    D"L>E

    629"!!$.00 $"21$"2!6.00

    $2"29!.00 ##"$!%.00

    32,297.00 88,375.00

    Petrol

    0.00

    5- 3-

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    15/16

    D"L>E

    5- 3-

    D"L>E

    $12"$%0.00 1"%"26%.00

    1$"#9.00 "%.00

    13,849.00 44,445.00

  • 7/23/2019 Monthly Cost Analysis - 30062012 Consolidated

    16/16

    Petrol

    0.00

    4- 3-

    D"L>E

    4- 3-