Distribute Work hours, when the required Work Hrs are more than available Work Hrs

Hello

Please help me solve the issue mentioned in the spreadsheet(work allocation)

I have 4 different tasks , each take 25 min , hence need 1 hr 40 min to clear all.

The problem : I only have 60 mins

catch :

Task A -60% Priority
Task B -25% Priority
Task C-10% Priority
Task D-5% Priority

hence have to clear as many of them in the above proportion in 60 min

Hello

Thank you for the reply , that was good and will help

Could you help me further with the priority.

For example out of the 1 hour of production total items than can be cleared (A+B+C+D) is "X" and the rest will be pending (have to touch base and work on all may be not complete all )

I need to ensure 60% of "A" is cleared of the "X"
I need to ensure 25% of "B" is cleared of the "X"
I need to ensure 10% of "C" is cleared of the "X"
I need to ensure 5% of "D" is cleared of the "X"

Regards
Ashish