I am totally lost with this problem. I have tried time and time again to solve it, only to find out its not right. If any one could help show me how to solve I would appreciate it. This is a practice problem. The necessary information is attached below.
Excel file contains calculations of cost of production of different department and allocation this cost to different products.