Posts

Create a projec2on to determine the gross margin, opera2ng expenses, and opera2ng income for the six-month period December through April based on projected sales during that 6-month period.

Financial Projection

Overview
You are the Assistant Director of Finance in the Accoun2ng department at a subsidiary of the Crazy Eddies Electronic Corpora2on; Nu?y John’s Appliance World (owned by his brother John). You need to create a projec2on to determine the gross margin, opera2ng expenses, and opera2ng income for the six-month period December through April based on projected sales during that 6-month period. The Director of Accoun2ng has provided you with the template as shown in Figure-1.

  • In Part 1 you will create the worksheet.
  • In Part 2 you will create a 3-D Bar chart and move it to a new sheet from the data.

Instruc@ons Part 1: To create the worksheet in Figure-1, do the following:

1. Format the worksheet 2tle in cell A1 to 28-point. Merge and Center across the range: A1:H1. Add a light blue background

2. Format the worksheet sub2tle in cell A2 to 16-point. Merge and Center across the range: A1:H1. Add a light blue background

3. Place a thick black border around the range A1:A2

4. Format the range B3:H3 as follows
a.
Center each month in its cell

b.
Change the font size to 11

c.
Rotate the contents of each cell in the range B3:H3 angle counter clockwise

5. Enter the following formulas (using absolute cell referencing where appropriate) in column B: (Note: Commission, Marke@ng, Research and Support, General and Administra@ve expenses are calculated as a % of each month’s sales using the values in the What-If-Assump@ons table.
a.
B5: Calculate the Cost of Goods Sold for December using the formula: Sales x (1 – Margin). Copy the formula across the range C5:G5

b.
B6: Calculate the Gross Margin for December. Copy the formula across the range C6:G6.

c.
B9: Insert an IF func2on to calculate a Bonus in any month where sales exceed the sales target for bonus ($23,750,000). Copy the formula across the range C9:G9

d.
B10: Calculate the December Commission expense. Copy the formula across the range C10:G10

e.
B11: Calculate the December Marke@ng. Copy the formula across the range C11:G11

f.
B12: Calculate the December Research expenses. Copy the formula across the range C12:G12

g.
B13: Calculate the December Support, General, and Administra@ve. Copy the formula through the range C13:G13

h. B14: Calculate the Total Expenses for December. Calculate the formula across the range C14:G14
i.
B16: Calculate the Opera@ng Income for December. Copy the formula across the range C16:G16

j.
H4: Calculate the Total Sales for the 6-month period.

k.
H5: Calculate the Total Cost of Goods Sold for the 6-month period.

l.
H6: Calculate the Total Gross Margin for the 6-month period.

m.
H9:H13: Calculate the Total for each Expense Category for the 6-month period.

n.
H14: Calculate the The Total Expenses for the 6-month period.

o.
H16: Calculate the Total Opera@ng Income for the 6-month period.

p.
Ensure that all column widths are wide enough so that ###### is not displaying

6. B5:H16 format as currency style with no decimal places and with nega2ve numbers enclosed in parentheses.

7. Add bo?om borders to the ranges B5:H5 and B13:H13.

8. Name the Sheet1 tab: “6th Month Financial Projec2on”. Change its color to Blue.

9. Set the worksheet to print in landscape orienta2on, fit to one page.

10. Add a Header as follows
a.
Leh Header Box: Page #

b.
Middle Header Box: You Name. Apply bold

c.
Right Header: Date and Time

11. Upload assignment into Brightspace

After making a diagnosis, identify and discuss possible causes and assessment for confirming the diagnosis. Review the handout on the Multidimensional Model of Mental Health. Discuss in detail.

PSYCHOLOGY 336: ABNORMAL PSYCHOLOGY

Outline for the Diagnostic Case Write-Ups

  • https://www.studypool.com/questions/download?id=2772035&path=uploads/questions/1765420/20230313194632sample_of_diagnostic_case.pdf&fileDownloadName=attachment_3

Your diagnostic write-up will consist of the following sections:

1. Summarize the presenting DSM 5 disorder(s) based on the case.

a. What is the individual’s background (gender, ethnicity, socioeconomic class, etc.,)?
b. What are your diagnostic impressions (diagnosis) for the case?
c. What are the symptoms and DSM 5 criteria supporting your diagnoses?

2. Additional Factors

After making a diagnosis, identify and discuss possible causes and assessment for confirming the diagnosis. Review the handout on the Multidimensional Model of Mental Health. Discuss in detail.
a. What are plausible psychological/ cognitive causes for the case?
b. What are potential biological/ medical factors?
c. What are probable social/ environmental influences?
d. What two (2) specific psychological tests would you use to clarify or confirm your diagnosis?

Explain in your own words what each key element in the digital helix means. There are 7 elements in total. You must write 50-100 words per each element to receive maximum points. Give examples of brands that are doing well in that category to enhance your answers.

The 7 Elements Of The Digital Helix

1) Read Part 3 of The Digital Helix.

2) Explain in your own words what each key element in the digital helix means. There are 7 elements in total. You must write 50-100 words per each element to receive maximum points. Give examples of brands that are doing well in that category to enhance your answers.

Draft a 5- to 7-page essay (excluding the bibliography) on that topic, using a minimum of two scholarly, peer-reviewed sources in addition to any of the readings for class you may choose to use.

African Studies Question

Draft a 5- to 7-page essay (excluding the bibliography) on that topic, using a minimum of two scholarly, peer-reviewed sources in addition to any of the readings for class you may choose to use.

Provide some specific examples of how the religious landscape of the United States has been changing in recent years.

Diverse Learning

Provide some specific examples of how the religious landscape of the United States has been changing in recent years.

Support your response with evidence from the text.

Browse the Internet and select a picture of a magazine cover of your choice and save it. Create a new blank Photoshop document and save it as your last name_magazine cover.

Photoshop task

Task 1.

Type and Color Project Instructions:

Imagine that you are featured on a cover of a famous magazine. You can pick any topic of your choice for the headline on the magazine cover but it should allude to why you are featured on that specific magazine’s cover. For instance, if you are featured on Time magazine, the headline for the article might allude to the great humanitarian projects you have provided to the community/world or if you are featured on Home magazine, a headline might have a tagline that references your home decorating ideas. Overall, you will edit text and a photo using the color and type tools in Photoshop as well as other selection and alterations tools to depict that you really are featured on a well-known magazine cover.

1) Browse the Internet and select a picture of a magazine cover of your choice and save it.

2) Create a new blank Photoshop document and save it as your last name_magazine cover. Set the color mode for a print project. (CMYK)

3) Duplicate the magazine cover as close as you can. You may choose to mask the title if you can’t duplicate the font for the Magazine’s name; however, create texts that mimic the other fonts as close to the original as you can for all other headlines featured on the cover.

4) Place your image on the cover. Use the selection tools to edit and fix the image. Apply color correction options, like tone and hue and other image adjustments of your choice to mimic the correct color tone of the magazine.

3) Make sure to include at least 4 layers in your project and pay attention to order of the text and image on the cover; some text might be behind another text layer or image and also how the typography is formatted in terms of size, typeface, and style.

4) Save your Photoshop document and save a copy of the final image as a jpg and upload both the original and final jpg to Canvas.

 Sample of a final magazine cover

 

 

Task 2

Blending and Filters Project Instructions:

Start with a photo or drawing that is your own photo or drawing.  The photo/drawing can be of a person, place, or thing as long as it is your own image.

You will create at least 6 layers. Keep the original image object on the bottom layer and apply the following filter effects to all other layers.

  1. Original Picture without Filters.
  2. Duplicate the original image layer and apply Artistic Filter Effects (colored pencil, cutout, fresco, palette knife, etc.)
  3. Duplicate the original image layer and apply Blur Filter (motion, gaussian, lens, radial, etc.)
  4. Duplicate the original image layer and apply Distort Filter (displaced, pinch, shear, ripple, twirl, etc.)
  5. Duplicate the original image layer and apply Noise Filters (add noise, despeckle, dust & scratch, etc.)
  6. Duplicate the original image layer and apply Stylized Filters (diffuse, emboss, extrude, solarize, etc.)
  7. Duplicate the original image layer and apply other Filters of your choice (render, pixelate, sharpen, etc.)
  8. Apply a Blending mode (like Multiply) of your choice to any layer.
  9. Apply a Blending mode of your choice to another layer.
  10. Rearrange the images on your Canvas (if you need to) so that all your layer images don’t overlap so that parts of the applied filters show through the final composite image.  I should be able to discern at a glance that all 6 applied filters are applied to the document. Save the document as Jamali_blending-filters and then resave it as a jpeg and send it to me both the Photoshop document and jpg.

Sample Filters File

 

 

Task 3

Selection and Masking Project Instructions:

Pretend you have to edit a scene in a movie using Photoshop’s selection and masking options to accomplish this task. You will probably need to also apply some color correction tools, alteration tools like the healing brush, clone stamp or transform tools and brushes to create a cohesive scene.

Choose a scene from any movie and add and delete objects and/or type to that scene using various layers (at least a minimum of 2), selection and masking tools. You may choose any scene from an internet search but try to keep the image resolution low so that the image is only viewed on screen.

  1. Select a movie scene image from the Internet, save it and import it to a new Photoshop document.
  2. Save the Photoshop document filename as your last name_movie scene.
  3. Insert at least two items to the scene using masking tools (make sure to apply a new layer).
  4. Delete at least two items from the scene using selection tools and transform or clone/ tools to fix the space where the deleted items were placed (or you can insert the new items here).
  5. Make any other corrections you would like to any selected area of this movie scene (like color and lighting or more creative adjustments like adding text to a blank mug or a person’s shirt in the scene and have it look like it is really part of the scene).
  6. Save your final Photoshop document and export as a jpg with the same name and upload only the final jpg and the original saved movie scene to this assignment window on Canvas.

Note: Please make sure that the adjustments you’ve made with objects/texts seem like it belongs in the scene. So if you are doing a cartoon movie, you should have similar cartoon graphics placed in the scene, etc.

See a couple of samples below of the original movie scene and the final edited scene from the Harry Potter movies.  Can you spot the deletions in the first example and the additions in the second example?

 

Consider your favorite books, movies, works of art, etc. Compare or Contrast which of these have influenced or your Life in a meaningful way.

Compare two books or two movies

Consider your favorite books, movies, works of art, etc. Compare or Contrast which of these have influenced or your Life in a meaningful way.


In the past 20 years how has child abuse been more common? 
How has child abuse and neglect affected childhood?
 What mechanisms can help abused children to help manage from the aftermath of trauma?

Childhood trauma

Research Q’s :
In the past 20 years how has child abuse been more common?
How has child abuse and neglect affected childhood?
What mechanisms can help abused children to help manage from the aftermath of trauma?
How can children be protected from neglect and abuse?
What is the population of abused children in the United States and in the world?
What is the percentage of abused children have trauma in their later years as adults?

What is the patient’s medical problem? Is the problem acute? Chronic? Critical? Reversible? Emergent? Terminal? What are the goals of treatment? In what circumstances are medical treatments not indicated?

Nursing Question

Consider the “Four Topics Approach” (or Four Box method) to ethical decision making on page 61, Table 2.1 in Butts (below). Apply this model to a challenging situation in your nursing career that required you to consider the ethical dimensions of the patient case and the role you played in providing care. Specifically apply and address the questions within each topic area as they pertain to your situation.

In your conclusion, discuss the impact of the Four Topics process. Did applying these principles shape your decision making in any way? Does this seem like a valid process for you to apply in your practice?

Your paper should be 1-2 pages. Adhere to APA formatting throughout, and cite any outside sources you may use.

Review the rubric for further information on how your assignment will be graded.

TABLE 2-1 Four Topics Method for Analysis of Clinical Ethics Cases

Medical Indications: The Principles of Beneficence and Nonmaleficence
1. What is the patient’s medical problem? Is the problem acute? Chronic? Critical? Reversible? Emergent? Terminal?

2. What are the goals of treatment?

3. In what circumstances are medical treatments not indicated?

4. What are the probabilities of success of various treatment options?

5. In sum, how can this patient be benefited by medical and nursing care, and how can harm be avoided?

Patient Preferences: The Principle of Respect for Autonomy
1. Has the patient been informed of benefits and risks, understood this information, and given consent?

2. Is the patient mentally capable and legally competent, and is there evidence of incapacity?

3. If mentally capable, what preferences about treatment is the patient stating?

4. If incapacitated, has the patient expressed prior preferences?

5. Who is the appropriate surrogate to make decisions for the incapacitated patient?

6. Is the patient unwilling or unable to cooperate with medical treatment? If so, why?

Quality of Life: The Principles of Beneficence and Nonmaleficence and Respect for Autonomy
1. What are the prospects, with or without treatment, for a return to normal life, and what physical, mental, and social deficits might the patient experience even if treatment succeeds?

2. On what grounds can anyone judge that some quality of life would be undesirable for a patient who cannot make or express such a judgment?

3. Are there biases that might prejudice the provider’s evaluation of the patient’s quality of life?

4. What ethical issues arise concerning improving or enhancing a patient’s quality of life?

5. Do quality-of-life assessments raise any questions regarding changes in treatment plans, such as forgoing life-sustaining treatment?

6. What are plans and rationale to forgo life-sustaining treatment?

7. What is the legal and ethical status of suicide?

Contextual Features: The Principles of Justice and Fairness
1. Are there professional, interprofessional, or business interests that might create conflicts of interest in the clinical treatment of patients?

2. Are there parties other than clinicians and patients, such as family members, who have an interest in clinical decisions?

3. What are the limits imposed on patient confidentiality by the legitimate interests of third parties?

4. Are there financial factors that create conflicts of interest in clinical decisions?

5. Are there problems of allocation of scarce health resources that might affect clinical decisions?

6. Are there religious issues that might influence clinical decisions?

7. What are the legal issues that might affect clinical decisions?

8. Are there considerations of clinical research and education that might affect clinical decisions?

9. Are there issues of public health and safety that affect clinical decisions?

10. Are there conflicts of interest within institutions and organizations (e.g., hospitals) that may affect clinical decisions and patient welfare?

Describe what caused the problem, who were involved, what were others’ and your roles in the situation, and if a resolution was reached.

Sociology Question

1. Introduction: In this first content area, write a paragraph introducing C. W. Mills’s concept of sociological imagination, and give a general overview of how you will be applying it to the personal situation that you will discuss in your paper.

2. Personal Explanation: In this second content area, describe your personal situation/topic. Based on whether the situation is a current one or a past one, describe how you dealt or are dealing with it. You can also pick a situation from a person’s life who is closely related to you or whose experience affected you. You should know the person well enough to write the essay.

Describe what caused the problem, who were involved, what were others’ and your roles in the situation, and if a resolution was reached. This section is all about your account of your situation and should be no longer than four paragraphs (3/4 – 1 page).

3. Sociological Imagination: In this third content area, analyze your personal situation by applying sociological imagination, i.e., examine how society and social forces affected your situation. This section should be the most substantial portion of your essay. You should use terms and concepts from at least 3 different chapters from the textbook, and one sociological theory.

4. Data/Stats: Utilize at least 2 statistics or research studies from the textbook or outside sources such as the Galen College online library. The references should be scholarly and should be relevant to your situation (E.g., Inclusion of divorce rates in the US if the topic is on Divorce; inclusion of poverty rates, crime and victimization rates, or suicide rates if the topic is either on Poverty or Crime). Citing at least one outside source is required.

5. Conclusion: Write a wrap-up conclusion summarizing the major finding/themes in your paper. This should be no more than a paragraph.