The file named Varianceanalysis.xlsx contains monthly profit forecasts and monthly actual sales. The sales variance for a

Question:

The file named Varianceanalysis.xlsx contains monthly profit forecasts and monthly actual sales. The sales variance for a month equals (Actual Sales – Predicted Sales) / Predicted Sales. Highlight in red all the months with a favorable variance of at least 20 percent; highlight in green all the months with an unfavorable variance of more than 20 percent.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 60% (10 reviews)

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question