Topics

(Financial Management Analyst at U.S. Department of Defense) I work in the Financial Management department of a U.S. government agency. We use a MS Excel-based budgeting tool with which we record allocations of and expenditures from program budgets. In addition to budget allocations and expenditures, I need to incorporate in this...

(Financial Analyst) I need career advice from experts if I may. BACKGROUND: I came to USA as an MD and was not able to get into medical residency to pursue my career as an MD. I decided to go into the Healthcare Administration sector and ended up working as a Grants Financial Analyst in the...

(Financial Controller at CFG) Have you heard of cost allocation on this basis in management accounts and how should it work? This is to allocate revenue to each business line

(Entrepreneur) Hey all, I am currently struggling trying to figure out how to best structure my sales forecast. A small part of our business we have a fixed unit price and a goal for how many we want to sell of each per month at a predefined unit price. The main part of our business...

(Head of Client Service at SkyStem) Here is a story of what people used to do with Excel, back in the day… (here’s the full article) Forgive me if I now divert into telling you a quick story about my time spent on the Microsoft Excel team way back in 1991. (Yes, I know you were not born yet...

(Accounting Manager at Calypto Design Systems) I am working on a budget for next year need to figure out what is the revenue requirement for each GM and net income. For example, operating expense % over revenue is at 27% and GM is at 27%. For Net income of $1000, how much revenue require? If the GM is 1% lower which...

(Financial Reporting Manager) Has anyone used the Vena Solutions for Budgeting or Reporting? Thoughts?

(Senior Accountant) Hello- Would you please let me know if there is a way by using excel function to pull: 1) invoices from a string of texts below? 2) Invoices related to the associated companies only? i.e. I would like to pull only invoice started with CO#3 and disregard the all others sales...

(Managing Director at The Pros & The Cons) I need to include a table with prox 100 rows and 5 columns in html email. How do I create it so that people can click on the column top, header, row to sort by that column? Col 1, Col 2, etc.