Question
Task 3 - Performance reporting Qwerty Ltd has provided the following information for January: Actual Budget Sales 8000 8800 Cost of Sales 5200 60% of
Task 3 - Performance reporting
Qwerty Ltd has provided the following information for January:
| Actual | Budget |
Sales | 8000 | 8800 |
Cost of Sales | 5200 | 60% of budgeted sales |
Marketing expenses | 1000 | 15% of budgeted sales |
Administration expenses | 600 | 500 |
Finance Expenses | 200 | 300 |
a) Prepare a Variance Analysis Report in the format supplied below based on the information supplied above. Percentage variance are to be calculated to two decimal places.
| Budget | Actual | Variance $ | Variance % | F or U/F |
Sales | 8800 | 8000 | 800 |
|
|
Cost of sales |
|
|
|
|
|
Gross profit |
|
|
|
|
|
Operating Expenses: |
|
|
|
|
|
Marketing Expenses |
|
|
|
|
|
Administration Expenses |
|
|
|
|
|
Finance Expenses |
|
|
|
|
|
Total Expenses |
|
|
|
|
|
Net Profit |
|
|
|
|
|
b) Provide a brief written report to management discussing the business performance this month.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started