Organic Fertilizer Products

GFA has a contract with four local cities to acquire the compost that is recycled by city residents. GFA only pays for transportation from the compost collection facility. Once the compost is delivered to GFA's location, it is processed into three different kinds of organic fertilizer:

GreenBoost Compost Blend: nutrient$-$rich organic fertilizer made from carefully selected composted organic materials, including plant matter, animal manure, and agricultural residues. This is the most popular fertilizer as it is good for all types of crops.

Organicharvest Compost Tea: a liquid organic fertilizer produced through the process of aerated compost tea brewing. This fertifizer is primarily used for hydroponic and greenhouse farming.

BioGrow Organic Compost Pellets; slow$-$release organic fertilizer pellets made from premium$-$quality composted materials and natural binders. This fertilizer is used by home gardeners and landscapers.

These products are a result of a joint process that involves the removal of noncompostable materials from the raw compost, mixing the compost with various chemicals that accelerate the decomposition process, and then mixing the compost with organic soil and nutrients. This results in the GreenBoost Compost Blend product. Some of this product is further processed to create the Organicharvest and BioGrow products.

In $2023,$ the output at the split$-$off point was $500,000$ kilograms of GreenBoost. Each kilogram of GreenBoost retails for $$6$ per kilogram.

The joint costs of processing the compost in $2023$ was $$1,020,000.$ GFA used $100,000$ kilograms of the GreenBoost to create OrganicHarvest, and $60,000$ kilograms to create BioGrow. There is a $25\%$ loss of volume when creating the BioGrow product, and a $50\%$ loss of volume when creating Organicharvest.

The following table outlines the process:

$\backslash$table$[[$Products$,\backslash$table$[[$Volume at$],[$split$-$off $($in$],[$kilograms$)]],\backslash$table$[[$Separable$],[$processing$],[$costs$]],\backslash$table$[[$Volume after$],[$additional$],[$processing $($in$],[$kilograms$)]],\backslash$table$[[$Revenue$],[$per$],[$kilogram$]]],[$GreenBoost$,350,000,,,$$$6$

Calculate allocated joint cost using excel

Can you show calculation