[go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Quarterly Projections I

    Uploaded by

    DerickMwansa
    The document provides quarterly projections for maize requirements and production costs for a plant with an 80 metric tonne per day capacity. Over a 12 month period, the plant will require 21,120 metric tonnes of maize. Production costs include maize, labor, electricity and other expenses. Projected revenues, cash flows, profits and margins are provided for a 4 month period, with the gross profit margin at 24% and net profit margin at 12% assuming costs remain stable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Quarterly Projections I

    Uploaded by

    DerickMwansa
    14 views8 pages
    The document provides quarterly projections for maize requirements and production costs for a plant with an 80 metric tonne per day capacity. Over a 12 month period, the plant will require 21,120 metric tonnes of maize. Production costs include maize, labor, electricity and other expenses. Projected revenues, cash flows, profits and margins are provided for a 4 month period, with the gross profit margin at 24% and net profit margin at 12% assuming costs remain stable.

    Original Description:

    Business financial Projections

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides quarterly projections for maize requirements and production costs for a plant with an 80 metric tonne per day capacity. Over a 12 month period, the plant will require 21,120 metric tonnes of maize. Production costs include maize, labor, electricity and other expenses. Projected revenues, cash flows, profits and margins are provided for a 4 month period, with the gross profit margin at 24% and net profit margin at 12% assuming costs remain stable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    14 views8 pages

    Quarterly Projections I

    Uploaded by

    DerickMwansa
    The document provides quarterly projections for maize requirements and production costs for a plant with an 80 metric tonne per day capacity. Over a 12 month period, the plant will require 21,120 metric tonnes of maize. Production costs include maize, labor, electricity and other expenses. Projected revenues, cash flows, profits and margins are provided for a 4 month period, with the gross profit margin at 24% and net profit margin at 12% assuming costs remain stable.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    QUARTERLY REQUIREMENT OF MAIZE

    Plant Capacity 80metric tonnes/24hrs


    = 1,600 x 50Kg of maize/24hrs
    Maize required in a month of 22 working days
    1,600 x 22 = 35,200 x 50Kg of maize
    1,760 metric tonnes
    Maize required for 3 months
    3 months x 35,200= 105,600 x 50Kg of maize
    5,280 metric tonnes

    Maize required for 6 months


    6 months x 35200 = 211,200 x 50Kg of maize
    10,560 metric tonnes

    Maize required for 9 months


    9 months x 35200 = 316, 800 x 50Kg of maize
    15,840 metric tonnes
    Maize required for 12 months/ 1 year
    12 months x 35200 = 422,400 x 50Kg of Maize
    21,120 metric tonnes

    APPENDIX II
    PRODUCTION COST
    Maize @ K76.5 per 50Kg bag
    Product
    Yield
    Std
    Unit
    Kg
    Kg
    B/Fast
    25.5
    25
    R/Meal
    17.5
    25
    Bran
    7
    25
    50
    Add Direct Costs
    Monthly Monthly
    Pdction
    Costs
    (22days*24hrs)
    Maize
    Labour
    60,544
    200,000
    Electricity
    60,544
    25,000
    Distribution
    60,544
    50,000
    Water
    60,544
    10,000
    Cotton
    60,544
    6,000
    Empty Bags

    Bran
    S.Price
    Kg

    Maize
    Cost/Kg
    1.78
    1.78

    Maize
    Cost
    K
    44.5
    44.5

    Bran
    Gain
    K

    0.72

    7.2

    Break
    Fast

    Roller
    Meal

    44.5
    3.30
    0.412923
    0.825846
    0.165169
    0.099101
    2
    51.30642

    44.5
    3.30
    0.412923
    0.825846
    0.165169
    0.099101
    2
    51.30642
    7.2
    51.3064 44.1064
    60
    46
    8.69358 1.89358

    Less Bran Gains


    Marginal Cost/25kg
    Current SP
    Contribution/25Kg
    Note:
    *All the above calculations are based on full capacity that is at 24hrs
    per day, however, currently we working at 12hrs per day.
    *Cost per kg of maize is cost of 50kg bag divied by 86% of 50kg, 86% being
    extraction rate.
    *Bran gain is 7kg bran multiplied by 25kg of roller meal, divided by 17.5kg which is
    the std yield in 50kg bag of maize multiplied by selling price for 25kg of bran.
    *Monthly production units are obtained by taking into consideration the 80ton/24hrs
    capacity, extraction rate at 86%, 22 working days and 24hrs in each day.
    *The above costings shows that 86.73% of mealie meal cost is from maize hence
    the need to seriuosly consider cheaper sources of maize.

    ze hence

    APPENDIX I

    INPUT COSTINGS
    MONTH
    MAIZE
    50Kg
    March
    35,200
    April
    35,200
    May
    35,200
    June
    35,200
    of Maize for four months period.

    TOTAL REVENUE
    Month
    B/FAST
    Weight
    25Kg
    S. Price
    K60
    March
    2,112,000
    April
    2,112,000
    May
    2,112,000
    June
    2,112,000

    B/FAST
    25Kg
    39,354
    39,354
    39,354
    39,354

    R/MEAL
    25Kg
    21,190
    21,190
    21,190
    21,190

    R/MEAL
    25Kg
    K46
    1,810,284
    1,810,284
    1,810,284
    1,810,284

    M/BRAN
    25KG
    K18
    152,064
    152,064
    152,064
    152,064

    M/BRAN
    25Kg
    8,448
    8,448
    8,448
    8,448

    TOTAL
    M/Meal
    60,544
    60,544
    60,544
    60,544

    Note: Mealie meal split ratio is at 65% for Break fast and 35% for Roller meal.

    Maize
    Packaging
    K76.5/50Kg
    K2/bag
    2,692,800 121,088
    2,692,800 121,088
    2,692,800 121,088
    2,692,800 121,088
    10,771,200.00

    for Roller meal.

    POWER
    K
    25,000
    25,000
    25,000
    25,000

    Water
    K
    10,000
    10,000
    10,000
    10,000

    D/bution
    K
    50,000
    50,000
    50,000
    50,000

    Cotton D. Labour
    K
    K
    6,000 200,000
    6,000 200,000
    6,000 200,000
    6,000 200,000

    Total
    K
    3,104,888
    3,104,888
    3,104,888
    3,104,888

    APPENDIX III
    CASH FLOW ANALYSIS
    OPENING BALANCE
    MATERIALS
    ADMIN
    DISTRIBUTION
    ELECTRICITY
    WATER
    LABOUR

    March
    April
    May
    3,119,888
    4,074,348
    5,023,808
    2,819,888
    2,819,888
    2,819,888
    20,000
    20,000
    20,000
    50,000
    50,000
    50,000
    25,000
    25,000
    25,000
    10,000
    10,000
    ###
    200,000
    200,000
    ###
    -

    REVENUE
    B/FAST
    R/MEAL
    M/BRAN
    NET CASH FLOW

    5,000

    949,460

    2,112,000
    1,810,284
    152,064

    2,112,000
    1,810,284
    152,064

    4,074,348

    5,023,808

    1,898,920
    ###
    ###
    ###
    5,973,268

    PROFIT & LOSS PROJECTIONS


    PROFIT & LOSS
    MARCH
    APRIL
    MAY
    REVENUE
    BREAK FAST
    2,112,000.00
    2,112,000.00
    2,112,000.00
    ROLLER MEAL
    1,810,284.00
    1,810,284.00
    1,810,284.00
    M/BRAN
    152,064.00
    152,064.00
    152,064.00
    COST OF SALES
    3,104,888.00
    3,104,888.00
    3,104,888.00
    GROSS PROFIT
    969,460.00
    969,460.00
    969,460.00
    Provisional loss @ 2% of GP
    19,389.20
    19,389.20
    19,389.20
    DEPRECIATION
    15,000.00
    15,000.00
    15,000.00
    ADMIN
    20,000.00
    20,000.00
    20,000.00
    SALARIEES
    184,000.00
    184,000.00
    ###
    PROFIT BEFORE TAX
    TAX @35%
    NET PROFIT
    GROSS PROFIT MARGIN
    NET PROFIT MARGIN

    731,070.80
    255,874.78
    475,196.02

    731,070.80
    255,874.78
    475,196.02

    731,070.80
    255,874.78
    475,196.02

    0.24
    0.12

    0.24
    0.12

    0.24
    0.12

    The above projections assumes that there won't be adverse drastic changes in the cost of
    raw materials in the subsequent months.

    June

    Totals
    5,973,268
    2,819,888
    20,000
    50,000
    25,000
    10,000
    200,000

    11,279,552
    80,000
    200,000
    100,000
    40,000
    800,000

    2,848,380
    2,112,000
    1,810,284
    152,064
    6,922,728

    JUNE
    2,112,000.00
    1,810,284.00
    152,064.00
    3,104,888.00
    969,460.00
    19,389.20
    15,000.00
    20,000.00
    184,000.00
    731,070.80
    255,874.78
    475,196.02

    s in the cost of

    0.24
    0.12

    8,448,000
    7,241,136
    608,256

    You might also like