Ask Singapore Homework?
Upload a photo of a Singapore homework and someone will email you the solution for free.
Question
junior college 2 | H3 Maths
One Answer Below
Anyone can contribute an answer, even non-tutors.
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: 6 years ago
Views: 537
See 1 Answer
done
{{ upvoteCount }} Upvotes
clear
{{ downvoteCount * -1 }} Downvotes
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
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
Date Posted:
6 years ago
360 Tutoring Program