Janet, after years of working as a hairdresser and as a makeup artist, decided to go into business for herself. Over time the business has grown into a spa and beauty retreat and she now employs a few staff. With her growing operation she has identified the need to implement a computerized accounting information system. In order to have a system that meets her needs exactly and also to save cost, she has asked you to create a simple, customized solution for her business. Her immediate need is for a customer sales information system, so that is what you will now create. With customer service being so important to Janet, her customers tend to become regulars and she wants to maintain a record of each customerās contact information and preferences so that the spa will know what is important to the customer without having to be told each visit. The customer information that Janet considers important to maintain is the full name, cellphone number, favourite treatment, and special considerations (e.g. some customers have allergies or require fragrance-free products). For employees, Janet just needs to record the names and cell phone numbers in the database. The spa also has a standard list of services which each have a standard name, description and price. Janet also wants a database record of each customer visit both for customer billing at the time of service, as well as for future analysis. Janet wants to refer to these sales transactions as āVisitsā in the database in order to reflect the spaās focus on customersā experiences. For each of these customer visits it is important to record a unique visit identifier, the date, the customer, the main staff member who served the customer, and the service or services experienced (sold). ACCT 3015 Assignment 1 ā This is an individual assignment Page 2 of 3 Your Assignment Note: You might find this and other Unit 3 references to be useful while completing this assignment: https://www.datanamic.com/support/lt-dez005-introduction-dbmodeling.html Please submit
Questions 1-3 in either Microsoft Word or PDF format, and Question 4 in Microsoft Access. Submit your files to the Assignment 1 dropbox before the deadline. This is worth 15% of your course grade.
Question 1 (3 points):Based on your analysis of Janetās requirements, list out the entities and relationships that should be present in the database, indicating the cardinality of each relationship.
Question 2 (3 points): Create the Logical E-R data model
Question 3 (5 points): Create the Physical E-R data model, showing how you went from the Logical to the Physical using best practices.
Question 4 (4 points): Create the resulting accounting information system in LibreOffice Base (which is free) or in Microsoft Access.
In: Accounting
In several paragraphs, please answer the following case study question to the best of your ability.
In answering these case study questions, students are reminded that they need to refer to ethical theories (Bentham, Mill, Kant, Rawls, and Aristotle) and inherent values (Life, Happiness, Equal Worth and Autonomy) to justify their answers. They may also refer to specific articles we have read and discussed in class.
You work at a small tech company that is creating an app that would allow people to share pictures, notes, videos and thoughts with their very close friends and family. The app is built around the concept of Facebook, but geared towards private, intimate sharing. The idea is to market the app as something like Facebook that allows you to maintain meaningful personal connections with close family and friends. Rather than having hundreds or even thousands of people privy to your information, this app would allow you to share with a handful of those people whom you are closest to.
Currently, the app is being given away for free on all the major app distributions sites (Google Play, the Istore, etc.) The app is advertised as personal and secret. And it is growing in popularity. People seem to love the idea of having a private way to communicate with a close-knit group securely and safely. You feel proud of the work you are doing allowing people to maintain strong personal connections across vast distances.
However, one of your very close friends has refused to download the app. At first you were stunned as to why they resisted doing so, and a bit hurt that they didnāt want to have this close personal connection with you. Your friend explained that they had carefully read all the terms and conditions attached to the app, and noted that it was far from secret. The data people shared with their intimate friends using the app was being collected and sold to various advertising and market research companies. This is why the app was able to be given away for free. Your whole livelihood, in other words, has rested on the mining of data that people likely believe to be secret and private.
You dismiss your friend as too worried about this at first. After all, the data is stripped of any identifying features before it is sold. Itās not as though a name and email address were attached. The data is mostly just following trends such as location, word usage, number of close personal friends, etc. But as time goes by, you find yourself worrying more and more about the way the app is marketed. Is it right to market the app as personal and secret? Especially given that everything that is posted might be sold to another company? On the other hand, the Terms and Conditions do state clearly that this is what happens to user data. So if someone chooses to download the app, isnāt that their informed choice? But you know that most people donāt read the Terms and Conditions closely.
What should you do?
please make it plagiarism free.it worth 10 marks
In: Operations Management
You have been asked to look at production options for the Android01, since production methods and allocation of costs have implications for cost per unit. Two alternative methods of production are being considered. Begin by gathering data (using financial information in decision making), then determine the suitability of the project.
The production of Android01 will share some production facilities and service divisions with Processor01. Fixed costs are $5 million per year, and will be assigned at the rate of 30 percent to Android01 and 70 percent to Processor01.
The variable cost of the production facilities and service divisions is $25 million per year. The square footage of factory space and labor needed for the production of 500 units of Processor01 and 300 units of Android01 are listed below.
|
Square Feet |
Labor |
|
|---|---|---|
|
Processor01 (500 units) |
70,000 |
120 |
|
Android01 (300 units) |
30,000 |
80 |
The remaining cost for the production of Android01 is for components, at $25,000 per unit.
Question 1: In Method B, what would be the cost per unit of producing Android01 using factory space as the allocation basis? What would be the cost per unit using labor as the allocation basis?
Before starting on your calculations, review materials on production cost allocation.
An alternate method of assigning costs is activity-based costing.The major activities for the production of both Processor01 and Android01 are fabricator setup and component assembly. There are 500 units of Processor01 and 300 units of Android01 produced every year. There will be a total of 25,000 setups per year for at a total cost of $10 million. Each unit of Android01 will require 40 setups. There will be a total of 125,000 assemblies per year at a total cost of $15 million. Each unit of Android01 will require 180 assemblies. The remaining cost for the production of Android01 is for components, at $25,000 per unit.
Question 2: What would be the cost per unit of producing Android01 using activity-based costing?
Note that in addition to the setup costs and assemblies costs there are two more costs to add: (1) fixed costs of $5 million, which are still distributed at a rate of 30 percent to Android01 and 70 percent to Processor01, and (2) the cost of Android01 components at $25,000 per unit.
Discuss the differences in the cost per unit of Android01 using space as an allocation basis, using labor as an allocation basis, and using activity-based costing. Which method do you think is the most accurate way to assign costs?
Next, suppose IPS uses markup pricing for Android01. Fixed costs are $4.5 million, and for a level of production of 300 units, the variable cost per unit is $48,000.
Question 3: What is the price of the Android01 at 30 percent markup over full cost?
Submit your Markup Pricing Report and Calculations to the dropbox below. Submit a spreadsheet showing your calculations in Excel and provide a narrative analysis in Word. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of company.
In: Accounting
Jessica has decided to apply the concepts in a balanced scorecard to evaluate and improve her business. Her vision for this business is to provide clients with high quality websites that receive a relatively high number of hits. Recently, word-of-mouth advertising has led to more requests for websites with creative animated graphics. As part of her balanced scorecard, she tracked the following measures over the last two years for her individual clients.
|
2018 |
2019 |
|
|
Average revenue per individual client |
$2,000 |
$1,500 |
|
Average time from start to finish (business days) |
10 |
13 |
|
Average site ranking on top two search engines |
15 |
21 |
|
Total revenue |
$80,000 |
$78,000 |
|
Total labour cost |
$20,000 |
$22,000 |
|
Total electricity and phone costs |
$2,100 |
$2,400 |
|
Number of individual clients |
40 |
52 |
|
Employee turnover |
1 |
0 |
50 Required:
In: Accounting
A.B is a 56-yr-old white woman who was referred to the neurosurgery service for management of her temporal-parietal glioblastoma. She was diagnosed after presenting with persistent headaches, a seizure in her HCP's office, and left side upper visual field loss and neglect. Her MRI/MRA demonstrated a temporal-parietal glioblastoma that extends into the occipital lobes. She is scheduled for surgery to debulk the tumor. A.B. lives alone and holds a management position. She is concerned about her ability to return to work after her surgery.
A.B. returns from surgery to the neurosurgery unit drowsy but following commands. During the night A.B. is noted to have a pronator drift of the left arm, her pupils are equal and respond to light, but she has also developed left-sided weakness of both arm and leg and difficulty with answering questions.
Medications: dexamethasone 4āÆmg q6hr, famotidine, metoclopramide, ondansetron (Zofran), codeine, and levetiracetam (Keppra) since her admitting seizure
Subjective Data
Objective Data
Questions to Answer:
In: Nursing
CLUK is a producer of sports nutrition drinks and has two divisions, D1 and D2. Division D1 manufactures recyclable plastic containers which it sells to both Division D2 and also external customers. Division D2 makes high protein drinks which it sells to the retail trade in the containers that it purchases from Division D1.
You have been provided with the following budget information for Division D1:
|
$ |
|
|
Selling price to retail customers per 1,000 containers |
130 |
|
Variable costs per container |
0.04 |
|
Fixed Costs per annum |
2.4 million |
|
Net Assets |
4.0 million |
|
Production capacity |
40,000,000 containers |
|
Retail demand for containers |
38,000,000 containers |
|
Demand for containers from Division D2 |
20,000,000 containers |
You have been provided with the following budget information for Division D2:
|
$ |
|
|
Selling per container of protein drink |
0.50 |
|
Variable costs per drink (excluding container) |
0.15 |
|
Cost per container (from Division D1) |
At transfer price |
|
Fixed Costs |
1,750,000 |
|
Net assets |
12,650.000 |
|
Sales volume of protein drinks in containers |
20,000,000 |
Transfer Pricing Policy
Division D1 is required to satisfy the demand of Division D2 before selling containers externally. The transfer price for a container is full cost plus 20%.
Performance Management Targets
Divisional performance is assessed on Return on Investment (ROI) and Residual Income (RI). Divisional managers are awarded a bonus if they achieve the annual ROI target of 25%. CLUK has a cost of capital of 7%.
Required:
REQUIRED:
Using Excel, produce a profit statement for each division detailing sales and costs, separating external sales and inter-divisional transfers. You are advised to produce this statement in a Excel spreadsheet first and then copy this information into the PowerPoint slide
Using Excel, calculate the ROI for division D1 and division D2. Copy this information into Slide 2 of the PowerPoint presentation
Provide a brief commentary on the divisionalised profit statements and ROI results shown in slides 1 and 2
[40 MARKS]
The purchase of this machine will increase the net assets of Division D1 by $500,000. Assume that there is no impact on unit variable costs or fixed costs resulting from this purchase. Inter-divisional transfers will be priced at opportunity cost.
You are required to produce a report to the directors critically discussing the issues and implications of the Transfer Pricing Policy on this investment and divisional profits. You should support your answer with suitable analysis and revised profit statements (these should be included as appendices to your report). Your report should be produced in a Word document containing no more than 1,000 words (+/- 10%).
In: Accounting
In: Accounting
Please read the following on NC Economic Incentives: We have all heard that Amazon is planning on opening a second headquarters. The hope is that this new HQ could bring in 50,000 jobs and $5 billion in investments. As a result, states are in a bidding war to attract Amazon. These bids are what we can economic incentives. Many politicians have argued that the government should provide economic incentives to companies in order to bring jobs to NC. The proponents of economic incentives programs say that they are necessary for the State to give tax breaks, subsidies and other benefits to attract large companies to NC. Unfortunately, many other states are doing the same thing, thus making any NC incentive program difficult and expensive. For example, after some of the first Hunger Games movie was shot in NC, much of the subsequent movies went to Georgia. The point is that other states are outbidding NC and businesses are following the money and not coming to NC, but instead are going to other states. The opponents of State Sponsored Economic Incentives for businesses call this Corporate Welfarism. They point to the many times that government has failed to achieve its goals. Opponents of government economic incentives say that the program is too expensive for the results generated. More fundamentally, opponents say that the state shouldn't use tax money to pick winners and losers. They point to the failed attempts to pick Dell, Google, and Boeing; they point to government mistakes such as the "famous" Randy Parton Theater Project. (See here: https://www.carolinajournal.com/news-article/no-celebration-for-randy-parton-theaters-10th-birthday/) Additionally, they claim that picking winners leads to crony capitalism. 2. Suppose that you have been called to Raleigh to give expert testimony before a joint North Carolina House and Senate Committee assigned to review North Carolina's economic incentive policy. Using the questions below to help guide your testimony to the committee, write a three to four page paper in a Microsoft Word document to respond to this issue: When government uses tax monies to attract businesses (creating economic incentives--both the positive and the perverse), what are the short-term effects? What are the long-term effects? What are the effects on the local community? What are the wider implications? Can this problem be explained in a game theoretic context? If government economic incentives are so good, then why is it that North Carolina has reduced the amount of incentives offered to film and television companies? [Note: When economists use incentives, they mean it in a particular sense: broad institutions that influence people's decisions. So while a coupon for $5 off is an incentive, that is not what is being asked. Instead, economists look at broader policy implications. For example, unemployment insurance pays people if they do not work. Thus, the policy (regardless of intent) creates an incentive not to work.] 3. Your paper should be in written in APA style with appropriate references and bibliography. Titles pages and abstracts are NOT necessary.
In: Economics
Although the increasing popularity of the Southport neighborhood has generally been a very positive development, there are a few negatives associated with it. You already addressed parking concerns. Another serious issue involves criminal activity. Southport has always had low levels of violent crime, and fortunately this doesn't appear to be changing. However, there has been a significant increase in vandalism and graffiti incidents. The police force is already working overtime, but it just can't keep up with the rapid growth.
Because of these issues, the City Council is considering options to increase monitoring and reduce the load on law-enforcement officers. The budget is limited, which means it is important to make a cost-effective decision. The options being considered are described below:
The city has obtained data from other areas regarding the effectiveness of hiring additional officers and installing cameras and lights. The city has estimated that each crime prevented is worth $1,000 to the city (the amount includes the expenses incurred by the police department, courts, and prisons) Each additional police officer would be paid $20,000 per year. Each security camera/light installation would cost $8,000 per year to operate and maintain. A summary of this data is below:
| Number of Crimes Prevented Per Year |
Number of Officers Hired |
| 21 | 1 |
| 47 | 2 |
| 76 | 3 |
| 104 | 4 |
| 128 | 5 |
| 149 | 6 |
| 165 | 7 |
| 178 | 8 |
| 188 | 9 |
| 195 | 10 |
| Number of Crimes Prevented Per Year |
Number of Camera/ Light Installations |
| 6 | 1 |
| 13 | 2 |
| 25 | 3 |
| 33 | 4 |
| 40 | 5 |
Write a 300- to 500-word report to John Becker. In your report, be sure to
In: Economics
In: Nursing