Problem Solving: IndividualPages $22-23($Problems: $1\mathrm{.}1$; $1\mathrm{.}5$; $1\mathrm{.}6$; $1\mathrm{.}8)$ Make sure you use the spreadsheet given below to work and submit all problems. I will need to see all details, formulas and completed answers to the questionsDownload the spreadsheet $-$ work on the problems $-$ upload the spreadsheet $1$In chuck sox makes wooden doxes i which to snio morocces, chuck and nis three emo ovees invest a oral o u nours oer dav makinone Zu ooxe What is their productivity?Chuck and his employees have discussed redesigning the process to improve efficiency. If they can increase the rate to $125$ per day, what will be their new What will be their unit increase in productivity per hour?What will be their percentage change in productivity?$1\mathrm{.}5$ George Kyparisis makes bowling balls in his Miami plant. With recent increases in his costs, he has a newfound interest in efficiency. George is intereste the productivity of his organization. He would like to know if his organization is maintaining the manufacturing average of $3\%$ increase in productivity per year? He has the Show the productivity percentage change for each category and then determine the improvement for labor$-$hours, the typical standard for comparison.Units producedLabor $($hours$)$Resin $($pounds$)$Capital invested $($$$)$Energy $($BTU$)$Last Year NoW$1\mathrm{.}0003001\mathrm{.}00027510,0003,00011,0002,8501\mathrm{.}6$ George Kyparisis $($using data trom Problem $1\mathrm{.}5)$ determines nis costs to be as followsLabor: $$10$ per hourResin: $$5$ per poundCapital expense: $1\%$ per month of investmentEnergy: $$0\mathrm{.}50$ per BTUShow the percent change in productivity for one month last vear versus one month this vear. on a multifactor basis with dollars as the common denominato$1\mathrm{.}8$ Lillian Fok is president of Lakefront Manufacturing, a producer of bicycle tires. Fok makes $1,000$ tires per day with the following resources Labor$\mathrm{.}4$uu nours oer dav @ $"$ic$.$ou oer noulkaw matera$)20,000$ pounds per day @ $$1$ per poundEnergy:Capital costs:$$5,000$ per day $$10,000$ per dayWhat is the labor productivity per labor$-$hour for these tires at Lakefront Manufacturing?What is the multifactor productivity for these tires at Lakefront Manufacturing?What is the percent change in multifactor productivity if Fok can reduce the energy bill by $$1\mathrm{.}000$ per day without cutting production or changing