Answer the question

Joint cost allocation physical units method Board-It, Inc., produces the following types of 2 x 4 x 10 wood boards: washed, stained, and pressure treated. These products are produced jointly until they are cut. One batch produces 50 washed boards, 30 stained boards, and 20 pressure treated boards. The joint production process costs a total of $620 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. Joint Product Allocation Washed Stained Pressure treated Totals Joint cost allocation - physical units method Board-It, Inc., produces the following types of 2 x 4 * 10 wood boards: washed, stained, and pressure treated. The following data is provided: Joint product Washed Stained Pressure treated DATA Boards per Batch 50 30 Joint Costs $620 620 620 20 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. Proportion Allocation Formulas Joint product Washed Stained Pressure treated Totals