answer please

Joint cost allocation market value at split-off method Man O'Fort Inc. produces two different styles of door handles, standard and curved. The door handles go through a joint production molding process costing $30,000 per batch and producing 1,800 standard door handles and 900 curved door handles at the split-off point. Both door handles undergo additional production processes after the split-off point, but could be sold at that point: the standard style for $4 per door handle and the curved style for $2 per door handle. 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 Determine the amount of joint production costs allocated to each style of door handle using the market value at split-off method. Round your answers to the nearest dollar. Joint Product Allocation Standard door handle Curved door handle Totals Joint cost allocation - market value at split-off method D E F G Man O'Fort Inc. produces two different styles of door handles, standard and curved. The door handles go through a joint production molding process. Both door handles undergo additional production processes after the split-off point, but could be sold at that point. The following data is provided: Joint product Standard door handle Curved door handle DATA Door Handles at Selling Price per Door Split-Off Handle at Split-Off 1,800 $4 900 2 Joint Costs $30,000 30,000 Using formulas and cell references, perform the required analysis, and input your answers into the B, C, and D columns. Use the blue entry cells (B13:C14, B15) for intermediate calculations. Transfer the numeric results for the green entry cells (D13:D15) into the appropriate fields in CNOWV2 for grading. Total Market Value at Split-Off Percent of Total Market Value at Split-Off Allocation Joint product Standard door handle Curved door handle Totals Formulas Data +