Business Scenario
Healey Ltd is a small management consultancy, with 25 employees. The Managing Director is considering purchasing office productivity software for her employees but is unsure of the cost, or the benefits, of such a purchase.
You have been employed to achieve two tasks: task 1) to calculate the costs of this purchase, and task 2) to describe some benefits of the software.
Task 1: Costings for office productivity software and training (30% of total marks)
You have been asked to calculate total training and product costs for Healey Ltd.
Use the figures from the table below in your calculations:
| Training Types | Cost per person (excluding VAT) | Number of staff undertaking training |
| Basic | £30.00 | 10 |
| Intermediate | £40.00 | 25 |
| Advanced | £50.00 | 14 |
| Office productivity products | Cost per licence (excluding VAT) | Number of products required |
| Office 365 | £100.00 | 10 |
| Office 2013 | £140.00 | 15 |
Task 1 Instructions
Create a workbook, with 2 worksheets, to store your cost estimates for Healey Ltd.
Worksheet 1:
- Name the first worksheet “Training”.
- Add the title “Training Costs” at the top of your worksheet.
- Format the title – consider font style, font size, text colour, cell background colour, text alignment or merged cells.
- Insert today’s date at the top of the worksheet, using the DATE function.
- For each training type (basic, intermediate, advanced), write a formula to calculate the total cost excluding VAT.
- For each training type (basic, intermediate, advanced), write a formula to calculate the total cost including 17.5% VAT.
Make your formulas more robust, by using absolute referencing.
7) Format all currency as £, to two decimal places, e.g. £2.00
Worksheet 2:
- Name the second worksheet “Products”.
- Add the title “Product Costs” at the top of your worksheet.
- Format the title – consider font style, font size, text colour, cell background colour, text alignment or merged cells.
- For each product type (Office 365, Office 2013), write a formula to calculate the total cost excluding VAT.
- Calculate the total cost of products using SUM function.
- Your manager has allocated a budget of £1500 for software purchases. Using an IF function, compare the total cost of products to your budget, and return the text ”costs are within budget” if costs are less than or equal to £1500. Return “costs are over budget” if costs are greater than £1500.
- Format all currency as £, to two decimal places, e.g. £2.00.
Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).
After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.
If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.