Operational Auditing -- 2

I want you to calculate the full costs by traditional method

first work I want you to:
Pay attention building your tabs (presentation, formulas etc.)
• Calculate the Overhead rates (per Department)
• Calculate the Purchase costs for CDs and Vinyls
• Calculate the Production costs
• Calculate the Product costs
• Calculate the Operating results

The second work I want to you to:
All calculations must be presented with both total costs and unit costs
Pay a‚enࢢon in building your tabs (presentation, formulas etc.)
• Calculate the number (quantity) of cost drivers as a Total, then for ASK and for DO AND ASK
• Calculate the cost driver rates
• Calculate the indirect costs of “ASK” and of “DO AND ASK”
• Calculate the full costs of “ASK” and of “DO AND ASK”
• Calculate the operating results for “ASK” and “DO AND ASK”

I attached an excel sheet that I did it, so I want you to calculate as I did in the excel sheet step by step, and then you told me how you did it