Question: Service levels: 3 5 points The year is 2 0 3 2 and the Manila Subway System is evaluating the number of full time workers

Service levels: 35 points
The year is 2032 and the Manila Subway System is evaluating the number of full time workers is should hire for the train cleaning and maintenace crews. It is currently looking at the Quezon City Katipunan to Fort Bonifacio Line to to simplify the task it has divided each month into 4 periods and has noted. It also has gathered data for five years from 2028 to 2021. The Trasport Authority is budgeting an average of 25 US dollars per trip if they decide to hire full time personnel and it takes about 35 US Dollars per trip if they have it subcontracted. Please explore the different scenarios
1) If we have a service level of 70 percent consiodering all the months and years, what would be the number of trips? If we hire full time personnel to service the 70 percent service level how much will it cost us to pay the fill time service personnel? -10 points
2) If we decide on a service levvel of 95 percent considering all months and years, what will be the number of trips? If we hire the full time personnel to service the 95 percent service level how much will it cost us?-10 points
3) what is the difference in overhead costs of item 2 and 1?-5 points
4) If we consider only the regular days and the holidays, what is the nunmber of passengers we can serve using full time hires if we allocate 85% service level? what is the maxumum number of trips for regular days and holidays that will be catered by our outsourced maintenance services? -10 points\table[[,,,\table[[Number],[of trips]],\table[[Number],[of trips]],\table[[Number],[of trips]],\table[[Number],[of trips]]],[Month,Season,Week,2028,2029,2030,2031],[January,Holiday,1,2160,2203,2269,2405],[January,Holiday,2,2160,2160,2289,2243],[January,Holiday,3,2160,2095,2074,2198],[January,Holiday,4,2160,2224,2224,2290],[February,Regular Days,1,1793,1721,1738,1685],[February,Regular Days,2,1966,1926,1887,2000],[February,Regular Days,3,1944,2080,1996,2035],[February,Regular Days,4,1815,1923,1865,1920],[March,Regular Days,1,1901,1843,1935,1954],[March,Regular Days,2,1880,1898,1973,1913],[March,Regular Days,3,1880,1823,1950,1969],[March,Regular Days,4,1836,1946,2004,2024],[April,High Usage,1,2204,2248,2315,2407],[April,High Usage,2,2139,2245,2402,2377],[April,High Usage,3,2096,2179,2135,2177],[April,High Usage,4,2290,2221,2265,2355],[May,High Usage,1,2271,2202,2113,2134],[May,High Usage,2,2118,2245,2289,2357],[May,High Usage,3,2138,2116,2158,2222],[May,High Usage,4,2382,2477,2551,2653],[June,lean Months,1,1309,1256,1306,1332],[June,lean Months,2,1436,1507,1552,1505],[June,lean Months,3,1420,1519,1519,1594],[June,lean Months,4,1761,1866,1903,1864],[July,lean Months,1,1296,1270,1333,1306],[July,lean Months,2,1523,1492,1432,1446],[July,lean Months,3,1420,1491,1461,1504],[July,lean Months,4,1867,1941,1863,1993],[August,lean Months,1,1284,1373,1455,1513],[August,lean Months,2,1493,1448,1419,1404],[August,lean Months,3,1406,1490,1460,1518],[August,lean Months,4,1811,1756,1738,1859],[September,lean Months,1,1349,1375,1471,1456],[September,lean Months,2,1553,1490,1549,1641],[September,lean Months,3,1406,1490,1564,1657],[September,lean Months,4,1848,1958,1918,1860],[October,High Usage,1,1865,1995,2134,2048],[October,High Usage,2,2045,2188,2188,2297],[October,High Usage,3,1983,1923,1865,1976],[October,High Usage,4,1779,1867,1829,1810],[November,Holiday,1,2247,2224,2312,2450],[November,Holiday,2,2182,2203,2114,2261],[November,Holiday,3,2268,2222,2155,2262],[November,Holiday,4,2139,2117,2074,2156],[December,Holiday,1,2614,2796,2684,2657],[December,Holiday,2,2420,2492,2492,2666],[December,Holiday,3,2420,2323,2415,2318],[December,Holiday,4,2679,2652,2572,2520]]
 Service levels: 35 points The year is 2032 and the Manila

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!