The accounting manager has supplied you with this data and asked you to come up with the controllable margin total contribution

I have a single EXCEL ssignment that must be shown in excel with formats. here is the first assignment:

 

18-22 Phelps Glass Inc has reported the following financial data: net revenues of $10million, variable cost of $ 5 million, controllable fixed cost of $2 million, non-controllable fixed cost $1 million, and untraceable cost of $500,000. The accounting manager has supplied you with this data and asked you to come up with the controllable margin total contribution, cpc, and operating income.

 

Thank you.

 

The second assignment has been attached (multiple choice WORD)

  • attachment

    unit_6_test_06192015.docx