After spending a few weeks contemplating the next move for LSI, Jason has come up with two options. The first option is to streamline the performance baseball apparel department by eliminating the less profitable products. Jason knows that the profitability of each product is limited by the number of operating hours available to his production staff. By cutting the fat LSI can focus on producing fewer products at a higher quality, which will lead to higher profitability. Jason has put together the numbers $($Appendix III$)$ from the performance baseball apparel production department. He would like you to create an optimal production schedule given the departmental constraints. He would also like you to determine the forecasted Operating Income Statement for each year until $2027.$ Ignore the impact of both taxes and the time value of money Appendix IIIStreamline ProductsPerformance Baseball Apparel$2024$ BudgetSocksShortsPantsT$-$shirtsJacketsSales $($units$)145,00085,000,45,000,50,00060,000,$Sales Price $($per unit$)$$$19\mathrm{.}99$ $$49\mathrm{.}99$ $$74\mathrm{.}99$ $$27\mathrm{.}99$ $$129\mathrm{.}99$ Direct Materials $($per unit$)$$$3\mathrm{.}78$ $$23\mathrm{.}28$ $$37\mathrm{.}16$ $$4\mathrm{.}32$ $$34\mathrm{.}04$ Direct Labour $($per unit$)$$$8\mathrm{.}91$ $$11\mathrm{.}01$ $$22\mathrm{.}79$ $$1\mathrm{.}88$ $$12\mathrm{.}78$ Variable Overhead $($per unit$)$$$3\mathrm{.}24$ $$3\mathrm{.}24$ $$3\mathrm{.}24$ $$3\mathrm{.}24$ $$3\mathrm{.}24$ Variable Sales $($per unit$)$$$3\mathrm{.}00$ $$7\mathrm{.}50$ $$11\mathrm{.}25$ $$1\mathrm{.}20$ $$19\mathrm{.}50$ Fixed Overhead $($per year$)$$$977,500$$$1,437,500$$$1,150,000$$$725,000$$$2,156,250$Fixed Sales Expenses $($per year$)$ $$125,000$$$125,000$$$125,000$$$125,000$$$375,000$Production Minutes $($per unit$)11610830$Production Hours $($per unit$)0\mathrm{.}0170\mathrm{.}2670\mathrm{.}1670\mathrm{.}1330\mathrm{.}500$Total Production Hours Available$61,200$Note to Students The above chart can be copied and pasted directly into MS Excel, so you do not have to re$-$create the entire chart. Appendix III NotesThe marketing department has used the anticipated demand to forecast their $2023$ sales unitsJason would like this analyzed for five years $(2024-2028)$ Jason has assumed that variable $2024$ forecasted numbers will increase by $5\%$ per year until $2028$ and fixed $2023$ forecasted numbers will increase by $3\%$ per year until $2028.$ If LSI is going to continue producing performance baseball apparel, he would like to spend $$20$M on January $01,2024,$ on a national advertising campaign explaining the benefits of LSI performance apparel. This would be a one$-$time cost. Jason is positive that the LSI executives will want a break$-$even calculation for each of the products you recommend producing. This will be used as a part of Jasons recommendation to the LSI executives. SG&A $=$ Sales, general and administrative. The budgeted numbers are looking forward from $20242028,$ the numbers in Section $2$ Government Grant are actual numbers from $2023.$ These numbers are to be used in isolation and are completely independent of each other. If it is decided that a department should not produce any products from $2024-2028$ due to capacity constraints, the Fixed Overhead costs will continue, however, the Fixed Sales Costs will not.