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

  Marginal tax rate for the firm

Its cash expenses will be $1,000,000 million while depreciation expense will be $200,000; then what is the expected free cash flow from taking the project if the marginal tax rate for the firm is 30 percent?

  Draw a timeline

After that, the payments decrease by $10 every month until payments reach $0. If the nominal annuity rate of interest is 12% compounded monthly, what is the present value of this annuity? Draw a timeline and explain how you got your answer.

  A bond that has a 1000 par value and a contract or coupon

a bond that has a 1000 par value and a contract or coupon interest rate of 11.3. the bonds have a current market value

  What is the present value of the bond

In early 2012, Aaa bonds yielded 5.3% and Baa bonds yielded 5.9%. If some bad news causes a 10% five-year bond to be unexpectedly downrated from Aaa to Baa, what would be the effect on the bond price? Assume annual coupons.

  How much cash will the firm net from these stock sales

The firm is obligated by an earlier agreement to sell an additional 250,000 shares at 90% of the offering price. In total, how much cash will the firm net from these stock sales?

  Evaluate the firm sustainable growth rate

Using the company's financial statements, calculate and evaluate the firm's sustainable growth rate (SGR) for the last 2-3 years, and summarize your findings in your paper. Be sure to address the following:

  Problem regarding the investment strategies

An investor believes that the price of a stock, say IBM's shares, will increase in the next 60 days. If the investor is correct, which combination of the following investment strategies will show a profit in all the choices?

  Describe the events that occur in an efficient market

Describe the events that occur in an efficient market in response to new information that causes the expected return to exceed the required return. What happens to the market value?

  Why firms in these industries would prefer

Firms in the real estate investment trusts (REITs), airlines, electric utilities, and paper products industries tend to have high leverage. Explain why firms in these industries would prefer to have high leverage.

  What conflicts arise between shareholders and managers

Is the role of the Federal Reserve still relevant? What conflicts arise between shareholders and managers? Sarbanes Oxley: Is it working? Efficient Market Hypothesis: is it true?

  Effects on the after-tax profits and cash flow

Determine the effects on the after-tax profits and cash flow, if sales increase from $10.5 million to $11.8 million.

  Find the dollar amount of each payment

Jan sold her house on December 31 and took a $10,000 loan as part of the payment. The ten year mortgage has a 10 percent nominal interest rate, but it calls for semiannual payments starting next June 30.

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