Can u help me with this assignment? "Based on the products/services from each of your individual assignments, you are collectively required to prepare flexible budgets, undertake variance analyses, perform cost-volume profit (CVP) analysis, and consider transfer pricing options based on the standard cost and selling price you determined for your individual products/services in your individual assignment" i take docmarts boots for this one.

Based on the above information, prepare:

1. A static profit and loss statement budget at budgeted sales level for the month for each of your products/services.
2. A flexible profit and loss statement budget using actual sales level for the month for each of your products/services.
3. Actual profit and loss statement for the month for each of your products/services.
4. Calculate the significance levels for each of your products/services and classify them as either favourable or unfavourable and select two of the highest significance levels to perform variance analysis (one variance analysis for each group member's products/services).

And it needs excel calculation for this. can u also help me with the calculation?