Ask Singapore Homework?

Upload a photo of a Singapore homework and someone will email you the solution for free.



Ask ManyTutors

Question

junior college 2 | H3 Maths
One Answer Below

Anyone can contribute an answer, even non-tutors.

Answer This Question
Faith Marie
Faith Marie

junior college 2 chevron_right H3 Maths

It's a Management Accounting paper.

Question: Prepare a revised performance report.

But.. how do you find the Budget for Salesmen's Commission on revised performance report?

Date Posted: 7 years ago
Views: 586
add a comment

See 1 Answer

Ask ManyTutors
done {{ upvoteCount }} Upvotes
clear {{ downvoteCount * -1 }} Downvotes
Jithendar
Jithendar's answer
1 answers (Tutor Details)
1st
Hi Faith Marie,

Excel contains (as stated below)

1) Derive the values based on the Initial Budget and Initial Actual values provided.
a) Derive excel column for D4=C3/C4, D5=C3/C5, D6=C3/C6,
b) Derive excel column for G4=G3/G4, G5=G3/G5, G6=G3/G6

2) In the "Revised Performance Report" derive the new values based on the Budget of 10,000,000
a) assign C12=10,000,000
b) Derive excel column C13=C12/D4, C14=C12/D5, C15=C12/D6, C16=(C12-(C13+C14+C15))
c) assign F12=10,000,000
d) Derive excel column F13=F12/G4, F14=F12/G5, F15=F12/G6, F16=(F12-(F13+F14+F15))

Note : Salesmen's commission for Budget 10,000,000 = 555,555.56 (refer the excel column C14)

Hope this helps !!!

Thanks & Regards,
Jithendar