Pls help, need excel form and answers 1-8. Thankyou. Marshall Manufacturing Company processes a raw material that results in three products: Product X, Product Y, and Product Z. In December, joint costs amounted to P300,000.00 Sales value at split-off: X - 100,000.00 Y - 140,000.00 Z - 160,000.00 Cost to process further: X - 90,000.00 Y - 50,000.00 Z - 60,000.00 Sales value after further processing: X - 240,000.00 Y - 175,000.00 Z - 285,000.00

Part 1 - Allocation

1. How much of the total joint cost will Product X absorb?

2. How much of the total joint cost will Product Y absorb?

3. How much of the total joint cost will Product Z absorb?

Part 2 - Costing - Financial Performance

4. Assuming all the units processed further were sold, how much is Product X's gross profit?

5. Assuming all the units processed further were sold, how much is Product Y's gross profit?

6. Assuming all the units processed further were sold, how much is Product Z's gross profit?

Part 3 - Costing - Independent Assumption

7. Independent assumption: Assume that total units after further processing of Product X were 30,000 units. How much is the cost per unit of Product X?

8. Following No. 7, If 18,000 out of 30,000 units were sold, how much is the cost of goods sold of Product X?

FORMAT of Answers:

AMOUNTS MUST HAVE 2 DECIMAL PLACES: EXAMPLE: 1.00 10.00 100.00 1,000.00 10,000.00 100,000.00 1,000,000.00 Round off Ratios/ percentages to whole percent. Examples: 100/300 = 33.33% you will use 0.33 to allocate the joint cost. 200/300 = 66.66% you will use 0.67 to allocate the joint cost.