[SOLVED] Chester's balance sheet has $74,255,000 in equity.
Chester's balance sheet has $74,255,000 in equity. Further, the company is expecting net income of 4,000,000 next year, and also expecting to pay $5,000,000 in dividends. If there is no new stock issued what will be Chester's book value?
Select : 1
Submit Answer
The Baldwin company wants to decrease its plant utilization for Bell by 15%. How many units would need to be produced next year to meet this production goal? Ignore impact of accounts payable on plant utilization.
Select : 1
Submit Answer
Assume Digby Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives. Digby 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
Submit Answer
Chester has negotiated a new labor contract for the next round that will affect the cost for their product Cat. Labor costs will go from $2.88 to $3.48 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 Cat would need to be sold next round to break even on the product?
Select : 1
Submit Answer
[SOLVED] What would Chester Corporation's market capitalization be if the current price rose 10%?
What would Chester Corporation's market capitalization be if the current price rose 10%?
Select : 1
Submit Answer
Assuming no brokerage fees, calculate the amount of cash needed to retire Baldwin's 11.2S2030 bond early.
Select : 1
Submit Answer
Of Baldwin Corporation’s products, which earned the lowest direct labor as a percentage of its sales?
Select : 1
Submit Answer
The Baldwin Company currently has the following balances on their balance sheet: Total Liabilities $56,080 Common Stock $10,729 Retained Earnings $60,351 Suppose next year the Baldwin Company generates $36,500 in net profit and pays $15,000 in dividends and total liabilities and common stock remain unchanged. What must their total assets be next year?
Select : 1
Submit Answer
Baldwin Corp. ended the year carrying $15,786,000 worth of inventory. Had they sold their entire inventory at their current prices, how much more revenue would it have brought to Baldwin Corp.?
Select : 1
Submit Answer
[SOLVED] On the Income Statement, which of the following would be classified as a variable cost?
On the Income Statement, which of the following would be classified as a variable cost?
Select : 1
Submit Answer
Suppose the Baldwin company expands to other markets with good designs, high awareness and easy accessibility, what strategy would they be implementing?
Select : 1
Submit Answer
Digby's turnover rate for this year is 6.33%. This rate is projected to remain the same next year and no further downsizing will occur from automating. Digby plans to spend an additional $500 beyond the extra amount above the $1000 recruiting base it spent this year. The goal of this additional investment is to improve the quality of applicants. What would the total recruiting cost be for Digby next year?
Select : 1
Submit Answer
It is January 2nd and senior management of Digby 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
Submit Answer
This year Andrews achieved an ROE of 21.6%. Suppose the Board of Directors of Andrews mandates that management take measures to decrease 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's ROE?
Select : 1
Submit Answer
Andrews ROE will increase
The statement of cash flows for Baldwin Company shows what happens in the Cash account during the year. It can be seen as a summary of the sources and uses of cash (sources of cash are added, uses of cash are subtracted). Please answer which of the following is true if Baldwin's inventory goes up:
Select : 1
Submit Answer
Last year, Baldwin Corp paid their workers $26.81 per hour. How much will they be paying them 2 rounds from then?
Select : 1
Submit Answer
[SOLVED] Which mission statement best represents the Chester company?
Which mission statement best represents the Chester company?
Select : 1
Submit Answer
Innovation meets revolution. We create value for our customers through breakthrough designs that lead to unique high-performance products
[SOLVED] What is the Current Ratio of Chester?
What is the Current Ratio of Chester?
Select : 1
Submit Answer
The Andrews Company has just purchased $59,068,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 $5,906,800. What will the accumulated depreciation expense for this purchase (exclude all other plant and equipment) be after its second year of use? (Use FASB GAAP)
Select : 1
Submit Answer
If Baldwin issued 1000 shares of common stock at last year's end price, the effect on the balance sheet would be:
Select : 1
Submit Answer
Midyear on July 31st, the Chester Corporation's balance sheet reported: Total Assets of $243.772 million Total Common Stock of $7.620 million Cash of $12.060 million Retained Earnings of $49.549 million. What were the Chester Corporation's total liabilities?
Select : 1
Submit Answer
Baldwin has a leverage of 1.84 This means that: (Assume leverage is calculated as Assets/Equity)
Select : 1
Submit Answer
Review the Inquirer to determine Digby's current strategy. How will they seek a competitive advantage? From the following list, select the top five sources of competitive advantage that Digby would be most likely to pursue.
Select : 5
Submit Answer
Cat'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
Submit Answer
Investing $2,000,000 in TQM's Channel Support Systems initiative will at a minimum increase demand for your products 3.0% 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,085,264. Assuming similar sales next year, the 3.0% increase in demand will provide $4,892,558 of additional revenue. With the overall contribution margin of 34.1%, after direct costs this revenue will add $1,668,362 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 $2,000,000 TQM investment, rounded to the nearest month?
Select : 1
Submit Answer
Looking forward to next year, if Baldwin’s current cash amount is $20,132 (000) and cash flows from operations next period are unchanged from this period and Baldwin 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 Baldwin to the most risk of needing an emergency loan?
Select : 1
Submit Answer
[SOLVED] Deal is a product of the Digby company. Digby's sales forecast for Deal is 2079 units.
Deal is a product of the Digby company. Digby's sales forecast for Deal is 2079 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 Deal's Production After Adjustment have to be in order to have a 10% reserve of units available for sale?
Select : 1
Submit Answer
Refer to the HR Reports in the Inquirer. Through past investments in recruiting and training Chester has obtained a productivity index of 109.5%. This means that Chester's labor costs would be increased by 9.5% if it did not have these productivity improvements. This is a competitive advantage that Chester can sustain or even widen further if its competitors have no HR initiatives. Now, refer to the Income Statement in Chester's Annual Report. How much did Chester's productivity improvements save it in direct labor costs (in thousands) last year?
Select : 1
Submit Answer
Increasing the promotional budget for a product is not advisable in the short-term under which of the following circumstances?
Select : 1
Submit Answer
According to information found on the production analysis page of the Inquirer, Baldwin sold 1125 units of Bam in the current year. Assuming that Bam maintains a constant market share, all the units of Bam are sold in the Nano market segment and the growth rate remains constant, how many years will it be before Bam will not be able to meet future demand unless the company adds production capacity? Exclude any existing inventory.
Select : 1
Submit Answer
[SOLVED] Digby's product manager is considering lowering the price of the Dome product by $2.50
Digby's product manager is considering lowering the price of the Dome 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 Dome's contribution margin be if the price is lowered?
Select : 1
Submit Answer
In three years, assuming the competitive environment remains unchanged, how many units of Bam will Baldwin be selling in the Nano market segment?
Select : 1
Submit Answer
PREVALENCE OF CARDIO-VASCULAR ILLNESS IN MENTAL HEALTH PATIENTS SUFFERING FROM SCHIZOPHRENIA
PREVALENCE OF CARDIO-VASCULAR ILLNESS IN MENTAL HEALTH PATIENTS SUFFERING FROM SCHIZOPHRENIA
Introduction
Mental health care globally is one area receiving less focus, and despite this, it is a fact that mental health issues continue to soar and more people are affected. Of all the mental health cases, schizophrenia is the least common but chronic and severe. The symptoms of schizophrenia are very disabling, and interest in the research developed because of getting into contact with a patient suffering from cardiovascular disease who was schizophrenic (Fan et al., 2013). There are always strategies that can be developed and initiated to ensure that mental health patients get to live healthy lives similarly to their counterparts, but dedication and undivided support are vital. These people are human beings like the rest, citizens contributing to society and economy at large; hence have to enjoy the right to healthy lives (Bresee et al., 2010).
Experience from the contact with the schizophrenic patient drove my interest into researching about the topic, the current trends in the public health sector specifically dealing with intellectually disabled persons and lastly what interventions the government, health sector and other stakeholders in the industry have in place to improve the quality of lives of these persons. Despite the data, depicting some conflicting inferences, it can be concluded that recommendable steps have been made in the sector depicting the concern and effort various stakeholders are putting in place to ensure that intellectually disabled persons get to live a healthy life in the country.
Overview
Over the years, mental health issues have been swept under the carpet despite them being prevalent in society. Equality act of 2010 can be considered as the turning point in the management of mental health cases in the United Kingdom, under which schizophrenia is included. Before the bill being signed, most mental health victims may have been exposed to lower quality health care as compared to their counterparts but thanks to the law, changes in their health status are being recognized.
Schizophrenic patients record higher mortality rates as a result of cardiovascular diseases as depicted by research studies carried over the globe and not only in the United Kingdom. With such indexes, there is a need for health practitioners, families and the authority at large to invest more in caring and supporting these victims to ensure that deaths because of cardiovascular diseases are limited and schizophrenic patients get to live healthy lives exposed to little or no risk factors that may lead to cardiovascular diseases.
Various professionals have been significant in the management of schizophrenia and ensuring that schizophrenic patients do not suffer from cardiovascular diseases that may be brought about by their behaviors and lifestyles. The intervention strategies include developing proper diet plans that ensure these victims eat balanced diets and not only foods rich in fats, a precursor to cardiovascular disease development. Developing practice plans that ensure these patients exercise physically hence breaking the monotony of their sedentary lives and prescribing best medication for their conditions.
Definitions, statistics, and impacts
Meehl (2017) defines schizophrenia as a severe and long-term mental health condition that causes a range of different psychological symptoms. In most cases, schizophrenia is a particular type of psychosis whereby the victims are not able to distinguish the reality from their ideas and thoughts.
Data has it that one in every six people in the United Kingdom suffers from mental health at one stage in their lives and one in every 100 will experience a schizophrenic episode. An astonishing fact about schizophrenia is that it affects individuals from all lifestyles or social backgrounds, regardless of gender or social class. National Health Service (NHS) treats around 220,000 cases of schizophrenia annually, and these patients have an incidence of between 5- 10 percent of dying within 10 years after diagnosis (NHS, n.d.). Compared to the other population, this mortality incidence percentage is high. Regarding cost, schizophrenia is an economic burden in the United Kingdom (UK) as mental health cases cost the economy close to £77 Billion annually, and this calculated in percentage is close to 4 percent of the national Gross Domestic Product (GDP) (NHS, n.d.).
Cardiovascular diseases (CVD) on the other end are a class of ailments related to the heart and blood vessels. Examples of CDV’s include coronary artery diseases, stroke, heart failure, Venus thrombosis and congenital heart disease (World Health Organization, 2017). Despite 90 percent of CDV disease being preventable, statistics have it that it is the leading cause of mortality globally accounting for tens of millions of deaths annually.
Mortality among schizophrenic victims because of cardio-vascular illnesses has significantly elevated over the years, and despite the research and studies were done in this area, no single cause can be attributed to being a cause of the occurrence (NHS, n.d.). Deductions from this may be that the area has not been adequately addressed or no strict studies have been undertaken in the area. An example is the sedentary life of schizophrenic people hence increased incidences of diseases related to CDV (Taylor & Perera, 2015).
Role of a nurse practitioner in assisting Schizophrenic patients with cardiovascular disease
People with schizophrenia are the most affected by cardiovascular diseases, given the likelihood of the unhealthy life that they live. The basis of this statement is from statistics that show that schizophrenic patients record higher mortality rates from CDV compared to their counterparts, hence the need to develop appropriate public health interventions explicitly targeting this group of people with the aim of reversing the trend (Laursen et al., 2012).
Schizophrenic people just like other people with mental issues need adequate access to healthcare, and nurses as the primary health practitioners in the UK more likely to come into contact with them have to understand the needs of this select group of people. The equality act of 2010 makes this a mandatory requirement for people with mental disability, an area under which schizophrenia perfectly suits.
Research by Laursen et al., (2012) showed that the lifestyle of schizophrenic people is a leading factor towards their increased incidences of CVD’s but there also exists other factors contributing to that but with a much lower significance as compared to lifestyle. Given this, the central role of a nurse, at this phase is to enable schizophrenic victims with CVD’s live quality life.
There are strategies and programs in place to ensure that health practitioners play a vital role in providing medical support to schizophrenic patients with CDV. Contrary, studies have shown that inadequacy in relevant skills and knowledge as a result of inadequate training and reluctance to accept more responsibilities are leading factors towards limiting nurses offering services to these patients (Ringen et al., 2014).
Schizophrenic patients require assistance in managing their health despite their being variance in dependency on families or other practitioners to assist. The result is that nurses have to lias with family members or other people close to the patient to ensure that communication regarding the health needs of the patient, decision making and other health-related activities is enhanced for the health benefit of the schizophrenic patient (Bradshaw & Pedley, 2012). Given the sedentary life of most schizophrenic patients, developing issues like high blood pressure and being overweight is common and these are the leading risk factors for CVD. Nurses have a role to play, like ensuring that regular health check-ups are carried out on these people and the right medication or public health intervention auctioned.
Nurses also have the responsibility of enhancing self-management knowledge through public health education. The primary aim of this is to develop constructive and sustainable strategies aimed at mitigating the risk factors for CDV amongst schizophrenic patients (Videbeck & Videbeck, 2013). This may not be necessarily on the patients, but adults or family members of the patients may be advised and educated on the need to change their lifestyle or behavior patterns to limit the risks factors for developing CDV amongst schizophrenic persons. Nurses are professionally required to play this role effectively. Communication skills and knowledge of the particular nurse about the care and health needs of the schizophrenic patient with CDV is crucial in undertaking such a responsibility.
Prescription of medication in case a prior one is considered ineffective may be required and as a nurse frequently assessing the health condition of the patient, protocol to initiate such changes have to be observed. Prescriptions that trigger unlikely responses from the patient have to be substituted and given the fact that stress may be a risk factor to behavioral changes that may risk the development of CDV among schizophrenic patients; interaction with the patient in a manner that develops trust is a role to be played by the nurse. Development of such a relationship between the patient and the nurse not only enables the nurse to attain vital information from the patient but also enables the family and health practitioner to develop strategies and make decisions applicable and effective to the health of the patient (Videbeck & Videbeck, 2013).
Involvement of the patient, family and health practitioner (nurse)
Caring for schizophrenic victims with CVD is a responsibility to be performed by the family, health practitioner and the individual patient. Despite most people considering mental health cases victims like those who have schizophrenia as being incapable of making an informed decision, it is vital to involve them in the decision-making process since it is their health at stake and they have the right to make decisions also. Exceptional cases like where the victim is a minor or have been proved medically to be incapable of making such decisions are common, and it is only in such scenarios where the patient may be excluded from the decision-making process (Kakuma et al., 2011).
In most cases, schizophrenic patients live with their families, friends or extended families and it is always essential to ensure that all the people in close and frequent contact with the patient get to understand the condition their mate is suffering from to reduce conflicting instances. These family members and close acquaintances, commonly referred to as informal carers have to be actively involved in decision-making. Nurses have to ensure that the family members are presented with national policies and strategies that make it easier for them to assess the health needs of schizophrenic patients hence making it easier for the health practitioners to make informed decisions regarding the health status of the patient (Kakuma et al., 2011).
The support given to the schizophrenic patient has to be developed in a manner that makes it easier for both the nurse and family deliver health care that is manageable. Contact between the family and health practitioner is essential in ensuring that a strategy to offer the schizophrenic patient health care without any hardship or inequality on both ends hence regardless of the service provided by the family or nurse, the patient is satisfied (Richards et al., 2010). The family also plays a vital role in conjunction with the nurse and the patient may develop routines aimed at improving the health of the CDV schizophrenic patient. Like having routine chores that may enable the schizophrenic patient exercise. Diet management is also vital, and the parties involved may work together to develop a dietary routine that is healthy for the patient. Example, more vegetables may be included in the diet of the patient and foods with high levels of fats minimized, and this acts as a strategy to reinstate the health of the schizophrenic patient.
Characteristic health problems is also an area, which requires assistance and support from the parties involved; family and health practitioners. In some instances, schizophrenic patients with CVD may find it hard to express their emotions or communicate effectively. With the aid of the family, the connection that has been initially developed between the patients and their kinship they can be able to express their emotions or feelings. This may be vital in enabling health practitioners to make decisions regarding the health condition of the patient and develop supportive interventions (Kates et al., 2011).
Patients with schizophrenia and suffering from CDV’s are in most cases admitted to hospitals because of acute emergency conditions that can be easily avoided. Involvement of the patient’s family in the treatment process may play a significant role in minimizing the occurrence and likelihood of such emergency hospitalization cases depicting an improvement in the quality of life of the patient and limiting the economic burden because of frequent hospitalization of schizophrenic patients suffering from CDV’s. Engagement of the family and the nurse effectively ensures that knowledge and information for effective home-based care for the schizophrenic patient is initiated. The information provided by the nurse to the family and the victim is aimed at ensuring that the decisions made are sustainable and aim to improve the health status of the patient. Poor coordination and involvement of the parties in the treatment process increase the risks of failure, and the results may be deteriorated the health status of the patient or even mortality (Kates et al., 2011). To avoid such, it is always important to ensure that all the parties involved actively take part in the decision-making and initiation of health programs and strategies for the patient.
Roles played by different professionals in caring for schizophrenic victims suffering from CDV’s
Caring for schizophrenic patients with CDV involves various professionals. Nursing as a healthcare profession is considered the most involved in caring for these people but in reality, multiple professionals are involved but nurses play a major role, and that goes undisputed. The support provided by nurses is crucial as they provide physical care, public health advice and even support (Azad et al., 2016). The family and schizophrenic patient with CDV can share emotions and feelings with the nurse with the aim of relieving stress
Schizophrenic victims have a speech disorder. The order in which they organize their speech may be hard for others to understand. Speech pathologists role, in this case, is to work with these patients to help them manage their communication. These pathologists educate both the family and schizophrenic patient, and this is vital to enable the patient to communicate about their feelings and conditions about CDV’s. Communication is essential in ensuring that the right medication and decisions are made and limits the probability of misdiagnosis (Lee et al., 2017).
Apart from exercise, diet is important in enabling CDV patients to manage their conditions and live a healthy life. Dieticians help schizophrenic patients suffering from CDV’s and their families develop a healthy eating plan that is focused on the health needs of the victim. The objective is to enable the schizophrenic patient to eat healthy to reinstate their health condition or avoid risks factors that may lead to CDV. Emotional, practical and social support are required for schizophrenic patients with CDV and their families. These forms of support aid in relieving pain and gaining a better understanding of the system and social workers provide this support effectively (Lee et al., 2017). The families of schizophrenic CDV patients and the patients may take the initiative of enrolling themselves in societal groups that may offer these types of support or nurses, and other practitioners may pinpoint an organization where this support may be sort from. The main role of social workers, in this case, is to enable families, schizophrenic patients suffering from CDV adjust to changes, and experiences brought about because of the rehabilitation process (Azad et al., 2016). Pharmacists are also an essential professional in caring for schizophrenic patients with CDV. The medication provided to these patients may have effects and pharmacists may provide the information regarding these effects.
In some cases, the drugs provided may be ineffective, it is the role of the pharmacists to review the medication and advice health professionals on what changes can be made if necessary. Volunteers also work in close association with the health practitioners and aid in providing practical and emotional help. These include tasks such as getting schizophrenic patients to appointments. Specifically, volunteers do not replace paid health practitioners — psychologist’s aid in managing social factors, behaviors, and emotions related to schizophrenia and CDV. Psychologists may develop non-drug approaches that aid in the management of pain and health.
Pastoral care workers and chaplains are also essential healthcare professionals in managing schizophrenic patients suffering from CDV. Regardless of religion, pastoral care workers and chaplains provide emotional and spiritual support in rehabilitation.
The proposed plan of care and support
There is a need to develop a plan that is both manageable financially and sustainable in caring for schizophrenic patients with CVD. Lifestyle concerns are an important factor in the management of CDV. Practices such as smoking which is widely associated with CVD mortality is high among Schizophrenic patients as compared to the other population with indexes standing at about three times higher. Programs to ensure that these categories of people are educated against such practices are important as a health intervention to enable schizophrenic patients to limit risks for developing CDV (American Diabetes Association, 2015).
Schizophrenia is associated with a sedentary behavior that is associated with an increased risk of being overweight, a prerequisite risk for developing CDV. A plan to ensure that schizophrenic individuals engage in physical activities is essential and to improve their fitness hence reducing risks of developing Cardiovascular related illnesses (Bresee et al., 2010). The activities selected for a schizophrenic patient have to consider their functioning levels, and the nature of the psychiatric setting the victim is exposed to. Diet is also an important consideration when developing a care plan for schizophrenic patients. To avoid include foods rich in calories, carbohydrates, and fats as they increase the risk of CVD. People with schizophrenia have unhealthy diets if let to make diet decisions on their own, so it is important to develop a plan with balanced nutrition. Eating habits also have to be observed to ensure that these patients are served the right amounts of foods so that instances of overeating or undereating that may lead to eating disorders are minimized (De Hert et al., 2011).
Medication with Antipsychotic is a central and significant element in the treatment of schizophrenia. Some of this medication are obesogenic hence the need to ensure that these patients adopt an active lifestyle to reduce instances of developing CDV risks (Bresee et al., 2010). Adherence to medication is also a problem given the personal suffering associated with them, hence the need to include a plan that makes drug adherence a priority among these patients, and effectively may be making a family member monitor these patients to ensure that they do take their medication as prescribed.
Conclusion
Schizophrenia may be a rare condition but based on the facts, the economic burden is high, and interventions have to be made to ensure that the condition is managed and people suffering from it live a quality life, similarly to the other citizens in the country. Mortality and morbidity cases related to cardiovascular diseases are high among schizophrenic patients, hence the need for families and health professionals to intervene. Their sedentary lives and behaviors are considered as the main factors in them developing cardiovascular-related illnesses, whereby these diseases can be easily managed if proper care is initiated in time.
Various professionals are involved in the management of the health of schizophrenic patients, from families, social workers, nurses and even psychologists. Of importance is to ensure that proper communication is maintained for medication and all vital information assessed before decisions regarding the health of the victim are made. Schizophrenic patients also have the right to be involved in decision-making and made aware of the practices they are made to go through as a way of limiting aggressive behaviors that may be depicted at times.
References
American Diabetes Association. (2015). Standards of medical care in diabetes—2015 abridged for primary care providers. Clinical diabetes: a publication of the American Diabetes Association, 33(2), 97.
Azad, M. C., Shoesmith, W. D., Al Mamun, M., Abdullah, A. F., Naing, D. K. S., Phanindranath, M., & Turin, T. C. (2016). Cardiovascular diseases among patients with schizophrenia. Asian journal of psychiatry, 19, 28-36. Retrieved from http://www.ums.edu.my/fpsk/images/Journal/J.2016/2.11.pdf
Bradshaw, T., & Pedley, R. (2012). Evolving role of mental health nurses in the physical health care of people with serious mental health illness. International Journal of Mental Health Nursing, 21(3), 266-273.Retrieved from http://www.academia.edu/download/41981126/Evolving_role_of_mental_health_nurses_in20160203-22315-151ydzs.pdf
Bresee, L. C., Majumdar, S. R., Patten, S. B., & Johnson, J. A. (2010). Prevalence of cardiovascular risk factors and disease in people with schizophrenia: a population-based study. Schizophrenia research, 117(1), 75-82.
Bresee, L. C., Majumdar, S. R., Patten, S. B., & Johnson, J. A. (2010). Prevalence of cardiovascular risk factors and disease in people with schizophrenia: a population-based study. Schizophrenia research, 117(1), 75-82.
De Hert, M., Correll, C. U., Bobes, J., Cetkovich?Bakmas, M. A. R. C. E. L. O., Cohen, D. A. N., Asai, I., ... & Newcomer, J. W. (2011). Physical illness in patients with severe mental disorders. I. Prevalence, impact of medications and disparities in health care. World psychiatry, 10(1), 52-77. Retrieved from https://onlinelibrary.wiley.com/doi/full/10.1002/j.2051-5545.2011.tb00014.x
Fan, Z., Wu, Y., Shen, J., Ji, T., & Zhan, R. (2013). Schizophrenia and the risk of cardiovascular diseases: a meta-analysis of thirteen cohort studies. Journal of psychiatric research, 47(11), 1549-1556.
Kakuma, R., Minas, H., van Ginneken, N., Dal Poz, M. R., Desiraju, K., Morris, J. E., ... & Scheffler, R. M. (2011). Human resources for mental health care: current situation and strategies for action. The Lancet, 378(9803), 1654-1663. Retrieved from http://www.who.int/entity/workforcealliance/knowledge/resources/lancet_hrmentalhealth_oct2011.pdf?ua=1
Kates, N., Mazowita, G., Lemire, F., Jayabarathan, A., Bland, R., Selby, P., ... & Audet, D. (2011). The evolution of collaborative mental health care in Canada: A shared vision for the future. Canadian Journal of Psychiatry, 56(5), I1.
Laursen, T. M., Munk-Olsen, T., & Vestergaard, M. (2012). Life expectancy and cardiovascular mortality in persons with schizophrenia. Current opinion in psychiatry, 25(2), 83-88.
Lee, J., Nurjono, M., Wong, A., & Salim, A. (2017). Prevalence of metabolic syndrome among patients with schizophrenia in Singapore. Retrieved from https://open-access.imh.com.sg/bitstream/123456789/4562/1/Prevalence%20of%20Metabolic%20Syndrome%20Among%20Patients%20with%20Schizophrenia%20in%20Singapore.pdf
Meehl, P. E. (2017). Schizotaxia, schizotypy, schizophrenia. In Schizophrenia (pp. 21-46). Routledge.
NHS. Statistics. Retrieved from https://www.england.nhs.uk/statistics/
Richards, K., Campenni, C., & Muse-Burke, J. (2010). Self-care and well-being in mental health professionals: The mediating effects of self-awareness and mindfulness. Journal of Mental Health Counseling, 32(3), 247-264. Retrieved from https://www.researchgate.net/profile/C_Campenni/publication/279741291_Self-care_and_Well-being_in_Mental_Health_Professionals_The_Mediating_Effects_of_Self-awareness_and_Mindfulness/links/5bbb917d299bf1049b74f8d2/Self-care-and-Well-being-in-Mental-Health-Professionals-The-Mediating-Effects-of-Self-awareness-and-Mindfulness.pdf
Ringen, P. A., Engh, J. A., Birkenaes, A. B., Dieset, I., & Andreassen, O. A. (2014). Increased mortality in schizophrenia due to cardiovascular disease–a non-systematic review of epidemiology, possible causes, and interventions. Frontiers in psychiatry, 5, 137.
Taylor, M., & Perera, U. (2015). NICE CG178 Psychosis and Schizophrenia in Adults: Treatment and Management–an evidence-based guideline?. The British Journal of Psychiatry, 206(5), 357-359. Retrieved from https://www.researchgate.net/profile/Mark_Taylor18/publication/275717402_NICE_CG178_Psychosis_and_Schizophrenia_in_Adults_Treatment_and_Management_-_an_evidence-based_guideline/links/55ed109d08ae21d099c7459b/NICE-CG178-Psychosis-and-Schizophrenia-in-Adults-Treatment-and-Management-an-evidence-based-guideline.pdf
Videbeck, S., & Videbeck, S. (2013). Psychiatric-mental health nursing. Lippincott Williams & Wilkins.
World Health Organization. (2017). Noncommunicable diseases: progress monitor 2017.
Code Switching As Language Acquiring StrategyBackground and
Code Switching As Language Acquiring Strategy
Background and rationale
Control processes are what govern speech comprehension and production. In most cases, code-switching has been utilized by language speakers to achieve a particular objective, and in most cases, code-switching is influenced by recurrent demands dictated by the context of interaction (Auer, 2013). The globe is tremendously changing and given the fact that it is becoming a global village, learning foreign language especially international ones like English, Spanish, French and even mandarin is growing inevitable.
In the course of the conversation, it is necessary to decide on a particular code and change between various languages by either code-mixing or code-switching. In some instances, when multilingual or bilingual people converse, their first language influences them to a greater extent yet there is a way to control the first language’s influence. For the people, not very conversant with international foreign languages, cognitive control of code-switching may be the most effective way of enhancing their understanding of foreign languages. Myers?Scotton (2017) states that most monolingual speakers view multilingualism as unimportant as they fail to understand the real essence of multilingualism or bilingualism in real life and this has been found to be the primary holding back factor against them developing interests in learning foreign languages.
Aims and Objectives
The primary objective of this research is to understand the more excellent details of how cognitive code-switching may be utilized as a strategy for enhancing multilingualism. Other goals to be satisfied by this research include; determine the perception the community has towards code-switching and the impact of code-switching on learning foreign languages.
Research questions
Research questions that are aimed at guiding this research include;
a. What is the impact of cognitive code-switching on conversations?
b. What perceptions do the people have on code-switching and learning foreign languages?
c. What influence does code-switching have on learning foreign languages?
Theoretical framework and methodological approach
The focus for the research revolves around institutions of higher learning in China, explicitly selecting Chinese students. The main reason behind the selection of this group of people is the exposure they have gained in foreign languages that have molded their unique view of the society, politics and ethic portions of the different people in China.
Data collection, analysis, and discussion are the major considerate activities to be undertaken for the research to be complete. The primary source of data would be reviews from literature and the responses made by the study sample of 100 students selected randomly from Chinese students in institutions of higher learning within the country.
The principal method of data collection to be utilized for the research is questionnaires with standardized Likert scale format. The scale comprises of indexes labeled 1-5. Where 1- strongly agree, 2- agree, 3- undecided, 4- disagree, 5- strongly disagree. Instructions ought to be offered before the respondents are included in the research to ensure that validity is observed.
The main collaboration deemed essential in this research is support from the languages department of the university. The lecturers and other stakeholders in the department are considered the main consultants in this case and their support would be highly appreciated.
On matters ethics, safeguarding the respondent’s information, using the data for the right intended purpose and seeking informed consent before incorporating respondents into the research would be the key factors to consider.
Analytic discussion of scholarly research to date
The issue of cognitive code-switching has been the focus for most researchers recently, and this may be as a result of the increased intercultural interaction being experienced all over the globe currently. Thanks to contributions by Shana Poplack and Carol Myers-Scottons contributions in the area of linguistic code-switching as their models form the basis for most researches in the sector and formation of strategies that facilitate second language acquisition. The research apart from contributing to the literature in the sector, also play a role in the coining of strategies that aim at effectively utilizing cognitive code-switching in learning foreign languages.
References
Auer, P. (Ed.). (2013). Code-switching in conversation: Language, interaction and identity. Routledge. Retrieved from http://catalogtxtgin.info/peter-auer-code-switching-in-conversation-language-interaction-and-identitypdf-archive-gin-book.pdf
Myers?Scotton, C. (2017). Code?switching. The handbook of sociolinguistics, 217-237.
STAFF FUTUREHuman resource management in projects is
STAFF FUTURE
Human resource management in projects is of crucial importance. The success or failure of a project largely hinges on the way the human resource management department functions, coupled up with the programs and strategies enacted to manage employees in the project. Facts have it that project durations differ, like one project may run for a week while others run for over a decade, but regardless of the duration, all projects aimed at delivering what was initially promised. Failure to deliver means the project is a failure and was just as good as not being run.
For our case, project A is expected to run till 2025, and with the current employees, the dilemma is the human resource management plan. Is there need to recruit more employees or does using the current pool of employees till the end of the project advisable. The most viable option may be to use the current pool of employees to the end of the project but in various, unavoidable circumstances recruitment of new employees may be inevitable especially in instances where new skills and expertise that is missing in the current pool of employees is required.
The first significant reason behind settling for using the current pool of employees until the end of the project is workplace culture. Staff are a replaceable resource, but the quality of experience and dedication among the employees is an essential ingredient to project success. Workplace culture is developed only when employees get to interact over a more extended period working together and with a high turnover of employees in the form of newer recruitments, developing and maintaining a workplace culture may be hard.
Loyalty is also created when the employees who started the project are retained to completion. The impact loyalty creates is that a positive relationship between the project management team and the employees is established which goes a long way into ensuring that the employees are satisfied. With satisfaction, morale is boosted among the employees hence the quality of deliverables raised, conflict resolution becomes an easy task to handles, and it is more likely that these employees may go beyond what is required from them with the aim of aiding the project, something that may be unfamiliarly experienced with recruited new employees.
Retaining employees also improves their experience with the approach of project management the organisation utilises and this is invaluable. These employees compared to recruited ones are always in a better position to advertise the organisation hence increase its marketability, unlike newer contracted employees. The quality of projects delivered by these teams is always of high quality hence endear the project organisation to its clients.
The other issue at stake is identifying top talent that can be maintained by the shareholders. There are various strategies that can be applied, first would be important to do away with the traditional aspects of identifying top talents which solely relied on the manager’s instincts and deductions from observations.
Leadership would be the foundation for selecting top talents based on three vital leadership aspects which are foundations of leadership, emergence and lastly effectiveness. With foundation, one would observe how employees manage their careers, example how they handle work-related issues like conflicts and social interaction. With leadership emergence, the employees may be categorised based on how they stand out as compared to their peers. Those that are naturally viewed as leaders and exert a massive influence on their peers may always prove to be top talents as compared to others. Lastly under aspects of leadership when identifying top talent is leadership effectiveness. Under leadership effectiveness, especially for the project team, the focus may be on team leaders. Like the leaders who always drive their teams to success always stand out and these leaders also have to depict some sense of maintaining these high performing teams and this is primarily based on their leadership skills.
In accordance with Harvard Business Review, the other strategy that may be applied in the move to identify top talent is to use three distinguished markers which are a drive, social skills and ability. On ability, the employees with the capability of strategically thinking and adapting to the organizations changing environments are considered top talents and may prove crucial if maintained by the organisation. Emotional intelligence is what defines social skills, and top talents in an organisation are the employees able to carry themselves with integrity and dignity apart from effectively managing others. Lastly, is a drive which is the will and desire to work extra hard as compared to one’s peers and driven by the desire to achieve. Behaviorally, the drive can be manifested through the willingness of an employee to take additional roles, sacrifices made and eagerness to take newer responsibilities. Incorporating the two distinct aspects of identifying top talents in an organisation may prove useful.
What happens with the other employees once top talents have been identified and projects have been completed primarily rests with the stakeholders of the project, but productive advice is that the contracts with these employees have to be maintained in a manner that is cheaper and easily managed by the organisation. The reason behind such a decision is that, even though these employees may not be top talents, they have the experience and expertise of running a project based on the experience gained and may prove beneficial to the organisation in future. These employees may be easier to incorporate in future projects as compared to newer recruits.
[SOLVED] Which company has the most efficient SG&A / Sales ratio?
Which company has the most efficient SG&A / Sales ratio?
Select : 1
Submit Answer
Your Competitive Intelligence team reports that a wave of product liability lawsuits is likely to cause Digby to pull the product Dome entirely off the market this year. Assume Digby scraps all capacity and inventory this round, completely writing off those assets and escrowing the proceeds to a settlement fund, and assume these lawsuits will have no effect on any other products of Digby or other companies. Without Digby's product Dome how much can the industry currently produce in the Core segment? Consider only products primarily in the Core segment last year. Ignore current inventories. Figures in thousands (000).
Select : 1
Submit Answer
11,860
[SOLVED] Last year Aft charged $5,040,000 Depreciation on the Income Statement of Andrews.
Last year Aft charged $5,040,000 Depreciation on the Income Statement of Andrews. If Aft sold a fully depreciated piece of equipment at a loss, the effect on Andrews's financial statements would be (all other items remaining equal):
Select : 1
Submit Answer
Currently Chester is paying a dividend of $10.65 (per share). If this dividend stayed the same, but the stock price rose by 10% what would be the dividend yield?
Select : 1
Submit Answer
In the Month of March, Digby Corporation received orders of 145 units at a price of $15.00 for their product Daze. Digby uses the accrual method of accounting and offers 30 day credit terms. Digby delivers 96 units in March and the balance of 48 units in April. They received payment for 48 units in March, 48 units in April, and 48 units in May. How much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
Select : 1
Submit Answer
Chester Corporation is considering adding capacity to their Cake product, currently automated to 7.0. Assume: - They will use the new capacity next year to make and sell 200 additional units (000). - Each unit of capacity will cost $34.00. - Cake's price will be unchanged at $34.00. - Material costs will remain $13.04 next year. - Labor costs will remain $5.34 on first shift, and $7.91 on second shift. - Bond interest will remain 12.3% next year. - Depreciation will be straight line over 15 years. - SG&A costs can be ignored because they would be the same with or without the new capacity. Which of the following tactics will yield the highest ROI in their first year of production?
Select : 1
Submit Answer
Buy 100 units of capacity. Finance the $3,400 purchase entirely with a stock issue
Chester Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives. How much will the company pay in separation costs if each worker receives $5,000 when separated?
Select : 1
Submit Answer
[SOLVED] The Baldwin's balance sheet has $94,137,000 in equity.
The Baldwin's balance sheet has $94,137,000 in equity. Further, the company is expecting $3,000,000 in net income next year. Assuming no dividends are paid and no stock is issued, what would their Book Value be next year?
Select : 1
Submit Answer
The Digby 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
Submit Answer
[SOLVED] Which description best fits Chester in your industry? For clarity:
Which description best fits Chester in your industry? 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 this competitor?
Select : 1
Submit Answer
Assuming no brokerage fees, calculate the amount of cash needed to retire Baldwin's 11.2S2027 bond early.
Select : 1
Submit Answer
-$775,219
The Chester company will increase its automation for the Cid product by 2.0. Assuming no further change in capacity, how much will this investment in automation cost?
Select : 1
Submit Answer
How much would it cost for Chester Corporation to repurchase all its outstanding shares if the price went up by 10%? Assume no brokerage fees.
Select : 1
Submit Answer
Of Chester Corporation’s products, which earned the lowest direct labor as a percentage of its sales?
Select : 1
Submit Answer
Chester has negotiated a new labor contract for the next round that will affect the cost for their product Cake. Labor costs will go from $7.51 to $8.11 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 Cake would need to be sold next round to break even on the product?
Select : 1
Submit Answer
1,354
[SOLVED] The Baldwin company currently has the following balances on their balance sheet:
The Baldwin company currently has the following balances on their balance sheet: Assets $219,040 Common Stock $52,266 Retained earnings $34,045 Suppose next year the Baldwin Company generates $20,000 in net profit, pays $10,000 in dividends, assets change to $151,000, and common stock remains unchanged. What must their total liabilities be next year?
Select : 1
Submit Answer
The statement of cash flows for Baldwin Company shows what happens in the Cash account during the year. It can be seen as a summary of the sources and uses of cash (sources of cash are added, uses of cash are subtracted). Please answer which of the following is true if Baldwin issues bonds:
Select : 1
Submit Answer
The Baldwin's workforce complement will grow by 10% (rounded to the nearest person) next year. Ignoring downsizing from automating, what would their total recruiting cost be? Assume Baldwin spends the same amount extra above the $1,000 recruiting base as they did last year.
Select : 1
Submit Answer
Chester Corp. ended the year carrying $14,319,000 worth of inventory. Had they sold their entire inventory at their current prices, how much more revenue would it have brought to Chester Corp.?
Select : 1
Submit Answer
Which description best fits Digby? 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 this competitor?
Select : 1
Submit Answer
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
Submit Answer
It is January 2nd and senior management of Baldwin meets to determine their investment plan for the year. They decide to fully fund a plant and equipment purchase by issuing 75,000 shares of stock plus a new bond issue. Assume the stock can be issued at yesterday’s stock price ($27.57) and leverage changes to 2.8. Which of the following statements are true? Select all that apply.
Select : 3
Submit Answer
[SOLVED] On the income statement, which of the following would be classified as a Period cost?
On the income statement, which of the following would be classified as a Period cost?
Select : 1
Submit Answer
[SOLVED] This year Andrews achieved an ROE of 18.4%.
This year Andrews achieved an ROE of 18.4%. Suppose the Board of Directors of Andrews mandates that management take measures to decrease 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's ROE?
Select : 1
Submit Answer
Andrews ROE will increase
[SOLVED] What is the Profit Margin of Chester?
What is the Profit Margin of Chester?
Select : 1
Submit Answer
[SOLVED] The Chester Company has just issued $6,493,586 in dividends last year.
The Chester Company has just issued $6,493,586 in dividends last year. The effect of this payment on the balance sheet is:
Select : 1
Submit Answer
[SOLVED] Review the Inquirer to determine Chester’s current strategy
Review the Inquirer to determine Chester’s current strategy. Where 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
Submit Answer
Which description best fits Baldwin in your industry? 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 this competitor?
Select : 1
Submit Answer
Rank the following companies from high to low cumulative profit, (in descending order, 1=highest, 4=lowest).
Select : 4
Submit Answer
The Andrews Company has just purchased $59,328,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 $5,932,800. What will the depreciation expense for this purchase (exclude all other plant and equipment) be for the second year of use? (Use FASB GAAP)
Select : 1
Submit Answer
$3,559,680
[SOLVED]Midyear on July 31st, the Digby Corporation's balance sheet reported:
Midyear on July 31st, the Digby Corporation's balance sheet reported: Total Liabilities of $25.487 million Cash of $2.010 million Total Assets of $40.680 million Total Common Stock of $1.270 million. What were the Digby Corporation's retained earnings?
Select : 1
Submit Answer
[SOLVED]Chester has an asset turnover of 1.53 (Asset Turnover = Sales/Assets). That means:
Chester has an asset turnover of 1.53 (Asset Turnover = Sales/Assets). That means:
Select : 1
Submit Answer
Chester's Elite product Cedar has an awareness of 72%. Chester's Cedar product manager for the Elite segment is determined to have more awareness for Cedar than Andrews' Elite product Acre. She knows that the first $1M in promotion generates 22% new awareness, the second million adds 23% more and the third million adds another 5%. She also knows one-third of Cedar's existing awareness is lost every year. Assuming that Acre's awareness stays the same next year (77%), out of the promotion budgets below, what is the minimum Chester's Elite product manager should spend in promotion to earn more awareness than Andrews' Acre product?
Select : 1
Submit Answer
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
Submit Answer
Assuming no direct factory overhead costs (i.e., inventory carry costs) and $2.75 million dollars in combined promotion and sales budget, the Bold product manager wishes to achieve a product contribution margin of 30%. Given their product currently is priced at $35.00, what would they need to limit the material and labor costs to?
Select : 1
Submit Answer
According to information found on the production analysis page of the Inquirer, Chester sold 1129 units of Cake in the current year. Assuming that Cake maintains a constant market share, all the units of Cake are sold in the Nano market segment and the growth rate remains constant, how many years will it be before Cake will not be able to meet future demand unless the company adds production capacity? Exclude any existing inventory.
Select : 1
Submit Answer
Assuming Digby’s current market share for its Dell product remains the same, how many units of Dell should Digby expect to sell in the primary segment for the upcoming year?
Select : 1
Submit Answer
A productivity index of 110% means that a company’s labor costs would have been 10% higher if it had not made production improvements. Assume that Digby had a productivity index of 112% and that Baldwin had a productivity index of 103%. Now refer to the Income Statements in the Annual Report for Digby and Baldwin. Using the labor costs shown in the Income Statements, how much more did Digby save in direct labor costs compared to Baldwin by having a higher productivity index?
Select : 1
Submit Answer
Looking forward to next year, if Chester’s current cash amount is $17,624 (000) and cash flows from operations next period are unchanged from this period and Chester 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 Chester to the most risk of needing an emergency loan?
Select : 1
Submit Answer
Investing $2,000,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.xls Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,712,225. Assuming similar sales next year, the 1.7% increase in demand will provide $2,783,108 of additional revenue. With the overall contribution margin of 34.2%, after direct costs this revenue will add $951,823 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 $2,000,000 TQM investment, rounded to the nearest month?
Select : 1
Submit Answer
Bid is a product of the Baldwin company which is primarily in the Nano segment, but is also sold in another segment. Baldwin 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 Bid are sold in the Nano segment. If the competitive environment remains unchanged what will be the Bid product’s demand next year (in 000’s)?
Select : 1
Submit Answer
Demand is created through meeting customer buying criteria, credit terms, awareness (promotion) and accessibility (distribution). According to the Thrift segment's customers, which of these products was the most competitive at the end of last year?
Select : 1
Submit Answer
The statement of cash flows for Baldwin Company shows what happens in the Cash account during the year. It can be seen as a summary of the sources and uses of cash (sources of cash are added, uses of cash are subtracted). Please answer which of the following is true if Baldwin repurchases some of its common stock:
Select : 1
Submit Answer
This year Andrews achieved an ROE of 19.9%. Suppose next year the profit margin (Net Income/Sales) increases. Assuming sales, assets and financial leverage remain the same next year, what effect would you expect this action to have on Andrews's ROE?
Select : 1
Submit Answer
[SOLVED]On the income statement, which of the following would be classified as a Period cost?
On the income statement, which of the following would be classified as a Period cost?
Select : 1
Submit Answer
It is January 2nd and senior management of Digby 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
Submit Answer
The Digby's workforce complement will grow by 20% (rounded to the nearest person) next year. Ignoring downsizing from automating, what would their total recruiting cost be? Assume Digby spends the same amount extra above the $1,000 recruiting base as they did last year.
Select : 1
Submit Answer
Next year Baldwin plans to include an additional performance bonus of 0.5% 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
Submit Answer
Suppose the Chester company begins to compete through good designs, high awareness and easy accessibility for their existing products, what strategy would they be implementing?
Select : 1
Submit Answer
[SOLVED]Baldwin Corp. ended the year carrying $17,515,000 worth of inventory.
Baldwin Corp. ended the year carrying $17,515,000 worth of inventory. Had they sold their entire inventory at their current prices, how much more revenue would it have brought to Baldwin Corp.?
Select : 1
Submit Answer
The Andrews company currently has the following balances in their equity accounts: Common Stock $14,081 Retained earnings $101,016 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
Submit Answer
[SOLVED]The Baldwin company will sell 100 units (x1000) of capacity from their Bat product line
The Baldwin company will sell 100 units (x1000) of capacity from their Bat product line. Each unit of capacity is worth $6 plus $4 per automation rating. The Baldwin company will sell the capacity for 35% off. How much do they receive when the capacity is sold?
Select : 1
Submit Answer
Chester has negotiated a new labor contract for the next round that will affect the cost for their product Coat. Labor costs will go from $2.94 to $3.44 per unit. Assume all period and variable costs as reported on Chester's Income Statement remain the same. If Chester were to pass on half the new labor costs to their customers, how many units of product Coat would need to be sold next round to break even on the product?
Select : 1
Submit Answer
Of Baldwin Corporation’s products, which earned the lowest direct labor as a percentage of its sales?
Select : 1
Submit Answer
Assuming Brokerage fees of $6000, calculate the amount of cash needed to retire Baldwin's 11.2S2029 bond early.
Select : 1
Submit Answer
How much would it cost for Chester Corporation to repurchase all its outstanding shares if the price went up by 10%? Assume no brokerage fees.
Select : 1
Submit Answer
[SOLVED]Refer to the HR Report section of the Inquirer
Refer to the HR Report section of the Inquirer. Chester will continue to keep their current hourly levels of training in order to help reduce turnover and improve productivity next year. How much must be spent per employee on an hourly basis to maintain the current training commitment?
Select : 1
Submit Answer
Suppose you were hired as a consultant for a company that wants to penetrate the Comp-XM market. This company wants to pursue a niche differentiation strategy. From last year’s reports, which company would be the strongest competitor?
Select : 1
Submit Answer
Currently Baldwin is paying a dividend of $14.68 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?
Select : 1
Submit Answer
[SOLVED]Which company has the most efficient SG&A / Sales ratio?
Which company has the most efficient SG&A / Sales ratio?
Select : 1
Submit Answer
In the Month of March, Chester received orders of 147 units at a price of $15.00 for their product Coat, and in April receives an order for 37 units of their product Coat at $15.00. Chester uses the accrual method of accounting and offers 30 day credit terms. Chester delivers 0 units in March, 147 units in April and 37 units in May. They received payment for 147 units in April, and payment for 37 units in May. How much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
Select : 1
Submit Answer
Your Competitive Intelligence team is predicting that the Chester Company will invest in adding capacity to their Cake product this year. Assume Chester's product Cake 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
Submit Answer
[SOLVED]Last year Abby charged $2,256,000 Depreciation on the Income Statement of Andrews.
Last year Abby charged $2,256,000 Depreciation on the Income Statement of Andrews. If Abby sold a fully depreciated piece of equipment at a loss, the effect on Andrews's financial statements would be (all other items remaining equal):
Select : 1
Submit Answer
Assume Baldwin is producing 600 units of Buddy next year. What would Buddy's plant utilization be?
Select : 1
Submit Answer
[SOLVED]Chester's balance sheet has $75,340,000 in equity
Chester's balance sheet has $75,340,000 in equity. If next year, assets decrease by $4,000,000 and liabilities increase by $2,000,000, what will be Chester's book value?
Select : 1
Submit Answer
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
Submit Answer
[SOLVED]Bill's product manager continues to perform well in the market.
Bill's product manager continues to perform well in the market. However, a competing product is coming on strong and is looking to take over as the market share leader in the segment. Without sacrificing contribution margin, what can the Bill product manager do in order to improve upon the buying criteria, and thus potentially increase demand?
Select : 1
Submit Answer
Assuming no direct factory overhead costs (i.e., inventory carry costs) and $3 million dollars in combined promotion and sales budget, the Daft product manager wishes to achieve a product contribution margin of 35%. Given their product currently is priced at $35.00, what would they need to limit the material and labor costs to?
Select : 1
Submit Answer
According to information found on the production analysis page of the Inquirer, Baldwin sold 1128 units of Bill in the current year. Assuming that Bill maintains a constant market share, all the units of Bill are sold in the Nano market segment and the growth rate remains constant, how many years will it be before Bill will not be able to meet future demand unless the company adds production capacity? Exclude any existing inventory.
Select : 1
Submit Answer
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
Submit Answer
[SOLVED]Baldwin's Elite product Boat has an awareness of 72%.
Baldwin's Elite product Boat has an awareness of 72%. Baldwin's Boat product manager for the Elite segment is determined to have more awareness for Boat than Andrews' Elite product Axe. She knows that the first $1M in promotion generates 22% new awareness, the second million adds 23% more and the third million adds another 5%. She also knows one-third of Boat's existing awareness is lost every year. Assuming that Axe's awareness stays the same next year (77%), out of the promotion budgets below, what is the minimum Baldwin's Elite product manager should spend in promotion to earn more awareness than Andrews' Axe product?
Select : 1
Submit Answer
Bill is a product of the Baldwin company which is primarily in the Nano segment, but is also sold in another segment. Baldwin 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 1128 of units of Bill are sold in the Nano segment. If the competitive environment remains unchanged what will be the Bill product’s demand next year (in 000’s)?
Select : 1
Submit Answer
Investing $2,000,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.xls Decisions menu.) Looking at the Round 0 Inquirer for Andrews, last year's sales were $163,508,343. Assuming similar sales next year, the 1.7% increase in demand will provide $2,779,642 of additional revenue. With the overall contribution margin of 34.1%, after direct costs this revenue will add $947,858 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 $2,000,000 TQM investment, rounded to the nearest month?
Select : 1
Submit Answer
[SOLVED]Looking forward to next year, if Baldwin’s current cash amount is $17,334 (000)
Looking forward to next year, if Baldwin’s current cash amount is $17,334 (000) and cash flows from operations next period are unchanged from this period and Baldwin 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 Baldwin to the most risk of needing an emergency loan?
Select : 1
Submit Answer
A productivity index of 110% means that a company’s labor costs would have been 10% higher if it had not made production improvements. Now refer to the Income Statement in Chester's Annual Report. The direct labor costs for Chester were $32,611. These labor costs could have been $20,000 higher if investments in training that increased productivity had not been made. What was the productivity index for Chester that led to such savings?
Select : 1
Submit Answer
From a marginal analysis perspective, what is the inventory carry cost for Andrews if the company carries one additional unit of Axe in inventory at the end?
Select : 1
Submit Answer
[SOLVED]What is the Profit Margin of Chester?
What is the Profit Margin of Chester?
Select : 1
Submit Answer
[SOLVED]Baldwin has an asset turnover of 1.52 (Asset Turnover = Sales/Assets). That means:
Baldwin has an asset turnover of 1.52 (Asset Turnover = Sales/Assets). That means:
Select : 1
Submit Answer
[SOLVED]Midyear on July 31st, the Chester Corporation's balance sheet reported:
Midyear on July 31st, the Chester Corporation's balance sheet reported: Total Liabilities of $25.439 million Cash of $2.010 million Total Assets of $40.623 million Total Common Stock of $1.270 million. What were the Chester Corporation's retained earnings?
Select : 1
Submit Answer
[SOLVED]Which mission statement best represents the Chester company?
Which mission statement best represents the Chester company?
Select : 1
Submit Answer
Review the Inquirer to determine Digby's current strategy. How will they seek a competitive advantage? From the following list, select the top five sources of competitive advantage that Digby would be most likely to pursue.
Select : 5
Submit Answer
The Andrews Company has just purchased $59,328,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 $5,932,800. What will the depreciation expense for this purchase (exclude all other plant and equipment) be for the second year of use? (Use FASB GAAP)
Select : 1
Submit Answer
If Baldwin issued 1000 shares of common stock at last year's end price, the effect on the balance sheet would be:
Select : 1
Submit Answer
Next year Baldwin plans to include an additional performance bonus of 0.5% 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
Submit Answer
[SOLVED]Suppose the Digby company shifts focus to only competing in the Thrift and Nano segment
Suppose the Digby company shifts focus to only competing in the Thrift and Nano segments, while competing on price by reducing costs and passing the savings to the customers, what strategy would they be implementing?
Select : 1
Submit Answer
[SOLVED]Andrews Corp. ended the year carrying $10,749,000 worth of inventory.
Andrews Corp. ended the year carrying $10,749,000 worth of inventory. Had they sold their entire inventory at their current prices, how many more dollars of contribution margin would it have brought to Andrews Corp.?
Select : 1
Submit Answer
It is January 2nd. Senior management of Digby meets to determine their investment plan for the year. They decide to fully fund a plant and equipment purchase by issuing 50,000 shares of stock plus a new bond issue. The CFO happily notes this will raise their Leverage (=assets/equity) to a new target of 2.8. Assume the stock can be issued at yesterday’s stock price ($27.43). Which of the following statements are true? Check all that apply.
Select : 3
Submit Answer
The statement of cash flows for Baldwin Company shows what happens in the Cash account during the year. It can be seen as a summary of the sources and uses of cash (sources of cash are added, uses of cash are subtracted). Please answer which of the following is true if Baldwin issues bonds:
Select : 1
Submit Answer
This year Andrews achieved an ROE of 18.6%. Suppose management takes measures that decrease Asset turnover (Sales/Total Assets) next year. Assuming Sales, Profits, and financial leverage remain the same, what effect would you expect this action to have on Andrews's ROE?
Select : 1
Submit Answer
[SOLVED]On the income statement, which of the following would be classified as a variable cost?
On the income statement, which of the following would be classified as a variable cost?
Select : 1
Submit Answer
The Digby's workforce complement will grow by 20% (rounded to the nearest person) next year. Ignoring downsizing from automating, what would their total recruiting cost be? Assume Digby spends the same amount extra above the $1,000 recruiting base as they did last year.
Select : 1
Submit Answer
Assuming Brokerage fees of $6000, calculate the amount of cash needed to retire Baldwin's 11.2S2029 bond early.
Select : 1
Submit Answer
The Chester company will continue to train their existing workforce at their current level to help reduce turnover and improve productivity next year. Employee training costs have increased to $30 per hour. How much would their training costs per employee be to the nearest dollar?
Select : 1
Submit Answer
Suppose you were hired as a consultant for a company that wants to penetrate the Comp-XM market. This company wants to pursue a niche cost leader strategy. From last year’s reports, which company would be the strongest competitor?
Select : 1
Submit Answer
The Baldwin company will increase its automation for the Best product by 2.0. Assuming no further change in capacity, how much will this investment in automation cost?
Select : 1
Submit Answer
If Chester Corp. were to buy all of it's shares outstanding at its current price, how much would it cost Chester Corp, excluding brokerage fees?
Select : 1
Submit Answer
$144 million
Baldwin has negotiated a new labor contract for the next round that will affect the cost for their product Bill. Labor costs will go from $7.70 to $8.20 per unit. In addition, their material costs have fallen from $13.66 to $12.66. Assume all period costs as reported on Baldwin's Income Statement remain the same. If Baldwin were to pass on half the new costs of labor and half the savings in materials to customers by adjusting the price of their product, how many units of product Bill would need to be sold next round to break even on the product?
Select : 1
Submit Answer
Of Baldwin Corporation’s products, which earned the lowest direct labor as a percentage of its sales?
Select : 1
Submit Answer
[SOLVED]Last year Attic charged $2,216,000 Depreciation on the Income Statement of Andrews
Last year Attic charged $2,216,000 Depreciation on the Income Statement of Andrews. If early this year Attic sold all its depreicable assets for their book value, the effect on Andrews's financial statements would be (all other items remaining equal):
Select : 1
Submit Answer
Assume Baldwin is producing 600 units of Boat next year. What would Boat's plant utilization be?
Select : 1
Submit Answer
[SOLVED]Chester's balance sheet has $73,467,000 in equity.
Chester's balance sheet has $73,467,000 in equity. Next year they expect Assets to increase by $4,000,000 and Liabilities to decrease by $2,000,000. If that happens, what will be Chester's book value?
Select : 1
Submit Answer
[SOLVED]Which company has the least efficient SG&A/Sales ratio?
Which company has the least efficient SG&A/Sales ratio?
Select : 1
Submit Answer
[SOLVED] Currently Baldwin is paying a dividend of $13.14 (per share).
Currently Baldwin is paying a dividend of $13.14 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?
Select : 1
Submit Answer
Chester Corp. is downsizing the size of their workforce by 10% (to the nearest person) next year from various strategic initiatives. How much will the company pay in separation costs if each worker receives $5,000 when separated?
Select : 1
Submit Answer
In the Month of March, Chester Corporation received orders of 153 units at a price of $15.00 for their product Clack. Chester uses the accrual method of accounting and offers 30 day credit terms. Chester delivers 102 units in March and the balance of 51 units in April. They received payment for 51 units in March, 51 units in April, and 51 units in May. How much revenue is recognized on the March income statement from this order? How much in the April Income statement? (Answer in thousands)
Select : 1
Submit Answer
[SOLVED] Your Competitive Intelligence team is predicting that the Chester Company
Your Competitive Intelligence team is predicting that the Chester Company will invest in adding capacity to their Cure product this year. Assume Chester's product Cure 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
Submit Answer
A productivity index of 110% means that
A productivity index of 110% means that a company’s labor costs would have been 10% higher if it had not made production improvements. Assume that Baldwin had a productivity index of 112% and that Chester had a productivity index of 103%. Now refer to the Income Statements in the Annual Report for Baldwin and Chester. Using the labor costs shown in the Income Statements, how much more did Baldwin save in direct labor costs compared to Chester by having a higher productivity index?
Select: 1
$3,340
$3,499
$3,181
$2,863
I am in need of some one to take my COMP-XM examination for me
I am in need of some one to take my COMP-XM examination for me
[SOLVED] example of company performance analysis. select
[SOLVED] example of company performance analysis. select two companies and compare their financial structures including WACC, book value, and market value.
United States steel is a steel production company located in Pittsburgh, Pennsylvania. The company was founded in 1901. The company area of operation includes the USA and central Europe. The company generated revenue of 10 billion in 2016 financial year. Facebook, on the other hand, is a social media platform founded in 2004. The company is based in Menlo Park California. The company generated a revenue of 27 billion 2016 financial year. These companies operate in different industries. Therefore, the underlying conditions that influence the earning of companies may be totally different. Besides, their assets and expenses are totally different. A company like Facebook invest most on research and development while a company like US steel invest heavily on plant and equipment.
United States steel (X) have 176,000,000 outstanding shares while Facebook have 2,930,000,000 outstanding shares. The price per share for United States steel (X) is 35.48 USD and for Facebook (FB) is 161.89 USD. Therefore, the value of United States Steel (X) is 6,244,480,000 USD and for Facebook (FB) is 474,337,700,000 USD (Yahoo, 2019). The book value of the company is calculated by taking the total asset value less total liability. Therefore the book value of each company is as calculated below
[SOLVED] UMGC Data 620 Assignment 7.2Your name:
[SOLVED] UMGC Data 620 Assignment 7.2
Your name:
Date:
Each student runs the Python development environment Jupyter Notebook! Using the browser from the computer, prints “hello world” and writes a Celsius to Fahrenheit converter.
Turn in separate document(s) with the following items. Please label each with the TURN IN # statement so we can easily follow it.
Deliverable
Description
Points
TURN IN #1
Turn in a screen shot of your successful editor Jupyter Notebook.
1
TURN IN #2
Turn in screen shot(s) showing “hello world” program execution with your name as the input string.
1
(You can put TURN IN #1 and TURN IN #2 in the same Word document.)
TURN IN #3
Your Python code to perform a Celsius to Fahrenheit conversion. Name your python file “XXXX-temp.ipynb” where XXXX is your name. Your deliverable here is just the Python notebook; you don’t need to include screen shots. (Note there is a Rubric for Python programs (located also in this week’s materials) for how we will grade this.)
8
TOTAL
10
The following walkthrough exercises from “Python for Everybody – Exploring Data Using Python 3” by Charles R. Severance are included here:
Chapter 1: Exercises 5, 7, 9
Chapter 2: Exercises 2, 3, 4
You are encouraged to walk through these exercises. To do this, you should type the commands into your computer and make sure they give the same results as here.
Browsing the Python Jupyter IDLE (Integrated Development Environment), writing and running a program:
Try Jupyter out without installing anything.
Step 1:
Go to Jupter
Sometimes the screen will look slightly different, like this below. In that case, you need to “Try Classic Notebook”
You will get binder starting Python IDE (give it some seconds), then you will see this screen below:
Step 2:
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 Entity Integrity Constraints (2 minutes)
· Caleb the Video Maker 2, “MySQL Lecture Series,” specifically:
o MySQL 11 - Entity Integrity
o MySQL 12 - Referential Integrity
o MySQL 13 - Domain Integrity
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): Primary Key
o (We skip his MySQL 15 - Auto Increment; you can certainly watch if you want to.)
o MySQL 16 - Foreign Key: Foreign Key
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%
