Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Budgeting
- This topic has 6 replies, 2 voices, and was last updated 9 years ago by John Moffat.
- AuthorPosts
- January 20, 2015 at 8:26 am #223048
Treehorn prepares budgets on a quarterly basis.each quarter consists of 13 weeks with five working days per week.
It is treehorns policy to maintain an inventory of finished goods at the end of each quarter equal to five days Demand of the next quarter.
Forecast sales units for the next five quarters are
Quarter 1 1950000
Quarter 2 2275000
Quart r 3 3250000
Quart r 4 2275000
Quarter 5 1950000Whn calculating the production budget how do we calculate the closing inventory? Ans: 2275000x5days/13 weeksx5 days=175000
But when i calculate
2275000x 5days/91days(13weeks)x5days i get 625000.
Where is the mistake?
Thanks in advanceJanuary 20, 2015 at 10:08 am #223063Your mistake is the 91 days. You have taken 13 weeks with 7 days a week.
However there are only 5 working days a week, and so the number of working days in a quarter is 13 x 5 = 65 days.January 20, 2015 at 10:12 am #223065Ohhh!!!ok sir…:)
Im still not getting the ans
can u pls write the equationJanuary 20, 2015 at 10:14 am #223066Oh no need…:i got it
January 20, 2015 at 12:54 pm #223077Great 🙂
January 20, 2015 at 5:47 pm #223112What if the question says
It is treehorns policy to maintain an inventory of finished goods at the end of each quarter equal to four days Demand of the next quarter. And each quarter consists of 13 weeks with 5 working days.is this correct?
2275000×4/(13×5)
January 20, 2015 at 7:27 pm #223121Yes – that would be correct 🙂
- AuthorPosts
- You must be logged in to reply to this topic.