Forecasts using excel, circular references and formulae
Currently doing monthly forecasts. Cost of sales in based on a percentage of turnover. Cost of sales consists of opening stock, purchases, carriage, packaging less closing stock. Closing stock is a manually entered figure, that becomes the opening stock for the next month etc, using + 'closing stock of previous month' cell.
I want a formula for purchases, that would leave the cost of sales as the stated figure based on % of turnover, that can accomodate any changes I make in the closing stock figure. (The purchases figure then copies into my creditor control account).
I am having problems here with circular references, but wonder if anyone know a way round it please?
I note you can allow the calculation in Excel 2007 by going into formulae and tools, but feel uncomfortable with this.
Thanks for everyones help in advanace. Again!
- Tax deductable portion of home rental cost 185 9
- JIEB Exams 127 1
- RTI 82 1
- Christmas party 91 1
- Am i Liable? 87 4
- Fee agreed but client disagrees on amount 735 10
- Checking a contract 287 8
- Flat Rate Scheme 308 15
- Altered PAYE cheque 223 5
- deleting customers on Sage 50 154 7
- VAT on garage rent 319 14
- Value-shifting 62 1
- Pattern for CTA 205 4
- Debiting private use proportion to directors loan account 447 18
- SDLT exemptions/reliefs 80 2
- Incorrect Accounts. Is it worth taking action against the old accountant? 220 3
- Film Partnership Enquiries - am I just unlucky? 235 5
- EBT 177 1
- Giving a seminar 528 28
- Joint Filing Help 107 1
- Desperately seeking Susan, Sam or anyone with any other name 1,206
- Experience with Islamic investor following Sharia-compliant rules? 601
- Darwinpay Partnership Assessment 405
- S464A Charge to tax: conferring benefit & BIK 313
- Bank interest in 'near' facility recall situation 192
- Alphabet shares 188
- Agent fees to sell business 187
- ACCA continuity of practice arrangement needed 181
- Quirky thread of the year: Community Awards 173
- VAT codes In Sage. Am I correct? 162