Loading...

Messages

Proposals

Stuck in your homework and missing deadline?

Get Urgent Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework Writing

100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Variance Report Manage budgets and financial plans

Category: Financial Management Paper Type: Report Writing Reference: APA Words: 1900

The budget is basically a measurement and setting of parameters that works according to the designed parameters and the measurement. The budget provides a guideline to the organization operations, and activities of the managers are provided through the variance reports. In the present work, based on the provided scenarios the financial management approaches are used to manage the resources effectively and efficiently through the main ingredients.

The main requirement is the classification of the budget plans and negotiation with the changes provided by the managers. The budget analysis provides risk identification, and contingency plan is designed to minimize and prevent the risk. The previously provided budget neglects some essential requirements, but still it is not achievable. The present variance report identifies the gap and provides some way to overcome. The basic accounting principles are used for the identification of the changes and negotiate with the manager. The organizational requirement is financial management, policies, procedures, and budget reports. For preparing the budget to meet a large scale, techniques and principles are needed.

The Budgeted gross profit is $(3100000-77500-200000-400000 = $ 242250). The expenses are constant and remained the same at $ 1401500 while the tax and the net profit before the interest was . The analysis defines that projected budget is defined accurately and the target of $ 1,000 000 can be achieved. The budget provides more than the target of the company. The cost allocation is required to define the needs and the importance of the sales volume according to the budgets. The equal cost is defined in the cost distribution. The cost allocation process distributes the cost of production and the actual consumptions for the production and the services. the expenses are used for the preparation of production and allocable cost.

The variance analysis provides information about the planned and actual activity. The variance analysis indicates a decline in the sales of the business by 6.45% for the present year. The sales volume changes defined decline in the direct cost of the sales by 5%. The commission on the sales was not determined properly, and the variance report has shown decline of 6.45. The reduction in wages was 0%, and it can be said that wages were planned accurately. The 10% reduction in the travel was defended for the short-term contracts that have no significant impact on the business. The decrease in the sales was 20% for the gross profit, and decline rate was less as 17.95%. The decrease in the general, as well as administrative expenses, is 50% that provides advantage to the business. The substantial increase in the employee expense involved the time wastage and distracted the contracted employees in the company. The predefined objectives of the incentive programs and the training programs are not achieved, and less variation in the marketing cost is observed, and fixed cost of advertisement expenses are determined (Yang, Northcott, & Sinclair, 2017). The cost of occupancy increased but required less attention for the employees due to reduction in the cost of the raw materials, water, paper, wastage, and electricity consumption. The lack of participation of employees in the budget-making process results in dissatisfaction with employee. The decrease in the net profit is 45%, and the projected profits can be decreased by 10%. The managers are required to consider effective measures to reduce the cost and to improve efficiency.

Details

Yearly

Q1

Q2

Q3

Q4

 

Budgeted

Actual

Variance

Variance

Budgeted

Actual

Variance

Budgeted

Actual

Variance

Budgeted

Actual

Variance

Budgeted

Actual

REVENUE

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Commissions

       77,500

       72,500

-6.45%

-14.29%

     17,500

   15,000

-10.00%

       25,000

     22,500

-14.29%

     17,500

     15,000

-14.29%

     17,500

   15,000

Direct wages fixed

    200,000

    200,000

0.00%

0.00%

     50,000

   50,000

0.00%

       50,000

     50,000

0.00%

     50,000

     50,000

0.00%

     50,000

   50,000

Sales

 3,100,000

 2,900,000

-6.45%

-14.29%

   700,000

 600,000

-10.00%

 1,000,000

   900,000

14.29%

   700,000

   800,000

-14.29%

   700,000

 600,000

Cost of Goods Sold

    400,000

    380,000

-5.00%

-5.00%

   100,000

   95,000

-5.00%

    100,000

     95,000

-5.00%

   100,000

     95,000

-5.00%

   100,000

   95,000

Gross Profit

 2,422,500

 2,247,500

-7.22%

-5.16%

   532,500

 505,000

-2.42%

    825,000

   805,000

32.39%

   532,500

   705,000

-5.16%

   532,500

 505,000

EXPENSES

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

General & Administrative Expenses

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Travel

       20,000

       22,000

10.00%

-20.00%

       5,000

     4,000

20.00%

         5,000

       6,000

20.00%

       5,000

       6,000

20.00%

       5,000

     6,000

Legal Fees

         5,000

         4,500

-10.00%

-16.00%

       1,250

     1,050

-8.00%

         1,250

       1,150

-8.00%

       1,250

       1,150

-8.00%

       1,250

     1,150

Bank Charges

            600

            700

16.67%

33.33%

           150

         200

33.33%

            150

           200

0.00%

           150

           150

0.00%

           150

         150

Office Supplies

         5,000

         4,000

-20.00%

-20.00%

       1,250

     1,000

-20.00%

         1,250

       1,000

-20.00%

       1,250

       1,000

-20.00%

       1,250

     1,000

Postage & Printing

            400

            500

25.00%

25.00%

           100

         125

25.00%

            100

           125

25.00%

           100

           125

25.00%

           100

         125

Dues & Subscriptions

            500

            600

20.00%

20.00%

           125

         150

20.00%

            125

           150

20.00%

           125

           150

20.00%

           125

         150

Telephone

       10,000

       11,200

12.00%

12.00%

       2,500

     2,800

12.00%

         2,500

       2,800

12.00%

       2,500

       2,800

12.00%

       2,500

     2,800

Repairs & Maintenance

       50,000

       45,000

-10.00%

-20.00%

     25,000

   20,000

0.00%

       25,000

     25,000

 

 

 

 

 

 

Payroll Tax

       25,000

       25,000

0.00%

0.00%

       6,250

     6,250

0.00%

         6,250

       6,250

0.00%

       6,250

       6,250

0.00%

       6,250

     6,250

Marketing Expenses

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertising

    200,000

    208,000

4.00%

4.00%

     50,000

   52,000

12.00%

       50,000

     56,000

0.00%

     50,000

     50,000

0.00%

     50,000

   50,000

Employment Expenses

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Superannuation

       45,000

       45,000

0.00%

0.00%

     11,250

   11,250

0.00%

       11,250

     11,250

0.00%

     11,250

     11,250

0.00%

     11,250

   11,250

Wages & Salaries

    500,000

    500,000

0.00%

0.00%

   125,000

 125,000

0.00%

    125,000

   125,000

0.00%

   125,000

   125,000

0.00%

   125,000

 125,000

Staff Amenities

       20,000

       23,000

15.00%

20.00%

       5,000

     6,000

0.00%

         5,000

       5,000

20.00%

       5,000

       6,000

20.00%

       5,000

     6,000

Occupancy Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Electricity

       40,000

       38,000

-5.00%

-20.00%

     10,000

     8,000

0.00%

       10,000

     10,000

0.00%

     10,000

     10,000

0.00%

     10,000

   10,000

Insurance

    100,000

    100,000

0.00%

0.00%

     25,000

   25,000

0.00%

       25,000

     25,000

0.00%

     25,000

     25,000

0.00%

     25,000

   25,000

Rates

    100,000

    100,000

0.00%

0.00%

     25,000

   25,000

0.00%

       25,000

     25,000

0.00%

     25,000

     25,000

0.00%

     25,000

   25,000

Rent

    200,000

    200,000

0.00%

0.00%

     50,000

   50,000

0.00%

       50,000

     50,000

0.00%

     50,000

     50,000

0.00%

     50,000

   50,000

Water

       30,000

       35,000

16.67%

33.33%

       7,500

   10,000

33.33%

         7,500

     10,000

0.00%

       7,500

       7,500

0.00%

       7,500

     7,500

Waste Removal

       50,000

       60,000

20.00%

20.00%

     12,500

   15,000

20.00%

       12,500

     15,000

20.00%

     12,500

     15,000

20.00%

     12,500

   15,000

TOTAL EXPENSES

 1,401,500

 1,422,500

1.50%

-0.01%

   362,875

 362,825

3.32%

    362,875

   374,925

1.33%

   337,875

   342,375

1.33%

   337,875

 342,375

NET PROFIT (BEFORE INTEREST & TAX)

 1,021,000

    825,000

-19.20%

-54.50%

   169,625

   77,175

-22.62%

    462,125

   357,575

52.92%

   194,625

   297,625

-49.84%

   194,625

   97,625

Income Tax Expense (25%Net)

    255,250

    206,250

-19.20%

-54.50%

     42,406

   19,294

-22.62%

    115,531

     89,394

52.92%

     48,656

     74,406

-49.84%

     48,656

   24,406

NET PROFIT AFTER TAX

  765,750

  618,750

-19.20%

-54.50%

 127,219

 57,881

-22.62%

  346,594

 268,181

52.92%

 145,969

 223,219

-49.84%

 145,969

 73,219

 Referring to the spreadsheet, commission, direct wages fixed, and sales are the revenue sources of the company. The actual commissions are less than forecasted commissions, i.e., 72,500 and 77,500, respectively, while actual direct wages fixed are the same as forecasted direct fixed wages, i.e., 200,000. In employment expenses, the only variation is observed in staff amenities where actual amount is higher than projected amount, i.e., 23000 and 20000 respectively while actual and forecasted superannuation and wages & salaries are same, i.e., 500, 000 and 500,000 respectively. Also, there is a minor difference in actual sales and forecasted sales, i.e., 2,900,000 and 3,100,000 respectively. On the other hand, the actual travel expenses are higher than forecasted travel expenses, i.e., 22,000 and 20,000 respectively, interestingly actual legal fee is 4,500 that is less than forecasted amount, i.e., 5,000, and similarly actual repair and maintenance expenses and office supplies expenses are 45,000 and 4,000 respectively that is less than forecasted amount, i.e., 50,000 and 5,000 respectively. Contrary, actual advertising expenses are much higher than forecasted expenses, i.e., 208,000 and 200,000 respectively. Last but not least, there is high variation in actual net profit after tax and forecasted net profit after tax, i.e., 618,750 and 765,750 respectively.

Modified contingency plan

Revised Contingency Plan

Company name: Big Red Bicycle Pty Ltd

Individual creating the strategy or plan

Name: Tom Copeland

Position: Managing director

Risk Identified

1.       The profit estimated in the budget is 19% above the actual profit.

2.       Total expenses are estimated at 1.50% lower than actual

3.       The sales are an estimated 6.45% higher than actual sales.

Strategies and activities for the minimization of the risk

By when

By whom

Analyzing the selling products and finishing the cycle of operation.

Accounting’s same year

CEO, MD and the CFO of the company

Keeping the data protected by password and allows it only to the reliable and authorized hands. The featured databases should be n excel with macros and generate the reports on these bases.

At the time while preparing the reports

Operation manager

Develop a report of quarterly variance for the identification of the income expense and the profit.

Q2

PR

Implementation of sales training and coaching programs.

Q2

PR

Introduce some programs of customer reward for the increase in sales.

Q2

PR

Consider the participation of the employee in the decision-making and budgetary processes.

Q2

PR

Consider the impact of wastage, water, paper, raw material, and electricity.

Q2

PR

Modified implementation plan

Risk identified: The profit of FY is higher and less than the budgeted programs

Activity

Monitored activities

By whom

Monitoring of Variance

Complete the variance report Q2

PR

Analyse the report for the identification of the issues

Management of the report Q2

PR

Send the emails to the employees to warn them about the risks of the jobs

Monitoring of results of variance report Q4

PR

Send a message or email to all employees to present the increase in commission to 14.29%

Monitoring of results of variance report Q3

PR

Send emails to workers about the present unapproved overtime.

Monitoring of results of variance report Q3

PR

Send emails to inform the employees about all the required and mandatory skills of sales and training programs

Monitoring of results of variance report Q4

PR

Send emails to the customers as well as employees regarding the modified consumer reward programs.

Monitoring of results of variance report Q4

PR

Voluntary training programs conducted in the company

Monitoring of results of variance report Q3

PR

Modification of the procedures for the re-education in the occupancy costs

Monitoring of results of variance report Q3

PR

Procedure of Manage budgets and financial plans

In order to update the plan and to improve the training models, there are some important components that must be considered, including goals, options and obstacles, reward programs, and the current reality.

Action and activity

Monitoring process

Timeline

Accountable

Management of the working capital

Report on working capital ratios

Must be provided at the end of the quarters

Senior accountant

Management of the cash

Development of the cash budget

On a monthly basis

Senior accountant

Reduction in the variable costs

Variance report and the variable expense budget

Must provide at the end of all the quarters

Senior accountant

References of Manage budgets and financial plans

Yang, C., Northcott, D., & Sinclair, R. (2017). The accountability information needs of key charity funders. Public Money & Management , 37 (03), 173-180.

Kung, F. H., Huang, C. L., & Cheng, C. L. (2013). An examination of the relationships among budget emphasis, budget planning models, and performance. Management Decision , 51 (01), 120-140.

Macinati, M. S., & Rizzo, M. G. (2014). budget goal commitment, clinical managers’ use of budget information, and performance. Health policy , 117 (02), 228-238.

Our Top Online Essay Writers.

Discuss your homework for free! Start chat

Top Rated Expert

ONLINE

Top Rated Expert

1869 Orders Completed

ECFX Market

ONLINE

Ecfx Market

63 Orders Completed

Assignments Hut

ONLINE

Assignments Hut

1428 Orders Completed