Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. 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.

image text in transcribedimage text in transcribedimage text in transcribed

9. 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)? (2 points) 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)? (2 points) c. What is the value of the marginal product of labor (VMPL) for the 84th worker-hour (round to the nearest whole number)? (2 points) d. What might be the problem with inferring that the 92nd worker-hour increased revenue by approximately $10 using only this data? (2 points) 1:12 71 100% FroYoData(3) BI U ABC 123 - | | x 116.83374786377 C D E F G H . 2 3 4 5 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 4 45 46 47 48 A B Labor (daily full-time equivalency) Revenue (dollars) 70.58866882 1444.975098 116.8337479 2021.85144 98.06056976 1799,008789 104.5057678 1876.998169 108.2531967 1921.605225 41.69612503 1017.265137 45.92435074 1084.92334 40.24022675 993.4453125 1.84254456 1722.13147 118.473465 2040,724731 51.61548996 1172.799438 43.72869492 1050.061401 7.67609406 1794.303467 6.61766815 1390.261963 44.57986069 1063.64367 8.63796234 1681835571 5,07977295 1636,519775 7.66564941 1262.74353 50.75442886 1159,719604 105.8580475 1893.155396 108.6161575 1925.898071 74.67721558 1500.24585 101.2191772 1837.435913 79.75547791 1567511353 61.57873917 1319.241211 81.77251434 1593.829834 114.7308273 1997516846 102.2523422 1849.918213 92.87984467 1735.074097 79.16140747 1559.717773 61.0137825 1311.159912 6.49900055 1388.610596 105.7538147 1891.912476 83.08690643 1610.863525 118.7395477 2043,779053 8.37324524 1802.831055 75.82983398 1515.643555 77.4044189 1539,674927 101.8510818 1845.075439 109.4771576 1936.062622 116.4651413 2017.596436 41.97190475 1021.745667 83.14092255 1611.561646 82.10249329 1598.114624 5722221375 1256.261841 89,49695587 12.68396 73.727928816 1487.504761 Sheet1 + 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 199 78.26702881 88.77202606 75.05819702 53.61935043 60.2845726 72.509758 119.2539063 111.5030136 47.29808044 73.53549194 74.45330811 62.81051636 93.96447754 75.56534576 78.86396027 56.94566345 93.17984009 40.84555435 82.76678467 118.1278381 104.8031616 64.12107849 45.95258331 40.72844315 40.61610794 49.34358597 1547.947632 1683.531006 1505.344116 1202.960571 1300.692139 1471.074585 2049.677246 1959.873779 1106.452271 1484.915405 1497.245605 1336.775879 1748.555786 1512.11731 1555.808228 1252.210815 1738.808105 1003.383362 1606.723267 2036.753784 1880.557617 1355.306641 1085.36792 1001.4646 999.6222534 1138.127319 9. 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)? (2 points) 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)? (2 points) c. What is the value of the marginal product of labor (VMPL) for the 84th worker-hour (round to the nearest whole number)? (2 points) d. What might be the problem with inferring that the 92nd worker-hour increased revenue by approximately $10 using only this data? (2 points) 1:12 71 100% FroYoData(3) BI U ABC 123 - | | x 116.83374786377 C D E F G H . 2 3 4 5 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 4 45 46 47 48 A B Labor (daily full-time equivalency) Revenue (dollars) 70.58866882 1444.975098 116.8337479 2021.85144 98.06056976 1799,008789 104.5057678 1876.998169 108.2531967 1921.605225 41.69612503 1017.265137 45.92435074 1084.92334 40.24022675 993.4453125 1.84254456 1722.13147 118.473465 2040,724731 51.61548996 1172.799438 43.72869492 1050.061401 7.67609406 1794.303467 6.61766815 1390.261963 44.57986069 1063.64367 8.63796234 1681835571 5,07977295 1636,519775 7.66564941 1262.74353 50.75442886 1159,719604 105.8580475 1893.155396 108.6161575 1925.898071 74.67721558 1500.24585 101.2191772 1837.435913 79.75547791 1567511353 61.57873917 1319.241211 81.77251434 1593.829834 114.7308273 1997516846 102.2523422 1849.918213 92.87984467 1735.074097 79.16140747 1559.717773 61.0137825 1311.159912 6.49900055 1388.610596 105.7538147 1891.912476 83.08690643 1610.863525 118.7395477 2043,779053 8.37324524 1802.831055 75.82983398 1515.643555 77.4044189 1539,674927 101.8510818 1845.075439 109.4771576 1936.062622 116.4651413 2017.596436 41.97190475 1021.745667 83.14092255 1611.561646 82.10249329 1598.114624 5722221375 1256.261841 89,49695587 12.68396 73.727928816 1487.504761 Sheet1 + 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 199 78.26702881 88.77202606 75.05819702 53.61935043 60.2845726 72.509758 119.2539063 111.5030136 47.29808044 73.53549194 74.45330811 62.81051636 93.96447754 75.56534576 78.86396027 56.94566345 93.17984009 40.84555435 82.76678467 118.1278381 104.8031616 64.12107849 45.95258331 40.72844315 40.61610794 49.34358597 1547.947632 1683.531006 1505.344116 1202.960571 1300.692139 1471.074585 2049.677246 1959.873779 1106.452271 1484.915405 1497.245605 1336.775879 1748.555786 1512.11731 1555.808228 1252.210815 1738.808105 1003.383362 1606.723267 2036.753784 1880.557617 1355.306641 1085.36792 1001.4646 999.6222534 1138.127319

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Detailed note on the contributions of F.W.Taylor

Answered: 1 week ago