please answer with complete solution kn microsoft excel

Nicdao Manufacturing Corporation produces three Products - Product G, Product O, and Product E. The number of units sold for December 2020, the Unit Selling Price, and Unit Variable Cost for each product is shown in the table. In this case, UVCs are separable costs associated with each product. Product E Product G 500 P 100 Producto 600 UNITS 700 USP P 200 P 100 90 UVC P 60 P 100 As seen in the diagram, there are two Departments involved in processing Products G, O, and E. The COO ensures that the cost for Department 1 and Department 2 are maintained in a ratio. In this case, Department 1 it 4x the cost of Department 2. The total Net Income for December 2020 is P 27,000. Product G Units: 500 USP: P 100 UVC: 60 Department 2 Input Fixed Cost = ? Producto Units: 600 USP: 200 UVC: 100 Department 1 Product G Units: 500 USP: P 100 UVC: 60 Department 2 . Input Fixed Cost = ? Department 1 Producto Units: 600 USP: 200 UVC: 100 Fixed Cost = ? Product E Units: 700 USP: 100 UVC: 90 Find: 1. The Total Contribution Margin for December 2020? 2. The Fixed Cost (Joint Cost) for Department 1? 3. The Unit Cost (Considering VC and FC) for Product G