Finline case historyMs. Yambedi is the
Finline case history
Ms. Yambedi is the Marketing director of Finline, a small financial services company. Ms. Yambedi is defining
the company’s marketing plan, or to be precise, she is deciding which products to offer to the clients, which
tariffs to apply and how to advertise the services offered by the company. As far at the latter is concerned,
every year the company’s president designates a budget that Yambedi can spend on marketing. For 2004 the
budget is $100,000. The objective that Yambedi proposes in the marketing plan is to maximise revenues
derived from the number of customers (estimated at $1000 per client).
Yambedi must decide what type of media to use, which marketing message to put across, in which countries
to launch the advertising campaign and which target audience to aim at. There are various factors which can
influence the success of the advertising campaign: above all the receptivity of the clients, which strongly
depends on the global economic climate; secondly the ability of the media used to reach a high number
potential clients, which can for example be measured with indicators such as the number of newspapers sold
or the number of television viewers or radio listeners; and finally, the aggressiveness of the advertising
campaigns launched by its competitors. Following a careful analysis of the sales data of past years and
information about its present clients, Yambedi has identified three possible alternatives:
• The first is an advertising campaign carried out with the main newspapers. This alternative costs
$88,000 and has a fairly certain return as the number of selected newspapers sold is high and quite
stable, and Yambedi could precisely calculate a rate of expected return. With this method an average
number of 10,000 clients per year can be expected, with a standard deviation of 3,000 per year.
• The second alternative involves advertising on an internet site of the company, where various services
are offered. The cost of this method is higher, at $100,000 which is mainly due to the design and
maintenance of the site. The expected return is higher - 18,000 clients per year, but uncertainty is high
because the number of hits to expect, and their possible return is not precisely known (the standard
deviation is 15.000).
• Lastly, Yambedi has identified the possibility to use specialist newspapers and conventions of the main
operators. The expected value of the number of clients is 8,000 per year, with a fairly high variability of
5,000 per year, due to the lack of knowledge of these channels of communication. The cost of this
method is $66,000.
Yambedi has actually identified a fourth alternative, which seems to be in a dominant position as far as the
expected returns and level of risk is concerned (expected return value of 25,000 clients per year and standard
deviation of 10,000 per year). This is to associate the company’s image with a company of international
standing, in particular Beldiline, and to transmit the advertising message in connection with those released by
the larger company. This alternative has, however, a high cost of $250,000, well over the budget available.
1. Highlight the objectives, constraints and limits of the Yambedi’s decision-making process.
2. Reconstruct Yambedi’s decision-making process, highlighting important variables, their causative
relationships and finally, the alternatives generated.
3. Which criteria might Yambedi use for her decision?
4. Suppose that Yambedi wants to weigh up the expected value with the risk of each alternative, which
approach and thus which alternative will she choose?
5. In your opinion, is it possible, with some modifications to the current decision-making process, for
Yambedi to consider the alternative of the partnership with Beldiline? If yes, what modifications are
necessary and in what conditions is it possible to carry out this campaign? What alternative would you
choose if the latter was possible?
[SOLVED] Project Guideline: Forecasting Demand Forecasting for
[SOLVED] Project Guideline: Forecasting
Demand Forecasting for the Inner-city Health Center
Inner City Health Center is a federally funded health clinic that serves the needs of the inner-city poor. Currently the center is at the end of third-year operation and is preparing its staffing plan for the upcoming year. The federal government requires that the center prepare a budget request each year. The request is based largely on the forecast of the # of Patient Visit for specific services during the next year.
The health center administrator has in the past tried using the last month’s # of Patient Visit and has also tried using the average of all historical data to predict the next period’s # of Patient Visit for the center. Neither of these two techniques has proven satisfactory due to complicated month to month data pattern. They are currently seeking outside helpers to forecast the # of patient visit for the upcoming January year 2016.
The # of patient visit each month in the preceding three years (including the current year) is available in the following Table.
Table. Emergency Service Demand for the Inner-city Health Center
Month
# of patient Visit
Year 2013
Year 2014
Year 2015
Jan.
251
382
537
Feb.
317
462
574
Mar.
329
464
652
Apr.
399
529
682
May
461
619
729
June
536
659
747
July
495
597
673
Aug.
455
548
676
Sept.
411
469
665
Oct.
343
490
571
Nov.
286
474
605
Dec.
288
375
562
Assignment: You may copy and paste the data to your Excel Spreadsheet. I would also suggestion that you re-arrange data into a 2-dimension table (Months, #of patient visit). To do so will make your job easier.
• Forecast
• Use a 3-month Moving Average Method to forecast the # of the emergency visit from April 2013 to January 2016.
• Use a Linear Projection Forecast Method to forecast the # of the emergency visit from January 2013 to January 2016.
• Use an Exponential Smoothing Forecast Method, with = 0.3, to forecast the # of the emergency visit from April 2013 to January 2016. Assume that initial forecast for March 2013 is 400.
• Plot One (nice) Chart for Data Series over time (Jan 2013 to Jan 2016):
• the historical data series,
• the data series of forecasts obtained in 1a), 1b) and 1c).
• Can you tell which of the three forecast methods is the best based on the chart?
• Use one of forecast Error Measurements, either MAD, or MSE, or MAPE (you choose) to determine which of the forecasts from 1a), 1b) or 1c) provides the best (smallest) forecasting error summary from the given historical data set.
• It is important to point out that error comparison of different forecast methods should be done on a Consistent Base. That is, the forecast error comparison for different forecast methods is meaningful only when we compare errors from the Same Range of forecasts.
• For the Exponential Smoothing forecast obtained in 1c), use Tracking Signal to monitor the forecast results and draw a conclusion on whether or not the forecasts are Biased, assume C = 3, and -C = -3 to be the control limits of the tracking signal method.
• Use the same Forecast Error Measurement you used in question 3), find the best smoothing parameter (i.e. the that leads to the smallest forecast error) of Exponential Smoothing Forecast Method.
• For the given historical data set,
• Based on the data pattern of the three-year data set, one can argue that the forecast methods used in 1a)-c), or, in general, we may conclude that Moving average, Linear Trend Project, and Exponential Smoothing Method should not be good Forecasting methods for the given data set. Can you Explain why?
• Propose Your Own Forecast Method (Other than the Moving Average, Linear Trend Project, and Exponential Smoothing Method) that might be better than the forecast methods 1a) - 1c). Use the Forecast Method proposed to do forecasts from May 2013 to December 2016.
• Use the Same Forecast Error Measurement as you used in part 3) to calculate forecasting error from your method, and then to compare the forecasting error with the results you obtained in 1a)- c). Is your method better?
•
Week 2: September 18 - 24 Print
Week 2: September 18 - 24 Print
This week you will get to know your client company: the important features of the industry in which it
operates and the important features of your client that will help it to operate successfully within its
industry and in a new country market. Your industry analysis will assess how industry features and trends
can represent either opportunity or threat to your client. Your company analysis will assess your client’s
internal strengths that can give it an advantage over its compe
tors, and its internal weaknesses that may
put it at risk in the market. The analy
cal tools you will use are Porter’s Five Forces for industry analysis;
and Value Chain Analysis and Resource analysis for exploring where your client may have par
cular
Strengths and Weaknesses . Next week you begin country level analysis—to assess poten
al opportuni
es
and threats for your client in different countries.
[SOLVED] ASSIGNMENT: Industry Profile [5-7 pages] -
[SOLVED] ASSIGNMENT: Industry Profile [5-7 pages] - Company (TESLA) - DUE SUNDAY
9/24/17
Introduction (1/2 Page)
Five Forces +2
-New Entrants
-Buyers
-Supplies
-Substitutes
-Rivalry
-Technology Trends
-Government Influences [Combined 3 pages]
Economic Opportunity (1 Page)
Threats (1 Page)
Strategies to mitigate risks (1 page)
Conclusion (1/2 Page)
2. ASSIGNMENT: Group Profile of client company [10 pages] -DUE SUNDAY 9/24/17
Introduction [1/2 page]
1. The Company [2 pages]
2. The Buyer [2 pages]
3. The Resources [2 pages]
4. Competition [1 page]
5. Strengths [1 page] (Tesla Motor)
6. Weaknesses [1 page] (Tesla Motor)
Conclusion [1/2 page]
As you can see, fitting all the requirements in within the maximum allotted page count can be
difficult.
This may not be perfect but gives us an idea of of the type of writing load we have.
Other key tasks:
Task:
Compiling teammate entries into single APA formatted paper in accordance with assignment
requirements (includes cover page, table of contents, references).
Task
Editing
Allowing time for the systematic review by each team member prior to submission.
Task:
Submission
There is 5 of us total and approximately 15-17 pages worth of writing.
Editing will be a group project essentially after the fact.
The compiling and formatting is an intensive process. I did this for my last classes, but it still
took me a good 1-2 hours depending on the quality of product coming in; followed by another 1-
2 hours of intensive editing.
I would suggest that you take on little writing during the week because the big lift will be the
formatting and initial edit.
We should wait to write introductions and conclusions until we have a cohesive product. I find
writing these ahead of time prove fruitless. They are relatively quick kills, but ensuring you
allocate page space is critical to stay within the page count. It's okay to initially exceed the page
count, because I find it's easier to edit and cut back after.
For me personally, with a shortened week; I would like to see initial writing products turned in by
Friday Night, because of the time zones I could compile these papers and format them first thing
Saturday morning. Allowing two full days of editing and corrections over the weekend before
the submission. However, I understand if you all want to move that up. It'll be challenging for
me personally, but I'll make it happen.
Also, Toyota operates in many of these countries. Paula mentioned Thailand, but Toyota
already has operating plants in Thailand. Who specifically wrote about Toyota in last weeks
discussion posts? Brazil already has a number of Toyota plants. This is why I pointed out a
company like Tesla that is largely only operating out of the US with distribution into Europe. If
you see the paper content, very little covers the specific company itself. I think this class is
more about the processes rather than the specific company we choose.
Finally, everyone does need to review the flow of the class. Including looking forward to future
assignments. This class is one large project and everything flows in together. Understanding
the end state and milestones along the way will allow us to better execute the individual
assignments we have week to week.
Based on the recommendations and analyses done
Based on the recommendations and analyses done by your team members, each Team will select its “client” company. Your
goal is to select a company in an industry with long-term growth potential and a company that is not already operating in
many of the BRICS+11 countries (which would leave you with little room for international expansion).
By Monday midnight, ONE Member should Post your client company name and industry in your Group Assignment folder
and title it CLIENT COMPANY AND INDUSTRY Explain why the team has selected this company as the client for the
strategy project, using both industry and company data to support your choice.
[SOLVED] Team Work Plan(The team projects
[SOLVED] Team Work Plan
(The team projects in this seminar require you to work together throughout the semester. One of the most
significant factors in effective team performance is effective time management. Teams that have been
most successful in the MBA program have allocated time each week to work on their projects. They have
completed drafts sufficiently in advance of the due dates to allow editing to produce a cohesive quality
document written in a single voice.)
Team work plans help team members to more effectively plan their time and avoids unnecessary
duplication of effort. In addition, if everyone knows what they have to do, what they can expect others to
do, and when they must deliver their contribution or can expect to receive the contribution of another
study group member, the possibility of a conflict over who should have done what and when can be
minimized.
Work plans are to be posted in the study group's assignment and locker in the week preceding each team
assignment. Faculty expect each member to make a meaningful contribution to the weekly assignments
and to follow the process outlined in the work plan. All of the contributions of each study group
member to the assignments must be posted in the study group's locker. Usually all the team members
receive the same grade for the team project, however, an individual’s grade may be reduced if the
individual did not contribute in a meaningful way to the team assignment. This determination will be
made by evaluating the member's individual contributions posted in the study group locker and
comparing them to the work plan.
Sample Work Plan: Team Tasks & Timeline for Delivery (Revise as appropriate for each team assignment.)
Task
Responsibility of Due to Thera by Final Edits due to
Thera by
Week 2
Company Description Paula Thursday, 9/21 Saturday, 9/23
Company Strengths Abram Thursday, 9/21 Saturday, 9/23
Company Weakness Abram Thursday, 9/21 Saturday, 9/23
Global Industry Description Paula Thursday, 9/21 Saturday, 9/23
Risk Mitigation Strategies for
the selected country of entry
Joshua Thursday, 9/21 Saturday, 9/23
Opportunity Exploitation
Strategies for the selected
country of entry
Christopher Thursday, 9/21 Saturday, 9/23
Business Plan TemplateYour job as hired strategists
Business Plan Template
Your job as hired strategists is to analyze the market data, organize it logically, and
usefully communicate that analysis in a way that will achieve your objective: buy-in and
funding for your proposed entry strategy. Use this template to integrate the research and
analyses (course assignments) into your proposed business plan.
Effective communication consists of a short executive summary of the Business Plan,
followed by a supporting document in which each section is organized in a way that will
best support the analysis and recommendations. As you begin your executive summary
(after completing the business plan), please use this first template sentence, representing
the outcome of your analysis, to keep your executive summary focused on support for
that recommendation.
"It is recommended that (selected client company) enter the_(named country) with
its (specified product/service) through a _(specify the type of legal structure) with
(selected company partner or acquisition)."
CONTENTS OF FINAL BUSINESS PLAN
Title Page
? State the client company, country and size of its market for the client’s
product/service, recommended legal structure, and alliance partner: for example:
Business Plan for [NAME OF COMPANY] to enter [COUNTRY’s] $(SIZE OF
MARKET IN DOLLARS) market for [PRODUCT/SERVICE] through a [type of legal
structure] with [NAMED ALLIANCE PARTNER]
? Date and contributing team member names
Table of Contents
? Page numbers for each major section
Executive Summary
? These 1-2 pages summarize the results of your analysis and how you arrived
at the recommendation.
? It is NOT an introduction, so you would not use words like “this paper will..”
The exec summary is all about what the paper DID do (not will do) and
therefore parallels the conclusion, not the introduction.
? It is a separate stand-alone summary, not a part of the paper body.
? Belongs on a separate page from the introduction to the paper.
1. Introduction (first paragraph of paper body)
? State the purpose of the paper
? Tell what the paper will do
? Name the industry, country and company
2. Company Description (Week 2 company profile) - PAULA
? Company type of business and industry
? Company product/service
? Targeted buyer and buying proposition (what needs/desires the product meets for
the targeted Buyer –and User if different from Buyer)
? Rationale for international expansion
? Goals and objectives for international expansion
? Company supports needed to be successful in country (e.g., will it need an in-
country workforce? Transportation infrastructure? Internet access? Facilities?)
3. Company Strengths (Week 2) – ABRAM
? Describe special features of the product or service
? Identify company competencies (competencies reside in people)
? Identify company assets that may strengthen the company’s competitive position
(e.g., human, financial, geographic, contractual, political assets)
? Identify company processes that may be a competitive advantage (e.g.,
manufacturing efficiencies, vertical or horizontal integration)
4. Company weaknesses (Week 2) - ABRAM
? These are the flip side of the strengths; e.g., undifferentiated product, lack of
human resources/skills; limited financial assets, no unique processes that set it apart
from competition
5. Global Industry Description (Week 2) - PAULA
? Global Industry Opportunities and Threats
? Global industry trends (e.g., technology change, growth forecasts)
6. Country Selection Rationale (Week 4)
? Explain the process for selecting the two countries you compare in this plan
(how you pared down from 16 to 2 countries)
i. Macro-level comparison of countries (opportunities/threats)
ii. Countries that are new to the Company
iii. Selection criteria/rationale for the two countries selected for analysis
iv. Ability to meet company support needs in country (section 2 above)
7. Country Comparison (Week 4)
? Opportunity comparison across the two analyzed countries
i. Market size, growth
ii. Business climate
iii. Industry structural advantages (e.g., access to suppliers; ease of entry;
government support; limited internal competition…)
iv. Other opportunities from PESTEL and Industry factors
? Risk comparison across the two analyzed countries (Week 4) - JOSHUA
i. This is the flip side of opportunity; focus only on risks relevant for your
company;
ii. Identify general level of competition in the countries (intensity, number
of competitors and potential new entrants/availability of substitutes)
iii. Other risks from PESTEL and Industry factors
8. Summary rationale for country selection (Week 4)
? Summarize opportunities and threats for both countries
? Explain major reasons for recommending the country of entry
i. Total Country market size and growth reflects the Opportunity
ii. Opportunity support factors
iii. Threats (to be mitigated, but not significant enough to override
opportunity)
9. Target Market size (Week 6)
i. Estimate Target Market(s) in dollars or units or buyers
ii. Estimate growth of Target Market over 3-5 years
10. Competitive risk/advantage in the selected country of entry (Weeks 6,7)
? Identify key multinational and local competitors and their competitive threat
? Identify client company’s competitive weaknesses
i. Relative to specific competitors
ii. Relative to other country threats (identified in 8. iii)
? Identify the competitive advantages of your company (based on strengths in Section
3 above, relative to competitors)
11. Risk Mitigation Strategies for the selected country of entry (Weeks 2, 6,7) -
JOSHUA
? Recommend strategy to mitigate competitive threat identified in section 10 above
(e.g., cost, differentiation, and/or focus strategies)
? Recommend mitigating strategies that would be needed for each of the industry
threats identified in 5 above (Week 2)
? Recommended mitigating strategies that would be needed for each of the other
country threats identified in 8. iii above (e.g., local partner/agent to mitigate
cultural and/or regulatory threats)
12. Opportunity Exploitation Strategies for the selected country of entry (Weeks 2, 7)-
CHRISTOPHER
? Recommend Strategies to exploit Opportunity and Opportunity support factors
(identified in 5,and 8i and 8ii above)
13. Entry Strategy Legal Structure (week 8)
? Develop 2 potential Entry Structures (legal) that will:
i. Mitigate specific risks
ii. Realize specific market opportunity
? Describe any alliance partner or in-country relationship
i. Specify how the in-country relationship supports and makes possible the
entry strategy and/or the risk mitigation strategy (these are benefits to your
client company)
ii. Will the partner/alliance help with competing, with overcoming country
threats?
iii. Justify the strategic “fit” with the partner /alliance organization.
a. How will the alliance with your client benefit the partner?
b. What are the “costs” to the partner (what will the partner contribute)?
? Compare the advantages/disadvantages of the two structures
? Summarize selection rationale and recommend one entry structure
14. Entry Strategy Organizational Structure for the recommended legal structure
(Week 8)
? Create organization chart showing :
i. your client’s salaries/costs for each position
ii. your client’s relationship to outside/alliance organizations (dotted lines)
? Describe responsibilities for each position in the organization chart
? Estimate capital/cost requirements for the structure (facilities, equipment)
15. In-country marketing plan and costs (week 9)
? Product modifications if needed and estimated costs to modify
? Pricing strategy and Price recommendation
? Promotional message
? Channels and methods for communicating product value to the target market and
estimated costs of materials and channels
? Estimated market share: What percent of the target market (9i) your client is likely to
gain
16. Financial Value of the entry strategy (create projected Income statement) (week 10)
? Estimate Revenue for first year of operation (Price x market share in units)
? Cost estimates for year zero and year one
i. Year zero: Start up costs before revenue is generated (e.g., negotiation time,
build-outs of facilities, importing of inventory)
ii. Year one: Operational cost estimates
a. Headcount dollars from organization chart
b. Promotional expenses from marketing plan,
c. Equipment and facilities expenses (e.g., office supplies, rent)
iii. EBIT: Potential profitability (Revenue less expenses)
? Separately identify Capital investment (e.g., in plants, depreciated
equipment), but balance sheet is not required.
17. Balanced Scorecard (week 11);Specify the major factors to be tracked for your strategy
to be successful
18. Conclusion: Two-three brief paragraphs summarizing the strategy and its expected
strategic and financial benefits,
Some Final Advice: Format & Integration
The final team project paper should be approximately 30 pages, exclusive of cover page,
appendices and references. References should be in proper APA format.
[SOLVED]topic three: program reflectionsSubscribeHide Description
[SOLVED]topic three: program reflections
Subscribe
Hide Description
Reflect on the program as a whole. What will you be able to use most in the future?
[SOLVED] Topic One: project reflectionsSubscribeHide
[SOLVED] Topic One: project reflections
Subscribe
Hide Description
Do you think your "client" company would benefit from the business plan your team developed? Why or why not?
[SOLVED]Topic two Company perspectiveLocked after Sunday,
[SOLVED]Topic two Company perspective
Locked after Sunday, September 17, 2017 11:59 PM EDT.
Subscribe
Hide Description
Using financial performance information at the company level for your selected Industry in topic one, discuss your
views on the following questions. Use and refer to the assigned readings to support your views.
1. How is it that, even among the best performing industries, only some companies do well? How can some
companies in poorly performing industries still do well?
2. Generally speaking, for companies in the same industry, what factors would explain differences in company
performance over the long term?
3. Which company in your selected industry would you recommend for your team's strategy project? Explain why,
using data to support your recommendation. Remember that you will want to select a company that is not already
operating in too many of the BRICS+ Next 11 countries, as that would leave you with little room for international
expansion.
[SOLVED]Using information from the ABI Inform and
[SOLVED]Using information from the ABI Inform and GlobalEdge Databases of Industry Performance, select data on the
following subset of industries:
automobile
healthcare
financial services
consumer goods
telecoms and technology
Based on the data you find, discuss your views on the following questions.
1. What kinds of industries tend to be better performers in the medium to long term? Why? What kinds of industries
tend to do poorly in the medium to long term? Why? Refer to the readings to support your views.
2. Can you make the claim that some industries are inherently more profitable than others? Provide arguments and
examples to justify your response.
3. Which of these industries would you recommend for your team's strategy project? Justify your recommendation.
Tips for Effective Business WritingHere are some
Tips for Effective Business Writing
Here are some basic suggestions that I hope will increase the effectiveness of your writing in business and other
management environments
First, decide the purpose of your writing. It is usually either to inform or to convince (persuade)
You should almost always follow the time-tested "formula" of Introduction, Body, Conclusion
Use the Introduction to clearly state your purpose or position, and to give a "roadmap" (outline) to the rest of your paper
In the Body, give your pieces of information or arguments one by one, setting them off from one another with meaning-
filled (think use of verbs) section headings if this helps comprehension - and such headings almost always do
Provide some concrete (specific) examples to support your arguments
It is usually better to develop a few good examples - explaining them as necessary - than simply to list some large number
of examples only by name
Summarize what you've said in the Conclusion, avoiding putting new material there which should have gone into the Body
In the Conclusion, leave your reader with something to remember, perhaps a "lesson learned", a "takeaway" or a concrete
recommendation for action
If you use an Executive Summary, remember to place it at the beginning of the paper and to include all key results in it
Don't forget to spell- and grammar-check! (Not only your computer software, but also a friend or spouse's review should
be helpful here)
[SOLVED] Individual Assignment (End-of-Seminar Project) (8%)Each student
[SOLVED] Individual Assignment (End-of-Seminar Project) (8%)
Each student is to
Identify an important managerial challenge facing his or her work or other organization.
Develop a plan that integrates effective financial and operational decision making to successfully meet this challenge and improve organizational
performance, in a succinct report that includes an executive summary.
More Information:
What is a succinct report? Could it be 10 pages or less? One reads that IBM decision papers are limited to that length, and we all recall the single-sheet Ringo
Sho approach to important decisions at Toyota.
As to overall plan format, I-B-C (http://polaris.umuc.edu/~jstewart/StewartWebSite/writingt.htm) is, recommended for your consideration.
A results-filled executive summary (ES) should lead off the plan. This link is to "How to Write an Executive Summary" in Course Resources. You may also
benefit from a review of the files in Course Resources specific to Writing Guidelines and the files showing proper APA citations.
Your individual paper must be posted in your assignment folder by the due date. Remember that there are NO EXTENSIONS of this final due date.
[SOLVED] Week 11 DiscussionLocked after Sunday,
[SOLVED] Week 11 Discussion
Locked after Sunday, August 6, 2017 11:59 PM EDT. Must post first.
Subscribe
Hide Description
Assignment: Discussion Activity (8%)
Each student is to critically assess the 1) mission, 2) goals, and 3) importance of information
systems and their management (ISM) in the firm, 4) using their own work organization as an
example.
Clarification:
The single most important point made in these materials is that information systems, and their supporting
information technology plus included telecommunications technology, are not drivers in well-managed
organizations; instead, they are when properly used, supporters of the business mission and strategy.
That is true of UMUC, where the mission is educate with the major marketing strategy to be online. It is also true of
Amazon.com, where the mission is to make a profit selling a wide number of products, and the major marketing
strategy is again, online.
The second most important point, stressed by Professor McFarlan and epitomized by Amazon.com, Apple and Google,
is that properly-designed and -implemented information systems can convey a strategic competitive advantage to
their enterprises.
Example: Here is a start on contributing to this week's discussions, with an example using UMUC as the firm.
The mission of information systems management at University of Maryland University College is
to support the teaching and administrative processes of the university in an efficient and effective
(!, recall operations management) way
The goals of UMUC ISM include:
Being at the state of the art in course delivery at a distance. That's why we have used Webex,
google- and pdf format and audio/video materials
Providing 24x7 reliability in the Learning environment, in PeopleSoft and other essential
information systems. 360 Support is on call via message and telephone at all hours, for instance.
Conserving State and student (ie, tuition) resources in accomplishing the foregoing, which
Maryland taxpayers and the state legislature expect.
The importance of ISM at UMUC is extremely high, given
First, that the University has strategically decided to be the open university of Maryland and the
United States, providing learning services to a growing student body mostly* at a distance, thus
using information systems heavily.
Second, there are a plethora of state and federal regulations, plus community standards, that
govern the management of information at UMUC and thus provide continuing, importance-raising
challenges.**
*Currently, about 82% of UMUC Adelphi students study exclusively online, and another 10% learn through a
"hybrid" online/F2F program.
**One example is the accommodation requirements of the federal ADA - Americans with Disabilities - Act. These
require that information be delivered at UMUC in ways that accommodate, for instance, visually- and hearing-
impaired students. This means, for one example, that we must prepare - and pay for - transcripts of audio
materials for hearing-impaired students (and some professors too).
Let the discussion begin. You must first post your contribution, then respond to at least two of your classmates'
contributions with a thorough analytical critique. Agreement or disagreement is not the point; the point is to air
different perspectives so they can be compared, distinguished, and evaluated.
[SOLVED] Reading (Required):Jacobs, F.R & Chase,
[SOLVED] Reading (Required):
Jacobs, F.R & Chase, R.B. (2013). Operations and supply management: the core, 3e. New York: McGraw
Hill/Irwin. Chapter 1 (in eReserves) Jacobs & Chase Operations and Supply Management, The Core
Multimedia (Required):
D’Mello, J. (2015). Introduction to operations management. AMBA 640 / DMBA
620. https://www.youtube.com/watch?v=WERYyASsKzQ
.
Closed captions available in the video
Assignment: Discussion Activity (8%)
Each student first succinctly defines in his or her own words the phrases “operational efficiency”,
“operational effectiveness”, "operations strategy" and "operational sustainability."
In addition, each student defines the concept of “quality” as used in his or her work organization or
family and presents examples.
Further, each student defines Six Sigma, and comments on its applicability and advises its value, if
any, in his or her or another organization.
Be prepared to do online research to learn more about Six Sigma as an important OM technique in the reduction
of production errors albeit at a high price to the enterprise using it.
Clarification:
You may or may not be able to agree with the following distinction between "operational efficiency" and
"operational effectiveness":
In terms of executing the day-to-day processes of an organization - ie, its operations,
Efficiency refers to resource conservation, while
Effectiveness has to do with mission or task accomplishment
The photographs in the Week 9 Content module could help to make this distinction clear.
There are numerous important external factors that affect the operational effectiveness and operational efficiency
of an organization. Two of the most significant external factors, typically, are resource constraints imposed
from above and laws and regulations with which compliance is required.
7/18/2017 Week 9 Discussion - DMBA 620 9044 Effective Financial and Operational Decision Making (2175)
https://learn.umuc.edu/d2l/le/271026/discussions/topics/1691129/View 2/2
Quality is rather hard to define. You may or may not be able to agree that in essence, quality means either
the "best" or the "best for the price".
According to the full version of Jacobs & Chase (2009) (ISBN 978-0073403304),
Six Sigma is a philosophy and set of methods companies use to eliminate defects in their products and
processes
However, whether or not you agree with the above views,
You are to succinctly define in your own words the phrases (1) "operational efficiency", (2) "operational
effectiveness", (3) operations strategy, and (4) operational sustainability
Then, you will define the concept of (5) "quality" as used in your organization
Finally, you are to define (6) "Six Sigma," and comment on its applicability and value, if any, in your
organization.
After posting your response, you are to respond to at least two of your classmates' postings. Be sure to think
analytically-- agreement or disagreement is not the goal. You must critique, compare, evaluate, and use
examples to clarify your points.
Should you not be working outside the home, you may refer to any organization of your choice, to include your
family.
[SOLVED] Gary Allison accepted a position at
[SOLVED] Gary Allison accepted a position at Scientific Engineering Corporation (SEC) soon after graduating with a Ph. D. in mechanical engineering. Over the
last 14 years he established a reputation as a respected and talented project engineer. Everything changed once he accepted a position as Project
Manager on the Orion Shield Project.
"This is impossible! Just totally impossible! Ten months ago I was sitting on top of the
world. Upper-level management considered me one of the best, if not the best engineer in
the plant. Now look at me! I have bags under my eyes, I haven't slept soundly in the last
six months, and here I am, cleaning out my desk. I'm sure glad they gave me back my old
job in engineering. I guess I could have saved myself a lot of grief and aggravation had I
not accepted the promotion to project manager."
Click the ABOUT SEC button (upper right corner of the screen) to learn more about Scientific Engineering
Corporation and the Orion Shield Project. Then click the forward arrow to start the scenario.
[SOLVED]Exercise 1Toyota Motor Corporation (1998 ff). The
[SOLVED]Exercise 1
Toyota Motor Corporation (1998 ff). The Toyota production
system. http://www.toyotageorgetown.com/tps1.asp
Exercise 2
Mind Tools. (n.d.). Grid analysis. http://www.mindtools.com/pages/article/newTED_03.htm
Exercise 3
Mind Tools. (n.d.). Decision tree analysis. http://www.mindtools.com/pages/article/newTED_04.htm
Knode, C.S. (2011) Decision tree video (setting up the problem). http://vimeo.com/duffer44/decision-
trees-part-1
Download Transcript
Knode, C.S. (2011) Decision tree video 2 (determining the value of perfect information
valuation).http://vimeo.com/duffer44/decision-trees-part-2
Download Transcript
Knode, C.S. (2011) Decision tree video 3 (determining the value of imperfect information
valuation).http://vimeo.com/duffer44/decision-trees-part-3
Download Transcript
Exercise 4
Do online research on "Toyota production North America" and similar topics.
Consider contacting the Toyota Motor Company USA on these topics.
[SOLVED]Lexus RX 350, Successor in 2007 to
[SOLVED]Lexus RX 350, Successor in 2007 to the RX 330
Assignment Taskings
Address the following four exercises:
Exercise 1: Making a Critical Assessment of the Toyota Production System (TPS) Today
a. Demonstrate your team's basic understanding of the TPS by 1) defining in your team's own
words any eight of the terms found athttp://www.toyotageorgetown.com/terms.asp, and
2) applying them to one or more of your team's own companies or other organizations.
For example, Pokayoke can be defined as an approach to create mistake proofing through use of
devices that detect or prevent production errors. At a software development firm, pokayoke might be
applied through use of a modular development process that includes extensive software module
testing before proceeding to module integration and total system testing.
b. Describe the TPS as a total entity. What are its purposes? Its advantages? Its limitations? How is it
now evolving? Is it getting better – or not? Has it been successfully copied by other motor vehicle
manufacturers? Why or why not?
Exercise 2: Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant
Location Decision for the RX 330
This exercise illustrates how when deciding among two or more competing plant location options,
various decision factors (which can typically be characterized as exogenous - in a company’s external
environment - or endogenous - internal to the company) can be qualitatively identified, and how
these factors can then be weighted to obtain an overall score for each competing location option.
a. List the factors your team considers key to the Toyota Motor Manufacturing Canada (TMMC): The
Lexus RX 330 Line North American plant location decision, identifying these factors as either
exogenous or endogenous, weighting them using your team's best judgment (stating any relevant
assumptions or constraints), and assigning two scores to each factor: one for production of the Lexus
RX 330 at TMMC, and one for production at a Toyota factory in the USA.
b. Using the scores from your team's weighted scoring model and working with regard to Ringo Sho
and Nemawashi, make and support your recommendation for the RX 330 North American plant
location - TMMC or a factory in the USA.
Exercise 3: Determining Production Capacity Needed at Toyota Motor Manufacturing of Canada
(TMMC)
Decision trees are another important if challenging world-class operations management method
which operations managers should understand and with which other managers should be familiar.
This exercise illustrates how using a decision tree, determination of an "optimal" production capacity
option can be made from among several possible capacity options based on the provided probable
market demand and expected costs/payoffs of events that influence the options.
It is spring 2000, and TMMC has indeed just been chosen to produce the new Lexus RX 330 line, with
the first units deliverable in 2003. Toyota must now determine the amount of annual production
capacity it should build at TMMC.
Toyota's goal is to maximize the profit from the RX 330 line over the five years from 2003-2007. These
vehicles will sell for an average of $37,000 and incur a mean unit production cost of $28,000 (here, $ =
the Canadian dollar).
10,000 units of annual production capacity can be built for $50M (M=million) with additional blocks of
5,000 units of annual capacity each costing $15M. Each block of 5,000 units of capacity will also cost
$5M per year to maintain, even if the capacity is unused.
Assume that the number of units actually sold each year will be the lesser of the demand and the
production capacity.
Marketing has provided three vehicle estimated demand scenarios with associated probabilities as
follows:
Demand 2003 2004 2005 2006 2007 Probability
Low 10,000 10,500 11,000 11,500 12,000 0.25
Moderate 15,000 16,000 17,000 18,000 19,000 0.50
High 20,000 24,000 26,000 28,000 30,000 0.25
a. To maximize profit earned during this period, which production capacity should TMMC in 2000
decide to build - 10,000, 15,000, 20,000, 25,000, or 30,000 cars? Justify your choice.
You may use the following decision tree developed by Toyota operations analysts in Toyota City,
Japan - or your group may choose to vary it in some way based, perhaps, on its presumed better local
market knowledge.
b. What are the weaknesses or limitations in this analysis? How might they be corrected or at least
reduced?
c. It is now late 2016. How well has the RX-330/350 actually done in the North American market? Is
its quality rated as high as if it were made in Japan?
Do some online research; it's part of improving your attainment of Information Literacy, one of
the UMUC MBA Competencies. Here see the Content/Week 10 references on Grid
Analysis and Decision Trees
Exercise 4: Assessment of Toyota’s Current Regional Production Strategy
North America
Source:www.worldatlas.com/<wbr><wbr>webimage/countrys/na.htm,
a. After doing necessary research online or otherwise, document and evaluate the current distribution
of Toyota production in North America. Here be sure to include Mexico.
b. Why does the team believe Toyota has chosen to produce its cars in the current manner? Has
Toyota been wise, or not?
In effect, this exercise provides the team an opportunity to think ahead to the politico-socio-economic-
technological considerations that will be quite important in DMBA 630.
Assignment: Group Assignment (10%)? Each group completes the tasks
Assignment: Group Assignment (10%)
? Each group completes the tasks to be found in the Week 10 Assignment, deciding where and
how Toyota should produce a particular Lexus model in North America, by the end of this week,
in a succinct report that includes an executive summary. The group product should be submitted
in the Group Assignment Folder by the end of the week
? Peer evaluations must be completed and submitted in each individual's assignment folder by
the end of the week
Assignment Clarification:
To properly complete this assignment, it will be important for each team to consider the following
points:
? Assignment Proper. Key to solving the assignment proper, possibly with supporting files, is
to tackle its various parts one by one, fully answering each requirement. In this regard, don't
get hung up on one exercise; move on to the next one. Do refer back to prior seminars or other
courses (properly cited of course) if they included any of the quantitative techniques required
here
? To remain motivated, remember that the overall learning goal here is to familiarize each team
member with the OM techniques and concepts involved, not to make you a Toyota production
planner
? Thus remember to explain the team's answers in succinct but good English, particularly if the
team wishes to obtain an above-task grade
? Be sure to study all the assignment help materials that are posted here.
? Please mark your answers clearly in your assignment submission, so they can be easily found
and identified.
? Post the team final paper in the Group Assignment Folder, clearly marked as the final
submission.
? After the team assignment is completed and submitted for grading, each team member is to
complete Peer Evaluation Assignment and submit the form in his/her own individual assignment
folder. NOTE: until a completed peer evaluation form is submitted, the individual member
concerned will not be assigned a grade for the team project.
Schwalbe defines a project as “a temporary
Schwalbe defines a project as “a temporary endeavor undertaken to create a unique product,
service, os result. Operations are work done in organizations to sustain the business. Projects
are different from operations in that they end when their objectives have been reached or the
project has been terminated” (Schwalbe, 2016). Projects can be any size and they can take any
amount of time. Attributes of projects include:
? Unique purpose (Schwalbe, 2016)
? Temporary (Schwalbe, 2016)
? Developed using a progressive elaboration or in an iterative fashion (Schwalbe, 2016)
? Requires resources from various areas (Schwalbe, 2016)
? Should have a primary customer or sponsor (Schwalbe, 2016)
? Involves uncertainty (Schwalbe, 2016)
Portfolio management is “a collection of projects and programs that are grouped together to
facilitate effective management to meet strategic business objectives” (Schwalbe, 2016). A
four-stage planning process for project selection is discussed by Schwalbe. One acronym
discussed is a SWOT analysis. SWOT = Strengths, Weaknesses, Opportunities, and
Threats. These concepts are used in aiding in the organization’s strategic planning
process. SWOT is used to identify strategic initiatives, defined as one-time projects with a
defined beginning, tasks, and conclusion in which resources will be allocated to (Schwalbe,
2016). The Four-Stage project selection planning process flows like this:
Strategic Planning -> Business area analysis -> Project planning -> Resource allocation
Other criteria and opportunity costs to be considered to aid in selecting projects include
performing financial projections, performing a net present value analysis, determining return
on investment, performing a payback analysis, implementing a weighted scoring model, and
possibly implementing a balanced scorecard (Schwalbe, 2016).
So is DMBA620 a project? In short, my answer is NO,.I think it is a collection of smaller projects
that together creates a portfolio. To determine this answer the following criteria should be
considered: unique purpose, temporary, developed using a progressive elaboration or in an
iterative fashion, requires resources from various areas, should have a primary customer or
sponsor, and involves uncertainty. The course description for this class states that DMBA 620 is
“a study of sound decision making in business, focusing on financial analysis and operational
issues found in every enterprise. Discussion covers economics, financial reporting and analysis,
information systems, and project management in an international context. The goal is to
understand and apply the principles and techniques of effective management planning, control,
and decision making in the global environment” (UMUC, 2017).
So, just in the course description DMBA has satisfied the unique purpose and has an elaborative
development plan. Additionally, the syllabus defines the timeline from 5/22/2017 – 8/13/2017
making it a temporary program with a definite end date. Throughout the syllabus, different
resources are outlined as well as a couple of team assignments satisfying the resources from
various area criteria. The uncertainty of the project is the grade we will get and the 6 credits
awarded upon successful completion of the class. Lastly, who is the customer? I am going to
say the customer is the professor, and our classmates, and our teammates, and our families
and possibly our employers. Basically, anyone that is affected or has a dog in the fight could be
considered a customer of us taking this class. Each of us, as the student, I believe would be the
primary sponsor by taking this class. In order for us to complete the class requires timely
submission of several smaller PROJECTS over the course of 12 weeks. These smaller projects
together make a portfolio, thus DMBA 620 I am calling a portfolio.
My Example
This time last year I was on deployment. In my deployment my command was embarked
onboard the USS Harry S Truman, CVN75. My Commodore came to me (as the leading
Weapons Department representative in the command) to come up with a 4 th of July celebration
for the Carrier Strike Group. The problem with that is fireworks are considered an illegal
pyrotechnic and cannot be stored onboard U.S. Naval vessels. Including the carrier, we had five
naval vessels to consider. The plan was actually quite simple. We first needed to determine
what resources we had available. Resources included small-arms machine guns, CIWS mounts,
5” gun mounts, and various signal flares. The concept was to align all of the ships in a straight
line and fire all munitions at the same time. Some rounds included illumination rounds while
others included starburst timed explosions. Ultimately, on July 4 th , 2016, the Harry S Truman
had a 4 th of July gunnery exercise in the middle of the Atlantic Ocean that provided morale
support for the 10,000 sailors that were finishing up a long eight month deployment.
Reference
Schwalbe, K. (2016). Revised: An introduction to project management (5th ed.). Boston: Course
Technology
University of Maryland University College (UMUC). (2017). DMBA 620 9044 Effective Financial and
operational Decision Making (2175). Retrieved
fromhttps://learn.umuc.edu/d2l/le/content/271026/viewContent/9526547/View
Executive SummaryAn Executive Summary is a
Executive Summary
An Executive Summary is a separate document from the main body of your document and must
stand alone on its merits. It may be the only page from your report that gets read by top
management -- so it must be able to "make the case" for your recommendation or proposal. The
Executive Summary:
1. Summarizes the main points of a longer document (e.g., a business plan or proposal) and
presents the essential issues in the paper: main points, analysis and recommendations. It is NOT
an introduction, which would tell what you intend to analyze, not what you found from your
analysis. If you are writing “this paper will....," then you are writing an introduction and not an
executive summary!
2. Establishes the need or states the problem; recommends the solution and explains the value of
the solution (why the reader should care); provides logical substantiation (your analysis!) for
how you arrived at your recommendation.
3. Is written in text, not a bullet-point outline (quality of analyses cannot be shown through bullet
points, which lack integrative logical connections among the bullet pointed ideas or data)
4. Should be one page or at most two pages for longer documents. No cut-and-pasting from the
main document. Write from scratch so you are not tempted to provide unnecessary details.
Always proofread the executive summary -- Ask people who haven't read the main document to
read the summary and comment on it -- does it present the idea? Does it show the value? Does it
"make the case" for your recommendation or proposal through clear logic based on sound data?
If you wish to explore further, this link is a sample of best resources for how to write a top-notch
Executive summary:
http://www.csun.edu/~vcecn006/summary.html
[SOLVED] Discussion Assignment: Part II (2%). Post
[SOLVED] Discussion Assignment: Part II (2%). Post Executive Summary of your Balanced Scorecard in this Discussion area
By Friday night, create a separate main topic in the Week 6 Discussion, Balanced Scorecard, using your name in the
title and post an Executive Summary in the discussion text. Do not include any confidential information in your
Executive Summary because your Executive Summary is not private. But you can include confidential information in
your paper because your assignment folder is private. Critique at least two of your classmates' Executive Summaries
in this Week 6 Balanced Scorecard Discussion. All postings must be completed by Sunday midnight.
[SOLVED] Build a Balanced Scorecard for the
[SOLVED] Build a Balanced Scorecard for the unit of the organization for which you work, or have worked. Unless you are in senior
management, focus on the unit with which you are most familiar rather than the organization as a whole. Identify the
strategic objectives of the entire organization and the secondary objectives for the unit. Develop three specific objectives
within each of the four perspectives for the unit. Each objective should have at least one quantified target metric associated
with it.
It is essential to understand what metrics are. Be sure to study the lecture material on "More Information on metrics" In this
assignment, the specific information needed to calculate each metric should be explained. For each metric state the
appropriate target value and the actions that need to be taken to achieve the target. The paper should be no more than 15
pages, including the reference list, and be formatted in accordance with the APA guidelines as modified for the MBA program
(http://info.umuc.edu/mba/public/MBA-apa.html). Please format your paper in Microsoft Word as a XXX.doc or XXX.rtf file,
and place the paper in your assignment folder.
Metrics
Develop three specific objectives within each of the four perspectives for the unit. Each objective should have at least one
quantified target metric associated with it. So your table should contain 4 perspectives, each with 3 specific objectives, and a
target value of the metric for each objective.
If you would like to see a sample table of metrics, here is one example:
Sample Table of Metrics for an Example Business Unit
DMBA 620 9044 Effectiv... Paula Pal-Kheav
Submit Cancel
6/5/2017 Week 6 Balanced Scorecard Part I Submit Files DMBA 620 9044 Effective Financial and Operational Decision Making (2175) UMUC Learning Manag...
https://learn.umuc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=488711&grpid=0&isprv=0&bp=0&ou=271026 2/3
Perspective Objective Metric Target Value
Financial Revenue Growth
Operating Profit Growth
Short-term Solvency
Long-term Solvency
Annual Rate of Growth
% EBIT/Sales
Current Ratio
Long-term Debt/Equity
> 6%
> 7%
> 2.0
< 30%
Customer Increase Number of Customers
Maintaining Transaction Size
Improve Customer Satisfaction
Annual rate of Customers Increase
Average Transaction Size
Median Score: Customer Survey
> 5%
> $600
> 90%
Internal Product Improvement
Ratio of New to Old Products
Maintain Market Share
% R&D Expense to Revenue
Ratio of New to Old Products
Market Share %
> 4%
> 8%
> 24%
Learning Employee Training
Employee Turnover
Employee Compensation
Annual Hours of Employee Training
Employee Turnover
Average Compensation
> 30,000
< 3%
> $38,000
[SOLVED] The Perkins Cove Yacht Company CasePerkins
[SOLVED] The Perkins Cove Yacht Company Case
Perkins Cove Yacht Company produces three models of yachts. All are 44 feet long. One is a
standard Fiberglass model with nylon sails and a fixed keel made of lead and fiberglass named
the Goose Rocks. It comes with a standard depth finder, compass and 20 horsepower diesel
auxiliary motor. It sells for $120,000.
The Kennebunkport model has upgrades with radar, GPS nautical charts, enhanced batteries,
and Teflon coated carbon fiber sails. The engine produces 100 horsepower and can run a
cabin heater. It can completely recharge the battery in less than an hour. The Kennebunkport
sells for $200,000.
The Ogunquit model is a custom-made with a deck made from teak and a cabin constructed
from special woods. The sails are made from the traditional flax based canvass. The hull is
from specially cut oak from local forests. It has the look of a vessel constructed in 1850 by a
quality Maine shipyard with 2016 comforts and safety. The Ogunquit sells for $800,000.
Workers who build the Ogunquit are specialty craftsmen. They earn twice the hourly rate of
those working on the two standard models. Note: Labor rate is fully loaded for benefits.
Most of Perkins Cove Yacht’s sales come from the Goose Rocks and the Kennebunkport, but
sales of the Ogunquit model have been growing. Below is the company's sales, production, and
cost information for last year:
Yacht Goose Rocks Kennebunkport Ogunquit
Volume 50 100 20
Price $120,000 $200,000 $800,000
Unit costs
Direct Materials $30,000 $82,000 $250,000
Direct Labor $36,000 $51,000 $440,000
Manufacturing
Overhead*
$27,000 $27,000 $27,000
Total Unit Cost $93,000 $160.000 $717,000
Unit Gross Profit $27,000 $40,000 $83,000
Direct Labor Hours 1,000 1000 4750
Rate per Hour $36.00 $51.00 $92.63
Manufacturing overhead* is made up as follows:
Depreciation $2,200,000
Maintenance $700,000
Purchasing $180,000
Inspection $350,000
Indirect Materials $290,000
Supervision $800,000
Supplies $70,000
Total Manufacturing Overhead Cost $4,590,000
*These manufacturing overhead costs are fixed in nature: they do not vary with the volume of
manufacturing activity.
The company allocates overhead costs using the traditional method. Its activity base is
unit volume. The predetermined overhead rate, based on 170 total yachts, is $27,000 per yacht
($4,590,000 ÷ 170 yachts). Richard Perkins, president of Perkins Cove yacht, is concerned that
the traditional cost-allocation system the company is using may not be generating accurate
information and that the selling price of the custom Ogunquit may not be covering its true cost.
Questions:
A. The cost-allocation system Perkins Cove has been using allocates over 88% of
overhead costs to the Goose Rocks and the Kennebunk because 88% of yachts
produced were these two models. How much overhead was allocated, in total, to each
of the three models last year? Discuss why this might not be an accurate way to assign
overhead costs to products.
B. Perkins Cove’s production manager proposes allocating overhead by direct labor hours
instead since the different models require different amounts of labor. How much
overhead would be allocated to each yacht (per unit and in total) under this method?
Show all supporting calculations.
C. How would the use of more than one cost pool improve Perkins Cove Yacht's cost
allocation?
D. Perkins Cove Yacht's controller developed the following data for use in activity-based
costing:
Manufacturing
Overhead
Amount Cost
Driver
Goose
Rocks
Kennebunkport Ogunquit
Depreciation $2,200,000 Square
Feet
20,000 30,000 30,000
Maintenance $700,000 Direct
Labor
Hours
50,000 100,000 95,000
Purchasing $180,000 # of
Purchase
Orders
1,500 1,500 6,000
Inspection $350,000 # of
Inspections
400 800 2,000
Indirect
Materials
$290,000 Units
Manufactured
50 100 20
Supervision $800,000 # of
Inspections
400 800 2.000
Supplies $70,000 Units
Manufactured
50 100 20
Total $4,590,000
Use activity-based costing to allocate the costs of overhead per unit and in total to each
yacht. Show all supporting calculations. It is appropriate to use an excel document to do
your computations in Excel.
E. Calculate the cost of one custom Ogunquit yacht using activity-based costing.
F. Why are the costs different between the traditional method and the activity-based
method?
G. At the current selling price, is the company covering its true cost of production of the
Ogunquit? Briefly discuss.
H. What should be the price that Perkins Cove Yacht Company charges for the Ogunquit?
Assume that the Ogunquit should have the same profit margin as the Kennebunkport.
Show all calculations.
I. What should Perkins Cove Yacht Co. do if the quantity of the Ogunquit yachts sold at the
new price falls to 10 per year?
J. What should Perkins Cove Yacht Co. do about the situation if the price of the Ogunquit
cannot exceed $800,000?
K. At a selling price of $800,000 each, what is the breakeven unit volume for the Ogunquit?
L. What are the lessons learned from this case?
Tiffany Nadeau established and ran a small
Tiffany Nadeau established and ran a small workshop that manufactured original design quality
jewelry. What began as a hobby for sale in craft shows grew into a small on-line business.
Later, it became a manufacturer for upscale jewelry shops in tourist locations across the
country. To accommodate the greater volume, Ms. Nadeau opened a small workshop in the
historic district of Santa Rosa, California, about 50 miles north of San Francisco. She paid the
following prices for some of her raw material: Gold $1,200 per ounce, Silver $16.50 per ounce.
Gold and Silver prices have been volatile making pricing difficult.
She marketed these creations to gift shops across the United States in batches of 20 assorted
items, for which she charged $2,880 per batch. In turn, the gift shop sold the jewelry at prices
averaging eight times what they paid for the jewelry.
Tiffany had a staff of 11. Ten workers produced the jewelry and Joseph helped with shipping
and cleanup. The production people were paid $30 per hour including benefits and Joseph was
paid $20 per hour for his unskilled labor. Jewelry production varied between a low of 14 and a
high of 26 batches per week, and averaged 1,000 batches per year. Each batch cost $130
(excluding wages) to pack, ship and insure, with Joseph doing all the packing and shipping. It
takes Joe 1 hour to pack and ship one batch. Joe also does other chores, such as sweeping,
vacuuming and cleaning, and he averages 30 hours per week of employment with Tiffany's
workshop, for the 50 weeks per year that he works for Tiffany (with his time split between
packing and shipping of batches and doing weekly cleaning, etc.)
Tiffany spends 10 weeks a year touring the U.S. She attends trade shows in order to sell her
jewelry, and to find suppliers of the components for her products. Her travel, hotel, show fees,
and food costs were $4,200 each week. Workshop rent and utilities cost her an average of
$7,500 per month. Insurance including liability, workers compensation, and unemployment cost
$1,500 per month. Advertising in trade journals and on Fashionista.com cost $38,000 per year.
Tiffany works 40 weeks a year at making jewelry, often working over 50 hours per week. She
spends 10 weeks marketing and takes 2 weeks of vacation.
The cost of raw materials averaged $1,900 per batch. It takes Maria and Juanita 20 hours per
batch to manufacture the jewelry. Tiffany does design work, creates the molds for the jewelry
and spends time making the items as needed to meet orders.
Business was brisk, and Tiffany could easily sell every batch that she produced. But she found
herself earning very little money, and after paying her 45% income tax for US and California,
she found herself with almost no money to live on. That led her to ask for your help.
She complained to you that she worked very hard, 50 weeks a year, but ended up broke and
frustrated. Tiffany said that Santa Rosa was expensive even though home prices were less than
half of what they were in San Francisco, some 50 miles to the south. Reasonable homes sold
for $500,000 to $2,000,000. These were about 4 times the price of homes in Croydon, New
Hampshire where her sister lived. With property taxes and insurance, Tiffany thought that she
needed at least $5,400 per month for her mortgage payment. That payment was far beyond
what she can afford. She would need $10,000 per month after tax to afford the mortgage and
have enough left for a moderate lifestyle.
You agreed to analyze her business operations and to advise her how to reach her goal of
earning $120,000 per year, after taxes.
After some calculation and some thought, you conclude that Tiffany has to increase her
revenues, perhaps by achieving greater volume, or perhaps by raising her selling price. Write a
short report directed to Ms. Tiffany Nadeau with your recommendation on how to increase
revenue, supported with a pro-forma contribution income statement which incorporates your
recommendations. You should show all calculations in a Microsoft Excel document. Include a
breakeven analysis for zero profit and a second analysis to achieve an after tax target income of
$120,000 for Ms. Nadeau and provide your conclusion. (The report to Ms. Nadeau can be
written in a Textbox (Textboxes automatically wrap text) in a separate worksheet in the same
Excel document.
Submit one document that contains your calculations, the 2 breakeven analyses, and the report.
Be sure to proofread. A PowerPoint presentation “Santa Rosa Jewelry Hints” has been posted
in this week’s module to get you started.
[SOLVED] Assignment Financial Statement Analysis:Your team
[SOLVED] Assignment Financial Statement Analysis:
Your team has been assigned to the CEO of a major company. The CEO keeps an eye on the
competition, and asks your team to do the following: Following the 2016 R DMBA Sample Week 3
Answer, use ratio analysis to compare two major competitors in the same industry and compare them
to the industry ratios. The sample compares Southwest Airlines Company with Jet Blue Airline
Company.
1. Create a single Excel file for your entire assignment.
2.The team may obtain financial information and the companies' latest annual reports on the web
directly from the Securities and Exchange Commission for the company website. MSN Money or Yahoo
Finance also have information but in some situations, it may be incomplete. Current stock price
information is not available from the SEC web site.
3. The team should calculate, and comment upon, at least 10 financial ratios for the last 2 fiscal years.
4. All calculations should be shown, and all answers should be thoroughly explained.
5. It is useful to compare financial ratios for a company with financial ratios of its industry. Industry
financial ratios can be found on Morningstar.com, Yahoo Finance and MSN Money and
http://www.bizstats.com/corporations.asp?profType=ratios
6.Whenever the team uses balance sheet items to calculate ratios, it is more accurate to average the
beginning-of-year and end-of-year amounts to get the average for that year. Dec 31, 2014 and Dec 31,
2015 would be beginning and end of year for 2015. Note: Averaging is NOT required. For some
students taking averages leads to calculation mistakes. The example answer does not use averaging and
includes most if not all possible ratios.
7. What can the team tell from the analysis? What are the strengths and weaknesses of each company?
Which is the stronger competitor? Give reasons.
8. Show that you have read and understood the required readings, links and attached files - cite and
reference them where appropriate.
9. The final Excel file should be submitted by one team member into the Group Assignment folder.
Team assignment requirement checklist:
1. Evaluate short-term solvency ratios
2. Evaluate profitability in relation to revenues
3. Evaluate profitability in relation to equity
4. Calculate the 4 ratios of the DuPont Analysis and evaluate what they mean for strategy, these ratios
are ROE, Profit Margin on Sales, TATO and the Equity Multiplier.
5. Evaluate long-term solvency
6. Evaluate market value ratios (not just book value ratios)
7. Correctly interpret results for items above. At random, we will test a few calculations for accuracy
8. Combine all findings into a coherent final summary Each item above carries roughly equal weight
Below is the companies used for comparison -
Google:
Key Ratios for GOOGL
http://financials.morningstar.com/ratios/r.html?t=GOOG
Microsoft:
Key Ratios for MSFT
http://financials.morningstar.com/ratios/r.html?t=MSFT
Also, attached is the start of our spreadsheet. I have also uploaded it to the Google Drive. All info was
retrieved from sec.gov as well as MorningStar. Everything is RED is an example. We will also have to
amend the compared calculations from each income statement, balance sheet, and cash flow statement.
[SOLVED] You should answer all of the
[SOLVED] You should answer all of the questions listed below as they relate to the financial statements of any U.S. public company of your choice in its latest annual report. Please use the Securities and Exchange Commission web site as your primary source for financial statements. All publicly traded U S companies have their annual reports called the 10-K available through the Securities and Exchange Commission web site. http://www.sec.gov/
Instructions for use of the site are as follows: About half way down the home page is a box titled Search EDGAR, free access to over 21 million filings. Enter the company name or ticker symbol. That brings up a page called EDGAR Search Results. In the line "filter results" enter "10-K" in filing type and hit search. That will bring up recent company annual reports. Note: You have a choice of "Documents" or "Interactive Data." Both contain all the information. "Interactive Data" uses Excel and provides the best access to information for questions 1, 2, and 3. "Documents" provides information that is easy to read for questions 4 through 8. After you click on Documents, click on the red letters and numbers to the right of the "10-K" heading.
Also you can find the financial statements of any U.S. public company by visiting Morningstar, Yahoo Finance or MSN Money, and using the stock market symbol for your chosen company (which can be looked up on Morningstar, Yahoo Finance or MSN Money). Please be aware that sometimes these services omit some numbers in order to fit their preferred formats. Many companies have links to the Annual Report as filed with the SEC. It can be found on the Investor relations page of the company web site.
If you work for a U.S. public company, you may want to use the financial statements of your company - but the choice is up to you.
1) What 3 items of important information does the income statement reveal about the financial performance of the company over the last three years?
2) What 3 items of important information does the balance sheet reveal about the financial position of the company over the last two years?
3) Can you identify the major sources of funding used by the company from the information presented in the company's annual report? Please look at the Statement of Cash Flows, formerly called the Source and Uses of Funds Statement.
4) Who is responsible for:
a) the issuance, and
b) the content
of the company financial statements? (Note: this information may be difficult to find. Look for statements by management and the independent auditing firm.)
5) What assurance, if any, is there that the financial statements are in compliance with GAAP, and are free of material misstatements?
6) Of what use, if any, are the notes to the financial statements? Give an example of something learned from the footnotes of your company.
7) What can you learn from the Business Section of the 10-K? Give two facts learn from reading this section.
8) What can you learn from the Management Discussion and Analysis of Financial Condition and Results of Operations (MD&A)? Give two facts learned from reading this section.
*************
Post in your individual assignment folder by the due date. .
Quantitative analysis tied to the financial statement concepts will add value to your work.
The Power Point (Financial Statements R-2.ppt) should be very helpful. It is below
[SOLVED] The Really Annoying owners see the
[SOLVED] The Really Annoying owners see the change in profits from the price decrease in May and the projection for June. They decide to go back to a price of $10.00 and have 31,000 deliveries in June. They decide that they are only willing to manage enough bicycle messengers to support 31,000 deliveries at a price of $10.00. However, if they raised price to $11.00 per delivery, they would be willing to hire and manage enough messengers to make 45,000 deliveries in July.
[SOLVED] Shaun suggests that there wasn’t enough
[SOLVED] Shaun suggests that there wasn’t enough time in the experiment. He estimates that in the second month, June, the Really Annoying Company will have 36,000 deliveries at $9.00. Please answer the following assuming that Shaun is correct. You want to get an idea of what will happen to profits before you commit to an action. If profits go up assuming that Shaun is correct, then you will keep the current price of $9.00 during June. If the profits go down, you plan to return to $10 per delivery.
[SOLVED] Analysis of Pricing: You manage The
[SOLVED] Analysis of Pricing: You manage The Really Annoying Bicycle Messenger Company which makes deliveries for lawyers, consultants, accountants, and lobbyists in the much of Washington DC including Georgetown. The company makes deliveries of documents and small packages at a price of $10.00 each. The average number of deliveries in one month is 31,000. The owners of the Really Annoying Bicycle Co. would like to increase its sales and profits. They know that, if price is lowered, they will generate more deliveries. So they run an experiment. Price is lowered to $9.00 per delivery in May and the number of deliveries increases to 33,000.
[SOLVED] For each employee with a commission less
[SOLVED] For each employee with a commission less than 0.04, compute the number of orders taken. The result should include the employee number, employee last name, employee commission rate, and the total number of orders taken by that employee. Assume each distinct OrdNo in the OrderTbl counts as one distinct order. Each employee should be displayed only once; for example, if employee Mickey Mouse took five orders, there should be one line displaying his name, not five.
[SOLVED] Write a new query. Display only the product name, product number, and the order
Write a new query. Display only the product name, product number, and the order state for all the orders for which the OrderTbl state is Colorado. Do *not* use the Group By command. Make it print only unique (distinct) product names. Sort it ascending by product name. Write a sentence: how many records do you have, and do you have any duplicate product names? Why might this be? What is the difference between this and the query you did first? (Hint: look up SELECT DISTINCT)
[SOLVED] UMUC Data 620 Assignment 5.2first, you
[SOLVED] UMUC Data 620 Assignment 5.2
first, you will submit a SQL script file showing your answers for all of the problems below, based on the template at the end of this document. Name it “XXX-Assignment-5-2.sql”, where XXX is your initials or your name.
Second, you will take screenshots of your results and put them into this document in the space provided after each question.
Deliverables
Possible Points
This Assignment requires you to have our create the Order Entry database from the attached script. Below is an ERD for this database:
1. Display the product name, product number, order number, and the order state for all the orders for which the OrderTbl state is Colorado. Sort it ascending by product name. Don’t group it by anything. Write a sentence: how many records do you have, and do you have any duplicate product names? Why might this be?
TURN IN: a screen shot of your results (paste it below); your SQL code for this goes under “Problem 1” in the template.
[SOLVED] W8 Report Outline-Optional AssignmentExecutive summary.
[SOLVED] W8 Report Outline-Optional Assignment
Executive summary.
1. The report will give a brief outline of the mission springs water district, its performance
evaluation and its employee appraisal.
2. The water district company will be used for interview analysis as well as evaluation analysis.
Introduction
1. The importance of employee analysis in an organization,case in point the water district
company.
2. The reason why the employee analysis is an important responsibility of managers.
3. The consequences of poor employee appraisal to the management and to the organization at
large.
Literature review and analysis.
1. Review various scholarly articles that are relevant to the employee appraisal and evaluation.
2. evaluate the dominant methods used in springs water district in selecting people to join their
organization.
3. Examine the reliability of tests, interviews and other selection procedures in water district
company.
4. Examine the various methods that are used to pose the legal, ethical or practical issues that
could pose a challenge to managers.
5. Examine the various methods that would be adjusted taking into consideration the diverse and
multicultural workforce.
6. Analyze and identify the performance program used in springs water district company.
Conclusion.
1. Based of the analysis I will have identified various points of change that would make the
organization managers improve in employee selection and appraisal.
2. All recommendations will be fully supported by the literature review done .
References.
[SOLVED] View the videos on bullying and
[SOLVED] View the videos on bullying and sexual harassment in the workplace and share your experience of harassment in the
workplace. What has your employer done to prevent harassment in the workplace? What would you recommend
based on your knowledge of the law and ethics of business? Be sure to support your views with reference to the
readings.
[SOLVED] Quinn v. Mongo CorporationKevin Quinn
[SOLVED] Quinn v. Mongo Corporation
Kevin Quinn was a 60-year old engineer who had worked for Mongo Project Corporation for thirty years.
Quinn was approached by Mongo to work as manager of engineering on the Jumbo Project, a two-year project
constructing an industrial city in Saudi Arabia. The project was to be performed by Saudi Arabian Mongo Company
(SAMCO), a Mongo foreign subsidiary, for the Royal Commission, an organ of the Saudi government. The Royal
Commission retained the right in its contract with SAMCO to remove or replace any SAMCO personnel at its sole
discretion. Quinn accepted the offer, viewing the position as the final "jewel in the crown" of a successful career.
SAMCO submitted Quinn's resume, which included his date of birth, to the Royal Commission, and he was approved
for the job.
Before leaving for Saudi Arabia, Quinn signed a "Recital of International Employment Conditions," which
stated: "Your assignment is for an indefinite period; and, assuming your performance is satisfactory, the assignment
will continue until Mongo advises you that your services are no longer required, in which event you will be given a
minimum of four weeks written notice of assignment completion."
When Quinn arrived in Saudi Arabia, he was informed by Michael Hammer, SAMCO's program director for the
Jumbo Project, that Quinn was going to have a problem because his grey hair showed that he was "over fifty," and
people over fifty were "regarded with suspicion" in Saudi Arabia. (Saudi Arabian law does not prohibit employment
discrimination on the basis of age.) Shortly after Quinn's arrival, Hammer received a letter from the deputy director
of the Royal Commission stating that Quinn did not satisfy the Commission's requirements and should be replaced as
soon as possible. As a result, Hammer immediately took Quinn off the project.
After he retuned to the U.S., Quinn was depressed and withdrawn as a result of his dismissal. Mongo offered
him many other projects, but he turned them down. Quinn then sued Mongo Corporation, claiming that his
employment on the SAMCO Jumbo Project was terminated because of his age.
[SOLVED] Toyota annotated bibliography
What is the company doing to be socially responsible?
Write one to two paragraphs explaining the sources can help supporting your research.
Please try get it back by Saturday 3/11/17 at 7 or 8 pm.
Please me know if you have questions.
[SOLVED] On page 345 of the Law,
[SOLVED] On page 345 of the Law, Sales and Marketing text review exercise 1A and 1B, discuss and address the questions
raised and explain your conclusions.
"1. a. Mr. and Mrs. Smith, an elderly couple, had no relatives. When Mrs. Smith became ill, the Smiths asked a
friend, Henrietta, to help with various housekeeping chores, including cleaning and cooking. Although the
Smiths never promised to pay her, Henrietta performed the chores for eighteen months. Henrietta now claims
that she is entitled to the reasonable value of the services performed. Is she correct? Explain.
b. Assume instead that the Smiths asked Mrs. Smith’s sister, Caroline, who lived nearby, to help with the
housekeeping. After eighteen months, Caroline claims she is entitled to the reasonable value of the services
performed. Is she correct? Explain."
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[SOLVED] If the employer had required employees
[SOLVED] If the employer had required employees to sign a document indicating that they had read and understood the
requirements of the employment manual would that change the analysis in the case? Explain your reasoning.
"Unilateral Contract and At-Will Employment
Woolley v. Hoffmann-La Roche, Inc.
491 A.2d 1257 (N.J. 1985)
Wilntz, C. J.
Plaintiff, Richard Woolley, was hired by defendant, Hoffmann-La Roche, Inc., in October 1969, as an Engineering
Section Head in defendant’s Central Engineering Department at Nutley. There was no written employment
contract between plaintiff and defendant. Plaintiff began work in mid-November 1969. Sometime in December,
plaintiff received and read the personnel manual on which his claims are based.
[The company’s personnel manual had eight pages;] five of the eight pages are devoted to “termination.” In
addition to setting forth the purpose and policy of the termination section, it defines “the types of termination”
as “layoff,” “discharge due to performance,” “discharge, disciplinary,” “retirement” and “resignation.” As one
might expect, layoff is a termination caused by lack of work, retirement a termination caused by age,
resignation a termination on the initiative of the employee, and discharge due to performance and discharge,
disciplinary, are both terminations for cause. There is no category set forth for discharge without cause. The
termination section includes “Guidelines for discharge due to performance,” consisting of a fairly detailed
procedure to be used before an employee may be fired for cause. Preceding these definitions of the five
categories of termination is a section on “Policy,” the first sentence of which provides: “It is the policy of
Hoffmann-La Roche to retain to the extent consistent with company requirements, the services of all employees
who perform their duties efficiently and effectively.”
In 1976, plaintiff was promoted, and in January 1977 he was promoted again, this latter time to Group Leader
for the Civil Engineering, the Piping Design, the Plant Layout, and the Standards and Systems Sections. In March
1978, plaintiff was directed to write a report to his supervisors about piping problems in one of defendant’s
buildings in Nutley. This report was written and submitted to plaintiff’s immediate supervisor on April 5, 1978.
On May 3, 1978, stating that the General Manager of defendant’s Corporate Engineering Department had lost
confidence in him, plaintiff’s supervisors requested his resignation. Following this, by letter dated May 22, 1978,
plaintiff was formally asked for his resignation, to be effective July 15, 1978.
Plaintiff refused to resign. Two weeks later defendant again requested plaintiff’s resignation, and told him he
would be fired if he did not resign. Plaintiff again declined, and he was fired in July.
Plaintiff filed a complaint alleging breach of contract....The gist of plaintiff’s breach of contract claim is that the
express and implied promises in defendant’s employment manual created a contract under which he could not
be fired at will, but rather only for cause, and then only after the procedures outlined in the manual were
followed. Plaintiff contends that he was not dismissed for good cause, and that his firing was a breach of
contract.
Defendant’s motion for summary judgment was granted by the trial court, which held that the employment
manual was not contractually binding on defendant, thus allowing defendant to terminate plaintiff’s
employment at will. The Appellate Division affirmed. We granted certification.
Search MAIN TOPIC POST HERE: Week 6 - Topic #2
Week 2 - Critical
Thinking and Decision
Making
0
W4 Team Agreement
and Work Plan
0
Week 8: HR Functions:
Recruitment, Selection,
and Assessment
0
Week 9: HR Functions:
Performance
Assessment and
Management
0
Week 10: Forms of
Organizations,
0
3/6/2017 MAIN TOPIC POST HERE: Week 6 Topic #2 DMBA 610 9040 Ethical Leadership in Organizations & Society (2172)
https://learn.umuc.edu/d2l/le/202553/discussions/threads/9105611/View 2/3
Week 12: Corporate
Social Responsibility
and International Issues
2
Hide the Topics List
The employer’s contention here is that the distribution of the manual was simply an expression of the
company’s “philosophy” and therefore free of any possible contractual consequences. The former employee
claims it could reasonably be read as an explicit statement of company policies intended to be followed by the
company in the same manner as if they were expressed in an agreement signed by both employer and
employees....
This Court has long recognized the capacity of the common law to develop and adapt to current needs....The
interests of employees, employers, and the public lead to the conclusion that the common law of New Jersey
should limit the right of an employer to fire an employee at will.
In order for an offer in the form of a promise to become enforceable, it must be accepted. Acceptance will
depend on what the promisor bargained for: he may have bargained for a return promise that, if given, would
result in a bilateral contract, both promises becoming enforceable. Or he may have bargained for some action or
nonaction that, if given or withheld, would render his promise enforceable as a unilateral contract. In most of
the cases involving an employer’s personnel policy manual, the document is prepared without any negotiations
and is voluntarily distributed to the workforce by the employer. It seeks no return promise from the employees.
It is reasonable to interpret it as seeking continued work from the employees, who, in most cases, are free to
quit since they are almost always employees at will, not simply in the sense that the employer can fire them
without cause, but in the sense that they can quit without breaching any obligation. Thus analyzed, the manual
is an offer that seeks the formation of a unilateral contract—the employees’ bargained-for action needed to
make the offer binding being their continued work when they have no obligation to continue.
The unilateral contract analysis is perfectly adequate for that employee who was aware of the manual and who
continued to work intending that continuation to be the action in exchange for the employer’s promise; it is
even more helpful in support of that conclusion if, but for the employer’s policy manual, the employee would
have quit. See generally M. Petit, “Modern Unilateral Contracts,” 63 Boston Univ. Law Rev. 551 (1983) (judicial
use of unilateral contract analysis in employment cases is widespread).
...All that this opinion requires of an employer is that it be fair. It would be unfair to allow an employer to
distribute a policy manual that makes the workforce believe that certain promises have been made and then to
allow the employer to renege on those promises. What is sought here is basic honesty: if the employer, for
whatever reason, does not want the manual to be capable of being construed by the court as a binding contract,
there are simple ways to attain that goal. All that need be done is the inclusion in a very prominent position of
an appropriate statement that there is no promise of any kind by the employer contained in the manual; that
regardless of what the manual says or provides, the employer promises nothing and remains free to change
wages and all other working conditions without having to consult anyone and without anyone’s agreement; and
that the employer continues to have the absolute power to fire anyone with or without good cause.
[SOLVED] Sean Brosnan was a high school
[SOLVED] Sean Brosnan was a high school senior. He filled out his applications for college in September of 2016, including an
application for early decision to Queens University. In December Brosnan received a thick packet from Queens, which
included a glossy brochure entitled, “Welcome to Queens.” The first page of the brochure said, “Welcome to Queens!!
We are delighted to have you as a member of the university community! We will be holding a place for you in the class of
2021 if you submit a $200 deposit by January 20. We would remind you that by your application for early decision, you
indicated your commitment that if you were accepted to Queens, you would withdraw any applications that you have filed
to other colleges and universities.”
The brochure included an “Acceptance Coupon” providing that the signer was making a “definite commitment to attend
Queens University during the coming academic year, to withdraw applications from any other colleges and universities, and
to enclose a check for $200.” Brosnan signed the form and sent it with a $200 check to the Queens Admission Office.
He then withdrew his applications from the six other universities to which he had applied.
A few days later he got a phone call from the Director of Admissions at Queens saying, “I’m sorry, we did not intend to
give you the impression that you had been accepted. Your mailing should have been a deferral letter and should not have
included the acceptance brochure. In any case, you had no business sending in a check—we didn’t even send you a letter
of acceptance. We are returning your check.”
Please discuss the questions below using common law contract principles.
Questions:
Topic 1. Has Queens University entered into a contract with Sean Brosnan? Give the legal arguments that can be
made on each side of the issue. Suppose that Queens discovered its error and contacted Brosnan prior to receiving
Brosnan’s acceptance coupon. Would this change your analysis? If so, how and why?
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
NOTE: Please note that there are three (3) required topics this week (1, 2, and 3). Each requires a main response +
2 participation postings. Thus, by the end of the week, there will be a total of nine (9) postings (3 for Topic 1, 3 for
Topic 2 and 3 for Topic 3). There must be a total of nine (9) postings (three per topic as outlined above), to meet the
minimum requirements to earn a B grade on this Week 6 Discussion conference assignment.
[SOLVED] Assume instead that the Smiths asked
[SOLVED] Assume instead that the Smiths asked Mrs. Smith’s sister, Caroline, who lived nearby, to help with the housekeeping. After eighteen months, Caroline claims she is entitled to the reasonable value of the services performed. Is she correct? Explain.
[SOLVED] a. Mr. and Mrs. Smith, an
[SOLVED] a. Mr. and Mrs. Smith, an elderly couple, had no relatives. When Mrs. Smith became ill, the Smiths asked a friend, Henrietta, to help with various housekeeping chores, including cleaning and cooking. Although the Smiths never promised to pay her, Henrietta performed the chores for eighteen months. Henrietta now claims that she is entitled to the reasonable value of the services performed. Is she correct? Explain.
A new and used car dealership hired
A new and used car dealership hired Employee to perform various duties such as cleaning and gassing vehicles,
moving vehicles from one lot to another and maintaining the showroom and vehicle lots. In this position, Employee
had access to keys to the vehicle through a "key control shack procedure." Under this procedure an attendant keeps
the keys in a control shack. When any employee wants to move a company vehicle, s/he must fill out a key "tag" or
request form, which contains spaces for the date, time, stock number of vehicle, name of employee checking out the
vehicle, and the destination of the vehicle.
For example, the vehicle might be taken to a body shop for repairs or to a gas station, or to a company lot at a
different location. Every time an employee checks out a vehicle, the reason must be for company business use. It
was not necessary to put the expected return time on the tag, but if a vehicle was expected to be gone for a long
time, this information was supposed to be put on the tag. Sometimes the key shack attendant fills the tag out for the
employee. When the tag is completed, the key shack attendant adds the information from the tag to key control log,
gives the keys to the employee who has requested them, and hangs the tag on the board in the control shack. When
the vehicle is returned the key shack attendant crosses out the entry for the vehicle in the control log, replaces the
keys, and removes the tag from the board. Sometimes vehicles are gone for more than one day, but a new page of
the control entry is started each day. Some vehicles may be removed permanently if they are sold from another lot.
In these cases, the managers of the other lots call to let the key shack attendant know that the vehicle will not be
coming back. Sometimes employees would drive cars back and leave the keys with other employees. This practice
was acceptable to the dealership.
One day Employee asked the key shack attendant if he could use a car for 30 minutes on his lunch break to go to his
mother's house. The key shack attendant told him it was okay as long as he brought it back because, otherwise, she
could get in trouble. Employee took the car and left. On his way back to the dealership, Employee rear-ended a car
stopped at a stop light, causing injuries to the driver and a passenger. Employee told a police officer at the scene of
the accident that he was on a lunch break from his job and that he had permission to drive the car, but his boss was
not aware he had the car.
The plaintiffs sued the car dealership on the grounds that it was responsible for the injuries caused by Employee.
Assignment: Individual Report 2 (15%)Be sure
Assignment: Individual Report 2 (15%)
Be sure to leave enough time for your review of your work and final editing for all necessary corrections. Post your final paper in Assignments by the due date.
Deliverable: Submit an analysis of the employee selection and performance appraisal methods used in your workplace or in one with which you are familiar. If you do
not have a current employer you may use the provided alternative assignment. One single organization must be used for the entire paper. Thus, whatever organization
you use for the hiring analysis must also be used for the evaluation analysis. You are not permitted to use two or more organizations (e.g, one company for application
analysis, one government agency for interview analysis, one company for evaluation analysis, etc.). One topic organization is required and it must be used for the entire
paper.
Purpose: Employee selection and assessment are important responsibilities for all managers. When done poorly, significant problems can arise for managers, those they
supervise, and the organization. This assignment gives you an opportunity to: a) complete a thorough, thoughtful, and objective analysis of the process and methods
used for selection and performance assessment in an organization; b) identify strengths and areas that may need improvement; and b) make preliminary
recommendations based on your analysis.
Process Steps:
1. Research: Complete the assigned readings and at least two additional relevant scholarly articles you will use and cite as references in your report. Simply selecting
an "academic article" in a library database does not guarantee the work has benefited from blind review by scholarly experts. You should check the credentials of the
authors whose work you are citing and see whether the articles have have been cited by others. You should complete your research in week 8.
2. Analysis and Diagnosis:
1) Identify and evaluate the dominant methods used in your workplace, or one with which you are familiar, to select people for jobs. Examine whether:
The interviews, tests, and/or other selection procedures are reliable and valid.
The methods used pose any ethical, legal, or practical issues that could present problems for managers and/or the organization. Methods might need to be adjusted given the increasingly diverse, multicultural, and geographical dispersed workforce.
2) Identify and analyze the performance appraisal program used in your organization. Questions to guide your analysis include:
Is the program formally or informally applied? Note that even when there is no formal appraisal system decisions are made about pay, promotions, and
terminations and these are generally influenced by an assessment of performance.
Are there clearly articulated and well communicated goals for the appraisal? [Note: These may be both the formally articulated goals and those you believe will
be important. Offer a brief explanation of and support for each goal, relying where appropriate on insights gleaned from seminar readings.]
Is there a relationship between the strategic goals of the organization and standards used for evaluating individual performance?
Is there evidence of criterion contamination or deficiencies?
Are there measures in place to ensure reliability?
Are there any legal issues the organization might want or need to consider? Explain your reasoning. Note that all systems have the potential to introduce ethical
and sometimes even legal concerns, in design and/or in implementation. Who is involved in conducting the appraisals (supervisors, self, subordinates, peer, team, customer, all of these) and what are the pros and cons of this approach?
Cite references to support your analysis and conclusions.
Does the program meet best practice standards for appraisals including training to eliminate common rating errors and ensure sound feedback methods? Which specific method from your research into appraisal methods most closely matches the one in use in your organization and what is your support for this
conclusion? What are the relative strengths and limitations of this method and what are the practical implications for your organization and managers? Note any differences
between policy and actual practice and consider why these exist. (Note: Be sure to refer to information gleaned from the work of scholarly experts when
undertaking this assessment of the method you are examining.)
Does the method used limit the organization’s ability to foster diversity and operate effectively in a multicultural global marketplace? Explain and support your
reasoning.
3) Conclusions and Recommendations: Based on your critical analysis, identify changes you believe might be made to improve how your organization manages
employee selection and appraisal. Each recommendation must be derived from your research and analysis and must be supported by a well reasoned argument and
references to the literature. If you have observed a difference between the stated organizational goals, policies, and what happens in practice you should be sure to
address this in your recommendations.
4) Reflections: Reflect on lessons you take from your analysis as a current or future manager or leader in this organization or industry. Consider the implications for
your need to ensure performance and commitment of all those for whom you will be responsible.
5) Write and submit your report:
a) Word count range = 1,800 to 2,000 words not including cover page, reference list or executive summary. Points will be deducted if papers significantly exceed the
word count limitation. Be sure to use word count before submitting your paper.
b) Your report should address the above questions and should recognize, integrate, and cite relevant theories, concepts, and ideas from the readings and your research.
Include a maximum 250 word executive summary, an introduction, conclusion, and properly APA-formatted list of references.
In the introduction be sure to include a succinct narrative description of your organization and position. You do not need to give the specific name of your
organization if you prefer to keep that confidential but you should give sufficient information (for example, the industry and nature of the business) so the context
can be understood.
Include page numbers on all pages
c) Submit your final write-up in Assignments by the specified due date (by 11:59 PM EST on the last day of Week 9).
In the W9 area you will find the rubric that will be used to grade your research project.
Please note that because this is an advanced graduate student research project, the quality of your research counts for 15% of the grade. Be sure to incorporate
a minimum of two articles from scholarly journals.Incorporating an article into your paper means more than simply quoting and citing it. You need to demonstrate that
you understand the point the authors are making and can apply their ideas to the unique circumstances of the workplace practices that are the subject of your paper.
Writing and presentation counts for 25% of the grade. As advanced graduate students, you are expected to understand how to write a research paper with good
grammar and attention to citation format. Part of the presentation also involves adhering to word count limit, which is 2,000 words, not counting the reference list and
the cover page. The word count does not include the 250 word executive summary, but your executive summary should not exceed 250 words.
JumpstarterIn the late nineties, Jumpstarter, Inc. became
Jumpstarter
In the late nineties, Jumpstarter, Inc. became aware that its product Jumpstart I a pacemaker designed to regulate heartbeat within the body had begun to
fail when the temperature rose to above normal body temperature. The company asked hospitals with unused units ofJumpstart I to return them for credit and
advised doctors to remove any Jumpstarter I products that had been implanted in patients.
Bob Hartley required several major open chest surgeries to correct problems that occurred because of the Jumpstart I. After settlement negotiations broke
down, Hartley sued Jumpstarter, Inc. Hartley claimed that the Jumpstart I could have been made safer through inexpensive tests and use of an alternative
design.
a. Plaintiffs: Develop a case for Hartley. On what theory can he recover from Jumpstarter, Inc.? What should his damages be?
b. Defendants: What defenses can you assert for Jumpstarter Inc.?
c. Everyone: Who will win? Is it ethical to recall a product and fight a lawsuit at the same time?
Brunhilde and Joy are entertainers who have
Brunhilde and Joy are entertainers who have enjoyed a very successful career. For the past twenty years they have been wowing Las Vegas audiences with their
magic act which features "big cats," including lions, tigers and panthers. They have performed their act before millions of fans of all ages, including many
celebrities and a few U.S. Presidents. In the past few years, their act has averaged around $40 million a year gross nearly $1 million per week.
Brunhilde and Joy were starting to get on in years. They were both into their fifties but still very active with the animals, and their act was thriving.
Working with large, wild animals is always dangerous, but Bruhilde and Joy trained the animals well. They didn't use cages. They brought the animals out on
leashes. Aside from a few minor incidents with the animals biting each other or mildly misbehaving, there were no problems with the big cats until one fateful
night when they were performing their act to a soldout crowd at Nero's Palace Casino.
Joy noticed that the 400pound "star" tiger, Archibald, was a bit edgy just before the night's performance. During the performance, she had to discipline the tiger
repeatedly by pulling on his collar and tapping his nose with the microphone. Then Joy tripped on one of her high heels. Brunhilde and the audience gasped in
horror as they watched Archibald grab Joy by her neck and drag her offstage. Although Archibald's jaw was strong enough to break Joy's neck, he apparently
grabbed her gently. Her neck wasn't broken, but the bite resulted in two large puncture wounds. She lost a great deal of blood which resulted in a stroke.
Joy spent several months in the hospitalrecovering from her wounds. She had to have physical therapy to recover from the effects of the stroke. Brunhilde had
to cancel the act, because she could not find a replacement for Joy. Besides she was too disheartened and worried about her friend to be able to continue
without her.
a. Does Joy have a case against the casino? What claims can she make? What defenses does the casino have?
b. What if an audience member had been injured by the tiger? How would that change the case against the casino?
Read the "Terrible Tiger" case posted in
Read the "Terrible Tiger" case posted in Topic 1 in the discussion and discuss the following issues:
a. Does Joy have a case against the casino? What claims can she make? What defenses does the casino have?
b. What if an audience member had been injured by the tiger? How would that change the case against the casino?
2. Read the Jumpstarter case posted in Topic 2. Students will be assigned to take either the role of the plaintiff, Hartley or the role of the defendant,
Jumpstarter in this case.
a. Plaintiffs : Develop a case for Hartley. On what theory can he recover from Jumpstarter? What should his damages be?
b. Defendants: What defenses can you assert for Jumpstarter?
c. Everyone: Who will win? Is it ethical to recall a product and fight a lawsuit at the same time? Final discussion responses must post by Sunday, 11:59 p.m.
_____________________________________________________________________________________________________________
What do I post this week?
TOPIC 1:
Everyone posts a response and one participation posting to Topic 1A by the end of the week.
Everyone posts a response and one participation posting to Topic 1B by the end of the week.
TOPIC 2:
NOTE: If your last name begins with LZ, you will post a response to Topic 2A (Plaintiffs) by Day 3 (Wednesday). By the end of the week on
Day 7 (Sunday) you will also post two participation postings to Topic 2 (to any combination of 2A, 2B or 2C that you select).
NOTE: If your last name begins with AK, you will post a response to Topic 2B (Defendants) by Day 3 (Wednesday). By the end of the week
on Day 7 (Sunday) you will also post two participation postings to Topic 2 (to any combination of 2A, 2B or 2C that you select).
Everyone posts a response to Topic 2C by Sunday.
There are two (2) required topics this week (Topic 1 and Topic 2). Each one requires two (2) responses + two (2) participation postings. Thus, by the end of
the week, there will be a total of eight (8) postings (4 for Topic 1 and 4 for Topic 2).
There must be a total of eight (8) postings (as outlined above), to meet the minimum requirements to earn a B grade on this Week 5 Discussion
conference assignment. Students who far exceed the minimum requirements may earn an A grade.
Assignment: Individual Paper (15%)Scroll down to
Assignment: Individual Paper (15%)
Scroll down to see the Required business document
Analyze the business document below (scroll down), applying all 8 steps of the critical thinking framework model discussed in the US Army
Management Staff College AMSC Critical Thinking report (citing Dr. Richard Paul model) at
http://www.au.af.mil/au/awc/awcgate/army/critical/roy.htm. Post this assignment in the assignment folder by the end of week 2.
You are using the 8 step method disseminated by Roy Eichhorn, Strategic Systems Department, Army Management Staff College, in the
report entitled, DEVELOPING THINKING SKILLS: CRITICAL THINKING AT THE ARMY MANAGEMENT STAFF COLLEGE in section
COMPONENTS OF CRITICAL THINKING AT AMSC.
From the ASMC report: "
THE AMSC PHILOSOPHY ON CRITICAL THINKING [...] We are often asked why we go to the effort of trying to teach critical thinking;
people already know how to think. The first answer to this question is that yes, we all think, but do we do it well and are we able to evaluate the
quality of our thinking? [...] Dr. Paul responded to this question with the statement that reflects our philosophy: "We are always thinking, the
question is, are we in charge of our thinking, or is our thinking in charge of us?"
The following is one of Dr. Paul’s definitions of critical thinking that summarizes our approach:
"Critical thinking is the ability to think about one’s thinking in such a way as:
1. to recognize its strengths and weaknesses and, as a result,
2. to recast the thinking in improved form.
Such thinking about one’s thinking involves the ability to identify the basic elements of thought (purpose, question, information, assumption,
interpretation, concepts, implications, point of view) and assess those elements using universal intellectual criteria and standards (clarity,
accuracy, precision, relevance, depth, breadth, and logicalness)."
In a short paper (78 doublespaced pages) apply all of the steps of the critical thinking model to assess the arguments made in the memo.
Include all of the steps. Leaving out discussion of steps will adversely affect your grade. You must include all 8 of the AMSC steps. As the
final 9th step in the paper, use the content on fallacies in Almossawi, Ali (2013). An Illustrated Book of Bad Arguments
https://bookofbadarguments.com/?view=allpages to identify any fallacies in the memo. Although not necessary for a passing grade,
answers to some of the questions may be enhanced by doing additional research.
Remember that your task here is to evaluate the author's argument as objectively as possible, not to give your own opinions on the
issue. Be sure to use the analytical points as set out in the critical thinking report, not your own thoughts on the issue.
The citations and the reference list in the paper should be formatted in accordance with the APA guidelines.
This paper is due by 11:59 PM the last day of Week 2.
Objective 2: Use a critical thinking framework to evaluate alternative courses of actions and reach sound decisions in workplace situations.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2/7/2017 Required Business Document Memo for Analysis DMBA 610 9040 Ethical Leadership in Organizations & Society (2172)
https://learn.umuc.edu/d2l/le/content/202553/viewContent/8953735/View 2/4
SAGAFTRA Nevada Local
Memo
To: Mr. Kanye KardashianFuentes (President, SAGAFTRA Nevada Local)
From: Ms. RuPaul Fabowlus (Director of Human Resources, SAGAFTRA Nevada Local)
CC: None (Confidential)
Date: January 22nd, 2017
Re: Al Jazeera America (AJAM) termination of union member employment contract (allegedly due to defamation by prior
employer, FOX News).
This is in response to your request for our union HR office to evaluate the legal representation notification letter sent to you by
the attorney for our union member, “Lil’ Lady RaRa” (legal name, Eugenia Glover). The letter indicated that she intends to file
lawsuits against FOX News and AJAM. You wanted to know if the union should publicly support the union member in
publicizing their legal case(s).
1.0 Background
“Lil’ Lady RaRa” (hereinafter referred to by her legal name, Ms. Eugenia Glover) has been an inconsistent dues paying member
of our union since 2004. She is a DJ, voiceover artist, mime, program host and former news editor (self described on her website
as “the Hottest Host in the Galaxy”). Ms. Glover worked at FOX News from 1999 – 2005. She was working as a news editor on
the FOX News show, “The O'Reilly Factor hosted by Bill O’Reilly” in May of 2005. On the show on the evening of May 10,
2005, there was a segment of an interview with guest, Courtney Anderson.
Courtney Anderson Enterprises LLC
The interview included a discussion of laws regarding child abuse laws in Texas and the newspaper, the Houston Chronicle. The
host, Bill O’Reilly, made comments on the air that resulted in the Houston Chronicle newspaper writing and publishing an
Editorial Journal on May 12, 2005 entitled, “Editorial Journal: The No Facts Zone.”
2/7/2017 Required Business Document Memo for Analysis DMBA 610 9040 Ethical Leadership in Organizations & Society (2172)
https://learn.umuc.edu/d2l/le/content/202553/viewContent/8953735/View 3/4
It stated in part,“O'Reilly claims his show is free of spin. Spin is when someone casts the facts in such a light as to reinforce
his argument and weaken his opponent's. What O'Reilly did was to disregard the facts altogether, even going so far as to
attribute to the Chronicle words and views it did not print and does not espouse. That's not spin; it's misrepresentation that
is unprofessional, unwarranted and injurious to the public debate about a serious and urgent issue: protecting children from
predators.” (Gibbons, 2005)
Six days after the show aired, on May 16
th
, 2005, our member, Ms. Glover, was terminated from her job as news editor at “The
O'Reilly Factor”. Although she subsequently applied at over 400 media outlets around the world, she was not hired at any
television channels. After Ms. Glover provided her FOX News employment for reference and background checks, she was
always told that she was not selected for the position. Ms. Glover worked as an independent DJ, mime and substitute teacher
during this ten year time period (from May 16, 2005 December 1, 2015). On December 1, 2015, AJAM offered her a news host
position.
As you know, our union, SAGAFTRA, fiercely represents our members who are, “the faces and voices that entertain and inform
America and the world.” (SAG) Ms. Glover was hired by AJAM on December 1, 2015 prior to her background check being
completed. On December 16, 2015, AJAM called her in the Human Resources office and told her that she was being placed on
suspension pending an assessment of her prior work history. She was fired on December 20
th
, 2015 when she received a text
message from her supervisor at AJAM that stated, “You are done here. Bye! LOL!” On January 13th, 2016 it was reported in the
Chicago Tribune (via Paul Farhi with The Washington Post) that AJAM told its staff that it would shut down operations at the
end of April 2016 (http://www.chicagotribune.com/business/ctaljazeeraamericashuttingdown20160113story.html).
Ms. Glover hired an attorney and is moving forward to take legal action against FOX News for interfering with her ability to
work and for AJAM for wrongful termination. She is planning to appear with her attorney on national news media outlets
(including “Good Morning America”, “The View” and “Entertainment Tonight”) to publicize her perspective on these events.
She posted on Twitter on December 1st, 2016, “#NEWSLIES U Will NO the TRUTH SOON...” Her attorney has stated that as
her union representation, we are “either with her or against her.” The attorney notification letter to our union office stated that we
are “bullies” and “the dumbest union leaders in the universe” and have “wholly failed to adhere to the purported Mission
Statement by abandoning a loyal member and one of the greatest talents of the millennia.”
As you are fully aware, our Mission Statement includes the following,
“SAGAFTRA is committed to organizing all work done under our jurisdictions; negotiating the best wages, working
conditions, and health and pension benefits; preserving and expanding members’ work opportunities; vigorously
enforcing our contracts; and protecting members against unauthorized use of their work.
A proud member of the AFLCIO, SAGAFTRA partners with our fellow unions in the U.S. and internationally to seek
the strongest protections for media artists throughout the world. We work with governments at the international,
federal, state, and local levels to expand protections for American media professionals both at home and abroad.”
(http://www.sagaftra.org/content/aboutus)
2.0 Discussion
This attorney notification is an assault on our union. It is antiAmerican. Foreign artists and everyone in these United States and
beyond knows we are the most powerful labor union for media artists. Ms. Glover and her greedy lawyer want us to put our good
name and reputation on the line to support a member who could not get a job for over ten years. If we are publicly embarrassed
by Ms. Glover and her attorney on national television, our more famous and successful members (Justin Bieber, Paris Hilton,
Meryl Streep, Charlie Rose, Honey BooBoo, etc.) will not vote for you in the upcoming union presidential election. Therefore,
if you rebut her lawyers’ proposal (for us to appear publicly with her in the media), you will win the admiration of all our
members. I had lunch the other day with a group of our members, and everyone was in agreement that if you opposed this, they
would vote for you (at least 73% of the voters). This will set the stage for your reelection next year at the end of your present
term.
Ms. Glover is a weak mime and we should only represent the best mimes in the world (http://www.mime.info/). Also, it was an
embarrassment to Mr. O’Reilly at FOX News when the show on May 10, 2005 aired.
The Houston Chronicle editorial stated, “The 19th century American writer and philosopher Ralph Waldo
Emerson once said of a man, "The louder he talked of his honor, the faster we counted our spoons." Were he alive
today, Emerson might be thinking of television host Bill O'Reilly.” (Gibbons, 2005)
The editorial made the show host look foolish (I attached a clip of the show for you to see for yourself what really happened).
Everyone knows that Mr. O’Reilly is one of the smartest people in the entire country which is why he was given a primetime
cable news television show. My brotherinlaw says that he is a genius and supreme leader of their genius group, MENSA.
2/7/2017 Required Business Document Memo for Analysis DMBA 610 9040 Ethical Leadership in Organizations & Society (2172)
https://learn.umuc.edu/d2l/le/content/202553/viewContent/8953735/View 4/4
After the May 10, 2005 show, even leading global media experts like “The Rude Pundit” posted on the web,
“He claimed the paper said the law was too harsh, he said the paper's "taken a lot of shots at me" so it must be liberal,
and then, while "interviewing" Austin criminal defense attorney Courtney Anderson, he took out the bunny and starting
gulping down eyeballs like olives: "Counseling, community service projects, all of this touchy feely BS the Houston
Chronicle's putting out there, because whoa, far be it from society to have zero tolerance against child molesters. We
can't have that. This is the kind of pinhead stuf that's hurt this country." When Anderson dared to imply that what
O'Reilly was saying was not, actually, in the article, O'Reilly bit the head of the bunny: "You're misreading this article.
This article, number one, criticizes Florida for passing the law, says they don't like the law. The law is too harsh, all
right, number one."” (http://rudepundit.blogspot.com/2005/05/whybilloreillyoughttobesodomized.html)
Ms. Glover is an unpopular DJ and an even worse news editor. If we were to allow such a nonfamous and unaccomplished
individual to sully our union name by associating with her, our Nevada Local office could cease to exist. We represent the best of
the best in the world and are the #1 ranked most phenomenally powerful labor union in American history
(http://en.wikipedia.org/wiki/SAGAFTRA) with 92.7% approval. We have to maintain our reputation!
We must oppose Ms. Glover and her attorney now, or we do a disservice to our members and will regret it later. I speak for truth
and common sense. We have to be strong and show no weakness to this delusional member. I am currently checking to see if her
union dues are current right now because everyone knows that people who are not famous and successful do not pay their bills.
Finally, lawsuits and the greedy ambulance chasing lawyers who file them, are ruining this country. According to a recent article
posted in a prestigious Wall Street newspaper, the additional legal costs of doing business adds 21.3% of hidden costs to the
price of each product or service transaction in this country. If we were to support Ms. Glover and she publicly insults FOX
News, their hosts or AJAM, we will have to deal with potential legal action from their lawyers which could bankrupt us. Ms.
Glover has already destroyed AJAM as they are now out of business. Is it a coincidence that shortly after she worked there the
company (AJAM) announced they were closing? Do we want to be next to fail? Ms. Glover is proven to be toxic to the entire
entertainment industry.
3.0 Conclusion and Recommendation
SAGAFTRA Nevada Local should not support Ms. Glover. Our members will lose their pride in being part of our union and
potentially their jobs if we appear in the media attacking powerful organizations like FOX News and AJAM. If Ms. Glover
wants to be successful, she should abandon this wasteful legal action and instead practice her mime, DJ and hosting skills. She
needs to leave our prestigious union alone.
Just say the word and I will draft a reply to this effect for your signature.
Gibbons, James H. "Editorial Journal: The No Facts Zone." Houston Chronicle. Houston Chronicle, 12 May 2005. Web. 10 Sept.
2013.<http://www.chron.com/opinion/editorials/article/EditorialJournalTheNoFactsZone1935986.php>.
NOTE: Only hit "Reply" to this message.
NOTE: Only hit "Reply" to this message. Do Not start a new thread. Thanks!
Week 4, Topic #1
Compton v. Merlotte's
When Bill Compton started working for Merlotte Enterprises, he received a copy of Merlotte's Employee Handbook.
As part of his acceptance of employment at Merlotte's, Bill signed a form stating that he received the handbook and
understood its terms and agreed to abide by the terms. During Bill's third year of employment, Merlotte revised the
handbook. One of the revisions was the addition of an arbitration clause that stated that all disputes arising out of
employment with Merlotte would be settled by binding arbitration. Merlotte advised its employees of the specific
changes to the handbook terms and required all employees to sign waivers stating that they read, understood, and
accepted the revised terms. Bill signed this form and continued working at Merlotte's until his employment was
terminated. Bill sued Merlotte alleging various claims of unfair dismissal.
Should the Court hear Bill's claim or is he bound by the arbitration agreement? Discuss the pros and cons and be
sure to refer to the law in your textbook to support your views.
==================================================
NOTE: Everyone will post one substantive response and two participation postings to this topic. There are two
(2) required topics this week. Each one requires a response + 2 participation postings. Thus, by the end of the
week, there will be a total of six (6) postings (3 for Topic 1, 3 for Topic 2).
MANDATORY STUDENT TASKS –
A) Please have the topic number in the subject section of all of your discussion conference postings. For
example, you are going to post your response to Topic #1. You click on that Discussion and then you click on
“Reply” (which is how you post your reply). A box pops up and you have a “Subject” section. Either leave the
existing “Topic 1” in that subject section (or add it if you change the text around). If you want to add a subtitle
to your posting you can (e.g., “Topic 1 – Why I love teams!”, etc.) that is great! The key is to always post the
Topic number. Do not submit a discussion conference posting without the topic number in the
subject. Otherwise, when I go to grade your discussion conferences for the week, it will be very difficult for me
to assign the correct grade (as the number of postings per topic matter and when I pull your portfolio, it is not
clear which topic you are posting to without the title clearly labeling your topic). You do not need to add your
name to the title (e.g., - “Topic 1 – Jane Smith”) but if you want do to so that is fine. I pull up each student
individually so your name is not necessary to add.
(B) Please do not include other posts in your reply (I need to see only your response and not the other
comments that you are addressing). Here is information regarding this issue:
– On your name in the upper right corner of the screen, use the drop down menu and click on “Account
Settings”, then on the Account Settings page click on the tab (right underneath the title) that states
“Discussions”, under Personal Settings scroll down the page to the very last item named “Reply Settings” and
uncheck the box (next to “Include original message text in reply”).
NOTE: Only hit "Reply" to this message. Do Not start a new thread. Thanks!
Week 3 - Topic #2: Loose Lips?DMBA
Week 3 - Topic #2: Loose Lips?
DMBA 610 Discussion Week 3
Topic#2
Is Sharkey's behavior ethical? Does it make a difference if the allegation of the affair
between his boss and Sheila Sharpe is true or false?
Week 3 - Topic #2: Loose Lips?DMBA
Week 3 - Topic #2: Loose Lips?
DMBA 610 Discussion Week 3
Topic#2
Is Sharkey's behavior ethical? Does it make a difference if the allegation of the affair
between his boss and Sheila Sharpe is true or false?
[examples] how to write university discussion
[examples] how to write university discussion response?
Betty Bass was a highly respected Senior
Betty Bass was a highly respected Senior Vice President at Colossal Technology Enterprises and well knownfor her community service work. Betty had been at Colossal for over ten years and had risen from the ranks,starting out as an assistant project specialist and steadily progressing to a senior management position.Betty's performance evaluations during her time at Colossal ranged from Very Good to Outstandingperformance. Betty's leadership on many Colossal projects resulted in increased revenue for the company.She was generally well respected in the company, but, as is often the case with office politics, there weresome people who had competed with her for positions in the past and were envious of her success.Shortly after Betty's most recent promotion to Senior Vice President, Joe Johnson, who was also a candidatefor the position, attended a conference. Joe was very disappointed about not getting the promotion, and, aftera few too many drinks at a social gathering, he shared his disappointment with a couple he had just met thatnight. He was comparing his qualifications with Betty's and he mentioned Betty's name. As it turned out, theman he was talking with had known Betty at a previous job, and he mentioned to Joe that he was interestedto hear that Betty had completed her MBA at UMUC because when he knew her, she had dropped out.
DMBA 610 Discussion Week 3Topic# 3 Ethical issues
DMBA 610 Discussion Week 3
Topic# 3
Ethical issues arise in the workplace all the time. Describe a situation that you have encountered in the workplace that you believe raises some ethical issues. Then apply one of the assigned ethical frameworks to analyze the situation.
XBRL GROUP GRADED ASSIGNMENT (10%)The CFO is
XBRL GROUP GRADED ASSIGNMENT (10%)
The CFO is expecting that soon Ramsey will be required to file interactive financial statements with the
SEC. The CFO wants your team to practice XBRL tagging to learn more about it, and to test a product
called SmartXbrl. You are going to do this using a sample company called, Boson Clothes, Inc.
You have two weeks (Sessions 10 and 11) to complete the following tasks:
Part A: Map the company’s balance sheet and income statement that appear in the attached
spreadsheet by going to the 2012 US GAAP Financial Reporting Taxonomy to view the taxonomy,
selecting the appropriate linkbase, and cutting and pasting the correct tag into the Excel
spreadsheet. For this initial set of statements no extensions should be required, but if you feel
some are needed, feel free to create them.
Note: For the purposes of this exercise, I would pull headings from the presentation linkbase, items
under the headings from the presentation linkbase, and subtotals and totals from the calculation
linkbase. In many reports in the real world, you will find multiple linkbase references for any XBRL
item. We’re keeping it simple.
Everyone should claim some part of the financials to map and document in your group and in the final
submissions indicate who did what.
Part B: Transfer the financial statements into the XBRL Word Doc Template provided by SmartXbrl
(attached in this conference). When you open the template, be sure to read my comment in red.
Demo the SmartXbrl software by following that attached directions for establishing a demo account.
Document your journey with screen shots placed in a Word doc.
For both Parts A and B, upload a copy of your group’s final submission to your individual Assignment
folder by the end of Session 11.
Identify one primary strength and one primary weakness for each of
Identify one primary strength and one primary weakness for each of the following methods of investment analysis:
Net present value:
Internal rate of return:
Payback Period:
Average accounting return:
The Golden Goose is considering a project
The Golden Goose is considering a project with an initial cost of $46,700. The project will produce cash inflows of $10,000 a year for the first two years and $12,000 a year for the following three years. What is the payback period?
What is the net present value of
What is the net present value of the following set of cash flows at a discount rate of 7 percent? At 20 percent?
time cashflow
0 -17000
1 4500
2 8700
3 11900
What is the net present value of
What is the net present value of a project with the following cash flows if the discount rate is 15 percent?
year cashflow
0 -39,400
1 12800
2 21700
3 18100
ASSIGNMENT: 1. Start with the Zip Code Data
ASSIGNMENT:
1. Start with the Zip Code Data Excel file (attached to this assignment as “Assignment 4.3 – zip code data.XXXX.xlsx”). The XXXX is just a version control number and will probably be some series of numbers. You can disregard the exact numbers.
2. Insert a record for your favorite US city (make sure it’s not a duplicate of something already on there), and assign your favorite city a tourist rating of 6.
3. Save it as a .csv file, and import it into your MySQL. Make a new database called my_zip_codes and name the table in it zip_code_data.
4. Write an SQL script which will query your zip_code_data table as follows:
a. Select just the city and zip code and rating (not the state)
b. For which the tourist rating is a 4 or higher (this will include all ratings of 4)
c. Sort it descending by tourist rating (so the highest rating is the first record)
d. Put a comma between all fields
5. Name your script ‘tourist.sql’ .
6. Make sure it produces a results file with your personalized information in it. If my name is Carrie, my script should produce a resulting file named “carrie_hotspots.csv” . And Carrie’s favorite city should be featured at the top line among the results.
7. Use the Azure Export example above to export the MySQL file into an outfile called “XXXX_hotspots.csv” where XXXX is your first name. (It’s OK if you want to use a suffix, like v01, v02, etc. when debugging and then just leave the suffix on when turning it in.)
a. Hint from FA Bhakthi Liyanage – you are going to want some CLI that looks a little bit like the following, where you have replaced the “xxxxxx-spring” with the name of your database.
b. mysql.exe -h data620-xxxxxx-spring.mysql.database.azure.com -P 3306 -u adminuser@data620-xxxxxx-spring -p < tourist.sql > c:\Documents\week 4\XXXX_hotspots.csv
c. where tourist.sql is your sql script and XXXX_hotspots.csv is your output file.
8. TURN IN #1: Attach your script (Note the requirement here is a full SQL script, with comments; see the SQL script rubric from Week 1 to see how to do this. It is OK if your script requires the user to have created, loaded, and activated the database before running the script, and simply issues the SQL commands. If this is the case, make sure your comments reflect that.)
9. TURN IN #2: Attach your .csv file.
Do you have a Mac? This one’s for you. From FA Bhakthi Liyanage:
Here is a YouTube clip that explains how to execute mysql on a Mac.
Watch until 0:36 and after that, it is not relevant.
https://www.youtube.com/watch?v=ryvNDIX3gQA
Basically, what you have to do is;
$ cd /usr/local/mysql/bin
$ ./mysql -h <mysql server host name> -P 3306 -u <mysql user name> -p --batch < input\SQL Script\location\filename.sql > output\file\location\filename.csv
or you may execute:
/usr/local/mysql/bin/mysql -h <mysql server host name> -P 3306 -u <mysql user name> -p --batch < input\SQL Script\location\filename.sql > output\file\location\filename.csv
Healthy Snacks, Inc. has a target capital
Healthy Snacks, Inc. has a target capital structure of 55 percent common stock, 5 percent preferred stock, and 40 percent debt. Its cost of equity is 14.3 percent, the cost of preferred stock is 8.9 percent, and the pretax cost of debt is 8.1 percent. What is the company's WACC if the applicable tax rate is 35 percent?
Smith and Weston firm has 55,000 shares
Smith and Weston firm has 55,000 shares of common stock outstanding at a price of $31 a share. It also has 3,000 shares of preferred stock outstanding at a price of $62 a share. The firm has 8 percent, 12-year bonds outstanding with a total face value of $400,000. The bonds are currently quoted at 101.2 percent of face and pay interest semiannually. What is the capital structure weight of the firm's preferred stock if the tax rate is 35 percent?
For the period 1926-2011, small-company stocks had
For the period 1926-2011, small-company stocks had a risk premium of 12.6 percent. What does the term risk premium mean? Is the risk premium on these stocks considered to be relatively high or relatively low as compared to other investment classes? Explain why?
Explain the difference between a bid price
Explain the difference between a bid price and an asked price and also explain why the prices are different.
The common stock of The Garden of
The common stock of The Garden of Eden is selling for $42 a share. The company pays a constant annual dividend and has a total return of 5.8 percent. What is the amount of the dividend?
Swan Lake Marina is expected to pay
Swan Lake Marina is expected to pay an annual dividend of $1.58 next year. The stock is selling for $18.53 a share and has a total return of 12 percent. What is the dividend growth rate?
What additional features would you like added
What additional features would you like added to Cognos Analytics for exploring and preparing data?
1. What kinds of projects could you
1. What kinds of projects could you use Cognos Analytics for in your organization?
1. What was hard to learn about
1. What was hard to learn about using Cognos Analytics?
1. What are some useful data preparation
1. What are some useful data preparation and data exploration features of the Cognos Analytics software?
University of Maryland University CollegeDATA 610 –
University of Maryland University College
DATA 610 – Decision Management Systems
Assignment ?2 – Exploratory Data Analysis (EDA) using Cognos Analytics
Deadline: Last day of week 5, 11:59 pm Eastern Time
Submission via LEO.
This is an individual assignment. Each student will complete the assignment outlined below and post his/her written results to the appropriate assignment. Please note that only 1 document is allowed to be submitted. See content on p.4-5.
Grading criteria
Submitted assignments will be graded for (a) content, (b) document quality (i.e. formatting, following guidelines, pleasant to read, etc.), and timeliness of submission. Assignments submitted late will be deducted 5 points for each day it is late.
Activities
1. For this assignment, you will use the Nashville housing data. Read the data source description at https://www.kaggle.com/tmthyjames/nashville-housing-data.
2. Provide a brief description of the dataset in your paper. Discuss the number of cases, description of the inputs, description of the variables that could be used to develop predictive models, etc. Which variables are missing data?
Using Cognos Analytics:
3. Data preparation
a) Create Data Module
o Login to your Cognos Analytics account
o Copy the dataset from Team Content ->Data for DATA 610 Assignments -> Assignment 2 folder in Figure 1 into My Content area.
Figure 1: Nashville Housing Data location
o Navigate to My content and make sure that you see a copy of the Nashville housing data.
o Select Create data module from action menu in Figure 2.
Figure 2: Create data module
o The new data module will open. Click on an arrow next to save icon in Figure 3 and select save as to save new data module into my content.
Figure 3: Save Data module
o Click on Nashville housing data csv in the left panel in Figure 4 to preview data.
Figure 4: Preview data
b) Handle Missing data
Cognos Analytics represents missing data as Null
Apply the approaches in the assigned readings to handle missing data, including filtering rows, removing columns, and replacing the missing value with the average. Discuss the approaches you used in your paper.
c) Handle irrelevant variables – Which variables in the data are irrelevant? Explain why they are irrelevant and how you handle them.
Make sure to save the data module before moving on to the next part of the assignment.
4. Explore the dataset:
Return to the Welcome page and expand My Content
Select Create exploration from the action menu of the Nashville housing data module in Figure 5.
Figure 5: Create Exploration
a) Are there outliers? If so, what fields have outliers and what do you recommend as solutions?
b) Pose an initial set of questions to use for data exploration. Provide any insights gained from using Cognos Analytics with this dataset
a) Develop new specific questions which provide additional insights into and answer specific questions from the dataset. Discuss how these insights could be useful. Discuss how you would improve the relevancy.
b) Develop and explain at least five different visualizations. Experiment with the available options and summarize the results. Provide insights to what the visualizations show.
c) Utilize features (e.g., filters, comparisons) with the visualizations to uncover and explain interesting aspects of the data set.
d) Create and explain at least one insightful calculation. Discuss why this would be useful.
Submission
Each student will submit a single document conforming to the guidelines and standards outlined below.
Document format:
§ limited to 8 pages (excluding title page, references, and appendix),
§ Double-spaced, 12 point Times New Roman font, 1” margins, Bottom-right page numbering.
Note: Submitted report must be either in MS Word or PDF format and titled: “Assignment2_LastName”.
Only one document will be allowed to be submitted.
Content (note that the document must have clearly marked sections for the items listed below)
1) Title page (1 page limit): course number and term, assignment number and project title, student name and contact information, instructor’s name. Format it so it looks pleasant and presentable. Follow formatting guidelines above.
2) Introduction. Provide a brief outline of the dataset you are using for this assignment. Briefly describe the content of the data. Include a screenshot of the data (not all, but partial as far as all relevant variables are visible).
3) Data preparation – handling missing data, removing irrelevant variables
4) Data exploration process. Explain and discuss what data exploration you performed (e.g., questions generated about the data set content). Include any specific ideas or suggestions as to how this could be used in your organization.
5) Visualizations created. Explain the visualizations created. Include the value-added aspects of the visualizations. Include creative aspects for increasing potential for higher assignment grade.
6) Calculation which adds insights or value to the data set. Include and explain the value of the calculation, i.e., insights provided by the calculation.
7) References (1 page limit): List all references in APA format used in preparing this report. It is strongly recommended to use outside knowledge in setting-up the analysis or discussing the results where possible.
8) Appendix (4 page limit):
a) Appendix A: Include any appropriate workbooks and/or screenshots (figures, tables, diagrams) used in this assignment. Make sure all tables, figures, or diagrams are properly numbered and titled. For example, “Table 1. Model Results”. Make sure all tables or figures or diagrams are easily readable and visually presentable.
General guidance
§ Assignments that: 1) adequately address all required tasks; 2) are submitted on time; 3) are properly formatted (APA format for references, no typos or misspelled words, no grammar errors, cover page, etc.) will receive a grade of B (80-89, depending on content).
§ In order to increase (but not guarantee) your chances of receiving a higher grade, you need to show clear evidence of critical thinking. Critical thinking can take many forms, depending on the type of assignment. In some instances, showing greater depth (e.g., such as creating more models, looking at more than one insightful fact or relationships, and comparing them on key criteria) is one method for providing evidence of critical thinking. In other cases, it might include providing more explanation to include the pros and cons of the approach used or the arguments in favor and against the proposal as well as some criteria for choosing among the alternatives. Still another example would be providing significant insights as to how the assignment outcome would benefit (or would meet resistance) in your organization and what steps might be employed to facilitate acceptance. Certainly, this is not a complete list, but gives some examples of critical thinking aspects.
Part 1 - Account access verificationscreenshot of
Part 1 - Account access verification
screenshot of your user information
Part 2 – Upload Data
screenshot of insurance data in My Content
Part 3 - Data Exploration
Variable Properties
How many variables are in the insurance data?
7
What is the datatype of Age?
Integer
What is the datatype of Charges?
decimal
What is the usage type of an Age column?
measure
What aggregation types are available for the Smoker column?
total
Explore the Relationships
What is the relationship strength between smoker and charges?
75%
What is the relationship strength between age and charges?
64%
What does the relative width of connecting line represent?
Strength of relationship
Which variables do not have a direct relationship with charges?
BMI and region
Spiral Diagram
Screenshot of the spiral diagram and the list of drivers
What driver has the highest predictive strength? What is the predictive strength?
BMI, smoker, and age is predictor of charges with predictive strength of 83%
What driver information do you see in the tooltip?
Predictive strength and composition of drivers
Which variables in insurance data are not on the spiral diagram for charges?
Sex, children, region and insuranceclaim
Summary Visualization and Using Filters
Use the summary visualization to return the average age. Take a screenshot of the visualization and paste it into the answer sheet.
Edit the summary visualization to return the minimum age. Take a screenshot of the visualization and paste it into the answer sheet.
Edit the summary visualization to show an average age of an individual with 5 children. Take a screenshot of the visualization and paste it into the answer sheet.
Edit the summary visualization to show an average age of an individual with 5 children who is a smoker (smoker=1). Take a screenshot of the visualization and paste it into the answer sheet.
Comparison Visualization of Your Choice
Visualization Screenshot
Explain the visualization purpose and summarize the insights.
1. What are the hurdles keeping your
1. What are the hurdles keeping your organization from improving its AQ? What steps would you recommend to help improve the AQ?
1. What is your organization's Analytical Quotient
1. What is your organization's Analytical Quotient (AQ)?
1. Where do you see the biggest
1. Where do you see the biggest hurdles in adopting a more 'evidence-based' approach?
1. Which approach (Davenport or CRISP-DM) would
1. Which approach (Davenport or CRISP-DM) would work better in your organization?
1. Which approach (Davenport or CRISP-DM) would work
1. Which approach (Davenport or CRISP-DM) would work better in your organization?
WK 3 – DATA 610 6/3/20 – DISCUSSION Questions/answers
1. Which methodology (Davenport or CRISP-DM) do you prefer, and why?
1. Generate an "analytics requirements
1. Generate an "analytics requirements document"
1. Complete the model (flesh out a
1. Complete the model (flesh out a full model of the decision to include decomposing the decision, refining the needed information sources for the analysis, refining authorities)
1. Specify the decision requirements (input requirements,
1. Specify the decision requirements (input requirements, analytic requirements, other knowledge about the decision, related decisions, etc.)
1. Describe the decision in full (include
1. Describe the decision in full (include business context, organizational context, and application context)
1. Identify the decision to be made
1. Identify the decision to be made (e.g., reduce churn, identify fraud, improve product mix, etc.)
1. How Good is your problem-solving? Please
1. How Good is your problem-solving? Please post the results of your Problem-Solving inventory checklist from Mindtools here. Posting of results is helpful to see how we compare as problem solvers.
1. What assistance have you seen from
1. What assistance have you seen from using analytical approaches to improve decision making?
1. Have you seen instances of poor
1. Have you seen instances of poor decision making in your organization?
1. Where does culture fit in the
1. Where does culture fit in the decision trap?
1. What is the impact of 'poor'
1. What is the impact of 'poor' or 'incomplete' decision making? What measures of effectiveness are used in your organization?
1. What are the 'decision traps' we
1. What are the 'decision traps' we all fall into?
Book Report Assignment This assignment requires that students
Book Report Assignment
This assignment requires that students read the assigned book – The Critical Chain – and submit a 5-page book report online on Canvas as a MS Word document after reading and understanding the above text. The guidelines on how to write the book report are provided below:
1. For this class, the book report must be organized around 3 major elements: Discussion, Application, and Evaluation (DAE approach).
2. Write 1-1½ pages discussing the book. Do not write a summary chapter by chapter or make lists. Write in narrative form. Make sure that your write up includes answers to these questions:
· What is the book about (briefly about 1 paragraph)?
· Describe the major themes (a couple of central ideas or gems) in the book from your perspective. Key word here is “major” themes, not just peripheral ideas such as role of communication or importance of team work etc. Remember this is operations management (OM) class and your gems should revolve around concepts related to OM.
· Give rationale why you think the above identified gems/themes are important from your perspective. (use critical thinking to add some rigor to your rationale)
3. Write 2-2½ pages on the application of the major ideas/themes/gems as identified in the discussion section above to your work place (any work place – past or present? In your own words, what is the meaning or significance of these ideas as they apply to your current or any work-setting? How does the author suggest that they be applied?
4. Finally, evaluate the book (½ to 1 page) along the following lines:
· How useful are the ideas?
· How practical are the ideas?
· How well organized and written is the book?
· Would you recommend it?
The book report must be 5 full pages, double-spaced, number 12 font with no more than one inch margins. Your write-up should make use of headings/sub-headings as needed. Rubric for grading book report is given below:
Rubric for Grading Book Report
A
A-/B+
B/B-
Exceeds Expectations
Meets Expectations
Basic Requirements
Instructions:Put your SQL in the "Problem 6"
Instructions:
Put your SQL in the "Problem 6" location in the SQL template.
Put your row count in the green box in cell D5.
Start with the same problem statement as in Problem 5, except this time generate a summary report. For each course name, list the count of the students who will need to be contacted for each format. Sort your report so it’s alphabetically sorted on Course Name, then by format (online or in person). A sample output is below (your data may vary.)
Paste a screen shot of successful execution below. Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.
Instructions:Put your SQL in the "Problem 5"
Instructions:
Put your SQL in the "Problem 5" location in the SQL template.
Put your row count in the green box in cell D5.
Professor Victoria Emmerline is set to retire immediately before spring semester. You want to generate a list of all students who are currently enrolled in any class she is teaching this spring, so you can reach out to them and let them know there will be a different professor. Assume each class she teaches could be assigned to a different professor – i.e. if Professor Emmerline was set to teach Calculus I and Calculus II, it’s possible Calculus I will be assigned to Professor X and Calculus II will be assigned to Professor Y.
Generate SQL code to make a report which will do the following
· Generate a concatenated class name/number string, such as “FIN 200” from something in the Finance Department where the course number is 200
· Print that class name/number string in the first column of your report
· Print the class description (such as “Introduction to Finance”)
· List the student’s first name and then last name
· List the offering term and the format (online or in person)
· List the professor’s first name and last name
· Sort your output ascending by the class name/number string, so “FIN 200”, “FIN 120” and “ART 100” would be sorted in the following order: “ART 100”, “FIN 120”, “FIN 200.”
· Within the same class, further sort your output so it’s alphabetical by student last name, student first name
Instructions:Put your SQL in the "Problem 4"
Instructions:
Put your SQL in the "Problem 4" location in the SQL template.
Put your row count in the green box in cell D5.
You want to see how your various students are doing, GPA-wise. Create a report which will give the student’s last name, student’s first name (should be concatenated into a single field as in the example), the student’s major, and the student’s average GPA.
Include only students who have actually taken at least one class (if they took it and earned 0 GPA points indicating they failed it, that record should be included.) Do not include a student who has not taken any classes.
The average GPA is the average of the GPA Points column in the enrollment table; display this to four or more decimal places. Sort alphabetically by “Last, First” name combination.
Paste a screen shot of successful execution below. Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.
For example, if your input data is like this: (note the in the last row – indicates student Tyrone Brown is new and has not taken any classes yet, has only declared a major.)
Instructions:Put your SQL in the "Problem 3"
Instructions:
Put your SQL in the "Problem 3" location in the SQL template.
Put your row count in the green box in cell D5.
Some faculty are grumbling that certain professors have an easy teaching load, defined as only a few courses with low capacity, while others have a heavy load of many courses with high seat counts. Run a query to help answer this question.
Your output should contain the faculty ID, faculty name (first and last – it’s fine to have this as two separate fields, also fine to concatenate together), the largest capacity class the faculty member is assigned to teach, the maximum possible total student load (sum of all the course capacities), and the number of classes the faculty member is teaching.
Include all faculty members, even if they are not assigned to teach any courses. Include courses only if they are taught by a faculty member. Sort your output ascending by the number of courses taught, with the professors with the fewest courses at the top.
For example, if you had the following input data (the blank row at the bottom means Professor Poldark did not teach anything):
Instructions:Put your SQL in the "Problem 2"
Instructions:
Put your SQL in the "Problem 2" location in the SQL template.
Put your row count in the green box in cell D5.
Write SQL which will give us the course id number (idCourse field), course description, the number of units, the offering term, whether it’s online or in person, and the capacity. Include only those courses which are more than 3 units and have a capacity of less than 40 students. We only want to list courses which have actually been offered at least once. Sort it ascending by idCourse.
Paste a screen shot of successful execution below. Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.
Instructions:Put your SQL in the "Problem 1"
Instructions:
Put your SQL in the "Problem 1" location in the SQL template.
Put your row count in the green box in cell D5.
Create SQL code to display all fields from the students table. Include only students whose major is Finance (‘FIN’) and who have an in-state residence. Sort it alphabetically by student first name.
Paste a screen shot of successful execution below. Be sure your screenshots show all the SQL you use; you are welcome to include several screen shots if necessary.
1. “XXX_Civiccenter_export.sql” where XXX are your initials.
1. “XXX_Civiccenter_export.sql” where XXX are your initials. This is an .csv file export of your “XXX_Civiccenter_query.sql” execution results. You can export this using the “export” icon in the Result Grid window in MySQL Workbench. (Note the data displayed below may or may not correspond to the data in this assignment.)
1. “XXX_Civiccenter_query.sql” where XXX are your initials.
1. “XXX_Civiccenter_query.sql” where XXX are your initials. This is an SQL script which will run a query on your database and show the results. Write SQL statement(s) which will produce an output table with the following fields in it, sorted with the most expensive tickets at the top, and then alphabetically by customer name:
Name
Opera
Cost
Date
Backstage Pass?
1. “XXX_Civiccenter_insert.sql” where XXX are your initials.
1. “XXX_Civiccenter_insert.sql” where XXX are your initials. This is an SQL script which will insert the problem data into your database.
1. “XXX_Civiccenter_create.sql” where XXX are your initials.
1. “XXX_Civiccenter_create.sql” where XXX are your initials. This is an SQL script which will drop any pre-existing Civic Center schema and create all the tables, keys, and other structures you will need. If we run this script, it should remove any existing civiccenter schema and create yours.
Assignment 3.1 This assignment is worth 70 points
Assignment 3.1
This assignment is worth 70 points and the full rubric is on the bottom of the page.
It’s time to go to the opera! You are going to use MySQL Workbench’s EER tool to create an Entity-Relationship diagram for the Civic Center Opera House. You will then engineer that to produce MySQL script(s) which will create and load the database schema with the information below. Finally, you will query your database to prove it is working.
Here is the relevant information.
· Susie attended Madame Butterfly and spent $25 on the ticket for the 1/11 performance, and then went to see La Traviata on 10/3 for $100. She also went to see Carmen for $30 on 10/10.
· Lee attended Madame Butterfly and spent $25 on the ticket for the 10/21 performance.
· Jackson attended Carmen and spent $30 on the ticket for the 5/12 performance. He also went to see La Nozze di Figaro on 1/20, and paid $100 for the ticket.
· Bobby attended Carmen and spent $30 on the ticket for the 1/26 performance, and then went to see La Boheme on 8/14 for $50.
· Margaret attended La Nozze di Figaro and spent $100 on the ticket for the 2/22 performance, and then went (with Jackson) to see Carmen on 5/12 for $30.
· Ulysses attended Rigoletto on 10/21 and spent $35 on the ticket.
· Each ticket has an option to have a “Backstage Pass” option. There is no additional cost associated with this, just a marking on the ticket that the backstage pass was selected.
· Backstage passes were selected by Margaret at all of her operas, and by Jackson when he went with Margaret to Carmen on 5/12. No other tickets chose a backstage pass.
Additional assumptions you should make:
· Assume all tickets for the same opera cost the same. For example, all tickets for Madame Butterfly are $25.
· All operas occurred last year. For example, if it is 2020 now, and the date says “November 11,” assume it was November 11, 2019.
Normalize this database and implement in MySQL Workbench using this information.
Name your database schema “CivicCenter.” Please try to use this exact name to make it easier to grade. It is not case-sensitive so it’s OK to use “civiccenter” or CIVICcenter.” Do not use “Civic_Center” or “civic-center.”
You may use as many or as few tables as you see fit.
Your deliverables are:
1. “XXX_Civiccenter_ERD.pdf” where XXX are your initials. This is a pdf of an entity-relationship diagram made using MySQL Workbench’s modeling tool (you can find this under File Menu -> Export.)
a. Entity-relationship diagrams made using other tools will not earn full points.
b. The diagram should show all entities you use (it’s OK to use more than one page if you need to, and you can cobble together screenshots if you need.)
c. All entities should show all fields and keys; expand the boxes or rearrange them if you need to.
d. All relationships and cardinalities should be easily visible
e. All relationships should have text sentence(s) labeling them. For example, if this were the pet database, you might write, “Each pet must have one and only one owner. Each owner may have zero or more pets.”
Last one! You want to know how
Last one! You want to know how many times products were shipped to customers. Note you want the total number of shipments, not the number of items shipped – one shipment of 10 items and one shipment of 20 items would be two shipments, not 30 items.
Include all products, even if they had no shipments. In this case, their count would be 0.
Include the manufacturer and the product name
Include the customer company name
Sort it so the smallest count of shipments is on top. After that, sort ascending by Manufacturer name and then product name.
Which of the following statements is true of your output? Check all that apply.
Question 6 options:
The top row of data is the Manufacturer Drill Bits R Us for its "Iron Man" product
The top row of data is from Manufacturer Born, Inc for its "To Be Wild" product
The bottom row of data shows Manufacturer Stephen, Product Name "Curried Basketball," for CompanyName Midland Imports, in 3 shipments
The bottom row of data shows Manufacturer Born, Inc, Product Name "To Be Wild," for CompanyName Bridge Fudge Retail, for 30 shipments
Question 5 (2 points) Question 5 options:[SQL Week 2
Question 5 (2 points)
Question 5 options:
[SQL Week 2 Question 200-505]
You want to report on a certain group of your products. Select
Only customers who have a balance of 0
Only shipments which were sent by employees whose employee location is California, Maryland, or New York
Only products which have had a shipment
Only employees who have made a shipment
Only customers who have received a shipment
Compute the total quantity of shipments which meet these criteria
Aggregate it by manufacturer and by product name. This means each manufacturer/product name combination appears on only one row in the table. If a manufacturer makes more than one product, it’s OK if it shows up once per product.
Sort it descending by the sum of the shipment quantity, so the largest shipment quantity shows up on top. Within shipment quantities, sort it alphabetically on manufacturer and then product name.
Your results should look something like this:
What is the total shipment quantity for General Widgets' "Widget Maximus" product? This would be in the green "A" in the screenshot above.
Which company had Total Shipments of 2 for the Twisters? This would show up in the blue letter "B" above.
Drill Bits R Us
Question 6 (2 points)
Question 4 (2 points) Question 4 options:[SQL Week 2
Question 4 (2 points)
Question 4 options:
[SQL Week 2 Question 200-504]
You want to compute the order total for your shipments. For all of your shipments, put together a report which contains the following column. Sort it ascending on idShipment
Create a new field in the output result called OrderTotal, which is the price per unit multiplied by the order quantity. You will need to calculate this field in SQL.
Your screen output should look something like this:
What is the Scantag for the entry outlined in blue above? Make sure you also type the hyphen in the middle of the scantag.
What is the quantity in the blue box? Enter your answer to the nearest integer.
What is the order total that should be in the blue box? Enter your answer to two decimal places.
Paste the SQL you used to execute this query below.
Question 3 options:[SQL Week 2 Question 200-503]You
Question 3 options:
[SQL Week 2 Question 200-503]
You suspect certain employees are not servicing very many shipments, and some may not have any shipments at all.
Create SQL to run a report which will
List all your employees and the customers they serviced along with the number of shipment for each customer. Include all employees, including those who may not have serviced any customers.
Note you want the number of shipments, not the sum of shipment quantity. For example, if you have one shipment of 10 units, and another shipment of 20 units, our number of shipments here is 2.
Sort the list descending on number of shipments, and then on employee id. If an employee has not serviced any customers, display that employee at the top.
What is the first name of the very first employee you display? (Just type the first name here.)
How many shipments did employee Sophia Moore have to Lake Erie Guitars?
If she didn't have any (or her name is not shown in the results anywhere even when you scroll down), enter the number 0.
[SQL Week 2 Question 200-502]You want to
[SQL Week 2 Question 200-502]
You want to make a report which will give you information about shipments sent by your lower-commission employees. Create a query which will
Include only all those shipments which were sent by an employee whose commission is 10% or less (include commissions of exactly 10%)
Print the state, company name, total quantity in the shipments for that customer, and the maximum employee commission in that order left to right.
Sort it alphabetically by state (ascending). If one state has several companies in it, they should be sorted within the state, with the highest total order quantity on top.
What information is found in the third row down, which should be the first one containing an entry from the State of Michigan? It corresponds to the blue box below.
Question 2 options:
Thumb Exports, 1, 0.04
Midland Imports, 57, 0.09
Something else not found here
Huron Bay Exporters, 68, 0.10
ABC Incorporated, 48, 0.09
WK 2 – DATA 620 QUIZ 2.5B – Multi-Table SQL Queries
SQL Week 2 Assignment 2.5B Questions
Question 1 (1 point)
Question 1 options:
[SQL Week 2 Question 200-501]
For every shipment in the shipment table, you want to know its shipment details, the customer information, and the employee information. Include exactly and only all the records for which a shipment ID exists. Sort it ascending by Scantag.
What is the idShipment of your first record?
What is the idCustomer of the first row returned?
What is the first name (EmpFirstName) of the employee in the first row returned?
(Make sure to type the first name only.)
Egbert
[SQL Week 2 Question 200-002] We want to
[SQL Week 2 Question 200-002]
We want to get a workload by employee printout. For every employee, print the first name, last name, all ticket ID numbers assigned to that employee, the ticket description, and ticket duration of our records. Include only tickets which have been assigned to an employee. Include all employees, even if that person doesn’t have any tickets in the current database. Sort them first alphabetically by first name (starting with letter A at the top) and then ascending by ticket duration.
Below is a screenshot of your query results. Which entry should go in the blue box?
QUIZ 2.3B – TWO TABLE SQL QUERIESSQL
QUIZ 2.3B – TWO TABLE SQL QUERIES
SQL Week 2 Assignment 2.3B Questions
Question 1 (1 point)
Question 1 options:
[SQL Week 2 Question 200-001]
Print the first name, last name, ticket ID, ticket description, and duration of the employees who are assigned with a ticket(s). Sort them first alphabetically by first name (starting with letter A at the top) and then ascending by Duration.
This query should have resulted in employee Ben Johnson as your first several rows.
What is the top row idTicket for Ben?
1. SQL Week 2 Question 200-506] Last
1. SQL Week 2 Question 200-506] Last one! You want to know how many times products were shipped to customers. Note you want the total number of shipments, not the number of items shipped – one shipment of 10 items and one shipment of 20 items would be two shipments, not 30 items.
a. Include all products, even if they had no shipments. In this case, their count would be 0.
b. Include the manufacturer and the product name
c. Include the customer company name
d. Sort it so the smallest count of shipments is on top. After that, sort ascending by Manufacturer name and then product name.
1. [SQL Week 2 Question 200-505] You
1. [SQL Week 2 Question 200-505] You want to report on a certain group of your products. Select
a. Only customers who have a balance of 0
b. Only shipments which were sent by employees whose employee location is California, Maryland, or New York
c. Only products which have had a shipment
d. Only employees who have made a shipment
e. Only customers who have received a shipment
f. Compute the total quantity of shipments which meet these criteria. Here we want the number of items shipped. If you have one shipment of 10 items, and another shipment of 20 items, this number should be 30.
g. Aggregate it by manufacturer and by product name. This means each manufacturer/product name combination appears on only one row in the table. If a manufacturer makes more than one product, it’s OK if it shows up once per product.
h. Sort it descending by the sum of the shipment quantity, so the largest shipment quantity shows up on top. Within shipment quantities, sort it alphabetically on manufacturer and then product name.
Your results should look a little bit like this. Your data may or may not match this example.
1. [SQL Week 2 Question 200-504] You
1. [SQL Week 2 Question 200-504] You want to compute the order total for your shipments. For all of your shipments, put together a report which contains the following columns.
a. Sort it ascending on idShipment
b. Create a new field in the output result called OrderTotal, which is the price per unit multiplied by the order quantity. You will need to calculate this field in SQL.
Your output will look a little bit like the following. Your numbers may vary from this example
1. [SQL Week 2 Question 200-503] You
1. [SQL Week 2 Question 200-503] You suspect certain employees are not servicing very many shipments, and some may not have any shipments at all.
Create SQL to run a report which will
a. List all your employees and the customers they serviced along with the number of shipments for each customer. Include all employees, including those who may not have serviced any customers.
b. Note you want the number of shipments, not the sum of shipment quantity. For example, if you have one shipment of 10 units, and another shipment of 20 units, our number of shipments here is 2.
c. Sort the list ascending on number of shipments (so the smallest numbers of shipments are at the top), and then on employee id. If an employee has not serviced any customers, display that employee at the very top.
For the Question 4, you may want to review the SQL Aliases functionality (“select X from Y as Z”). There is a section in WWW3 SQL schools on this.
1. [SQL Week 2 Question 200-502] You
1. [SQL Week 2 Question 200-502] You want to make a report which will give you information about shipments sent by your lower-commission employees. Create a query which will
a. Include only all those shipments which were sent by an employee whose commission is 10% or less (include commissions of exactly 10%)
b. Print the state, company name, total quantity in the shipments for that customer, and the maximum employee commission in that order left to right.
c. Sort it alphabetically by state (ascending). If one state has several companies in it, they should be sorted within the state, with the highest total order quantity on top.
Your data may or may not match the example below.
For example, if your input data looks like this
Shipment
Customer Company Name
Customer State
Quantity
Employee
Employee Commission
1
ABC
MN
1
Sarah
0.05
2
ABC
MN
2
Thomas
0.10
3
Junior
MN
5
Sarah
0.05
4
DEF
GA
1
Thomas
0.10
5
DEF
GA
1
Victor
0.11
6
G
MD
10
Wally
0.01
7
H
MD
20
Xerxes
0.09
Your answer would look like this:
State
Customer CompanyName
Total Quantity shipped to this customer
Maximum Employee Commission in these shipments
GA
DEF
1
0.10
MD
H
20
0.09
MD
G
10
0.01
MN
Junior
5
0.05
MN
ABC
3
0.10
Part 2 – Construct your Warehouse SQL
Part 2 – Construct your Warehouse SQL statements
This is where you start to turn things in. To turn in your assignment, delete the preceding pages and start with this one. Make sure to put your name up top.
Construct SQL to answer each of the following questions. For each query, paste your SQL code below, and also paste a screenshot of the first 10 or so rows the query gives you.
Give an answer to the question based only on what you see in your MySQL database. (Do not use Excel or other tools to answer these questions; since we are trying to learn MySQL here, you should do these exercises in MySQL.)
You will eventually submit this document as part of your week’s homework.
After you have completed your first draft of this document, you will use the online quiz to verify your answers. The online quiz uses the same numbering system given here, so you can quickly find the question you need.
You are welcome to update your homework document with results from the online quiz, and submit the homework document after you’ve checked your homework online.
1. [SQL Week 2 Question 200-501] For every shipment in the shipment table, you want to know its shipment details, the customer information, and the employee information.
a. Include exactly and only all the records for which a shipment ID exists.
b. Sort it ascending by Scantag.
c. Your output should look a little like this. Note the “shipment information” will be in the form of several distinct columns. (Hint: look up the “ Select * ” command to select several columns at once.)
Assignment 2.5A In this assignment, we walk you
Assignment 2.5A
In this assignment, we walk you through joins which use more than two tables.
Here’s what you are going to do for this assignment.
· Review this document. There are several parts to this document.
o Part 1 is instructions only. There is nothing to turn in, but it contains important information.
o Part 2 of this document is called the TURN IN part. This contains something you should turn in for this assignment.
· Go through this document and write SQL to answer all the questions listed below. As part of your SQL, you will capture screenshots and paste them where indicated.
· Refer to this document as you complete the online quiz which verifies your homework.
· You are welcome to use the quiz results to update your homework file.
· When you have completed the online quiz, submit the TURN IN portion of this document in the Assignment dropbox.
· Remember, you can always reach out for help to your FA or instructor if your SQL is not behaving for you.
· Your completed deliverables for this assignment are:
o The TURN IN section of this document, submitted to the LEO dropbox
o The completed online quiz results
· There is no deliverable of a SQL script for this assignment. You are welcome to create one for your own records, but the TURN IN section of this document will suffice for your faculty.
· And, you probably already know this by now, but you can always reach out to your FA for assistance.
Purpose: get more practice with multi-table SQL queries. We will practice
· Complex joins
· LEFT and FULL joins
· Order by and Group by
Part 0 – Get into your Folder
We will continue to work in the “Week2” folder inside your “DATA620” folder. Download everything into this folder and run it from there.
Part 1 – Fire up the Warehouse database
1. Go ahead and fire up MySQL Workbench and connect to your Azure MySQL database.
2. Download and run the following scripts. They will install a new database schema called “warehouse” which contains information about your customers, your products, your employees, and your shipments.
a. Warehouse_setup.sql – this will create a database schema called “warehouse”
b. Warehouse_insert.sql – this will populate your database with information about your customers, products, employees, and shipments. (Note there may be a numeric suffix on the end of your sql, so its name may be ‘warehouse_insert_v04.sql’ for example. The information in your database may or may not be exactly the same as in this example. That’s OK.)
c. You can make sure that all tables are properly populated by executing;
SELECT * FROM warehouse.<replace-table-name>;
Where <replace-table-name> is in {customer, employee, product, shipment}
d. The insert SQL also contains one query at its bottom, which should give you a list of the company names and shipments. The first one should be from ABC Incorporated, with an idShipment of 1200 and a Quantity of 9.
3. Let’s reverse engineer this database to see what the EER looks like.
a. Remember how? Database -> Reverse Engineer and then click “next” until it gives you the EER. I needed to drag my tables a little bit apart so I could see them all.
b. You can export your diagram using File -> Export -> Export as PNG. You can also grab a screenshot.
c. Verify you can see one primary key for each table. The primary key is denoted by a golden key icon.
d. Verify you understand the relationships. You should be able to see that a customer, product, and employee can exist independently.
e. You should also be able to see that a shipment ties a quantity ordered with the customer who ordered it, the product which was ordered, and the employee who fulfilled the order. A shipment also contains a Scantag and a Reference Number, two internal notations the company sometimes uses.
4. You may want to refresh your memory about how to do three-table joins. In the WWW3 Schools SQL instructions, you can see the “SQL Inner Join” on the left menu, and halfway down that page there’s a note about how to JOIN three tables.
5. There is nothing to turn in from this part.
UMGC Data 620 Assignment 4.3 Your name:Date: DeliverablesPossiblePointsTURN
UMGC Data 620 Assignment 4.3 Your name:
Date:
Deliverables
Possible
Points
TURN IN #1 – SQL script
5
TURN IN #2 – csv file
5
TOTAL
10
This assignment covers how to import data from Excel to MySQL, and how to export data from MySQL to Excel.
If you have a Mac, please see the last page (Appendix) for some helpful notes.
Reading:
? MySQL Reference Manual, Section 13.2.9.1 – how to use the SELECT INTO command
This document contains an EXAMPLE of each type of operation; you do not need to turn in anything related to the examples. The basic logic path of this assignment is:
1. Get your SQL up and running, and connected to the Cloud.
2. Prepare your Excel file into a .csv for import and get it in the right spot.
3. Import: Using Table Import Wizard
4. Export: One option presented; this sends your output file to a designated folder on your local machine.
After the examples, there is an assignment. Your deliverable here is marked with TURN IN and consists of:
? An SQL script
? An output .csv file
I have chosen to err on the side of lavish documentation here, so if you’re feeling Spartan instead, you are welcome to skip straight to the assignment on the last few pages. But if you’d like an extravagant collection of screenshots with commentary, turn straight to page 2.
EXAMPLE of an IMPORT:
Raw data stored in xls/xlsx files can be imported into MySQL databases easily. The following tutorial will demonstrate the data import process. This tutorial demonstrates a simple 50 row Excel sheet import process:
Please be aware of the following facts before you attempt the import process:
? You can only export one worksheet at a time to the MySQL database that you have created. Exporting is fast and easy provided they are in compatible formats and within a reasonable file size.
? The Excel worksheet should be clean (free of fancy formatting such as images, colors, wrap text and fancy fonts) before exporting. (The example we are doing here is well?behaved, but if you are trying to import other data from the wild, you may need to tame it a bit before doing the import.)
Get your Excel file prepared for upload to MySQL:
1. Make yourself a “Week 4” folder. Pay attention to whether you put a space between the “Week” and the “4” – I suggest you put a space there because I did, and then your filename/paths will match these directions. (If the script calls for “Week 4”, and you have “Week4” or “Week_4”, the computer won’t find it.)
UMUC Data 620 Assignment 4.1AThis assignment covers
UMUC Data 620 Assignment 4.1A
This assignment covers entity integrity and referential integrity. This is a group assignment and only one person from your group needs to post your results. It is wise for all members of the group to be familiar with the assignment.
Your group’s deliverable is participation in the Discussion Forum. Review the material below, and post your group’s answers to the discussion forum.
Feel free to read and respond to other classmates’ postings.
Reading:
· Narasimhan, Girija, “Entity Integrity Constraints,”
o https://www.youtube.com/watch?v=0r-Lu48ZTD0 (2 minutes)
· Caleb the Video Maker 2, “MySQL Lecture Series,” specifically:
o MySQL 11 - Entity Integrity: https://www.youtube.com/watch?v=wCOpSR-_VvA
o MySQL 12 - Referential Integrity: https://www.youtube.com/watch?v=Q2XnoPDWwmY
o MySQL 13 - Domain Integrity: https://youtu.be/7g0tyzy2qOk
o MySQL 14 - Primary Key (the video starts with some deer jumping in a yard, but don’t be fooled, Caleb is waiting for you): https://youtu.be/E3Bs3H14C8Y
o (We skip his MySQL 15 - Auto Increment; you can certainly watch if you want to.)
o MySQL 16 - Foreign Key: https://youtu.be/5HQzigiRb5c
Part A: Data Integrity
This week’s reading refers to entity and referential integrity within databases. Without these items, your database would probably not work at all, and if you got it to work, it would break easily or give you crazy responses.
Get the database into MySQL Workbench
This is going to require a little bit of SQL from you.
1. Log into MySQL Workbench and create a new database. Name it “my_university.”
9/7/2020 Data 620 - Lesson 4: Data Manipulation
9/7/2020 Data 620 - Lesson 4: Data Manipulation and SQL File Input/Output - DATA 620 9040 Data Management and V isualization (2208) https://learn.umgc.edu/d2l/le/content/512831/viewContent/19677149/V iew 1/3 OVERVIEW: The first three weeks of this class introduced R X W R W K H J H Q H U D O D U H D R I G D W D P D Q D J H P H Q W D Q d gave R X D W D V W H R I K R Z W R X V H 6 4 / W R W D O N W R our database. Once R X K D Y H D Q R U P D O L ] H G G D W D E D V H D Q G D V N L O O H d SQL programmer , there are additional areas to consider . This week, we cover data quality, database design and operations, data governance, and data storage and indexing. W e also expand our SQL commands to include those to read data in from outside sources, and to write the results of SQL queries to outside sources: in our case, we use a comma separated values (csv) format. Data Qualit refers to how fit R X U G D W D L V I R U W K H S X U S R V H V ou intend. You could have a beautifull Q R U P D O L ] H d relational database with perfectl X Q L T X H S U L P D U ke V D Q G I O D Z O H V V I R U H L J Q N H relationships, but if all the customers’ names are spelled incorrectly, it will still not be ver X V H I X O I R U P D U N H W L Q J S X U S R V H V 7 K L V Z H H N , we’ll cover the major wa V W K L Q J V F D Q J R Z U R Q J Z L W K our data: it could be inaccurate, out of date, incomplete, or inconsistent with itself. We’ll also cover the major wa V W K L Q J V F D Q J R Z U R Q J Z L W K our database itself: R u can fail to have referential integrity , or R X U G D W D F R X O G I D L O W R I R O O R Z E X V L Q H V V U X O H V ' D W D T X D O L W is such a huge corporate issue that man F R P S D Q L H V K D Y H H Q W L U H W H D P V R I S H R S O H G H G L F D W H G W R H Q V X U L Q J G D W D T X D O L W y . In our stud R I Database Design and Operations this week, we investigate structural problems with databases. Because databases are so precisel V S H F L I L H G D Q G E H F D X V H W K H run on computers, a structural problem can be catastrophic. We have seen in previous weeks how to set up a good database, in which all primar N H s are unique and all foreign ke V O H D G W R V R P H Z K H U H 7 K L V Z H H N Z H Z L O O V W X G integrit F R Q V W U D L Q W V Z K L F K K H O p ensure that the foreign ke V U H I H U W R H [ L V W L Q J G H V W L Q D W L R Q V D Q G W K D W L I ou delete a record, R X G R Q ’ t bring down the database. We then turn our attention awa I U R P W K H Q R U P D O L ] H G U H O D W L R Q D O G D W D E D V H V F K H P D V R R I W H Q X V H G L Q R S H U D W L R Q D l data stores. W e look towards an alternative or ganization called the Snowflake or Star Schema . Rather than several smaller tables linked with ke V W K H V Q R Z I O D N H V F K H P D K D V R Q H F H Q W U D O L ] H G I L O H Z L W K Y D U L R X V ? D U P V ? R r points of the star) attached to it. Each “arm” contains the information R X Q H H G W R T X H U along one dimension. For example, a large flat file could contain the date of a purchase, the purchased item, the shipment destination, and the customer information. One arm of one star could break the dates down into months, quarters, and H D U V Another arm of the star might break the shipment destination down into states (such as Mar O D Q G R U U H J L R Q s (such as the Pacific Northwest). This lets the customer run quick queries for things like “all orders which shipped in Quarter 1 of 2015, to the state of Mar O D Q G ? R U ? D O O R U G H U V X Q G H U Z K L F K V K L S S H G L Q 0 D of any H D r, to an Z K H U H L Q W K H 3 D F L I L F 1 R U W K Z H V W ? 4 X H U L H V R I W K L V W pe are included in a method called Dimensional Anal V L s . Data Governance: Or , the care and feeding of R X U G D W a Data is crucial to modern corporate operations, and H W L W F K D Q J H V D O O W K H W L P H - X V W D V Q H Z E X L O G L Q J F R Q V W U X F W L R n needs to be maintained, and periodicall J L Y H Q D Q H Z U R R I P R V W F R U S R U D W H G D W D Q H H G V W R X Q G H r go regular maintenance, and periodicall J L Y H Q D U H R rganization. Even if nothing went wrong with R X U G D W D S H U L R G L F D O O y there are new laws (such as HIPAA) which require new measures to be taken with existing data. Data governance includes the activities a corporation needs to undertake to identif S U R E O H P V Z L W K L W V G D W D I L [ W K H P , and deplo W K H U H V X O W V Data Storage and Indexing: How do R X I L Q G our data quickl ? With our small databases in this class, it’ s not reall Q H F H V V D U to optimize for quer V S H H G D F R P S X W H U F D n simpl O R R N W K U R X J K H D F K R Q H R I R X U I H Z K X Q G U H G D L U O L Q H U H F R U G V W R I L Q G W K H R Q H Z H Z D Q W % X W Z K D W L I ou have a few million records? Or what if R X D U H ) D F H E R R N D Q G D U H J H Q H U D W L Q J P R U H W K D Q P L O O L R Q ? O L N H V ? H Y H U y minute [1] ? Even if R X U T X H U can search one million rows a minute, if R X D U H ) D F H E R R N ou are getting 4 minutes slower in R X U T X H U L H V I R U H Y H U minute of time which passes. Y ou started off behind and R X D U e slowing down. One solution is to use a data index (plural: several data indices ) to help cut R X U V H D U F K W L P H If R X K D Y H D O L V W R I Q D P H V V R U W H G D O S K D E H W L F D O O y , and the one R X Z D Q W V W D U W V Z L W K D ? 4 ? ou don’ t need to start 9/7/2020 Data 620 - Lesson 4: Data Manipulation and SQL File Input/Output - DATA 620 9040 Data Management and V isualization (2208) https://learn.umgc.edu/d2l/le/content/512831/viewContent/19677149/V iew 2/3 searching at the “A.” Data indexing is a wa W R F R Q V W U X F W D V H U L H V R I P D S V I R U our SQL query , so it can make use of alphabetical, numeric, and other sorted orders to accelerate R X U V H D U F K . SQL File Input/Output: How do R X read and write to external files? Up until now, our databases have magicall O L Y H G Z L W K L Q W K H & O R X G & R P S X W L Q J / D E V D Q G Z H K D Y H F U H D W H G D Q d destro H G W K H P Z L W K L Q W K H & O R X G & R P S X W L Q J / D E ’ s confines. But what happens if R X Z D Q W W R V D y, download a data file from the Center for Disease Control and run SQL queries on who got the flu? And then what if R X r quer U H V X O W V D U H V R E U L O O L D Q W ou’d like to share them with R X U E R V V Z K R Z L O O R Q O use Excel? There are commands in SQL R X F D Q X V H W R W H O O L W K R Z W R U H D G G D W D L Q I U R P D Q H [ W H U Q D O I O D W I L O H D Q G K R Z W R Z U L W H R X W S X W W o an external flat file. We will show R X K R Z W K R V H Z R U N W K L V Z H H N Required Readings for the W eek: 1. Data Quality M 6 4 / 11 - Entit , Q W H J U L W y M 6 4 / 5 H I H U H Q W L D O , Q W H J U L W y M 6 4 / ' R P D L Q , Q W H J U L W y M 6 4 / 3 U L P D U Ke V W D U W V Z L W K V R P H G H H U M X P S L Q J L Q D ard) (We skip the M 6 4 / $ X W R , Q F U H P H Q W ou can certainl Z D W F K L I ou want to.) M 6 4 / ) R U H L J Q . H y Chr V O H U V ' D W D 4 X D O L W Management Case Study Data Qualit & R Q F H S W V ' D W D 4 X D O L W T utorial, Data Warehousing Tutorial Data Qualit 0 D W W H U V T ech Vision 2018 T rend (Accenture) 2. Database Design and Operations Inmon vs. Kimball . This is a brief review of the normalized vs. star schema la R X W V . Star Schema Slides from Professor Majed Al-Ghandour . (Link refers to Data 620 Model Classroom 2158, material available in Week 4). 3. Data Governance Data Architecture: A Primer for the Data Scientist , b , Q P R Q D Q G / L Q V W H G W & K D S W H U 5 Data Management Practices Across an Institution: Surve D Q G 5 H S R U t Data Governance and Stewardship 4. Data Storage and Indexing Database Lesson #7 of 8 Database Indexes 5. SQL File input/output M 6 4 / 5 H I H U H Q F H 0 D Q X D l , Section 13.2.6 through Section 13.2.9.1. Also see Section 3.3.3, the LOAD command, for alternative wa V W R O R D G G D W D L Q W R D W D E O H . Optional Readings for the W eek: 1. Data Quality 2. Database Design and Operations 3. Data Governance Managing and Sharing Your Data: Best Practice for Researchers 4. Data Storage and Indexing 5. SQL File Input/Output 9/7/2020 Data 620 - Lesson 4: Data Manipulation and SQL File Input/Output - DATA 620 9040 Data Management and V isualization (2208) https://learn.umgc.edu/d2l/le/content/512831/viewContent/19677149/V iew 3/3 [1] http://editorial.designtaxi.com/editorial-images/news-data14082015/big.jpg
WK 4 – DATA 620 Discussion 4.1B
WK 4 – DATA 620 Discussion 4.1B - Data Quality and Governance Do this as a GROUP ASSIGNMENT. (Once your group has submitted, you should have access to this thread. If you don't, go ahead and submit a little something like 'Please disregard - Bobby from Group 9 posting so I can see responses.') This assignment covers data quality and data governance. Have your primary posting (the response to the boss) completed by Monday midnight, and have all your responses to classmates completed by Tuesday evening. Reading: Data Quality Inmon and Linstedt, Chapter 5.5 (Data Governance) Schwartzrock, Todd, "Chrysler's Data Quality Management Case Study," https://www.youtube.com/watch?v=N78lHpiCD0k (10 minutes) Edureka, "Data Quality Concepts | Data Quality Tutorial | Data Warehousing Tutorial," https://youtu.be/HWaBdqmTqEA (25 minutes) Accenture, "Data Quality Matters - Tech Vision 2018 Trend," https://youtu.be/abNDyLt8ilU (25 minutes) Data Governance and Stewardship (On this webpage, there is a button to download the pdf document) Watch the videos above and read Chapter 5.5 in Inmon and Linstedt. Assume you work at XYZ Automotive, a competitor of Chrysler, and your boss has written you the following email: “Hi, Everybody’s talking about data quality these days, but I’m not sure it’s actually worth the expense. I’ve got three issues here and I want you to enlighten me. First, I’m not really sure what data quality means – I know it means we spell the customer’s name right, but what else does it mean beyond writing down who bought what car when? In other words, can you define data integrity for me? Second, what exactly is data governance and how would it apply to our company? And last, I need to make a business decision. We’re considering having a consulting firm do an engagement which it says will radically improve the quality of our data. What business advantages has Chrysler actually seen from its data quality initiative? What advantages would you think we could get by doing our own?” Compose an email to answer your boss. Please paste the text of the email within the discussion forum; do *not* put your email as an attachment. Make it easy for us to respond! Include in your submission your group name; for example, if my group is Group X, I might title mine, "Group X says we absolutely need better data governance." Choose two other submissions to respond to. In your response, include three stars (three things they did well), plus one wish (constructive criticism.) The responses to classmates may or may not come from the same person who did the initial posting. Again, make sure it's easy to tell which group is responding; title it something like "Group X responds to Group Y." A successful submission will Contain approximately 300-500 words, plus a bibliography Be as formal (or informal) as you would take in a tone with an email to your boss – the only difference here would be that you do need APA citations and a bibliography. Pass a reference citation check for plagiarism – cite all your sources Define data quality and cite your sources. You may use sources outside of the Chrysler and Global Data Store assigned sources, but you must convince me you have watched those two sources as well. Define data governance and cite your sources. Again, you may use sources outside of Inmon and Linstedt, but you must convince me you have understood Chapter 5.5 in our textbook. Be as specific as you can about the business advantages for Chrysler from better data quality. List (or estimate) dollars and any other performance metrics you can find. (You are expected to be able to answer this using mostly just the Chrysler video; you are welcome do to brief Internet searches – and cite your sources - if you want to look up a fact or two, but this is *not* a research question.) Give good feedback to classmates on their postings.
WK 4 – DATA 620 Discussion 4.1C
WK 4 – DATA 620 Discussion 4.1C - Star Schema vs. Relational Databases
Do this as a GROUP ASSIGNMENT.
(Once your group has submitted, you should have access to this thread. If you don't, go ahead and submit a little something like 'Please disregard - Bobby from Group 9 posting so I can see responses.')
This assignment covers the star schema vs. relational database schema.
Have your primary posting (the response to the boss) completed by Monday midnight, and have all your responses to classmates completed by Tuesday evening.
Reading: Database schematics
This is not required reading, but it may be helpful: past students have also found useful information on the James Serra blog posting about data warehouse architecture.
Your boss is at it again. You are still working at XYZ Automotive, which is still a competitor of Chrysler, and your boss has written you the following email:
“Hi,
So I’ve done a little research on star schema vs. relational databases, and I’m just plain old confused. I’ve read the materials above, and Section 3.4 in the Inmon/Linstedt book, and I’m wondering if you could define the relational database model, define the star schema model, and tell me which one we need to use. In plain old English.”
Compose an email to answer your boss. Please paste the text of the email within the discussion forum; do *not* put your email as an attachment. Make it easy for us to respond! Include in your submission your group name; for example, if my Group is X, I might title mine, "Group X recommends the star schema"
Choose two other submissions to respond to. In your response, include three stars (three things they did well), plus one wish (constructive criticism.) The responses to others may or may not be from the same person who posted the initial submission.
A successful submission will
Investing $1,500,000 in TQM's Channel Support Systems
Investing $1,500,000 in TQM's Channel Support Systems initiative will at a minimum increase demand for your products 1.7% in this and in all future rounds. (Refer to the TQM Initiative worksheet in the CompXM Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,290,917. Assuming similar sales next year, the 1.7% increase in demand will provide $2,775,946 of additional revenue. With the overall contribution margin of 34.1%, after direct costs this revenue will add $946,598 to the bottom line. For simplicity, assume that the demand increase and margins will remain at last year's levels. How long will it take to achieve payback on the initial $1,500,000 TQM investment, rounded to the nearest month?
Currently Digby is paying a dividend of
Currently Digby is paying a dividend of $11.99 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?
Select: 1
$15.63
10.3%
13.5%
Assume Baldwin Corp. is downsizing the size
Assume Baldwin Corp. is downsizing the size of their workforce by 15% (to the nearest person) next year from various strategic initiatives. Baldwin is planning to conduct exit interviews to learn more about how they can improve in processes and increase productivity. The exit interviews are estimated to cost $100 per employee in additional to normal separation costs of $5000. How much will the company pay in separation costs if these exit interviews are implemented next year?
Select: 1
$96,600
$546,000
$234,600
$1,326,000
Which company has the least efficient SG&A/Sales
Which company has the least efficient SG&A/Sales ratio?
Select: 1
Chester
Baldwin
Digby
Baldwin's balance sheet has $77,547,000 in equity.
Baldwin's balance sheet has $77,547,000 in equity. Further, the company is expecting net income of 3,000,000 next year, and also expecting to issue $4,000,000 in new stock. If there are no dividends paid what will beBaldwin's book value?
Select: 1
$84,547,000
$76,547,000
$38,810,000
$30,810,000
Assume Baldwin is producing 2,480 units of
Assume Baldwin is producing 2,480 units of Bold next year. What would Bold's plant utilization be?
Select: 1
155.00%
151.90%
111.39%
158.10%
Assume Baldwin is producing 2,480 units of
Assume Baldwin is producing 2,480 units of Bold next year. What would Bold's plant utilization be?
Select: 1
155.00%
151.90%
111.39%
158.10%
Your Competitive Intelligence team is predicting that
Your Competitive Intelligence team is predicting that the Baldwin Company will invest in adding capacity to their Brat product this year. Assume Baldwin's product Brat invests in increasing its capacity by 10% this year. Because of this new information, your company anticipates all other products in the Core segment will increase their capacity by the same amount. How much can the industry produce in the Core segment the next year? Consider only products primarily in the Core segment last year. Ignore current inventories. Figures in thousands (000).
Select: 1
7,575
13,750
9,652
8,552
7,777
8,675
5,150
In the Month of March, Chester received
In the Month of March, Chester received orders of 102 units at a price of $15.00 for their product Cid. Chester uses the accrual method of accounting and offers 30 day credit terms. Chester delivers 102 units in April. They received payment for 51 units in March, and 51 units in April. In the March income statement, how much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
0, $765
0, $1,530
$1,530 , 0
$765 , $765
Currently Aft is charged $3,399,200 Depreciation on
Currently Aft is charged $3,399,200 Depreciation on the Income Statement of Andrews. Andrews is planning for an increase in this depreciation. On the financial statements of Andrews will this?
Select: 1
Decrease Net Cash from Operations on the Cash Flow Statement.
Have no impact on the Net Cash from Operations as depreciation appears in both Cash Flow and the Income Statement.
Increase Net Cash from Operations on the Cash Flow Statement.
Just impact the Balance Sheet.
The Andrews company currently has the following
The Andrews company currently has the following balances in their equity accounts:
Common Stock $25,080
Retained earnings $115,836
Suppose next year the Andrews company generates $46,300 in Net Profit, and declares and pays $16,000 in Dividends. What will Andrews ending balance in Retained Earnings be next year?
Select: 1
$146,136
$156,916
$140,916
$71,380
The Digby company will increase its automation
The Digby company will increase its automation for the Dune product by 2.0. Assuming no further change in capacity, how much will this investment in automation cost?
Select: 1
$7,350,000
$14,700,000
$8,400,000
$16,800,000
Suppose you were hired as a consultant
Suppose you were hired as a consultant for a company that wants to penetrate the Comp-XM market. This company wants to pursue a broad cost leader strategy. From last year’s reports, which company would be the strongest competitor?
Select: 1
Andrews
Chester
Baldwin
Digby
How much would it cost for Chester
How much would it cost for Chester Corporation to repurchase all its outstanding shares if the price fell by 10%? Assume no brokerage fees.
Select: 1
$73.9 million
$82.1 million
$84.0 million
$91.1 million
Assuming no brokerage fees, calculate the amount
Assuming no brokerage fees, calculate the amount of cash needed to retire Baldwin's 12.5S2027 bond early.
Select: 1
$13,765,142
$15,598,251
$14,665,611
Chester has negotiated a new labor contract
Chester has negotiated a new labor contract for the next round that will affect the cost for their product Cid. Labor costs will go from $1.77 to $2.37 per unit. Assume all period and other variable costs remain the same. If Chester were to absorb the new labor costs without passing them on in the form of higher prices, how many units of product Cid would need to be sold next round to break even on the product?
Select: 1
1,047
855
921
887
The Baldwin company will continue to train
The Baldwin company will continue to train their existing workforce at their current level to help reduce turnover and improve productivity next year. Employee training costs $20 per hour. How much would their training costs per employee be to the nearest dollar?
Select: 1
$800
$1,182
$1,982
$400
Digby Corp. ended the year carrying $9,701,000
Digby Corp. ended the year carrying $9,701,000 worth of inventory. Had they sold their entire inventory at their current prices, how much more revenue would it have brought to Digby Corp.?
Select: 1
$5,933,000
$9,701,000
$21,467,600
$15,785,000
This year Andrews achieved an ROE of
This year Andrews achieved an ROE of 16.8%. Suppose the Board of Directors of Andrews mandates that management take measures to increase financial Leverage (=Assets/Equity) next year. Assuming Sales, Profits, and Assets remain the same next year, what effect would you expect this new Leverage policy will have on Andrews ROE?
Select: 1
Andrews ROE will remain the same.
Andrews ROE will increase.
Andrews ROE will decrease.
Next year Baldwin plans to include an
Next year Baldwin plans to include an additional performance bonus of 0.25% in its compensation plan. This incentive will be provided in addition to the annual raise, if productivity goals are reached. Assuming the goals are reached, how much will Baldwin pay its employees per hour?
Select: 1
$29.63
$28.15
$31.04
$28.22
Chester's turnover rate for this year is
Chester's turnover rate for this year is 6.32%. This rate is projected to remain the same next year and no further downsizing will occur from automating. What would the total recruiting cost be for Chester, assuming it spends the same amount extra above the $1,000 recruiting base as they did this year?
Select: 1
$161,448
$316
$134,540
$2,128,469
It is January 2nd and senior management
It is January 2nd and senior management of Chester meets to determine their investment plan for the year. They decide to fully fund a plant and equipment purchase by issuing $10,000,000 in bonds. Assume the bonds are issued at face value and leverage changes to 2.8. Which of the following statements are true? Select all that apply.
Select: 3
Total Assets will rise to $207,341,821
Working capital will remain the same at $11,898,413
The total investment for Chester will be $18,828,179
Total liabilities will be $130,138,340
Chester’s long-term debt will rise by $10,000,000
On the income statement, which of the
On the income statement, which of the following would be classified as a variable cost?
Select: 1
Depreciation Expense
Promotion Expense
Direct Material Expense
R&D Expense
Company Baldwin invested $37,940,000 in plant and
Company Baldwin invested $37,940,000 in plant and equipment last year. The plant investment was funded with bonds at a face value of $28,711,622 at 13.9% interest, and equity of $9,228,378. Depreciation is 15 years straight line. For this transaction alone which of the following statements are true?
Select: 5
On the Balance sheet, Plant & Equipment increased by $37,940,000.
Cash went down by $37,940,000 when the plant was purchased.
Cash was pulled from retained earnings to cover the $9,228,378 difference between the plant purchase and bond issue.
Since the new plant was funded with debt and equity, on the Balance sheet Retained Earnings decreased by $9,228,378, the difference between the investment $37,940,000 and the bond $28,711,622.
On the Balance sheet, Long Term Debt changed by $28,711,622.
Buying the plant had no net effect on the Cash account, because the plant was paid for by the bond plus retained earnings.
Depreciation increased by $2,529,333.
Cash went up when the Bond was issued by $28,711,622.
Digby has an asset turnover of 1.51
Digby has an asset turnover of 1.51 (Asset Turnover = Sales/Assets). That means:
Select: 1
Every $1.00 of assets in the firm generates $1.51 of profit.
Every $1.51 of assets in the firm generates $1.00 of sales.
Every $1.51 of profit in the firm comes from each $1.00 of sales.
Each $1.00 of assets in the firm generates $1.51 of sales revenue.
The Andrews Company has just purchased $46,968,000
The Andrews Company has just purchased $46,968,000 of plant and equipment that has an estimated useful life of 15 years. The expected salvage value at the end of 15 years is $4,696,800. What will the book value of this purchase (exclude all other plant and equipment) be after its third year of use? (Use FASB GAAP)
Select: 1
$38,513,760
$37,574,400
$33,816,960
$40,705,600
Last year the Digby company increased their
Last year the Digby company increased their equity. In 2019 their equity was $49,360. Last year (2020) it increased to $50,897.
What are causes of change in equity? Check all that apply.
Select: 3
Profits of $10,148
A change in short term debt of-$4,032.
Plant Improvements of $9,580
A bond issue of$1,279.
Depreciation of -$41,287
An accounts payable change of$1,437.
A change in cash of -$5,803.
Issue and retirement of stock .
A change of plant and equipment of$9,580.
Dividend payment of$7,057.
Change in inventory of$871
What is the Liability to Equity ratio
What is the Liability to Equity ratio of Chester?
Select: 1
1.45
2.10
4.48
.34
Review the Inquirer to determine Chester's current
Review the Inquirer to determine Chester's current strategy. How will they seek a competitive advantage? From the following list, select the top five sources of competitive advantage that Chester would be most likely to pursue.
Select: 5
Offer attractive credit terms
Accept lower plant utilization and higher capacities to insure sufficient capacity is available to meet demand
Increase demand through TQM initiatives
Reduce cost of goods through TQM initiatives
Seek high automation levels
Add additional products
Reduce labor costs through training and recruitment
Seek the lowest price in their target market while maintaining a competitive contribution margin
Seek high plant utilization, even if it risks occasional small stockouts
Seek excellent product designs, high awareness, and high accessibility
which mission statement best represents the Baldwin
which mission statement best represents the Baldwin company?
Select: 1
Innovation meets revolution. We create value for our customers through breakthrough designs that lead to unique high-performance products.
Consistency and affordability are our goals. Our central mission is to offer dependable, low-price products that our customers can count on.
Providing value to our customers is why we get up in the morning. We accomplish this by offering products at a low price our customers can afford across a wide variety of market segments.
Lasting innovation is our motivation. We build premium products that are elegantly designed to meet the needs of a variety of market segments.
Midyear on July 31st, the Baldwin Corporation's
Midyear on July 31st, the Baldwin Corporation's balance sheet reported:
Total Liabilities of $127.704 million
Cash of $10.050 million
Total Assets of $204.791 million
Retained Earnings of $42.497 million.
What was the Baldwin Corporation's common stock?
Select: 1
$34.590 million
$44.640 million
$119.584 million
$129.634 million
Looking forward to next year, if Digby’s
Looking forward to next year, if Digby’s current cash amount is $19,378 (000) and cash flows from operations next period are unchanged from this period and Digby takes ONLY the following actions relating to cash flows from investing and financing activities:
Issues $2,000 (000) of long-term debt
Pays $4,000 (000) in dividends
Retires $10,000 (000) in debt
Which of the following activities will expose Digby to the most risk of needing an emergency loan?
Select: 1
Repurchases $10,000 (000) of stock
Purchases assets at a cost of $15,000 (000)
Issues 100 (000) shares of common stock
Sells $7,000 (000) of long-term assets
select all of the following statements that
select all of the following statements that are true four years from now, in the year 2023.
Select: 2
The Thrift segment will demand 7,744 thousand units
The Nano segment will demand 5,405 thousand units
The Core segment will demand 9,774 thousand units
The Elite segment will demand 5,871 thousand units
Cure is a product of the Chester
Cure is a product of the Chester company which is primarily in the Nano segment, but is also sold in another segment. Chester starts to create their sales forecast by assuming all policies (R&D, Marketing, and Production) for all competitors are equal this year over last. For this question assume that all 700 of units of Cure are sold in the Nano segment. If the competitive environment remains unchanged what will be the Cure product’s demand next year (in 000’s)?
Dot is a product of the Digby company. Digby's sales forecast for Dot is 505 units. Digby wants to have an extra 10% of units on hand above and beyond their forecast in case sales are better than expected. (They would risk the possibility of excess inventory carrying charges rather than risk lost profits on a stock out.) Taking current inventory into account, what will Dot's Production After Adjustment have to be in order to have a 10% reserve of units available for sale?
Refer to the HR Reports in the
Refer to the HR Reports in the Inquirer. Through past investments in recruiting and training Baldwin has obtained a productivity index of 109.4%. This means that Baldwin's labor costs would be increased by 9.4% if it did not have these productivity improvements. This is a competitive advantage that Baldwin can sustain or even widen further if its competitors have no HR initiatives. Now, refer to the Income Statement in Baldwin's Annual Report. How much did Baldwin's productivity improvements save it in direct labor costs (in thousands) last year?
Which description best fits Andrews? For clarity: -
Which description best fits Andrews? For clarity:
- A differentiator competes through good designs, high awareness, and easy accessibility.
- A cost leader competes on price by reducing costs and passing the savings to customers.
- A broad player competes in all parts of the market.
- A niche player competes in selected parts of the market.
Which of these four statements best describes your company's current strategy?
Select: 1
Andrews is a broad differentiator
Andrews is a broad cost leader
Andrews is a niche differentiator
Andrews is a niche cost leader
Chester's product manager is considering lowering the
Chester's product manager is considering lowering the price of the Camp product by $2.50 and wants to know what the impact will be on the product’s contribution margin. Assuming no inventory carry costs, what will Camp's contribution margin be if the price is lowered?
Bid's product manager is under pressure to
Bid's product manager is under pressure to increase market share, but is uncertain about how to make the product more competitive. The product is reasonably well-positioned in the Thrift segment and enjoys relatively high awareness and accessibility. Which of the following would most likely result in a quick increase in market share?
Select: 1
Re-position the product to the ideal spot within the segment
Increase awareness by 5%
Increase the unit contribution margin by decreasing the MTBF
Lower the unit selling price to the bottom limit of the segment price range
Brand managers know that increasing promotional budgets
Brand managers know that increasing promotional budgets eventually result in diminishing returns. The first one million dollars typically results in a 26% increase in awareness, while the second million results in adding another 18% and the third million in a 5% increase. Andrews’s product Agape currently has an awareness level of 79% . While an important product for Andrews, Agape’s promotion budget will be reduced to one million dollars for the upcoming year. Assuming that Agape loses one-third of its awareness each year, what will Agape’s awareness level be next year?
DATA 620 QUIZ 2.5B Muti-Table SQL Queries
DATA 620 QUIZ 2.5B Muti-Table SQL Queries (3rd Attempt) Week 2 Assignment 2.5B Questions Question 1 (1 point) Question 1 options: [SQL Week 2 Question 200-501] For every shipment in the shipment table, you want to know its shipment details, the customer information, and the employee information. Include exactly and only all the records for which a shipment ID exists. Sort it ascending by Scantag. SELECT* from Customer c Join Shipment s on c.idCustomer=s.Customer_idCustomer Join Employee e ON s.employee_idEmployee =e.idEmployee where idShipment is not null order by Scantag asc; What is the idShipment of your first record? What is the idCustomer of the first row returned? What is the first name (EmpFirstName) of the employee in the first row returned? (Make sure to type the first name only.) Egbert Question 2 (1 point)
Investing $1,500,000 in TQM's Channel Support Systems
Investing $1,500,000 in TQM's Channel Support Systems initiative will at a minimum increase demand for your products 1.7% in this and in all future rounds. (Refer to the TQM Initiative worksheet in the CompXM Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,290,917. Assuming similar sales next year, the 1.7% increase in demand will provide $2,775,946 of additional revenue. With the overall contribution margin of 34.1%, after direct costs this revenue will add $946,598 to the bottom line. For simplicity, assume that the demand increase and margins will remain at last year's levels. How long will it take to achieve payback on the initial $1,500,000 TQM investment, rounded to the nearest month?
