PLEASE PROVIDE EXCEL FORMULAS, NOT JUST THE ANSWERS!!

Marvis Lumber Mill produces large wooden beams for construction. Lately, a labor shortage has caused the amount of direct labor hours to diminish point where production will likely fall next quarter. Production supervisors are also worried that one of the saw mills may not make it to the end of th quarter, resulting in a reduction of machine hours. Data for Marvis Lumber Mill's products are below: Required: Fill out the charts and answer questions below concerning the constrained resources. Based on these calculations, put the beam types in priority order in accordance with profitability. Assume Labor Hours are the constrained resource and fill out the chart below: Based on these calculations, put the beam types in priority order in accordance with profitability. 11 2r 3r 4r 5r With Direct Labor hours as the constrained resource, fill out the chart below: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 51 52 c. A Note: All numbers should be shown as positive numbers. Use the two prior charts above to make the calculations for remaining hours: us 64 Fill out the chart below and use the final Remaining Hours above to calculate the units of the lowest priority pro 65 66 \begin{tabular}{l} 67 \\ 68 \\ 69 \\ \hline 7C \\ \hline 71 \\ \hline 72 \\ \hline 73 \end{tabular} 73 75 76 77 78 79 79 80 Assume Machine Hours are the constrained resource and fill out the chart below: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Marvis Lumber Mill produces large wooden beams for construction. Lately, a labor shortage has caused the amount of direct labor hours to diminish point where production will likely fall next quarter. Production supervisors are also worried that one of the saw mills may not make it to the end of th quarter, resulting in a reduction of machine hours. Data for Marvis Lumber Mill's products are below: Required: Fill out the charts and answer questions below concerning the constrained resources. Based on these calculations, put the beam types in priority order in accordance with profitability. Assume Labor Hours are the constrained resource and fill out the chart below: Based on these calculations, put the beam types in priority order in accordance with profitability. 11 2r 3r 4r 5r With Direct Labor hours as the constrained resource, fill out the chart below: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 51 52 c. A Note: All numbers should be shown as positive numbers. Use the two prior charts above to make the calculations for remaining hours: us 64 Fill out the chart below and use the final Remaining Hours above to calculate the units of the lowest priority pro 65 66 \begin{tabular}{l} 67 \\ 68 \\ 69 \\ \hline 7C \\ \hline 71 \\ \hline 72 \\ \hline 73 \end{tabular} 73 75 76 77 78 79 79 80 Assume Machine Hours are the constrained resource and fill out the chart below: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values