Forastero Farms is a leading producer of cocoa beans in South America. It produces two main products from the cocoa bean: sunscreen (from cocoa butter) and hot cocoa mix (from cocoa powder). As the cost accounting supervisor, you are tasked with allocating the joint costs of production to both products. Using data in the attached Option 1 Excel file : 1. Calculate product costs using the net realizable value method (NRV). 2. Using the cost allocations from requirement 1 , create a product-specific income statement. Follow the instructions you see on the Data tab of the worksheet. Show all calculations within the cells of the Excel spreadsheet. This means that you must use formulas and links so that your thought process can be examined. Ensure you include a detailed explanation of each journal entry that you make or do not make on each date to convey your thought process as well. There should be no hard coding of solutions