@php // from the month name get 1st date of the month and last date of the month $from_date = Carbon\Carbon::parse( $capacity_plan->production_plan, )->startOfMonth(); $to_date = Carbon\Carbon::parse( $capacity_plan->production_plan, )->endOfMonth(); @endphp @php // calculate the capacity pcs $capacity_pcs_weekly = number_format( ($capacity_plan->monthly_capacity_quantity / $capacity_plan->workingDays) * 7, 0, ); $capacity_pcs_daily = number_format( $capacity_plan->monthly_capacity_quantity / $capacity_plan->workingDays, 0, ); @endphp @php // calculate the capacity value $capacity_value_daily = number_format( $capacity_plan->monthly_capacity_value / $capacity_plan->workingDays, 0, ); $capacity_value_weekly = number_format( ($capacity_plan->monthly_capacity_value / $capacity_plan->workingDays) * 7, 0, ); @endphp

Month	From	To	Number of Working Days	Number of running machines	Number of helpers	working hours	Expected Efficiency%	Capacity Min			Capacity Pcs			Capacity Value
								Daily	Weekly	Monthly	Daily	Weekly	Monthly	Daily	Weekly	Monthly
{{ Carbon\Carbon::parse($capacity_plan->production_plan)->format('F-y') }}	{{ $from_date->format('d-M-Y') }}	{{ $to_date->format('d-M-Y') }}	{{ $capacity_plan->workingDays }}	{{ $capacity_plan->running_machines }}	{{ $capacity_plan->helpers }}	{{ $capacity_plan->working_hours }}	{{ $capacity_plan->efficiency }}	{{ $capacity_plan->daily_capacity_minutes }}	{{ $capacity_plan->weekly_capacity_minutes }}	{{ $capacity_plan->monthly_capacity_minutes }}	{{ $capacity_pcs_daily }}	{{ $capacity_pcs_weekly }}	{{ $capacity_plan->monthly_capacity_quantity }}	{{ $capacity_value_daily }}	{{ $capacity_value_weekly }}	{{ $capacity_plan->monthly_capacity_value }}