Management accounting excel mock

dingzheng

I cannot understand the question and the answer, can anyone help me. for example, what is c15 here.

Pian32

C15 = Total sales in Oct (C7) minus already received (C8)
D16= Total sales in Nov (D7) minus already received (D8)
D17= 60% of sales in December
E17= 40% sales in december
E18 = 60% of sales in January

The little table at the top is telling you when to expect receipts. You get the remaining Oct sales in December, the remaining Nov in january and the other months are split 60/40 as appropriate

wilburnet

Hi, which Mock is this from?

dingzheng

2022, Management accounting, aat mock

dingzheng

Hi,Pian32, really appreciate your help.