Reference no: EM131181426
Assessment Description-
Learning Outcome: Demonstrate technical knowledge with MYOB and Excel applications
Task 1: Gelato-to-go is a gelato ice cream making business specialising in large tubs of gelato for shops and cafes. The following table shows the expected number of gelato tubs to be sold between April and Jun 2016:
|
Month
|
Strawberries & Cream
|
Choc chip
|
Rum and Raisin
|
|
April
|
3400
|
1500
|
4100
|
|
May
|
6500
|
2500
|
6000
|
|
June
|
4500
|
1800
|
3800
|
The cost to produce each tub of gelato is as follows:
- Strawberries & Cream - $5.70
- Choc Chip - $6.50
- Rum and Raisin - $9.30
The selling price is determined by applying a mark-up percentage on cost as follows:
- Strawberries & Cream gelato is marked up by 60%
- Choc Chip Is marked up by 50%
- RUM and Raisin is marked up by 100%
REQUIRED:
A. Using the data above, prepare a Revenue table for gelato, for each month.
B. Using the data above, prepare a Profit Summary per month, for each gelato flavor (must calculate the profit directly. You CANNOT add another table for total cost).
C. Recalculate the profit for each for each product but this time using a different formula. (Double check - your two profit tables must be exactly the same).
D. Overall presentation i.e. borders, shading, titles and alignment.
Task 2: The enclosed worksheet ACC 202 Task 2 contains some of !he scores of different teams from matches played ill season 2014 at different venues.
Required:
Using suitable formulas (like IF, Gourd) to find and suitably present the following:
A. "Margin" for each round (margin is always a positive number) - insert additional column/s as appropriate.
B. The winning team for each round - Insert additional column/s as appropriate.
C. The losing team for each round - insert additional column/s as appropriate.
D. Identify the team(s) that won maximum number of rounds, overall.
E. Your work need be clearly presented and suitably labelled.
Task 3: The Following employees work for Bright Electricals Ltd, a public company specialising in production of electrical components. The employees are paid an hourly rate, based on their Job Classification level. If an employee works more than 40 hours, they will be paid the overtime rate for the additional hours.
The Following table summarises the classifications and level of pay per classification:
Table A-
|
Level
|
Hourly pay
|
|
1
|
$15
|
|
2
|
$20
|
|
3
|
$25
|
|
4
|
$30
|
|
5
|
$35
|
|
6
|
$45
|
|
7
|
$50
|
|
8
|
$55
|
|
Overtime*
|
$65
|
*The overtime hourly rate is $65 per hour for ALL employees, regardless of their classification level
Bright Lights Ltd has the hollowing employees: Table B
|
Staff name
|
Level
|
Hrs worked
|
|
Simonette
|
5
|
32
|
|
Dat
|
4
|
41
|
|
Jemma
|
4
|
78
|
|
Rosemarie
|
5
|
20
|
|
Jessica
|
2
|
41
|
|
'Nicole
|
8
|
56
|
|
Kellie
|
7
|
30
|
|
Alenna
|
3
|
58
|
|
Mulomaa
|
8
|
47
|
|
Tara
|
3
|
44
|
|
Yifang
|
8
|
22
|
|
Thomas
|
4
|
68
|
|
Suriya
|
7
|
37
70
|
|
Xunyi
|
7
|
|
Noble
|
3
|
56
|
|
Rulande
|
1
|
49
|
REQUIRED: You are required to setup a table which includes the following details:
|
Staff Name
|
Level
|
Hours worked
|
Hourly pay
|
Overtime hours (if any)
|
Regular pay
|
Overtime pay
|
Total pay
|
|
Typed
|
Must use a formula in this column
|
Please note
A. The above table must be sorted by level first and then by staff name.
B. Marks will be awarded for presentation and correct use of cell referencing, use of functions and formulae (e.g. VLOOKUP, IF, Sum)
C. All columns must be totalled where appropriate.
|
New premium burger through social media
: You are the marketing director for a McDonalds. The company has decided to introduce its new premium burger through social media. Write a short message that you would post to a social media site and name which social media channel would be the best t..
|
|
Calculate the labor force participation rate
: The small country of Nederland counts its unemployed using the same methods as the United States. Of the population of 350 people, 70 are under age 16, 190 are employed in paid work, and 80 are adults who are not doing paid work or looking for wor..
|
|
Manager of change follows kotter checklist
: This manager of change follows Kotter's checklist like a recipe, and will first establish a sense of urgency, and expect the others in the team to follow in suit. In this case, the manager will assume that the new change is going to be better, and..
|
|
Risk mitigation strategy should produce action plan
: A risk mitigation strategy should produce an action plan that identifies that includes all of the following except
|
|
Prepare a revenue table for gelato for each month
: Gelato-to-go is a gelato ice cream making business specialising in large tubs of gelato for shops and cafes. Using the data above, prepare a Revenue table for gelato, for each month
|
|
Identify tools currently being used by industry professional
: Using strictly open source information (FOIL requests, Internet, independent research), identify tools currently being used by industry professionals for the industry/area you chose to research for the Discussion Board.
|
|
What is the labor force participation rate in tatoonia
: Sheila is retired. Shawna does not work for pay, but is thinking about getting a job and has been looking through employment postings to see what is available. Bob has given up looking for work, after months of not finding anything. Ana, the only ..
|
|
What officials or departments are not included that you feel
: After reviewing the Executive Order of October 16, 2001, what areas do you feel are most vital to critical infrastructure protection? What officials or departments are not included that you feel should be to facilitate information sharing properly..
|
|
Diminishing returns to taking inventory
: Imagine you have some workers and some handheld computers that you can use to take inventory at a warehouse. There are diminishing returns to taking inventory. If one worker uses one computer, he can inventory 100 items per hour. If you assign one wo..
|