Please provide calculations or cell references, thank you!

Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an annual return on the assets invested at a rate of: The company has the following amount invested in the business: 16% $6,000,000 The annual budgeted costs for next year are: Support Services Variable costs $400,000 Fixed costs 1,900,000 The annual budgeted hours for next year are: Consulting services 50,000 hours You must use cell references for all calculations. Required: 1. Determine the Target profit for the company. 2. Determine the markup on variable costs in percentage terms. 3. Determine the variable cost per hour. 4. Determine the revenue per hour that will be charged if variable costs is the basis for markup. 5. Determine the markup on total costs in percentage terms. 6. Determine the total cost per hour. 7. Determine the revenue per hour that will be charged if total costs is the basis for markup. 8. Explain why answers 2-4 in comparison to 5-7 are the same or different 9. Discuss the advantages and disadvantages of using a cost-based pricing model. You need to include an outside reference that supports your discussion on advantages and disadvantages of using a cost-based pricing model. Make sure you include the reference in APA style. Enter your response in the textbox below. Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an annual return on the assets invested at a rate of: The company has the following amount invested in the business: 16% $6,000,000 The annual budgeted costs for next year are: Support Services Variable costs $400,000 Fixed costs 1,900,000 The annual budgeted hours for next year are: Consulting services 50,000 hours You must use cell references for all calculations. Required: 1. Determine the Target profit for the company. 2. Determine the markup on variable costs in percentage terms. 3. Determine the variable cost per hour. 4. Determine the revenue per hour that will be charged if variable costs is the basis for markup. 5. Determine the markup on total costs in percentage terms. 6. Determine the total cost per hour. 7. Determine the revenue per hour that will be charged if total costs is the basis for markup. 8. Explain why answers 2-4 in comparison to 5-7 are the same or different 9. Discuss the advantages and disadvantages of using a cost-based pricing model. You need to include an outside reference that supports your discussion on advantages and disadvantages of using a cost-based pricing model. Make sure you include the reference in APA style. Enter your response in the textbox below