Joint cost allocation - physical units method Board-It, Inc., produces the following types of 2410 wood boards: washed, stained, and pressure treated, These products are produced jointly until they are cut. One batch produces 45 washed boards, 25 stained boards, and 30 pressure treated boards. The joint production process costs a total of s710 per batch. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Using the physical units method, allocate the joint production cost to each product. Round your answers to the nearest cent. Board-it, Inc., produces the following types of 2410 wood boards: washed, stained, and pressure treated. The following data is provided: Using formulas and cell references, perform the required analysis, and input your answers into the B and C columns. Use the blue entry cells (B14:B16) for intermediate calculations. Transfer the numeric results for the green entry cells (C14:C17) into the appropriate fields in CNOWv2 for grading