can you solve the top problem set using excel

\begin{tabular}{|c|c|c|c|c|c|} \hline & A & 8 & c & 0 & E \\ \hline 1 & Season & Fall & Winter & 5pring & Summer \\ \hline 2 & Forecast & 10100 & 8100 & n00 & 12100 \\ \hline 3 & beginning inventory & 505 & =012 & 0 & =012 \\ \hline 4 & Productian requined & =02A3 & =02Cl & -02 & \\ \hline 5 & Production hours required & +84/0.5 & C405 & =0vos & ats/os \\ \hline 6 & Production hours avaitable & =30a60 & & & .06 \\ \hline 7 & Overtime hous & 0 & =csco & 0 & 0 \\ \hline B) & Temworkers & 0 & 0 & 0 & \\ \hline 9 & Tem worker available & =00ar60 & 0 & 0 & \\ \hline 10 & Total hours wallable & =86 & =CS & =06 & Afes: \\ \hline 11 & Actual production & & .cio*os & =0:005 & 810+05 \\ \hline 12 & Ending inventory & 811+0362 & 0 & =0110302 & 0 \\ \hline 13 & Workers tived & & 0 & 0 & sta \\ \hline 14 & Wotkers loid oft & & 0 & 0 & atiI \\ \hline 15 & Costs & Fall & Winter & Spring & Sumnier \\ \hline 36 & Straight tirnme & =586 & & 506 & \\ \hline 17 & owertirne & 0 & 4CrB & 0 & 0 \\ \hline 10 & imentory & +0 & +0 & =012+5 & 0 \\ \hline 19 & Bachorder & 2005+10 & =0 & + & =0 \\ \hline 20 & Firing & 0 & 0 & 0 & \\ \hline 21 & Layoti & 0 & 0 & 0 & 414:200 \\ \hline 22 & Total cost & =90MB16ean & Sumatcat & =5 SUMO1602x) & -5UMELG:2al \\ \hline 23 & Annual cost & =sume22cm & & & \\ \hline \end{tabular} Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,100; winter, 8,100; spring. 7,100; summer, 12,100. Inventory at the beginning of fall is 505 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotlated with the union an option to use the regular workforce on overtime during winter or spring only if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff, $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hout, with eight hours per day and 60 days per season. In each quarter, produce to the full output of your regular workforce, even if that results in excess production. In Winter and Spring. use overtime only if needed to meet the production required in that quarter. Do not use overtime to buld excess inventory in prior seasons expressly for the purpose of reducing the number of temp workers in Summer. (Leave no cells blank - be certain to enter "or wherever required, Negative values should be indicated by a minus sign. Round up "Number of temp workers, Workers hired and Workers laid off" to the next whole number and all other answers to the nearest whole number.)