Complete a new budget based on your recommendations

Assignment Help Finance Basics
Reference no: EM131401054

Written Assessment - Proactive Management Consultants

Read the case study on Proactive Management Consultants Pty Ltd below.

Your Task

1. Prepare you cash sales income for each month (taking into consideration your accounts receivable information).

2. Complete the financial reports for each period as requested (5 x Financial Reports contained in the assessment).

3. Analyse the data and complete your recommendations.

4. Complete a new budget based on your recommendations.

5. Notate your recommendations to PMC on actual sales and expenditure for the following months:

  • July
  • August
  • September
  • October
  • November

On the following pages adjust the actual sales and expenditure based on your recommendations.

Proactive Management Consultants

Proactive Management Consultants Pty Ltd (PMC) are a small service organisation that provide consultative services to a wide variety of clients and have been in existence for just over five years. Typically, they advise their clients on professional development opportunities, organisation structure and simple training initiatives.

While the past 12 months have been profitable for PMC, they face a very uncertain future. Reducing government support, the global financial crisis, an increasingly competitive market and a client base that already believes they are already paying too much.

PMC prides itself on the advice they give their clients, however, finance has never been their strength. The PMC Board has approached your company to provide monthly financial reports and recommendations on how they should proceed with their financial plans.

PMC has provided each month's sales and expenditure data from which they require your company to complete the reporting in the templates provided, interpret the data and provide recommendations.

Accounts payable are entirely paid month-to-month. Accounts receivable are calculated at 60% current month, 30% last month, 10% second to last month -actual May sales - $42,100; actual June sales - S47,300. These figures will be required to determine actual sales receipts for July and August.

PMC has also provided you with a list of initiatives they had planned to undertake over the next six months. They have budgeted for these in their financial planning and they need you to consider them in your recommendations.

They are:

a. Anticipate large invoicing month in July due to number of leads.

b. All company motor vehicle registrations and insurance are due in July, $18,000.

c. 15th August moving to new premises whereby rent increases to $3,500 per month.

d. To increase productivity PMC will upgrade all computers under expensed equipment in September at $12,000.

e. Have sought an aggressive advertising campaign in October to invigorate lost clientele, $16,000.

f. Due to advertising campaign, PMC are recruiting two new consultants in October. This will add 30% to November and December's payroll and $10,000 in recruitment and training during October. It will also result in increased business (40% November and December].

g. Purchasing a licence to deliver an innovative training program in November for $20,000. Have contractual agreements in January and February that will generate $32,000 in sales.

h. Three employees on annual leave will have 50% impact on sales in November.

i. Conducting a professional development week for all staff in December, $18,000.

j. Employee bonuses due in December, anticipate $16,000.

Source: Innovation and Business Skills Council Ltd, 2009.

Attachment:- Assignment Files.rar

Reference no: EM131401054

Questions Cloud

What are the variables and units in given regression : What are the variables and units in this regression?- What units does the slope have?- Do you think the slope is positive or negative? Explain.
Performing a strategic audit : What organizational development technique is most helpful for performing a strategic audit?
Should you choose to take given retest : Should you choose to take this retest? Explain.- Now explain to your friend what his decision should be and why.
Discuss about web design & interactive media as a career : I choose Web Design & Interactive Media as a career goal to compliment my Master's of Business Administration Degree that I currently have. I currently work for the County of Sacramento; the County of Sacramento has many opportunities to name a fe..
Complete a new budget based on your recommendations : Complete the financial reports for each period as requested (5 x Financial Reports contained in the assessment). Analyse the data and complete your recommendations. Complete a new budget based on your recommendations
What actions would you take with respect to obesity : In your opinion, should the food and restaurant industry be held responsible for the rise of obesity, or not? If you were a manager for a fast-food chain or food company, what actions would you take with respect to obesity.
Supply chain assignment : Can someone help me with this Supply Chain Assignment please? In our readings for this unit the authors have discussed different levels that a company may engage in. Some companies may strategically decide to stay at one level, while others may pr..
What price would you predict for a 3000 square foot house : Explain what the slope of the line says about housing prices and house size.- What price would you predict for a 3000-square-foot house in this market?
Identify what you learned from the experience : Psy 103/Psy103 : Identify what you learned from the experience.Describe how your learning could have occurred through classical conditioning. Identify the unconditioned stimulus, the unconditioned response, the conditioned stimulus, and the conditi..

Reviews

len1401054

2/20/2017 5:19:18 AM

Australian student, The spreadsheet named Proactive Management Consultants PTY Ltd is related to the first task. Read the case study on Proactive Management Consultants Pty Ltd, prepare you cash sales income for each month (taking into consideration your accounts receivable information).

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd