Assignment: Polyglot Persistence with NoSQL Systems

Introduction

In this assignment, you will show that you can work with different NoSQL systems for

data persistence and understand the strength and weakness of each system with respect to

certain query workload features. You are asked to work with a Question and Answer data

set and a list of target queries. The target queries include very basic OLTP type queries and

analytic queries. You will design data schema based on the data set feature and the given

query workload for MongoDB and Neo4j respectively. You will show that your design can

support the target queries by loading the data in each system following your schema and

by running queries against the data.

Data set

The data that you will use is the latest dump (publication date: 2017-08-31) of the Open

Data Stack Exchange question and answer site (https://opendata.stackexchange.com/).

The dump is released and maintained by stackexchange: https://archive.org/details/

stackexchange. The original dump contains many files in XML format. The assignment

uses a subset of the data stored in four csv files. The data files and the description

(readme.txt) can be downloaded from ELearning.

The assignment data set contains the following files:

_ Posts.csv stores information about post, each row represents a post, which could

be a question or an answer

_ Users.csv stores user’s profile, each row represents a user

_ Votes.csv stores detailed vote information about post, each row represents a vote,

including the vote type, the date this vote is made and a few other information

_ Tags.csv contains summary of tag usage in this site.

1

Target Queries

Simple queries

_ Find all users involved in a given question (identified by id) and their respective

profiles including the creationDate, DisplayName, upVote and DownVote.

_ Assuming each tag represents a topic, find the most viewed question in a certain

topic.1

Analytic queries

_ We want to discover the questions that are easy to answer. We measure easiness with

the time it took to receive an accepted answer. The shorter the time, the easier the

question. Given a list of topics, you are asked to list the question easiest to answer

in each topic.

_ We are interested in discovering trending topics in a certain period. An indicator of

trending could be the number of users who have participated in the discussion, by

posting either questions or answers, during the period. You are asked to list five such

hottest topics in a given period as well as the number of users in each.

_ We are also interested in discovering champion user in a certain topic. A champion

user has the most answers accepted in that topic. Given a topic, you are asked to list

the champion user and all questions the user has answers accepted in that topic.

_ Some questions may not have accepted answers. They are considered as unanswered

questions. We would like to recommend those questions to a group of potential

answerer. For any active user, if the user has n answers accepted in a certain topic

and n is greater than or equal to a threshold value _, we consider the user a potential

answerer of unanswered questions in that topic. You are asked to recommend up to

5 most recent unanswered questions to a given user.

_ We want to know if the acceptance of an answer would affect its upVote as well

as other answers’ upVote. We denote the day an answer is accepted as “decision

day”. You are asked to find out among all questions whoes total number of upVote is

greater than or equal to a certain threshold value _ :

– The question whose accepted answer has the highest percentage of upVote received

after the “decision day”

– The question whose other answers as a whole has the highest percentage of

upVote received after the “decision day”.

1For any query, if there are more results than the specified limit, e.g. two questions have the highest view

count but we only want one, you can return any of the valid results within the limit

2

_ Consider all users involved in a question as co-authors, for a given user, find out

this user’s top 5 co-authors based on the number of times they appear in the same

question either as originator or answerer.

Tasks

Your tasks include:

_ Schema Design for each system

You should provide two schema design versions to support both the simple queries

and the analytic queries. For each schema version, make sure you utilize features

provided by the storage system such as indexing, aggregation, ordering, filtering and

so on. Please note that your schema may deviate a lot from the relational structure

of the original data set. You will not get mark if you present a schema that is an exact

copy of the relational structure in the original data set.

You can discard data that are not useful. You can duplicate data if you find that

helps with certain queries. You may preprocessing the data by adding fields that are

not in the data set. Such preprocessing should not be used to create and save any

query result directly in the database. You need to justify any preprocessing you have

employed. The justification should include benefits, potential performance cost as

well as how often the preprocessing should be carried out. Keep in mind that the

storage system is also used to support online live transaction. Any activity such as

posting or voting will send one or more write queries to the system. You should not

use preprocessing that would cause significant delay to regular queries.

_ Query Design and Implementation

Load the complete data on both system and set up proper indexes that will be used

by the target queries. Design and implement all target queries. You may implement

a query using the provided query command (e.g. MongoDB shell or Cypher query)

alone, or a combination of JavaScript and shell command in the case of MongoDB

or as Python/Java program. In case that a programming language is used, make

sure that you do most processing at the server side. You may get significant mark

deduction if most of the analysis are implemented with programming language.

Deliverable and Submission Guideline

This is a group project, each group can have up to 2 students. Each group needs to produce

the following:

_ A Written Report .

The report should contain four sections. The first section is a brief introduction of

3

the project. Section two and three should cover a system each. Section four should

provide a comparison and summary.

There is no mark on section one. It is included to make the report complete. So

please keep it really short.

Section two and three should contain the following two sub sections

– Schema Design

In this section, describe the schema with respect to the particular system. Your

description should include information at “table” and “column” level as well

as possible primary keys/row keys and secondary indexes. You should show

sample data based on schema. For instance, you may show sample documents

of each MongoDB collection, a sample property graph involving all node types

and relationship types for Neo4j. Highlight the data that are different to the

given one and justify your decision. These would include data you decide not

to put in the database, data that are duplicated, or data that are results of

preprocessing.

– Query Design and Execution

In this section, describe implementation of each target query. You may include

the entire shell query command, or show pseudo code. You should also run

sample queries and provide a brief performance analysis of each query by citing

actual query execution statistics if such statistics are available or by indicating

that certain indexing would be used.

In section four, compare the two systems with respect to ease of use, query performance

and schema differences. You can also describe problems encountered in

schema design or query design.

Submit a hard copy of your report together with a signed group assignment sheet in

Week 10 lab.

_ System Demo

Each group will demo in week 10 lab. You can run demo on your own machine, on

lab machine or on some cloud servers. Please make sure you prepare the data before

the demo. The marker does not need to see your data loading steps. The marker will

ask you to run a few randomly selected queries to get an overview of the data model

and query design. The actual marking will be done after the demo using submitted

code.

_ Source Code/Script and soft copy of report

Submit a zip file through the eLearning site, before 2pm on Tuesday 10th of October,

2017 (week 10). The zip file should contain the following:

– a soft copy of the report

4

– query script or program code for each system

– data loading script or program for each system

– a Readme document for how to prepare the data and run the queries. The instruction

should be detailed enough for the markers to quickly prepare the data

and to run the queries. For instance, it is preferable that you prepare a single

script for data loading. You should also indicate where and how run-time

argument are supplied. If you used special features only available in a particular

version or environment, indicate that as well. You may not get mark if the

marker is not able to prepare the database and run your code.

Read More

All Open CoursesBUSN310 B001 Fall 17NEW ALLForum 2

Learning Objective: Given a company, the student will determine how government regulations affect the company and how to overcome barriers within the Domestic Environment using business theory.

Prompt:Choose a company of your choice from the Fortune 500 Best List (see resources) and complete the following:

1. Identify the company (for instance, US Airways).
2. Identify the industry your chosen company operates in (for instance, US Airways operates in the Airline Industry).
3. Identify the domestic environment (home country) of your chosen company (for instance, the domestic environment for US Airways is the USA).
4. Identify the business theorist you used in Forum 2.
5. Perform research (minimum of 2 scholarly sources identified in any format)
6. Investigate the government regulations associated with the industry (for instance, government regulations for the Airline industry).
7. How will the domestic government regulations affect your chosen company in its domestic environment?
8. How would your business theorist help your company in its domestic environment? You must provide some critical thought (see resources).

Read More

1. You are project manager for three different projects.

Project A: This project is scheduled to take 20 weeks to complete. You are in the planning stage of the project. You need to reduce the schedule for this project by 5 weeks. This project has a number of predecessors that were created by the project team’s preference. The sponsor insists on having all the work done on time without unduly increasing risk or costs to the project.

Project B: This project is in the execution stage of the project. It is behind schedule by 6 weeks; it was scheduled to be completed in 10 weeks. The sponsor is desperate to accomplish something on this project. The budget is limited to the original amount, and all soft predecessors have already been removed.

Project C: This project is behind schedule by 10 weeks. It was to have been completed in 2 months. The sponsor has additional funds to help complete the project on time if needed but does not want to increase risk to the project.

For each of the projects above, choose an appropriate schedule compression technique. It should be the best one for the example not just one that might work. Explain your choice.

2.Given the following information, calculate the CV, SV, CPI, and SPI for this project. Also provide recommendations to improve the project’s performance if needed.

It is only required that you calculate and discuss the status of the total project.

Calculate the EV, PV, and AC for each activity and then use them to calculate the values for the total project. You do not have to calculate the variances and indexes for the individual activities.

The percent complete is the work accomplished. The planned work is based upon the scheduled work.

Activity A: This activity is complete. It was completed in 6 weeks; it was supposed to be completed in 5 weeks. The original budget for this activity was $400,000; in the end, it cost $450,000.

Activity B: This activity is 50% complete. Its original budget was $100,000. The costs to date are $55,000. The original project plan had this activity scheduled for 5 weeks; currently it is entering its third week.

Activity C: This activity is 75% complete. Its costs so far are $100,000. It is at the end of Week 3 of 5. It was planned to cost $100,000 when completed.

Activity D: This activity is not started yet; it will start in 2 weeks. It is planned to cost $400,000. Its costs to date are $0.

Read More

You are CEO of Acme, Inc. located in the United States. You use the discounted payback period method and accept all projects that payback in three years. You are considering a project that will cost $5,500,000 and will produce one cash flow that occurs in three years. However, the cash flow is in pesos since the project is an overseas project. The current indirect exchange rate is 13.5 pesos per dollar. The cash inflow in pesos is 100,000,000 in three years, and the discount rate is 11.5%. During this time, the anticipated annual inflation rate is 5% in the United States and 4% in Mexico. Should you accept this project, using the discounted payback period method? Is this a good decision? Provide the six (6) steps you would utilize to determine whether or not this is a good decision.

Read More

Find Strategic Opportunities 



Describe Abell’s three-dimensional business-definition model and explain where it can be utilized. Then, consider Reader’s Digest Association, publisher of Reader’s Digest, the largest circulation magazine in the world in 1992. As famous and as popular as its magazine and brand were at the time, the real value to the company was the huge database of subscribers that it had (around 50 million readers). It has used that database to sell various products such as condensed books and other publications, videos, CDs, and so on. Using Abell’s model, explain what other products it could send down this distribution channel which would be amenable to mail order and that would appeal to its subscriber base.
In addition to the text, you must use at least one scholarly source. Your paper must be to three pages in length (excluding a cover page and reference page) and formatted according to APA style guidelines as outlined in the Ashford Writing Center. please cite all quotes all it would be considered plagerism

Read More

If an employee returns to work less than six weeks after the birth of their child, what might SPCA require them to do? Might this be problematic?

just need to find the section of the enterprise agreement it is in and copy and paste it but in differnet words and explain why its problematic. its on pages 52 and 54 i think. im just struggling

http://www.businessspectator.com.au/sites/default/files/SPC%20Ardmona%20Enterprise%20Agreement%20Decision.pdf

is the link to the agreement
it only needs to be 3 sentences long of an answer

Read More

 evaluate and discuss the human resource security privacy and stability issues affected by information technology. The increase of information technology has affected management greatly. The best guess is it will probably continue to do so. Given that, discuss the issues from the perspective of change and change management.what is the impact of such issues on the management of information technology? Conversely what is the effect of information technology on management? Why is this important to discuss in what way does information technology and management impact what you do or your job on a day to day basis? Why do you think this is important to discuss?

Read More

"Managing Employees and Diverse Workforce" Please respond to the following:
• Many states have banned smoking in public places, such as restaurants, shopping stores, and government offices. Many businesses also do not allow workers to smoke in the office, often designating smoke free areas. Based on the discussion case in Chapter 16, examine two (2) pros and two (2) cons of the Pennsylvania Geisinger Health System’s decision to refuse to hire smokers. Give your opinion on whether or not the decision is sound, and provide a rationale to support your response.

* Note: Harenda you do an excellent job in your last responses for me; However. I just need One (1) simple paragraph for the above question (3 or 4 sentences) and other questions in the future.
If you are able to do at this price I will send you business Always, and will only request you.

Read More

ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 1UNITCODE:ACT305UNITNAME:CORPORATEACCOUNTINGAssignment InformationSemester Two 2017Assessment 20%Maximum Marks: 100Instructions:If you create your worksheets in excel, please copy and paste them intoMSWord. Points are given for the quality of your calculation formats even if your finalcalculations are not correct. Once you have completed the assignment, it needs to be lodged through SafeAssign in the Assessments section of Learnline with an appropriate CDU coversheet. Your assessments must be lodged usingMSWord. Note: PDF, Excel or paper copies will not be accepted. Required: 1)Make sure your entire assignment can be readily printed on A-4paper in portrait (preferred) or landscape format with appropriate pagebreaks. Do not have a portion of a “wide” worksheet expand beyond 1page. 2)Make sureyour name and student number are on every page of yoursubmission. ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 2Question 1: (Marks 10)You own a financial accounting services called MyOwnWork Consultancy Pty Ltd. It’s thecompany you have established after graduating with honours degree in accounting andmanagement. The finance director of Millionaires Club Pty Ltd (MC) which is a privatecompany with many strategic investments, approached you and began discussing his concernthat he might be required to consolidate some of these investments, pursuant to AASB 10. Details of the investment relationships are as follows:a)MC has a 25 per cent interest in the share capital of LBX Pty Limited (LBX), which isa company involved in the same industry as MC. The remaining 75 per cent of theshare capital is owned by LBX’s founders, Mr and Mrs T. Mr and Mrs T areunfamiliar with the industry and so have given MC three seats out of the five seatsavailable on the board of directors. MC takes all the lead on all decisions, but thebusiness is closely monitored by Mr and Mrs T, who hold the other two boardpositions.b)MC has a substantial loan receivable from BBT Pty Ltd (BBT). BBT, as a result ofthe current economic climate, has experienced significant trading problems. BBT hasfailed to make its regular payments under the loan with the management of BBT thatMC executives will take control of the company’s finances for a period of five years. An executive of MC has been given control of BBT’s cheque book and makes allpayments. MC has not gained any seats on BBT’s board of directors, which is stilldominated by BBT shareholders. c)MC owns 50 per cent of Chatime Tea Ltd (CTL), with the other 50 per cent beingowned by Boost Juice Ltd (BJL). Both companies have equal voting rights and anequal share of seats on the board of directors. Under the agreement with BJL, MCsupplies the finance to the company on normal commercial terms. the loan is fullysecured against the assets of the company. BJL provides the management andentrepreneurial flair to CTL. under the agreement forged, BJL will receive amanagement fee in respect of the net profits of CTL after allowing for interestpayments on the MC loan. In times of no profits, the interest payments will still bemet, but BJL will not receive any remuneration.d)MC, Coffee Club Ltd (CCL) and Gloria Jeans Ltd (GJL) are each 33.33 per centshareholders of PGH Pty Ltd, a small proprietary company that is involved in themusic industry. CCL and GJL are passive shareholders with the one board seat eachout of a total of three. MC has one board seat and is also involved in the day-to-dayrunning of the business.e)MC hold a 75 per cent interest in JB Wifi Pty Ltd. The interest was created when MCconverted a substantial loan it made to JB Wifi into equity at the invitationof JB Wifiwhen JB Wifi began to trade poorly and recovery of the loan seemed uncertain. JBWifi has a large deficiency in net assets and has been consolidated for many years. MC is a passive investor, having no seats on the board of directors and no say in thefinancing or operating decisions of JB Wifi.ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 3Required: Being the owner and CEO of MyOwnWork Consultancy Ltd, advise the finance director ofMC of the requirements of AASB 10 in respect of the control criterion. For each of theabove investments, indicate where the control rests and whether or not consolidation will berequired. Discuss the reasons for your answers. Where possible, support your answer withexcerpts from AASB 10. You will be marked based on the explanation of your answer and not the Standard’s wordingsitself. Maximum 150 words per situation, excluding any words quoted from the standard.Question 2 (Marks 20)ChallengeMe Pty Ltd acquired 100 per cent of the issued capital of TakeItEasy Ltd on 30June 2018 for $900 000, when the statement of financial position of TakeItEasy Ltd was asfollows:Additional Information:?Tax rate is 30 per cent?As at the date of acquisition, all assets of TakeItEasy Ltd were at fair value, other than theproperty, plant and equipment, which had a fair value of $530 000. TakeItEasy Ltdadopts the cost model for measuring its property, plant and equipment. The property,plant and equipment is expected to have a remaining useful life of 10 years, and noresidual value.?One year following acquisition it was considered that TakeItEasy Ltd’s goodwill had arecoverable amount of $60 000.?TakeItEasy Ltd declared a dividend of $40 000 on 10 July 2018, with the dividends beingpaid from pre-acquisition retained earnings.Statement of financial position TakeItEasy Ltd as at 30 June 2018$(‘000)$(‘000)AssetsLiabilitiesAccounts receivable70 Loan300Inventory100Land400Shareholders’ equityProperty, plant and equip700Share Capital500Accumulated depreciation (270) Retained Earnings2001,0001,000ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 4The statements of financial position and statements of comprehensive income ofChallengeMe Pty Ltd and TakeItEasy Ltd one year after acquisition are as follows:Required:Provide the consolidated accounts of ChallengeMe Pty Ltd and TakeItEasy Ltd as at 30 June2019 with the following:?Acquisition analysis in recognition for Goodwill or Gain from Bargain Purchase.Show relevant calculations?All relevant worksheet journal entriesoFair Value of assets adjustmentoPre-acquisition eliminating entries?Consolidated worksheet for ChallengeMe Pty Ltd and its controlled entity for theperiod ending 30 June 2019 showing columns of Eliminations and adjustments andconsolidated amounts?Consolidated statement of financial position of ChallengeMe Group.Statement of financial position of ChallengeMe Pty Ltd and TakeItEasy LTd as at 30 June 2019ChallengeMe Pty Ltd($000)TakeItEasy Ltd($000)AssetsCash8040Accounts receivable5050Inventory140123Land600400Property Plant and equipment900700Accumulated depreciation(300)(313)Investment in Beach Ltd900-Total non-current assets2,3701,000LiabilitiesAccounts payable10010Dividends payable10050Loan670140Shareholders’ equityShare capital1,000500Retained earnings500300Total shareholders’ equity2,3701,000Reconciliation of opening and closing retained earningsProfit after tax400190Retained earnings — 30 June 2018300200Interim dividend(90)(40)Final dividend(110)(50)Retained earnings — 30 June 2019500300ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 5Question 3 (Marks 10)I Love Corporate Accounting Ltd commences operations on 1 July 2018 and presents its firststatement of profit and loss and other comprehensive income and first statement of financialposition on 30 June 2019. The statements are prepared before considering taxation. Thefollowing information is available:Other information?All administration and salaries expenses incurred have been paid as at year end.?None of the long service leave expense has actually been paid. ?Warranty expenses were accrued, and at year end, actual payments of $10 000 have beenmade (leaving an accrued balance of $20 000). ?Insurance was initially prepaid to the amount of $30 000. At year end, the unusedcomponent of the prepaid insurance amounted to $10 000.Statement of profit or loss and other comprehensive income for the year ended 30 June 2019Gross Profit730,000ExpensesAdministration expenses80,000Salaries200,000Long-service Leave20,000Warranty expenses30,000Depreciation expense – plant80,000Insurance20,000430,000Accounting profit before tax300,000Other comprehensive incomeNilAssets and liabilities as disclosed in the statemet of financial positions as at 30 June 2019AssetsCash20,000Inventory100,000Accounts receivable100,000Prepaid Insurance10,000Plant – cost400,000Less: Accumulated depreciation80,000320,000Total assets550,000LiabilitiesAccounts payable80,000Provision for warranty expenses20,000Loan payable200,000Provision for long service leave expenses20,000Total liabilities320,000Net assets230,000ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 6?Amounts received from sales, including those on credit terms, are taxed at the time of saleis made.?The plant is depreciated over five years for accounting purposes, but over four years fortaxation purposes.?The tax rate is 30 per centRequired:Prepare Deferred Tax worksheet for I Love Corporate Accounting Ltd as at 30 June 2019 andprovide the Journal entries to account for tax in accordance with AASB 112. Includesupporting calculation such as Taxable Income.Question 4 (Marks 20)Assuming that Wiley & Sons Australasia Ltd acquires 70 per cent of WileyPlus Ltd for acash price of $10 million when the share capital reserves of WileyPlus are:Share Capital $8 millionRetained Earnings $2 million $10 millionRequired:a)What amount will be shown in the consolidated statement of financial position forgoodwill pursuant to AASB 3 assuming that any non-controlling interest in the acquirer ismeasured at fair value?b)What amount will be shown in the consolidated statement of financial position forgoodwill pursuant to AASB 3, assuming that any non-controlling interest in the acquireris measured at the non-controlling interest’s proportionate share of the acquiree’sidentifiable net assets?c)What are some of the implications of allowing the group to have two options inaccounting for goodwill on consolidation? Discuss your answer. Maximum 200 words.ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 7Question 5 (Marks 40)The following financial statements of FinalHeadache Ltd and its subsidiary Solutions Ltdhave been extracted from their financial records at 30 June 2019.Reconciliation of opening and closing retained earningsFinalHeadache Ltd($000)Solutions Ltd($000)Sales revenue671.4540Costs of goods sold(464)(238)Gross Profit207.4302Dividends received from Solutions Ltd93-Management fee revenue26.5-Gain on sale of plant4035ExpensesAdministrative expenses(30.8)(38.7)Depreciation(29.5)(56.8)Management fee expenses-(26.5)Other expenses(101.1)(72)Profit before tax205.5143Tax expense(61.5)(42.2)Profit for the year144100.8Retained earning — 30 June 2018319.4239.2463.4340Dividends paid(137.4)(93)Retained earnings at 30 June 2019326247Statements of financial positionFinalHeadache Ltd($000)Solutions Ltd($000)Shareholders’ equityRetained earnings326247Share capital350200Current liabilitiesAccounts payable54.746.3Tax payable41.325Non-current liabilitiesLoans173.5116945.5634.3Current assetsAccounts receivable59.462.3Inventory9229Non-current assetsLand & Buildings224326Plant – at cost299.85355.8Accumulated depreciation – plant(85.75) (138.80)Investment in Solutions Ltd356-945.5634.3ACT 305 Corporate Accounting Assignment Due Date: 11.59 pm Friday 6th October in Study Week 11Page | 8Other Information:?FinalHeadache Ltd acquired its 100 per cent interest in Solutions Ltd on 1 July 2014, thatis five years earlier. At that date the capital and reserves of Solutions Ltd were:Share Capital $200 000Retained Earnings $180 000 $380 000At the date of acquisition all assets were considered to be fairly valued (Thank goodness!)?During the year FinalHeadache Ltd made a total sales to Solutions Ltd of $60 000, whileSolutions Ltd sold $50 000 in inventory to FinalHeadache Ltd.?The opening inventory in FinalHeadache Ltd as at 1 July 2018 included inventoryacquired from Solutions Ltd for $40 000 that costs Solutions Ltd $30 000 to produce.?The closing inventory in FinalHeadache Ltd includes inventory acquired from SolutionsLtd at a cost of $33 000. This cost Solutions Ltd $28 000 to produce?Closing inventory of Solutions Ltd includes inventory acquired from FinalHeadache Ltdat a cost of $12 000. This cost FinalHeadache Ltd $10 000 to produce.?On 1 July 2018 Solutions Ltd sold an item of plant to FinalHeadache Ltd for $116 000when its carrying value in Solutions Ltd’s account was $81 000 (cost $135 000,accumulated depreciation $54 000). This plant is assessed as having a remaining usefullife of six years. The Group has a policy of measuring its property, plant and equipmentusing the ‘cost model’.?Solutions Ltd paid $26 500 in management fee to FinalHeadache Ltd.?The tax rate is 30 per centRequired:Prepare the following for FinalHeadache Ltd and Solutions Ltd as at 30 June 2019:?Acquisition analysis to recognise Goodwill or Gain from Bargain Purchase showsupporting calculations?All relevant worksheet entries oPre-acquisition eliminating entriesoIntercompany eliminating entries?Consolidated worksheet for FinalHeadache Ltd and its controlled entity for the periodending 30 June 2019 showing columns of Eliminations and adjustments andconsolidated amounts?Consolidated statement of profit or loss of FinalHeadache Group?Consolidated statement of financial position of FinalHeadache Group. Hard work pays off. Good Luck?

Read More

Your organization is an organic food supplier with employees in the following jurisdictions:

• Manitoba
• Ontario
• Prince Edward Island

The organization is planning to implement a company-wide policy with respect to vacation leave and vacation pay that provides the same benefits to all employees, regardless of their province of employment. As Payroll Supervisor, provide Sharon Taylor, the Human Resources Manager, with the following information.

• Identify four specific items relating to vacation leave and vacation pay that will have to be addressed in the policy to ensure compliance with the employment/labour standards in each jurisdiction.

Research the details for each of the items you have identified using the course material and the employment/labour standards website for each jurisdiction.

• Using the results of your research, provide your recommendations to Ms. Taylor on how to address each of these items in the policy to provide the employees with the best benefit, while keeping the cost to the organization at a minimum. Please explain your reasoning.

Read More