please complete excel portion

Obj. 5 Rosie's Roses produces three colors of roses: red, white, and peach. The roses are produced jointly in the same garden, and aggregately cost a total of $110 per harvest. One harvest produces 80 red roses, 70 white roses, and 50 peach roses. Rosie also noted that the peach roses require a fertilizer that is twice as expensive as the fertilizer required by the white and red roses. However, due to the structure of the shared garden space, the more expensive fertilizer is used for all flower types in a joint production process. INSTRUCTIONS 1. Using the physical units method, allocate the joint costs of production to each product. 2. Using the weighted average method, allocate the joint costs of production to each product. 3. = Is the cost of the type of fertilizer required by each type of rose a good weight factor