Project Detail Sheet

{{ Form::open(['url' => route('detail_sheet.store', ['id' => $letterID])]) }} {{ Form::hidden('letterID', $letterID) }} @can('establishment_view') @endcan @can('store_view') @endcan @if (auth()->user()->hasRoleWisePermission('raw_view') || auth()->user()->hasRoleWisePermission('account_view')) @php $currentYear = $Budget->budget_year; $nextYear = $Budget->budget_year + 1; @endphp @endif @can('store_view') @endcan @can('store_view') @endcan @can('store_view') @endcan @can('account_view') @endcan @can('store_view') @endcan @can('store_view') @endcan @can('store_view') @endcan @can('account_view') @endcan @can('store_view') @endcan @can('store_view') @endcan @can('store_view') @endcan

Sr. No

Budget head no.

Name of Budget Head

Details

Outlay for Administrative Approval / Technical Sanction

Employee Cost

1) Monthly Gross Salary ( Employee)
including EPF & ESIC (Rs. x ) ( x )

2) O.T. X Month

3) T.A. x Month

4) Medical reimbursement/mediclaim

5) Leave Salary & Pension count Employees ( x )

6) Gratuity Fund Investment ( x )

7) Accidental Policy ( Employees)

8) GIS Policy

9) Bonus/Exgratia ( Employees)

10) Uniform, Raincoat, Gumboot, etc.

11) Leave Encashment

12) 7th pay Difference 1st Installment / Training / any New Recruitment

ENERGY COST

Raw Water Pumping Station, Shahad ( x ) (MSEDCL) =

Water Treatment Plant, Temghar ( x ) =

Pumping station, Patlipada ( x = ) + Others Rs. lacs. (MSEDCL) + STEM Office (Vardan Bldg. 1st Floor - and 9th Floor - ) Total= Lacs and if rates are increase

RAW WATER COST
Position of {{ $currentYear }} - {{ $nextYear }} (approx.)

@php $Domestic = json_decode($raw_water->DomesticRawWater, true); $Commercial = json_decode($raw_water->CommercialRawWater, true); $Rural = json_decode($raw_water->RuralRawWater, true); $indivMonth = []; //months 9 $quater = []; //months 3 $collectionMonth = [0, 0, 0]; $i = 1; $DomesticAmt = $CommercialAmt = $RuralAmt = 0; $exclude_month = ['4', '5', '6']; // echo "

";
                                                    $DomesticInLocal_cess = $DomesticDate = $DomesticInDate = $DomesticInAmount = 0;
                                                    $CommercialInLocal_cess = $CommercialDate = $CommercialInDate = $CommercialInAmount = 0;
                                                    $RuralInLocal_cess = $RuralDate = $RuralInDate = $RuralInAmount = 0;
                                                    $DomesticUnit = $DomesticAmount = $DomesticLocal_cess = $DomesticInAmt = 0;
                                                    $CommercialUnit = $CommercialAmount = $CommercialLocal_cess = $CommercialInAmt = 0;
                                                    $RuralUnit = $RuralAmount = $RuralLocal_cess = $RuralInAmt = 0;
                                                    foreach ($Domestic as $key => $value) {
                                                        // print_r($value);
                                                        $total_bill_amt =
                                                            $value['bill_amount'] +
                                                            $Commercial[$key]['bill_amount'] +
                                                            $Rural[$key]['bill_amount'];
                                                        $indivMonth[$key] = $total_bill_amt;
                                                        if ($i <= 3) {
                                                            //1,2,3  4,5,6   7,8,9
                                                            $DomesticAmt += $Domestic[$key]['bill_amount'];
                                                            $CommercialAmt += $Commercial[$key]['bill_amount'];
                                                            $RuralAmt += $Rural[$key]['bill_amount'];
                                                            $DomesticDate += $Domestic[$key]['days'];
                                                            $CommercialDate += $Commercial[$key]['days'];
                                                            $RuralDate += $Rural[$key]['days'];
                                                            $DomesticUnit += $Domestic[$key]['unit'];
                                                            $CommercialUnit += $Commercial[$key]['unit'];
                                                            $RuralUnit += $Rural[$key]['unit'];
                                                            $DomesticAmount += $Domestic[$key]['amount'];
                                                            $CommercialAmount += $Commercial[$key]['amount'];
                                                            $RuralAmount += $Rural[$key]['amount'];
                                                            $DomesticLocal_cess += $Domestic[$key]['local_cess'];
                                                            $CommercialLocal_cess += $Commercial[$key]['local_cess'];
                                                            $RuralLocal_cess += $Rural[$key]['local_cess'];

                                                            // common rate
                                                            $DomesticRate = $Domestic[$key]['rate'];
                                                            $CommercialRate = $Commercial[$key]['rate'];
                                                            $RuralRate = $Rural[$key]['rate'];
                                                            $DomesticUnit = $Domestic[$key]['unit'];
                                                            $CommercialUnit = $Commercial[$key]['unit'];
                                                            $RuralUnit = $Rural[$key]['unit'];

                                                            if ($i == 3) {
                                                                $quater[1][] = [
                                                                    'bill_amount' => $DomesticAmt,
                                                                    'rate' => $DomesticRate,
                                                                    'days' => $DomesticDate,
                                                                    'unit' => $DomesticUnit,
                                                                    'amount' => $DomesticAmount,
                                                                    'local_cess' => $DomesticLocal_cess,
                                                                ];
                                                                $quater[2][] = [
                                                                    'bill_amount' => $CommercialAmt,
                                                                    'rate' => $CommercialRate,
                                                                    'days' => $CommercialDate,
                                                                    'unit' => $CommercialUnit,
                                                                    'amount' => $CommercialAmount,
                                                                    'local_cess' => $CommercialLocal_cess,
                                                                ];
                                                                $quater[3][] = [
                                                                    'bill_amount' => $RuralAmt,
                                                                    'rate' => $RuralRate,
                                                                    'days' => $RuralDate,
                                                                    'unit' => $RuralUnit,
                                                                    'amount' => $RuralAmount,
                                                                    'local_cess' => $RuralLocal_cess,
                                                                ];
                                                                $DomesticAmt = $CommercialAmt = $RuralAmt = $DomesticRate = $DomesticDate = $DomesticUnit = $RuralDate = $DomesticAmount = $RuralUnit = $RuralAmount = $DomesticLocal_cess = $RuralLocal_cess = $CommercialRate = $CommercialDate = $CommercialUnit = $CommercialAmount = $CommercialLocal_cess = $RuralRate = 0;
                                                                -($i = 0);
                                                            }
                                                        }

                                                        if (!in_array($key, $exclude_month)) {
                                                            $DomesticInAmt += $Domestic[$key]['bill_amount'];
                                                            $CommercialInAmt += $Commercial[$key]['bill_amount'];
                                                            $RuralInAmt += $Rural[$key]['bill_amount'];
                                                            $DomesticInDate += $Domestic[$key]['days'];
                                                            $CommercialInDate += $Commercial[$key]['days'];
                                                            $RuralInDate += $Rural[$key]['days'];
                                                            $DomesticInAmount += $Domestic[$key]['amount'];
                                                            $CommercialInAmount += $Commercial[$key]['amount'];
                                                            $RuralInAmount += $Rural[$key]['amount'];
                                                            $DomesticInLocal_cess += $Domestic[$key]['local_cess'];
                                                            $CommercialInLocal_cess += $Commercial[$key]['local_cess'];
                                                            $RuralInLocal_cess += $Rural[$key]['local_cess'];

                                                            // common rate
                                                            $DomesticInUnit = $Domestic[$key]['unit'];
                                                            $CommercialInUnit = $Commercial[$key]['unit'];
                                                            $RuralInUnit = $Rural[$key]['unit'];
                                                            $DomesticInRate = $Domestic[$key]['rate'];
                                                            $CommercialInRate = $Commercial[$key]['rate'];
                                                            $RuralInRate = $Rural[$key]['rate'];

                                                            if ($key == 12) {
                                                                // $collectionMonth[0] = $DomesticInAmt;
                                                                // $collectionMonth[1] = $CommercialInAmt;
                                                                // $collectionMonth[2] = $RuralInAmt;

                                                                $collectionMonth[1] = [
                                                                    'bill_amount' => $DomesticInAmt,
                                                                    'rate' => $DomesticInRate,
                                                                    'days' => $DomesticInDate,
                                                                    'unit' => $DomesticInUnit,
                                                                    'amount' => $DomesticInAmount,
                                                                    'local_cess' => $DomesticInLocal_cess,
                                                                ];
                                                                $collectionMonth[2] = [
                                                                    'bill_amount' => $CommercialInAmt,
                                                                    'rate' => $CommercialInRate,
                                                                    'days' => $CommercialInDate,
                                                                    'unit' => $CommercialInUnit,
                                                                    'amount' => $CommercialInAmount,
                                                                    'local_cess' => $CommercialInLocal_cess,
                                                                ];
                                                                $collectionMonth[3] = [
                                                                    'bill_amount' => $RuralInAmt,
                                                                    'rate' => $RuralInRate,
                                                                    'days' => $RuralInDate,
                                                                    'unit' => $RuralInUnit,
                                                                    'amount' => $RuralInAmount,
                                                                    'local_cess' => $RuralInLocal_cess,
                                                                ];
                                                                $DomesticInAmt = $CommercialInAmt = $RuralInAmt = $DomesticInRate = $DomesticInDate = $DomesticInUnit = $RuralInDate = $DomesticInAmount = $RuralUnit = $RuralInAmount = $DomesticInLocal_cess = $RuralInLocal_cess = $CommercialInRate = $CommercialInDate = $CommercialInUnit = $CommercialInAmount = $CommercialInLocal_cess = $RuralInRate = 0;
                                                            }
                                                        }
                                                        $i++;
                                                    }

                                                    // // Set the start date to the current date of the current year

                                                    $year = 0;
                                                    $currentDate = new DateTime();

                                                    $currentDate = $Budget->budget_year;

                                                    // echo $currentDate;

                                                    $startDate = new DateTime($currentDate . '-04-01');

                                                    // // Set the end date to March 1 of the next year
                                                    $endDate = new DateTime($currentDate + 1 . '-04-01');

                                                    // // Create an interval of one month
                                                    $interval = new DateInterval('P1M');

                                                    // // Create a DatePeriod object
                                                    $datePeriod = new DatePeriod($startDate, $interval, $endDate);

                                                    // // Loop through the months and print them

                                                    echo "";
                                                    $AmountFinalValue = 0;
                                                    foreach ($datePeriod as $key => $date) {
                                                        echo '';
                                                    }
                                                    echo "";
                                                    echo "
                                            
                                            
                                            
                                             Month - Year
                                            Amount
                                            
';
                                                        echo $date->format('F Y');
                                                        echo ' ';
                                                        $Amount = $indivMonth[$date->format('n')];
                                                        $formatAmount = number_format($Amount / 100000, 2);
                                                        echo $formatAmount;
                                                        $AmountFinalValue += $formatAmount;
                                                        echo '
Total : - $AmountFinalValue ";

                                                @endphp

A) Domestic :- @foreach ([$quater[1][1], $collectionMonth[1]] as $index => $data) @endforeach

SR.No	Period	Days	Unit	Rate	Amount	20% cess	Total Amount
{{ $index + 1 }}	@if ($index === 0) (01.04.{{ $Budget->budget_year }} to 30.06.{{ $Budget->budget_year }}) @else (01.07.{{ $Budget->budget_year }} to 31.03.{{ $Budget->budget_year + 1 }}) @endif	{{ $data['days'] }} days	{{ $data['unit'] }} (1,000 ltr)	Rs.{{ $data['rate'] }}	Rs.{{ number_format($data['amount'], 2) }}	Rs.{{ number_format($data['local_cess'], 2) }}	Rs.{{ number_format($data['bill_amount'], 2) }}

@php $totalAmountNew = $quater[1][1]['bill_amount'] + $collectionMonth[1]['bill_amount']; $totalAmountNew1 = $quater[2][1]['bill_amount'] + $collectionMonth[2]['bill_amount']; $totalAmountNew2 = $quater[3][1]['bill_amount'] + $collectionMonth[3]['bill_amount']; $TotaLfinalAmtNew = $totalAmountNew + $totalAmountNew1 + $totalAmountNew2; // Ensure $raw_water_extra is initialized if ($raw_water_extra) { $raw_water_extra->domestic_value = $raw_water_extra->domestic_value ?? 0; $raw_water_extra->commercial_value = $raw_water_extra->commercial_value ?? 0; $raw_water_extra->rural_value = $raw_water_extra->rural_value ?? 0; } else { // Initialize default values if $raw_water_extra is null $raw_water_extra = (object) [ 'domestic_value' => 0, 'commercial_value' => 0, 'rural_value' => 0, ]; } $original_val = number_format($TotaLfinalAmtNew / 100000, 2); if ( !empty($raw_water_extra->domestic_value) || !empty($raw_water_extra->commercial_value) || !empty($raw_water_extra->rural_value) ) { $finalAmount = $original_val + $raw_water_extra->domestic_value + $raw_water_extra->commercial_value + $raw_water_extra->rural_value; } else { $finalAmount = round($TotaLfinalAmtNew / 100000, 2); } @endphp

B) Commercial :-

SR.No	Period	Days	Unit	Rate	Amount	20% cess	Total Amount
1	(01.04.{{ $Budget->budget_year }} to 30.06.{{ $Budget->budget_year }})	{{ $quater[2][1]['days'] }} days	{{ $quater[2][1]['unit'] }} (1,000 ltr)	Rs.{{ $quater[2][1]['rate'] }}	Rs.{{ number_format($quater[2][1]['amount'], 2) }}	Rs.{{ number_format($quater[2][1]['local_cess'], 2) }}	Rs.{{ number_format($quater[2][1]['bill_amount'], 2) }}
2	(01.07.{{ $Budget->budget_year }} to 31.03.{{ $Budget->budget_year + 1 }})	{{ $collectionMonth[2]['days'] }} days	{{ $collectionMonth[2]['unit'] }} (1,000 ltr)	Rs.{{ $collectionMonth[2]['rate'] }}	Rs.{{ number_format($collectionMonth[2]['amount'], 2) }}	Rs.{{ number_format($collectionMonth[2]['local_cess'], 2) }}	Rs.{{ number_format($collectionMonth[2]['bill_amount'], 2) }}

C) Rural :-

SR.No	Period	Days	Unit	Rate	Amount	20% cess	Total Amount
1	(01.04.{{ $Budget->budget_year }} to 30.06.{{ $Budget->budget_year }})	{{ $quater[3][1]['days'] }} days	{{ $quater[3][1]['unit'] }} (1,000 ltr)	Rs.{{ $quater[3][1]['rate'] }}	Rs.{{ number_format($quater[3][1]['amount'], 2) }}	Rs.{{ number_format($quater[3][1]['local_cess'], 2) }}	Rs. {{ number_format($quater[3][1]['bill_amount'], 2) }}
2	(01.07.{{ $Budget->budget_year }} to 31.03.{{ $Budget->budget_year + 1 }})	{{ $collectionMonth[3]['days'] }} days	{{ $collectionMonth[3]['unit'] }} (1,000 ltr)	Rs.{{ $collectionMonth[3]['rate'] }}	Rs.{{ number_format($collectionMonth[3]['amount'], 2) }}	Rs.{{ number_format($collectionMonth[3]['local_cess'], 2) }}	Rs. {{ number_format($collectionMonth[3]['bill_amount'], 2) }}

@php $totalAmount = $quater[3][1]['bill_amount'] + $collectionMonth[3]['bill_amount']; $finalAmount = !empty($raw_water_extra->rural_value) ? round($totalAmount / 100000, 2) + $raw_water_extra->rural_value : round($totalAmount / 100000, 2); @endphp

Chemicals (Alum, PAC, Chlorine, Co. Aid Lime, Bleaching Powder)

1) Liquid Chlorine ( Kg Tonner) = M.T x

2) Liquid Poly Aluminium Chloride (PAC) = M.T x

3) Liquid Alum = MT *

4) Coagulant aid, Caustic soda, Bleaching Powder, Lime. Other things & 5) AMC of Chlorinators

5) AMC of Chlorinators

Security Charges

M/s. Maharashtra State Security Corporation Wages - X
& M/s Eagal Security Services - x

6 & 7

Operation & Maintenance & Repairing Exp. (Civil, Mechanical & Electrical)

Spill over & Provision (Old tenders final bills) & New (Civil, Mechanical & Electrical) List Attached

Organic Scientific & Chemical Testing Expenses

Chief Bacteriologist DPH Lab, VJTI & other water testing expenses.

Professional Expenses

@if (!is_null($professional_data) && count($professional_data) > 0) @foreach ($professional_data as $key => $professional_datas) @endforeach @else @endif

Sr.No.	Particular	Number	Rate	Amount	Action
{{ $key + 1 }}
{{ $key + 1 }}

Audit Fees (Statutory Audit Fee)

Statutory & Tax Audit fees.

Transportation Expenses

MD- A.O.- G.M.- DE's- OMR Temghar - Total - vehicles

Priting & Stationary Exp.

As per requirement time to time. Purchase New xerox Machine

Property & License -Taxes

@if (is_countable($storeclerk_property)) @else @endif @if (!empty($storeclerk_property)) @foreach ($storeclerk_property as $key => $storeclerk_propertys) @endforeach @else {{-- --}} @endif

Sr.No.	Property Name	Year	Tax	Amount	Action
{{ $key + 1 }}
1

MISCELLANEOUS EXPENSES

@if ($storeclerk_miscellanous) @foreach ($storeclerk_miscellanous as $key => $storeclerk_miscellanou) @endforeach @else {{-- --}} @endif

Sr.No.	Property Name	Amount	Action
{{ $key + 1 }}
1

Rent

1) Rent for Vardhan Office = 9th Floor Sq.mtr x Rs. x x x % (GST) = lacs (Per Month).
1st Floor Sq. mtr. x Rs. x x x % (GST) = Rs. lacs (Per Month),
2) Thane Creek = lacs.
3) Factory Licence Renewal Rs. /-

DEPRECIATION

As per company Act

MAT, I.Tax, Penalty & Interest etc..

Depends Upon Profit / Situation.(Provision Only)

Provision for Bad Debts, RDD

BNCMC & Rural (Provision)

Safety Expenses

@if (isset($storeclerk_safety) && is_iterable($storeclerk_safety) && count($storeclerk_safety) > 0) @foreach ($storeclerk_safety as $key => $storeclerk_safetys) @endforeach @else {{-- --}} @endif

Sr.No.	Property Name	Amount	Action
{{ $key + 1 }}
1

Advertisement Expenses

Total of Revenue Work

Rural Capital

Statement Attached

Urban Capital

Statement Attached

Computers & Computer Software

As per requirements

Office Equipment

As per requirements

Furniture & Fixture

As per requirements

{{ Form::button('Update', ['class' => 'btn btn-primary btn-block', 'type' => 'submit', 'name' => 'btn_add_detail_sheet', 'value' => 'NEXT']) }}

@if (auth()->user()->hasRoleWisePermission('raw_download') || auth()->user()->hasRoleWisePermission('account_download')) @endif