accounting building blocks project managerial accounting excel file

9 sheets to be done. please.

 

prof emailed this:

 

my recommendation for pages 7-8-9-10 do one by one. starting on number 7, then submit and make sure you have the correct answer before proceding to number 8-9 or 10, because the following may happen since we are working with an excel file it is formatted to correct formulas, so your formulas for number 8-9-10 may be correct but the calculations for the first number was incorrect. 

please follow my advice and submit the file, upon completion of each sheet and make sure you are in the right track.

you should by now have worked on several pages of your project and I believe you need to be extra careful when calculation the budgets.

for 7.01: You have to start with the planned sales (given at the top) and the desired ending inventory. They tell you in the fact pattern that they want to decrease finished goods by 20%. If you look at the Balance Sheet you will see that they had 3,000 items in finished goods last year. They want to decrease that number by 20% which would be 600. Therefore, the desired ending inventory is 2,400 (3,000 – 600).