Let us worry about your assignment instead!

We Helped With This Accounting Economics Homework: Have A Similar One?

SOLVED
CategoryEconomics
SubjectAccounting
DifficultyUndergraduate
StatusSolved
More InfoAccounting Assignment
288011

Assignment Description

 

Excel and LinkedIn

Brief and Marking Scheme

 


 

Requirements

This is a two part assignment, it consists of:

1.    A group spreadsheet task, and

2.    An individual LinkedIn profile

Submission

Only one submission is required per group, the submission must be one single Excel spreadsheet that contains both of the above tasks.  The Spreadsheet will need multiple sheets, the majority of which will be for the group spreadsheet task, however and very importantly there must be one extra sheet, which details the students P numbers and the four web addresses to the four students’ LinkedIn profiles.


 

Group Spreadsheet Assignment

Anonymous Charity

 

A large national charity that is best described as a learned society and professional body, has a need for an advanced spreadsheet to assist the organisation in budgeting.  The charity is undertaking a costing review of the prices of its qualifications and requires a spreadsheet that is simple to use. 

The requirements are:

1.    A single file spreadsheet, with a “Calculator Sheet”, bringing together all of the various costs,

2.    The ability to quickly and easily choose which method of allocation the cost should be shared on, the two options are:

o    By total student numbers (all students pay the same), and

o    By qualification (the qualification is charged the same percentage, but this standardised cost is shared amongst the students on that qualification).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Data

The charity offers six qualifications, with different numbers of enrolled students:

Qualification

A

B

C

D

E

F

Enrolled Students

40

300

25

125

250

110

 

The charity has the following annual costs:

Staff Costs

£250,000 per year

Premises Costs

£45,000 per year

Development Costs

£25,000 per year

Promotion Costs

£25,000 per year

Regulatory Costs

£40,000 per year

Assessment Costs

As per below

Meeting Costs

As per below

 

Each qualification has a different number of assessments and meetings with varying number of delegates, thus unlike the above, each qualification (cost centre) has different costs (for the avoidance of doubt, both allocation options need to be available in the spreadsheet, even though each qualification carries a different cost):

Qualification

A

B

C

D

E

F

Total Assessments

12

9

15

28

8

12

Cost of assessment (each)

£200

£175

£240

£80

£130

£0

Yearly Meetings

4

4

3

3

4

2

External delegates

10

10

10

12

12

8

Staff Members

2

2

2

2

2

2

 

 

 

The costs of holding a meeting, regardless of qualification:

Room

Travel

Accommodation

Refreshments

Stationery

£450

Max. £250

Max. £150

£25

£15

 

External delegates are entitled to claim travel and accommodation.  Staff members can only claim travel.  The budget must account for refreshments and stationery for both external delegates and staff members.

The charity currently pays approximately 38% of the maximum claimable expenses; however this has grown 5 percentage points in both of the last two years.

The charity requires the ability to adjust the percentage above quickly and easily.

The Charity wishes to charge the students a single fixed fee factoring in the different average study lengths.

Qualification

A

B

C

D

E

F

Average Length of Study

3

4

4

3

3

2

 

No support will be provided as to the technical excel nature of this assignment, however clarification on the requirements of the charity can be sought in person only during the following times:

§  Wednesday 7th February,            during your lecture slot

§  Monday 5th March,                       HU2.02 between 2pm and 2:50pm

§  Wednesday 7th March,                during your lecture slot

§  Thursday 8th March,                      HU2.02 between 2pm and 2:50pm

§  Monday 12th March,                     HU2.02 between 2pm and 2:50pm

§  Wednesday 14th March,              during your lecture slot.

§  Thursday 15th March,                    HU2.02 between 2pm and 2:50pm


 

Individual LinkedIn Profile

Each member of the four person team needs to complete their own LinkedIn profile in line with the style, techniques and knowledge that was shared during the lecture.


 

Assignment Submission and Format

The assignment must be submitted via Blackboard no later than 11:59pm on the hand-in date and No paper copy is required

Only one submission is required per group, the submission must be one single Excel spreadsheet that contains both of the above tasks.  The Spreadsheet will need multiple sheets, the majority of which will be for the group spreadsheet task, however and very importantly there must be one extra sheet, which details the students P numbers and the four web addresses to the four students’ LinkedIn profiles.

Please refer to the Handbook and Regulations for Undergraduate Awards (p.13) regarding late submission and reassessment.

 


 

Marking Scheme

Marks will be awarded as follows:

Spreadsheet 60% – Group Score

§  Ease of Use

§  Ability to share costs as per the two methods

§  Calculator arrives at the correct total cost for all expenses

§  Future proofing, from the ‘calculator’ sheet

§  Visual presentation

§  Effectiveness

LinkedIn Profile 40% Individual Score

§  Quality of Introduction

§  Experience and Education

§  Featured Skills and Endorsements

§  Picture and Cover image

§  Effectiveness

Example Score

For the benefit of doubt, your overall grade will be made up of two scores, for example:

Student:

A

B

C

D

Spreadsheet

Group score of 55%

LinkedIn Profile

40%

50%

60%

70%

Overall Score

49%*

53%

57%

61%

*55% x 60% weighting + 40% x 40% weighting = 49%

It is therefore very possible that each of you will receive different scores overall.

Penalties

§  Where the group size is not 4, a 10-mark deduction will be applied to the final grade.

§  Support will be provided to help students form groups, to take advantage of this support you must attend your lecture were at the end of the session time will be made available for students to make their groups.  There will be one opportunity:

o   Wednesday 7th March at 1pm

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta


Paypal supported