Yogurtland's frozen yogurt is incredible. It sells delicious yogurts in Riverside. The attached spread sheet shows their hours/day in labor and their total revenue. Andrew (the owner) hires people to scoop his frozen yogurt at $12/hour. Use the excel data file FroYoData to answer this question.
a. Based on this data, what do you believe is the optimal number of workers to hire (round to the nearest whole number)?
b. Why do you think that is the optimal amount of labor to use (attach any graphs, math, or screenshots of what you used to solve this question)?
c. What is the marginal revenue product of labor for the 84th worker-hour (round to the nearest whole number)?
d. What might be the problem with inferring that the 92nd worker-hour increased revenue by approximately $10 using only this data?
Labor (daily full-time equivalency) Revenue (dollars) 70.5886688232422 1444.975097656 116.83374786377 2021.85144043 98.0605697631836 1799.008789063 104.505767822266 1876.998168945 108.253196716309 1921.605224609 41.6961250305176 1017.265136719 45.9243507385254 1084.923339844 40.2402267456055 993.4453125 91.8425445556641 1722.131469727 118.47346496582 2040.724731445 51.6154899597168 1172.799438477 43.7286949157715 1050.061401367 97.6760940551758 1794.303466797 66.6176681518555 1390.261962891 44.5798606872559 1063.643676758 88.6379623413086 1681.835571289 85.0797729492188 1636.519775391 57.6656494140625 1262.743530273 50.7544288635254 1159.719604492 105.858047485352 1893.155395508 108.616157531738 1925.898071289 74.6772155761719 1500.245849609 101.219177246094 1837.435913086 79.7554779052734 1567.511352539 61.5787391662598 1319.241210938 81.7725143432617 1593.829833984 114.730827331543 1997.516845703 102.252342224121 1849.918212891 92.8798446655273 1735.07409668 79.1614074707031 1559.717773438 61.0137825012207 1311.159912109 66.4990005493164 1388.610595703 105.753814697266 1891.912475586 83.0869064331055 1610.863525391 118.739547729492 2043.779052734 98.3732452392578 1802.831054688 75.829833984375 1515.643554688 77.6404418945313 1539.674926758 101.851081848145 1845.075439453 109.477157592773 1936.06262207 116.465141296387 2017.596435547 41.9719047546387 1021.745666504 83.1409225463867 1611.561645508 82.1024932861328 1598.114624023 57.2222137451172 1256.26184082 89.496955871582 1692.683959961 73.7279281616211 1487.504760742 71.9359741210937 1463.303588867 41.5246658325195 1014.474487305 56.0425224304199 1238.935791016 83.5945205688477 1617.41784668 118.404006958008 2039.927001953 113.306869506836 108.103408813477 70.1818008422852 92.8112564086914 42.098747253418 57.2113494873047 76.3394927978516 102.57105255127 121.379669189453 119.346206665039 105.709594726563 114.329635620117 70.772102355957 43.4439086914063 89.2653350830078 109.53199005127 96.9989471435547 87.4457626342774 119.740409851074 80.1230163574219 78.2670288085938 88.7720260620117 75.0581970214844 53.6193504333496 60.2845726013184 72.5097579956055 119.25390625 111.50301361084 47.2980804443359 73.5354919433594 74.4533081054688 62.8105163574219 93.9644775390625 75.5653457641602 78.8639602661133 56.9456634521484 93.1798400878906 40.8455543518066 82.7667846679688 118.127838134766 104.803161621094 64.1210784912109 45.9525833129883 40.728443145752 40.6161079406738 49.3435859680176 123.643997192383 108.836112976074 80.502799987793 84.5977096557617 89.8769912719727 86.737548828125 47.1266250610352 1980.954711914 1919.83215332 1439.417236328 1734.219726563 1023.803161621 1256.102661133 1522.427246094 1853.760375977 2073.962890625 2050.734619141 1891.385131836 1992.857543945 1447.477294922 1045.497436523 1689.762207031 1936.708862305 1786.001098633 1666.720825195 2055.247802734 1572.323364258 1547.947631836 1683.531005859 1505.344116211 1202.960571289 1300.692138672 1471.074584961 2049.677246094 1959.873779297 1106.452270508 1484.915405273 1497.245605469 1336.775878906 1748.555786133 1512.11730957 1555.808227539 1252.21081543 1738.808105469 1003.383361816 1606.723266602 2036.75378418 1880.557617188 1355.306640625 1085.367919922 1001.464599609 999.622253418 1138.127319336 2099.676513672 1928.497314453 1577.288085938 1630.33215332 1697.472412109 1657.709716797 1103.776855469 62.2233505249023 85.3264694213867 123.190925598145 95.0687713623047 98.3272094726562 114.628814697266 81.7499618530274 47.1158409118652 83.4350509643555 94.2592849731445 76.3324127197266 57.1251640319824 43.2121734619141 44.7339820861816 87.4064407348633 43.8142547607422 53.3099746704102 66.1400909423828 49.1333236694336 55.6140823364258 43.0861053466797 112.569557189941 52.3461227416992 105.843818664551 102.540328979492 60.0420227050781 45.5465927124024 84.9576110839844 41.017448425293 58.9135246276855 103.99690246582 57.3515701293945 81.5775604248047 92.4695739746094 102.455108642578 97.5634307861328 64.6506195068359 56.8876609802246 115.044738769531 109.867813110352 80.0286483764648 85.9438552856445 70.2011260986328 63.7387580871582 107.028602600098 56.4447479248047 79.0280685424805 104.389442443848 69.8938140869141 77.8115310668945 106.737022399902 50.2980918884277 46.2695693969727 1328.431884766 1639.681640625 2094.544189453 1762.228759766 1802.268554688 1996.332641602 1593.536621094 1103.608398438 1615.360229492 1752.211303711 1522.333129883 1254.840942383 1041.776123047 1066.09375 1666.221191406 1051.430664063 1198.328857422 1383.60949707 1134.891723633 1232.61340332 1039.749023438 1972.3515625 1183.841064453 1892.985839844 1853.390136719 1297.200805664 1078.965576172 1634.952880859 1006.196472168 1280.895507813 1870.900146484 1258.154296875 1591.295532227 1729.96081543 1852.362915039 1792.923461914 1362.758300781 1251.360351563 2001.158691406 1940.665527344 1571.088623047 1647.581542969 1439.681518555 1349.91394043 1907.0859375 1244.856689453 1557.965820313 1875.605102539 1435.476806641 1541.936035156 1903.620727539 1152.75769043 1090.353515625 121.314758300781 85.320556640625 89.0644454956055 83.7270278930664 59.1144485473633 44.5972709655762 104.579887390137 115.919647216797 87.6003036499023 66.3976745605469 41.2803649902344 66.2217178344727 93.5622787475586 97.8059539794922 60.414192199707 56.1853446960449 67.4738311767578 53.0569000244141 93.2540664672852 71.1191711425781 85.2251434326172 114.389343261719 75.6054077148437 54.1210784912109 53.4194984436035 40.3509292602539 122.67960357666 64.3121948242188 80.6025161743164 66.9591598510742 102.6328125 54.3541259765625 79.4777984619141 109.35009765625 70.0224151611328 83.5227508544922 60.4009475708008 98.257568359375 107.784973144531 58.2984085083008 104.867408752441 84.1604843139649 58.6447715759277 58.4779510498047 113.251365661621 61.6867485046387 61.753101348877 92.1116943359375 43.9156455993652 107.91185760498 57.6935272216797 91.4678268432617 110.401077270508 2073.223388672 1639.605957031 1687.226074219 1619.126586914 1283.806152344 1063.920532227 1877.885620117 2011.291748047 1668.683959961 1387.199584961 1010.491577148 1384.747802734 1743.562744141 1795.893432617 1302.555786133 1241.039916992 1402.148193359 1194.533325195 1739.731445313 1452.205810547 1638.383422852 1993.551269531 1512.651611328 1210.453125 1199.969604492 995.2665405273 2088.744384766 1357.998413086 1578.590209961 1395.009033203 1854.504394531 1213.925537109 1563.87097168 1934.564331055 1437.237060547 1616.491943359 1302.365356445 1801.417480469 1916.060424805 1271.963989258 1881.325927734 1624.709960938 1276.997070313 1274.57421875 1980.307739258 1320.783447266 1321.73046875 1725.494384766 1053.052124023 1917.563598633 1263.150512695 1717.444091797 1946.940063477 103.487022399902 48.1091194152832 80.0109176635742 77.6111145019531 66.9910125732422 120.534103393555 55.0212554931641 94.4720458984375 118.35498046875 90.7419967651367 57.7959747314453 68.3429336547852 82.4113693237305 84.9585647583008 81.1351089477539 50.8561782836914 52.5279502868652 59.334228515625 78.8343887329102 42.3792686462402 123.827354431152 48.9699325561523 52.5472450256348 56.5843086242676 121.577812194824 56.9659080505371 48.2024612426758 71.2350006103516 78.6659698486328 82.7677001953125 117.741737365723 83.0376281738281 94.3025741577148 64.9610061645508 62.420295715332 48.8809471130371 84.7544784545898 91.0916519165039 108.111503601074 72.5952911376953 85.8879165649414 69.4328155517578 110.240242004395 79.6004943847656 91.613395690918 88.3318557739258 68.5344314575195 62.8213996887207 88.7567977905274 69.1807250976563 98.3365859985352 55.7651519775391 115.914291381836 1864.780029297 1119.064941406 1570.856567383 1539.287231445 1395.451416016 2064.320068359 1223.838256836 1754.846923828 2039.364013672 1708.346313477 1264.645385742 1414.162963867 1602.120239258 1634.965087891 1585.536499023 1161.269042969 1186.580810547 1286.986206055 1555.419433594 1028.346191406 2101.751708984 1132.374389648 1186.871459961 1246.907836914 2076.219482422 1252.50769043 1120.511962891 1453.782104492 1553.20324707 1606.735107422 2032.313354492 1610.2265625 1752.747680664 1367.116455078 1331.233520508 1131.002197266 1632.345703125 1712.731933594 1919.928100586 1472.231201172 1646.866577148 1429.157958984 1945.048706055 1565.480102539 1719.265869141 1677.961303711 1416.803344727 1336.930297852 1683.338378906 1425.696533203 1802.383178711 1234.844604492 2011.229858398 117.667030334473 121.543304443359 51.1807899475098 60.6623268127441 42.1781120300293 53.8506088256836 56.4745903015137 118.422210693359 117.466903686523 81.1637649536133 76.1972045898438 94.7496948242187 60.6153297424316 98.3080673217773 41.195728302002 75.9786987304688 49.1509399414062 65.1816787719727 87.3321533203125 97.8822479248047 72.7807846069336 52.0032119750977 77.9495010375977 74.3205108642578 92.0085906982422 99.9529342651367 62.6687431335449 123.803344726563 107.460540771484 56.3727951049805 104.547630310059 110.882026672363 115.948295593262 83.4180297851563 51.6290550231934 103.790473937988 63.7881546020508 122.627326965332 42.9954948425293 96.91552734375 56.3998069763184 75.8466949462891 107.348793029785 115.31861114502 119.478782653809 50.7598266601562 110.765586853027 58.6449737548828 46.9302139282227 110.949340820313 84.1982803344727 59.7644081115723 94.6690444946289 2031.453613281 2075.826660156 1166.205322266 1306.119995117 1025.089477539 1206.416992188 1245.295532227 2040.136108398 2029.149536133 1585.909790039 1520.534912109 1758.283569336 1305.4453125 1802.034667969 1009.109985352 1517.626586914 1135.163085938 1370.21081543 1665.276977539 1796.827270508 1474.737915039 1178.665161133 1543.758056641 1495.46472168 1724.206542969 1822.079956055 1334.763549805 2101.479980469 1912.213500977 1243.798583984 1877.499511719 1952.590332031 2011.623046875 1615.14050293 1173.004882813 1868.423583984 1350.611328125 2088.150878906 1038.290771484 1784.976928711 1244.195922852 1515.868286133 1910.887573242 2004.333374023 2052.252929688 1159.801757813 1951.223022461 1277 1100.707763672 1953.380615234 1625.196411133 1293.19934082 1757.285644531 100.352523803711 47.5153007507324 81.0268859863281 63.2914199829102 97.7875900268555 42.930980682373 41.4131202697754 77.9705123901367 78.7923583984375 79.0535049438477 111.65673828125 114.587966918945 102.115234375 106.029312133789 81.1692123413086 111.832077026367 68.9500198364258 104.723999023438 106.956192016602 53.5361747741699 111.604476928711 111.379043579102 117.932723999023 77.7156143188477 85.4914474487305 103.892288208008 100.371788024902 96.432014465332 70.6088333129883 89.7768630981445 106.510322570801 72.4295272827149 60.3300323486328 112.257011413574 53.8574905395508 46.3008422851563 69.6001358032227 80.2949523925781 91.426155090332 71.7075881958008 98.6511306762695 68.6100082397461 70.2937545776367 40.6889228820801 58.9369621276856 119.381927490234 42.7363967895508 48.0398826599121 1826.932861328 1109.837402344 1584.126220703 1343.590576172 1795.668701172 1037.251953125 1012.656921387 1544.035522461 1554.866455078 1558.300170898 1961.674804688 1995.858276367 1848.264160156 1895.196777344 1585.980712891 1963.727661133 1422.525268555 1879.610473633 1906.225708008 1201.716308594 1961.0625 1958.420898438 2034.510375977 1540.668579102 1641.794555664 1869.645507813 1827.166503906 1779.03515625 1445.250244141 1696.211425781 1900.924194336 1469.989135742 1301.345825195 1968.69921875 1206.519775391 1090.844726563 1431.452880859 1574.572021484 1716.922363281 1460.204833984 1806.224487305 1417.844726563 1440.947509766 1000.81652832 1281.235229492 2051.143798828 1034.115356445 1117.991088867
