Master the Data: Advanced Environmental Recycling Technologies $($AERT$)$ sells plastic$/$wood composite decking through

its brand name, Choicedek. AERT sells its product through Lowe's and sells most of its products in the spring and summer,

when consumers install or remodel their decks.

The dataset provides some weekly sample data for its costs in Lab $8-3$ Data.xlsx$.$

Software needed

Excel

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $8-3$ Data.x$|$sx

Perform the Analysis: Refer to Lab $8-3$ in the text for instructions and steps for each of the lab parts.$|$

Answer the following questions based the details provided.

#$1.$ options

a$.$$$0\mathrm{.}427$ per board foot

b$.$$$4\mathrm{.}858$ per board foot

c$.$$$10\mathrm{.}519$ per board foot

#$2.$ options

a$.$ Materials are more expensive during busy season

b$.$ Materials are less expensive during busy season

c$.$ More overtime by workers since they need to produce more product

d$.$ Less overtime by workers since they need to produce less product

#$3.$ options

a$.$ Fixed costs

b$.$ Mixed costs

c$.$ Variable costs

#$4.$ options

a$.$ Busy Season costs

b$.$ Total company costs

c$.$ Total production Cost

d$.$ Total production in board feet

#$5.$ options

a$.($$$0\mathrm{.}427*$ Production bard feet$)+($$$4,858\mathrm{.}671*$ busy season$)$

b$.$ $$10,519\mathrm{.}019+($$$0\mathrm{.}427*$ production board feet$)$

c$.$ $$10,519\mathrm{.}019+($$$0\mathrm{.}427*$ production bard feet$)+($$$4,858\mathrm{.}671*$ busy season$)$ Master the Data: Advanced Environmental Recycling Technologies $($AERT$)$ sells plastic$/$wood composite decking through its brand name, Choicedek. AERT sells its product through Lowe's and sells most of its products in the spring and summer, when consumers install or remodel their decks.

The dataset provides some weekly sample data for its costs in Lab $8-3$ Data.xlsx$.$

Software needed

$-$ Excel

$-$ Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $8-3$ Data.xlsx

Perform the Analysis: Refer to Lab $8-3$ in the text for instructions and steps for each of the lab parts.

Answer the following questions based the details provided.