Prroblem $1)25$ points

The Robotics Section of the Manufacturing Plant wants to monitor its effective capacity and utilization for the weldinf off levonciaga car bodies. The car body takes $1\mathrm{.}65$ hours to complete welding.

$.$ It has retrieved historical data from the plant and it wants to compute for efficiency, utilization $.$ Subsequently it wants to predict when it will breach $100\%$ efficiencty and $100\%$ Utilization.

August is considered a holiday so there is no production that happens during that month

Find the Following using the table below.

$1)$ the Design Capacity per month $-$ Bonus Given

$2)$ Find the Effective Capacity per month $-5$ points

$3)$ how many Levonciagga vehicles can the robot weld on average per day and per month? $-5$ points

$4)$ what is the current capacity utilization per month? $-5$ points

$5)$ what is the current efficiency per month? $-5$ points

$6)$ at the rate we are going, when will we reach $100\%$ efficiency? $-5$ pointsA. Actual Engine Output Schedule per month

$\backslash$table$[[$A$.$ Actual Engine Output Schedule per month,B$.$ Assumptions for the Design Capacity,Unit of Measure,Remarks$],[$Year$,$Month,Quantities made,Item,Quantity$],[$Y$1,$M$1,1950,$Number of robots in Plant,$4,$robots,You can Edit this$],[$Y$1,$M$2,2025,$Operating Shift Daily,$9,$hours,Basis for Design Capacity$],[$Y$1,$M$3,2000,$Operating Days a Month,$30,$Days,Basis for Design Capacity$],[$Y$1,$M$4,1962,$Operating Months in a year,$12,$Months,Basis for Design Capacity$]]$

$\backslash$table$[[\backslash$table$[[$Average time spent welding$],[$Levonciagga Vehicles$]],1\mathrm{.}8$ Hours$]]$

$\backslash$table$[[$C$.$ Assumptions for the Effective Capacity,,,$],[,$Quantity,Unit of Measure,Remarks$],[,,,],[$Daily Start up time,$0\mathrm{.}50,$Hours,This affects effective capacity$],[$Daily Shut Down Time,$0\mathrm{.}33333333,$Hours,This affects effective capacity$],[\backslash$table$[[$Provision for Downtime for calibration$],[$and maintenance$]],5\%,$Percent,$\backslash$table$[[5\%$ of the remaining available$],[$hours$]]],[$Effective Operating Days in a Month,$26,$Days,$],[$Effective Operating Days in a Year,$11,$Months,$]]$