Budgeting, Forecasting & Cashflows Management - Report Writing - Management Assignment Help

Download Solution Order New Solution
Assignment Task:

Task:

Question One

You work for Clifton’s Limited and you have been asked to prepare an Incremental Profit & Loss Budget for 20X9. Using the additional information provided below and the 20X8 Profit & Loss Statement, generate the 20X9 Budget.

 

Clifton’s Limited

Profit and Loss Statement

For the year ended 31 March 20X8

Income

 

 

Revenue

290,000

 

Less: Cost of Sales

(104,750)

 

Gross Profit

 

185,250

Other Income

   

Interest income

 

5,720

Total Income

 

190,970

Expenses

   

Selling and Distribution Expenses

   

Advertising

8,400

 

Freight

1,900

 

Commission Paid

17,300

27,600

Administration Expenses

   

Depreciation

2,920

 

Insurance

1,690

 

Kitchen Supplies

2,480

 

Motor Vehicle expenses

4,800

 

Rent

29,300

 

Stationery

2,800

 

Subscription fees

1,680

 

Wages

62,980

108,650

Financial Expenses

   

 Interest

2,700

2,700

Total Expenses

 

138,950

Net Profit before tax

 

52,020

 

 

 

Required

Fill out the budgeted profit and loss statement for the next financial year using the additional information below -

Additional information:

  • Revenue is expected to increase by 4%.
  • Interest income is expected to remain the same.
  • Cost of sales is expected to increase by 3%.
  • Selling and Distribution expenses are expected to increase by 3%.
  • Administration expenses are expected to reduce by 5%.
  • Financial Expenses are expected to increase by 2%.

 

Clifton’s Limited

Budgeted Profit and Loss Statement

For the year ended 31 March 20X9

Income

 

 

Revenue

 

 

Less: Cost of Sales

 

 

Gross Profit

 

 

Other Income

 

 

Interest income

 

 

Total Income

 

 

Expenses

 

 

Selling and Distribution Expenses

 

 

Advertising

 

 

Freight

 

 

Commission Paid

 

 

Administration Expenses

 

 

Depreciation

 

 

Insurance

 

 

Kitchen Supplies

 

 

Motor Vehicle expenses

 

 

Rent

 

 

Stationery

 

 

Subscription fees

 

 

Wages

 

 

Financial Expenses

 

 

 Interest

 

 

Total Expenses

 

 

Net Profit before tax

 

 

 

 

 

Question Two

 

Part A

You have been provided with the budged figures for the 20X8 year for Clifton’s Limited, as well as the Actual results for 20X8.

You are required to calculate the variance amount for each account balance and specify whether the variance is favourable or unfavourable.

 

Clifton’s Limited

Profit and Loss Statement

For the year ended 31 March 20X8

 

Budgeted

Actual

Variance

Fav/Unfav

Income

 

 

 

 

Revenue

648,000

598,040

-49,960 

Unfavourable

Less: Cost of Sales

-294,000

-314,000

 

 

Gross Profit

354,000

284,040

 

 

Other Income

 

 

 

 

Interest income

4,920

4,010

 

 

Total Income

358,920

288,050

 

 

Expenses

 

 

 

 

Selling and Distribution Expenses

 

 

 

 

Advertising

16,400

12,300

 

 

Freight

2,900

1,780

 

 

Commission Paid

14,600

11,960

 

 

Administration Expenses

 

 

 

 

Depreciation

3,900

3,900

 

 

Insurance

2,140

2,140

 

 

Kitchen Supplies

5,200

6,450

 

 

Motor Vehicle expenses

14,400

16,030

 

 

Rent

18,200

18,200

 

 

Stationery

3,810

2,790

 

 

Subscription fees

950

120

 

 

Wages

198,000

173,600

 

 

Financial Expenses

 

 

 

 

 Interest

3,480

3,350

 

 

Total Expenses

283,980

252,620

 

 

Net Profit before tax

74,940

35,430

 

 

 

 

 

Part B

Once you have determined each of the variance amounts and identified whether the variance is a favourable or unfavourable result, provide at least two possible causes for the variance between the budgeted amount and the actual results, for each of the following specific balances. The first one has been done for you as an example:

 

Account Balance

Possible cause of variance

Revenue

  1. Sales have dropped due to staff loss and the staff not being replaced

 

 

 

Advertising

 

 

 

 

 

Commission Paid

 

 

 

 

 

 

Motor Vehicle expenses

 

 

 

 

 

Wages

 

 

 

 

 

 

 

 

Question Three

You have been provided with the following data in respect of payables, receivables, sales and cost of sales for Clifton’s Limited for the year ended 31 March 20X8.
 

Opening Inventory - 20X8

17,800

Closing inventory - 20X8

21,500

 

 

Opening Accounts Receivable - 20X8

24,500

Closing Accounts Receivable - 20X8

29,800

 

 

Opening Accounts Payable - 20X8

12,050

Closing Accounts Payable - 20X8

23,650

 

 

Sales - 20X8

598,040

Cost of sales - 20X8

314,000

Using the figures provided calculate the Cash Conversion Cycle (CCC) for Clifton’s Limited. You must include the formula and your workings in these calculations.
 

 

 

Reminder

 

Click here: “Managing the Cash Conversion Cycle“ to refer to your course notes for the formulas. Alternatively, copy and paste the below link in your browser to directly go to the page.

 https://careeracademy.online/mod/book/view.php?id=4305&chapterid=2392

 

Days Inventory Outstanding

 

 

 

Days Sales Outstanding

 

Days Payables Outstanding

 

 

 

 

Cash Conversion Cycle (Days)

 

 

Provide two (2) suggested actions to improve the CCC in the following period.  Each suggestion must include an explanation on how this will improve the CCC

 

This Management Assignment has been solved by our Management  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.