Highlights
Task:
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:
|
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 |
|
|
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 |
|
|
Advertising |
|
|
Commission Paid
|
|
|
Motor Vehicle expenses |
|
|
Wages |
|
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.
|
|
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.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.