Calculating correct inventory value

ClaudiaL
1 Post
User
Australia
ClaudiaL

1Posts

0Kudos

0Solutions

Calculating correct inventory value

Good afternoon,

 

I've trying to complete my cert 4 of bookkeeping and one of the subject is about inventory.

 

I wasn't able to figure out why my current value of this particular item is different to the model answer. Using excel to do my calculation, I got my final current value of item 204 as $2056.627.

 

MYOB is giving me a different value - $2,324.29, I notice the discrepancy is starting from the entry dated 11/6/2016 - the average cost & current value start to change from that date. 

 

Can anyone give me a solution about this? I need my current value to be $2,056.63 to complete my assessment. (as shown on my spreadsheet below)

 

Thank you!

 

Kind Regards,

Claudia

 

MYOB .jpegCurrent Value.jpeg

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post