FNSACC503 Assessment Task On Manage Budgets And Forecasts

Get Expert's Help on Assessment Writing

PART B

Task 2 Retail industry – Cost of goods sold

This task required the preparation of a Cost of Goods Sold Budget for the quarter July to September for the 7-inch Personal Tablet only. It was required that opening and closing values of inventory as well as purchases be included (as these values are later required for inclusion in Task 3).

One section in your formula/s could be improved by instead of typing the % required in (0.75), linking this back to the data sheet. This way, any amendment is only required on the data sheet rather than in multiple locations

Cost of Sales – working section is to be 50% of the expected Sales Forecast in the first row of data. For example if July Sales = 53,000 x 50% = ?.

Opening inventory is 75% of Cost of Goods sold. July COGS is 26,500 x 75% = ?.

Closing stock is going to be the same as the following months Opening inventory, for example we know that August’s opening inventory is, then this is going to be the same value as July’s closing inventory.

In the “Total column – Opening Inventory” this is the Opening inventory for the Quarter being your first Inventory value known which is July. It is not the addition of all Opening inventories.

In the “Total column – Closing Inventory” this is the Closing inventory for the Quarter being your last Inventory value known which is September. It is not the addition of all Closing inventories.

Our Academic Assistance: service is all about doing research and being good at it. The more research one will do, the better the paper will turn out.

Expert's Answer

Ask a New Question
*
*
*
*
*

Plagiarism Checker

Submit your documents and get Plagiarism report
Check Plagiarism

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

TOP

Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X