Assignment #$8$ deals with the Excel tools we used in Module $6.$ Make sure you have worked on the sample questions included in this pdf file before answering the questions contained in the Canvas assignment link. Note: Once you open the assignment link, you will have one hour to answer all of the questions.

Problem

ClassicPanel Inc. manufactures three types of pressed paneling from pine and spruce: Western, Tuscan, and Colonial.

Production requirements and profits per unit are summarized in the table below. The panel sheets must be cut and pressed. Each sheet of Western requires $5$ pounds of pine, $2$ pounds of spruce, $1$ hour of cutting, and $1$ hours of pressing. A sheet of Tuscan requires $4$ pounds of pine, $5$ pounds of spruce, $1$ hour of cutting, and $4$ hours of pessing. Each sheet of Colonial requires $4$ pounds of pine, $2$ pounds of spruce, $2$ hours of cutting, and $2$ hours of pressing.

$\backslash$table$[[$Resource$,$Western,$\backslash$table$[[$Panel$],[$Tuscan$]],$Colonial$],[$Pine $($lb$/$un$.),5,4,4],[$Spruce $($lb$./$un$.),2,5,2],[$Cutting $($hr$./$un$.),1,1,2],[$Pressing $($hr$/$un$.),1,4,2],[$Profit$/$un$.,$$$10\mathrm{.}00,$$$24\mathrm{.}00,$$$16\mathrm{.}00$