Download the Excel template and data file and complete the questions below. Bando Boards manufactures plywood and shelving out of raw pine timber. The timber is purchased directly from a landowner who grows and harvests the timber and delivers it to Bando in truckload quantities. Bando must strip the bark prior to cutting into its two products. Bando's sales mix and production ratio is about one plywood sheet for every shelving board. Due to recent significant increases in lumber prices, the company wants to examine if it should make a change to the sales and production mix. Due to competition in the lumber market, Bando has been increasing its selling price to cover its increase in raw timber costs, which are in line with competitors. Brando's average selling prices for each product during the past two month are provided here. (a) Determine the board foot for both plywood and shelving. (Round answers to 2 decimal places, e.g. 15.25.) Download the Excel template and data file and complete the questions below. Bando Boards manufactures plywood and shelving out of raw pine timber. The timber is purchased directly from a landowner who grows and harvests the timber and delivers it to Bando in truckload quantities. Bando must strip the bark prior to cutting into its two products. Bando's sales mix and production ratio is about one plywood sheet for every shelving board. Due to recent significant increases in lumber prices, the company wants to examine if it should make a change to the sales and production mix. Due to competition in the lumber market, Bando has been increasing its selling price to cover its increase in raw timber costs, which are in line with competitors. Brando's average selling prices for each product during the past two month are provided here. (a) Determine the board foot for both plywood and shelving. (Round answers to 2 decimal places, e.g. 15.25.)