Economic Analysis Skills

/in /by

Economic Analysis Skills

https://geniusproessays.com/

Economic Analysis Skills:

follow the pdf step and answer the questions.

Note:

  • The following changes have been made to question 2a
    • Plot the relationship between agricultural commodity prices (Farm Product Price Index) & retail food prices (Food CPI). Do this for Jan 2020 through to July March 2022.

    Please submit the following:

  1. Your typed answers as a PDF file
  2. Your completed excel file

Qn 1Need some Excel skills and need economic analysis skills

Data Sources
Wheat Prices: World Bank Commodities Price Data (The Pink Sheet) https://www.worldbank.org/en/research/commodity-markets
Canadian Inflation Rate: Bank of Canada https://www.bankofcanada.ca/rates/price-indexes/cpi/
Period Wheat, US HRW ($/mt) Canadian Inflation Rates Example
2015-Jan 248 1.0%
2015-Feb 237 1.0%
2015-Mar 231 1.2%
2015-Apr 223 0.8%
2015-May 215 0.9%
2015-Jun 210 1.0%
2015-Jul 197 1.3%
2015-Aug 180 1.3%
2015-Sep 173 1.0%
2015-Oct 173 1.0%
2015-Nov 177 1.4%
2015-Dec 189 1.6%
2016-Jan 193 2.0%
2016-Feb 187 1.4%
2016-Mar 191 1.3%
2016-Apr 187 1.7%
2016-May 172 1.5% Answer
2016-Jun 173 1.5%
2016-Jul 152 1.3%
2016-Aug 149 1.1%
2016-Sep 151 1.3%
2016-Oct 152 1.5%
2016-Nov 151 1.2%
2016-Dec 142 1.5%
2017-Jan 153 2.1%
2017-Feb 155 2.0%
2017-Mar 154 1.6%
2017-Apr 166 1.6%
2017-May 180 1.3%
2017-Jun 190 1.0%
2017-Jul 202 1.2%
2017-Aug 171 1.4%
2017-Sep 179 1.6%
2017-Oct 176 1.4%
2017-Nov 180 2.1%
2017-Dec 184 1.9%
2018-Jan 192 1.7%
2018-Feb 192 2.2%
2018-Mar 192 2.3%
2018-Apr 214 2.2%
2018-May 214 2.2%
2018-Jun 219 2.5%
2018-Jul 218 3.0%
2018-Aug 237 2.8%
2018-Sep 212 2.2%
2018-Oct 213 2.4%
2018-Nov 204 1.7%
2018-Dec 211 2.0%
2019-Jan 210 1.4%
2019-Feb 219 1.5%
2019-Mar 206 1.9%
2019-Apr 200 2.0%
2019-May 200 2.4%
2019-Jun 206 2.0%
2019-Jul 196 2.0%
2019-Aug 181 1.9%
2019-Sep 190 1.9%
2019-Oct 200 1.9%
2019-Nov 203 2.2%
2019-Dec 211 2.2%
2020-Jan 225 2.4%
2020-Feb 215 2.2%
2020-Mar 209 0.9%
2020-Apr 219 -0.2%
2020-May 206 -0.4%
2020-Jun 198 0.7%
2020-Jul 222 0.1%
2020-Aug 223 0.1%
2020-Sep 248 0.5%
2020-Oct 272 0.7%
2020-Nov 273 1.0%
2020-Dec 269 0.7%
2021-Jan 289 1.0%
2021-Feb 289 1.1%
2021-Mar 273 2.2%
2021-Apr 281 3.4%
2021-May 297 3.6%
2021-Jun 286 3.1%
2021-Jul 294 3.7%
2021-Aug 325 4.1%
2021-Sep 338 4.4%
2021-Oct 355 4.7%
2021-Nov 379 4.7%
2021-Dec 377 4.8%
2022-Jan 374 5.1%
2022-Feb 391 5.7%
2022-Mar 486 6.7%
2022-Apr 495 6.8%
2022-May 522 7.7%
2022-Jun 460 8.1%
2022-Jul 383 7.6%

Qn 2; Need some Excel skills and need economic analysis skills

Data Sources
Statistics Canada. Table 32-10-0098-01  Farm product price index (FPPI), monthly https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3210009801
Statistics Canada. Table 18-10-0004-01  Consumer Price Index, monthly, not seasonally adjusted https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000401
Date Farm Product Price Index Food CPI
Jan-20 132.4 153.5 Question 2a)
Feb-20 132.4 152.9
Mar-20 132.7 152.8
Apr-20 130.5 154
May-20 134.5 154.3
Jun-20 133 154.8
Jul-20 132.5 155
Aug-20 132.9 153.8
Sep-20 134.3 152.6
Oct-20 137.3 153.3
Nov-20 138.2 153.9
Dec-20 139.5 153.6
Jan-21 143 155
Feb-21 147.9 155.6
Mar-21 153.1 155.5
Apr-21 158.5 155.4 Question 2bi)
May-21 158.6 156.6
Jun-21 164.4 156.8
Jul-21 167.5 157.6
Aug-21 163.8 158
Sep-21 167 158.5
Oct-21 167.4 159.2
Nov-21 173.6 160.7
Dec-21 175.7 161.6
Jan-22 185.7 163.9
Feb-22 195.3 166
Mar-22 201.4 167.5

Qn 3a; Need some Excel skills and need economic analysis skills

Data Sources
Statistics Canada. Table 32-10-0098-01  Farm product price index (FPPI), monthly https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3210009801
Statistics Canada. Table 18-10-0004-01  Consumer Price Index, monthly, not seasonally adjusted https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810000401
Date Farm Product Price Index Food CPI Quarterly Food Product Price Index Quarterly Food CPI Period
1/1/00 85.4 92.1
2/1/00 86.7 91.9
3/1/00 88.3 92.3 86.80 92.10 Quarter
4/1/00 90 92.5
5/1/00 89.9 93.2
6/1/00 88.4 93.8 89.43 93.17 Quarter
7/1/00 87 94.3
8/1/00 87.6 94
9/1/00 86.8 93.3
10/1/00 87.1 93.1
11/1/00 87.7 93.9
12/1/00 89.1 95.1
1/1/01 88.4 95.3
2/1/01 91.4 96.1
3/1/01 94.4 96.9
4/1/01 94 97.2
5/1/01 94.2 98
6/1/01 94.4 98.2
7/1/01 94.4 98.6
8/1/01 96.1 97.9
9/1/01 97.3 97.2
10/1/01 95.7 97
11/1/01 95.4 97.5
12/1/01 95.2 98.6
1/1/02 97.5 99.7
2/1/02 99.7 100.3
3/1/02 99.1 100.1
4/1/02 96.8 100.5
5/1/02 96.9 100.1
6/1/02 96.5 100.5
7/1/02 99.1 100.5
8/1/02 98.7 99.9
9/1/02 96.7 99
10/1/02 98.8 98.5
11/1/02 98.6 100.1
12/1/02 98.8 100.8
1/1/03 101.3 101.6
2/1/03 102.8 101.5
3/1/03 101.1 101.7
4/1/03 100.4 101.8
5/1/03 100.4 102.1
6/1/03 94.3 102.4
7/1/03 87.8 102.4
8/1/03 86.6 101.5
9/1/03 89 100.8
10/1/03 89.7 100.7
11/1/03 90 101.7
12/1/03 89.5 102.6
1/1/04 89.6 102.8
2/1/04 90.1 102.6
3/1/04 93.3 102.7
4/1/04 94 102.5
5/1/04 95.8 103.4
6/1/04 95.9 104.4
7/1/04 94 104.4
8/1/04 94.6 104.1
9/1/04 91.9 103.7
10/1/04 89.2 104.2
11/1/04 86.7 105.2
12/1/04 88.5 105.7
1/1/05 89.2 105.4
2/1/05 91.1 105.2
3/1/05 88.8 105.6
4/1/05 87.8 106.6
5/1/05 88.2 106.8
6/1/05 87.7 107.2
7/1/05 87.9 106.9
8/1/05 92.1 106.8
9/1/05 89.6 105.8
10/1/05 88.9 106.2
11/1/05 87.2 106.7
12/1/05 88.1 107.5
1/1/06 87.6 108.4
2/1/06 87.5 108.2
3/1/06 87.7 108.2
4/1/06 87.3 108.1
5/1/06 88.6 108.7
6/1/06 89.6 109.2
7/1/06 89.4 109.2
8/1/06 92.8 109.2
9/1/06 92.1 108.8
10/1/06 90.6 109.2
11/1/06 91.5 110.1
12/1/06 91.8 109.9
1/1/07 93.1 110.9
2/1/07 96 112.6
3/1/07 97.9 112.2
4/1/07 98 112.2
5/1/07 98 112.5
6/1/07 97.6 112.6
7/1/07 96.9 112.3
8/1/07 103.7 111.8
9/1/07 106.2 110.9
10/1/07 104.2 110.7
11/1/07 105 111.3
12/1/07 104.1 111.7
1/1/08 104.8 112.4
2/1/08 109.2 112.8
3/1/08 110.3 112.6
4/1/08 112.4 113.5
5/1/08 115.2 114.6
6/1/08 118.8 115.8
7/1/08 120.5 116.5
8/1/08 116.3 116.8
9/1/08 113.4 117.1
10/1/08 113.5 117.4
11/1/08 112.2 119.5
12/1/08 110.1 119.8
1/1/09 108.6 120.6
2/1/09 109.5 121.2
3/1/09 110.8 121.5
4/1/09 110.9 121.6
5/1/09 110.7 121.9
6/1/09 108.9 122.2
7/1/09 107.5 122.3
8/1/09 104.1 121.5
9/1/09 99 120.4
10/1/09 97.4 120.1
11/1/09 96.6 121.5
12/1/09 100.2 121.8
1/1/10 100 122.3
2/1/10 100.7 122.7
3/1/10 100.6 123.1
4/1/10 101.4 122.8
5/1/10 104 122.9
6/1/10 101.9 123
7/1/10 102.6 123.7
8/1/10 109 123.5
9/1/10 109.6 122.9
10/1/10 108.4 122.7
11/1/10 107.9 123.3
12/1/10 110 123.9
1/1/11 113.7 124.9
2/1/11 117.3 125.3
3/1/11 120.2 127.2
4/1/11 121.7 126.9
5/1/11 119.2 127.7
6/1/11 120.1 128.3
7/1/11 121.4 129
8/1/11 124 128.9
9/1/11 123.8 128.2
10/1/11 124.2 128
11/1/11 124.7 129.2
12/1/11 123.5 129.3
1/1/12 124.6 130.2
2/1/12 125.8 130.4
3/1/12 126 130
4/1/12 124.3 130.1
5/1/12 124.2 130.9
6/1/12 126.1 130.9
7/1/12 127.6 131.7
8/1/12 127.4 131.7
9/1/12 126.2 130.3
10/1/12 127.7 130.5
11/1/12 129.3 131.4
12/1/12 129.7 131.2
1/1/13 130.6 131.6
2/1/13 132.6 132.9
3/1/13 132.5 132.4
4/1/13 132.6 132.1
5/1/13 134.7 132.6
6/1/13 136.5 132.5
7/1/13 133.1 132.7
8/1/13 129.5 133
9/1/13 125.5 131.9
10/1/13 124.6 131.7
11/1/13 121.5 132.8
12/1/13 121.7 132.5
1/1/14 121.5 133
2/1/14 122.3 134.3
3/1/14 128.8 134.4
4/1/14 132 134.6
5/1/14 131.9 135.7
6/1/14 131.3 136.4
7/1/14 131.3 136.5
8/1/14 135.3 135.9
9/1/14 130.7 135.5
10/1/14 132.5 135.4
11/1/14 131.9 136.9
12/1/14 133.4 137.4
1/1/15 134.2 139.1
2/1/15 136 139.5
3/1/15 136.4 139.5
4/1/15 137.6 139.4
5/1/15 138 140.8
6/1/15 137.6 141
7/1/15 138.3 140.9
8/1/15 139.5 140.8
9/1/15 138.8 140.3
10/1/15 135 140.9
11/1/15 133 141.6
12/1/15 131.6 142.5
1/1/16 134.3 144.6
2/1/16 134.9 145
3/1/16 135.6 144.5
4/1/16 133.7 143.8
5/1/16 136.4 143.3
6/1/16 137.1 142.8
7/1/16 133 143.2
8/1/16 127.8 142.3
9/1/16 124.7 140.4
10/1/16 124.5 139.9
11/1/16 125.1 140.6
12/1/16 128.8 140.6
1/1/17 129.5 141.5
2/1/17 130.8 141.7
3/1/17 132.6 141.8
4/1/17 132.1 142.2
5/1/17 135.2 143.1
6/1/17 136.2 143.6
7/1/17 136.2 144.1
8/1/17 132.8 143.6
9/1/17 128.6 142.4
10/1/17 128.5 141.7
11/1/17 130.2 142.9
12/1/17 129.1 143.4
1/1/18 129.7 144.7
2/1/18 129.9 144.7
3/1/18 130.6 144.2
4/1/18 129.5 144.8
5/1/18 131.2 144.6
6/1/18 132.8 145.6
7/1/18 133.6 146.1
8/1/18 130.1 145.9
9/1/18 128.1 144.9
10/1/18 129.4 144.6
11/1/18 128.4 146.1
12/1/18 127.8 147.5
1/1/19 130 148.7
2/1/19 129.9 149.3
3/1/19 132 149.4
4/1/19 135.2 149
5/1/19 135.2 149.7
6/1/19 133.5 150.7
7/1/19 131.6 151.6
8/1/19 132.8 151.1
9/1/19 127.6 150.2
10/1/19 128.8 149.9
11/1/19 129.2 151.1
12/1/19 130.4 151.9
1/1/20 132.4 153.5
2/1/20 132.4 152.9
3/1/20 132.7 152.8
4/1/20 130.5 154
5/1/20 134.5 154.3
6/1/20 133 154.8
7/1/20 132.5 155
8/1/20 132.9 153.8
9/1/20 134.3 152.6
10/1/20 137.3 153.3
11/1/20 138.2 153.9
12/1/20 139.5 153.6
1/1/21 143 155
2/1/21 147.9 155.6
3/1/21 153.1 155.5
4/1/21 158.5 155.4
5/1/21 158.6 156.6
6/1/21 164.4 156.8
7/1/21 167.5 157.6
8/1/21 163.8 158
9/1/21 167 158.5
10/1/21 167.4 159.2
11/1/21 173.6 160.7
12/1/21 175.7 161.6
1/1/22 185.7 163.9
2/1/22 195.3 166
3/1/22 201.4 167.5

Notes: The quarterly series will consist of 3-month averages. • Q1 (The first quarter) will be the average value of Jan, Feb, Mar • Q2, the average of Apr, May, Jun • Q3, the average of Jul, Aug, Sep • Q4, the average of Oct, Nov, Dec Tips (one of several methods): 1)Use a formula in column G to identify the end of a quarter 2) Filter by Period, “Quarter” 3) Copy quarterly data and paste as values into the Qn 3b & c sheet

Qn 3b & c

Plot these over the period Q2-2000 to Q1-2022 Example
Period Quarterly Food Product Price Index Quarterly Food CPI Quarterly Percentage Change in Food Product Price Index Quarterly Percentage Change in Food CPI
Q1-2000 86.80 92.10
Q2-2000 89.43 93.17 3.03% 1.16%
Q3-2000
Q4-2000
Q1-2001
Q2-2001
Q3-2001
Q4-2001
Q1-2002
Q2-2002 Question 3c)
Q3-2002
Q4-2002
Q1-2003
Q2-2003
Q3-2003
Q4-2003
Q1-2004
Q2-2004
Q3-2004
Q4-2004
Q1-2005
Q2-2005
Q3-2005
Q4-2005
Q1-2006
Q2-2006
Q3-2006
Q4-2006
Q1-2007
Q2-2007
Q3-2007
Q4-2007
Q1-2008
Q2-2008
Q3-2008
Q4-2008
Q1-2009
Q2-2009
Q3-2009
Q4-2009
Q1-2010
Q2-2010
Q3-2010
Q4-2010
Q1-2011
Q2-2011
Q3-2011
Q4-2011
Q1-2012
Q2-2012
Q3-2012
Q4-2012
Q1-2013
Q2-2013
Q3-2013
Q4-2013
Q1-2014
Q2-2014
Q3-2014
Q4-2014
Q1-2015
Q2-2015
Q3-2015
Q4-2015
Q1-2016
Q2-2016
Q3-2016
Q4-2016
Q1-2017
Q2-2017
Q3-2017
Q4-2017
Q1-2018
Q2-2018
Q3-2018
Q4-2018
Q1-2019
Q2-2019
Q3-2019
Q4-2019
Q1-2020
Q2-2020
Q3-2020
Q4-2020
Q1-2021
Q2-2021
Q3-2021
Q4-2021
Q1-2022

image1.png

image2.png

Finance 300

/in /by

Finance 300

https://geniusproessays.com/

Finance 300: Finance 300

Assignment 2

Due Monday, Sep 19 Midnight, 5 minute grace period (12:05AM of Tuesday)

Submit via Canvas Assignments Dropbox

 

 

Assignment grades will be based on 50% completion and 50% accuracy. Please show all work, including cell references if you are using Excel.

 

 

Using the Excel File “MCD vs. WEN Annotated_v2” uploaded on Canvas, find the following variables in 2017 to 2021 for Wendy’s. All questions are worth 5 points each.

 

1. Find the Current Ratio

2. Find the Quick Ratio

3. Find the Cash Ratio

4. Describe the trend of the above ratios from 2017 ~ 2021

5. In 2021, which firm, in general, has more safety in terms of meeting obligations over the next 12 months?

 

6. Find the Total Debt ratio (use textbook definition debt = liabilities)

7. Find the Debt to Equity ratio (use textbook definition debt = liabilities)

8. Find the Equity Multiplier (use textbook definition debt = liabilities)

9. How is the debt situation looking like for Wendy’s in years 2017 ~ 2021?

10. In 2021, which firm is using more debt proportionally?

 

11. Find the Asset Turnover ratio

12. In 2021, which firm is using its assets more efficiently?

 

13. Find the Net Profit Margin

14. Find the ROA

15. Find the ROE

16. Describe the trend of the above ratios from 2017 ~ 2021

17. Which firm is more profitable?

18. Is the ROE meaningful in this case? If yes, describe what it measures. If no, describe why it’s not meaningful

 

19. What is the difference between market capitalization and enterprise value? What do each of these variables measure?

20. Go to Key Stats spreadsheet for each firm and scroll down to the current capitalization section. Which firm is larger? McDonald’s or Wendy’s? Why?

21. Bonus: Stay on the Key Stats spreadsheet and scroll all the way down to Valuation Multiples based on Current Capitalization. You should be able to find the P/E ratio for each firm in row 79. Which firm has a larger P/E ratio in 2021 (1 pt)? Explain one potential reason why this company would have a larger P/E ratio (4 pts).

Advertising

/in /by

Advertising

https://geniusproessays.com/

Advertising: Just write a reply to these two posts. Write in your own words. One paragraph for each post. Please differentiate which reply is which.

Reply A Grant

I think the kind of advertising that I fall for most is the false dilemma type. Like with shampoo. They tell us that we need to wash all of the nasty gunk and dirt out of our hair. Then next thing you know you shouldn’t wash your hair as often because it’s actually bad for you.  It will dry out your hair. I find that I get trapped when I know i didn’t really have a problem before and an ad makes me think oh now I do have a problem. What do ya know the only solution to that problem is their product.

I think about the Dr. Squatch commercials when I think about ads that I fall for most. My deodorant works just fine but they make me think there is something wrong with it. It works really well on me. I go on rants looking at the ingredients on all of the stuff I get now. I don’t use their products, but they have made me look at the stuff I use on my body completely differently than I used to. I am not on social media for that reason. I believe it isn’t good for you because places like Instagram can literally sell your information and most liked stuff to companies for them to run you specific ads. I am very easily swayed especially when it comes to food. Every time I see a big lighted up Taco Bueno sign, I pull in 80 percent of the time.

 

Reply B Daizie

Advertising is something I see everyday. I am active on social media and I check my accounts  consistently throughout the day. I fall most for advertisements about clothes or accessories. I already have a passion for clothes and making outfits so it is hard to look past the ads. Personally I tend to be more convinced with videos instead of pictures. For example, I will scroll on tik tok and see videos of someone unboxing new shoes and people will comment and say things like “i just bought these” or “I have these and wear them everyday”. I think I fall for it because I am seeing an actual person wear the item which gives me a better idea of how it would look on me. Just the other day I saw a video about this girl who bought Bluetooth headphones and she decorated them really cute, which then made me look on Amazon for some. I did end up buying them when I didn’t need them so I did fall for it haha.

 

I didn’t really think about advertisement until this forum. After thinking about the questions, I thought about past time’s time when I would go look at websites or online shop after seeing an ad. Now I am aware and know that my response to advertisement is impulse buying. I think once you have money of your own everything is appealing. Sometimes I know I don’t need something and will think to myself “well if you really wanted it you can get it”. I also believe the internet algorithm is also a huge advertisement. There have been times where I was specifically looking for something and then a few days later I will see ads about it. They pop up on Instagram the most for me. It’s kind of crazy how the internet knows exactly what your looking for.

 

Report to Your Supervisor

/in /by

Report to Your Supervisor

https://geniusproessays.com/

Report to Your Supervisor:

Writing Assignment #4 Report to Your Supervisor

 

Summary of the Assignment: • Task: In this assignment, you will write a short report to the owner of a company to which you

have just been hired.

• Length: 1200-1500 words, single-spaced

• Graphics: You must integrate at least one graphic

• Sources: You will integrate at least three sources into the report.

The Situation and Your Role In It You have been hired for the position of Manager for Customer Service at Lawn and Order Services, a

landscaping company.

Lawn and Order maintains a robust business in landscaping both residential and business properties. The

company has many clients in the local DC-Maryland-Virginia (DMV) area.

The landscaping staff that services residential and business properties comprises 75 individuals. In

addition, the company has several staff working in its office in Landover, Maryland. Included among

these office staff members is the IT Department, which consists of 10 employees.

The growth of the company has led to some problems that concern you as a new employee.

 

The History of Lawn and Order Services

Some history on the company will help to explain the problems Lawn and Order has now.

Lawn and Order started off in 2010 as a small outfit, owned and operated by Chris Taylor. Chris grew up

in Prince George’s County, Maryland. He graduated from high school and took a few courses at a local

community college. He never graduated from the community college but instead, after completing 18

credits, decided to leave school to start a landscaping business.

Chris started off the business with one truck, three lawn mowers, and a few helpers. He operated the

business out of his house. Eventually, as the number of clients grew, so did the number of trucks, lawn

mowers, and pieces of equipment. He added new employees to assist with the landscaping.

Chris eventually leased office space in Landover in order to have a more professional and scalable base

from which to operate the company. In addition, as the company grew and its office staff grew, so did the

technology and IT needs.

 

 

For the IT needs of the company, Chris took several steps. He hired a web developer, Sandra Davidson,

to develop a website for Lawn and Order. Sandra used WordPress as the platform. Chris later hired Jack

Johnson to develop and maintain a database of customers, past and present. The database includes

personal information on the customers, such as physical addresses, email addresses, and, for some, credit

card information.

Eventually, Chris hired a few more IT employees, all of whom persuaded Chris to put the company’s

database on the cloud instead of purchasing an expensive server to maintain in the office. Chris agreed.

The company then contracted with CloudSecure, a local cloud company.

The IT Department grew as the company grew. Marsha Nolton was later hired. She maintains the

company blog, also on WordPress, but with a different account from that of the website. The blog is an

effective marketing tool. It provides weekly updates on services, deals, and other information on the

company. In addition, other functions began to involve IT. Jared Stone was hired to run payroll for Lawn

and Order. With Jared’s input, the payroll information was put on the cloud. CloudSecure maintains all

payroll information on its servers.

Problems That Have Developed

Chris, in hiring the IT staff and organizing the department, was not privy to best practices in security in

the area of IT. As a result, some problems have developed.

For example, only Jack has access to the database of past and present clients. Jack logs into the system

with an ID and password that CloudSecure has provided him. This is not an ideal situation. If Jack were

to experience a medical emergency and become unavailable for a period of time, no one else at Lawn and

Order Services would have access to the database. If Jack were to leave the company, no one else at

Lawn and Order Services would be able to peform his duties. In addition, CloudSecure has a company

policy that forbids it to provide login or password information to anyone other than approved individuals.

The only approved individual now is Jack.

Morever, Sandra maintains the website through WordPress. She uses her personal email and password to

log into the system. But she is the only individual in the office who has access to or is able to update

anything on the website. Again, if anything were to happen to Sandra, Lawn and Order would be stuck.

No one else in the company can update its website.

Marsha manages the company’s blog, also on WordPress. The blog is an excellent marketing tool, with

weekly updates on services, deals, and other information on the company posted weekly. However,

Marsha is the sole maintainer of the blog. No one else at Lawn and Order has access to the blog to update

it.

Jared runs payroll. Like the others, he is the only individual with any access to the payroll records.

Because the records are also on CloudSecure, if something were to happen to Jack, no options are

available for anyone else in the company to access the payroll records.

Overall, Lawn and Order grew at a rapid pace. Chris Taylor applied excellent management skills in

growing the landscaping business. However, Chris needs help in establishing responsible IT personnel

policies for the company. Chris has no background in this area.

 

 

Chris is not aware of the problem the current arrangement poses.

 

Your Concern About the Situation

As a new hire at Lawn and Order, you have observed this situation, and you are concerned. The current

arrangement leaves the company in a very vulnerable situation if one of these individuals experiences a

medical emergency or has to leave the company for any reason.

In addition, the current arrangement poses a cybersecurity danger to the company. Any one individual, if

he or she is dissatisfied with the company or becomes disgruntled for any reason, can take advantage of

Lawn and Order and do great damage with the IT function the individual controls.

For example, personal data on customers resides with CloudSecure’s servers, which only Jack Johnson

can access. If Jack were to develop a toxic relationship with the company, Jack could use his sole access

to customer records and wreak havoc with them, possibly manipulating the company with his control or

simply compromising the privacy of the customers. Lawn and Order, not Jack, would be liable in such a

situation.

As Manager for Customer Service, you realize that many of the potential problems that could arise at

Lawn and Order will have an impact on your area. Customers will not have records updated, will not be

billed on time, will not receive blog updates, and will be impacted in other ways if any of the situations

described above occur.

Moreover, if customers’ records are compromised, you will have a customer service crisis on your hands.

 

 

 

 

 

 

 

 

Please turn to the next page.

 

 

Your Task You are to write a short report to Chris Taylor, the owner, and point out the problem with the

current personnel policies at Lawn and Order. You also want to suggest some basic steps the

company take take to address the situation before a problem arises.

Some concepts and strategies you might want to point out to Chris include the following:

• separation of duties

• mandatory vacations

• job rotation policies

• agreements with vendors, including password and other login information

• IT confidentiality agreements

 

Your report will

• be 1200-1500 words in length.

• incorporate at least three references.

o Integrate more than three references if you would like.

o Cite and list them in APA 7th edition style.

• include at least one graphic. The graphic should demonstrate either the current personnel

arrangement (and the problems it poses) or your proposed personnel arrangement (and how it

addresses the current problems) or both. Of course, if you would like to include more than one

graphic, you may do so.

You will need to apply the following Golden Rules of Technical Communication:

• Rule #1: Paper is Permanent. Make sure your word forms are accurate and your grammar and

mechanics are correct. Others in the company in addition to Chris might see your memo. It is

not only Chris who might be judging your message based on the quality of your writing.

• Rule #2: Know your Audience.

o Keep in mind that you are writing to Chris Taylor. He is your primary audience. He is

not an IT expert, nor is he a human resources professional. In addition, consider his

education level and his lack of acumen for IT-related matters.

o Note that Chris is your boss. You are writing to a superior about a problem that he does

not realize is a problem.

o Understand that, while Chris is your primary audience, other members of the IT team are

secondary audiences. They might see your memo eventually.

▪ Consider their level of education. Some of them have bachelor’s or master’s

degrees.

▪ Don’t offend them. You don’t want to write anything that would cause a

problem between you and members of the IT Department if they see your memo.

• Rule #4: Break It Out. Instead of writing long, thick, dense paragraphs, you want to write

readable text.

o Bullet information in places if necessary

o Write short, crisp sentences that are readable.

o Write short paragraphs rather than long ones, as you deem necessary.

Use your judgment about how to break out your text as you consider the rhetorical situation.

 

 

• Rule #7: Signpost. Use headings to help Chris navigate your document. Provide a table of

contents to help Chris see the different sections of your report and help him to find them easily.

• Rule #9: Contemplate Before You Illustrate. As you construct your graphic, make sure it adds

to your document and does not simply dress up the document. Consider how best to illustrate the

current problem or the possible solution with your graphic(s).

• Rule #10. Cut the Fluff. Chris is a busy business owner. He is not expecting your report. He

has not budgeted time in his schedule to read it. You will need to communicate the current

problem and suggest an alternative to it without getting wordy or including information that is not

helpful to your purpose.

 

How the Report Should Be Organized

Your short report will have the following sections:

• Memo (written to Chris Taylor) – no more than 150 words

• Executive Summary – no more than 250 words

• Table of Contents

• The Problem

• Suggested Solution

• Conclusion – no more than 200 words

• References

Due Date: Your instructor will notify you of the due date. You will write a first draft, your instructor will comment

on the first draft, and you will submit a second draft using the comments as your guide.

The bulk of the report will be The Problem and Suggested Solution. These

two sections together should compose half or more of the length of the report.

Components Necessary for a Market

/in /by

Components Necessary for a Market

https://geniusproessays.com/

Components Necessary for a Market:

Question 1

Respond to the following in a minimum of 175 words:

  • Discuss the main components necessary for a market to occur.
  • Discuss a market you have recently participated in, either professionally or personally. Why is it important for you to take part in this market, and what differentiates it from other markets?

RESPONSE TO THE FOLLOWING STUDENTS POST.

Yesenia post

Market is a place that two or more parties are able to meet or use to engage in an economics transaction. Markets involve services, goods, currency, and information which can pass along from one to another. Some examples of markets can be coffee, eBay, online, rice, tv, and stores. Markets are not labeled to one physical or geographical location. The main components have three components, which are goods and services market at the other end, the companies that are making the products, and factor market at one end. The market is the law of demand and supply which manages the production of goods and services. The market I have recently participated in was using the market store like Target and other stores. It is important for me to take part in this market because I was looking for a faster delivery time and this specific store was able to provide me the products sooner then need to wait. It was different from other markets because it allowed me to purchase the products the same day to be delivered and other markets were not able to provide that service.

Kenneth post

 

A market is where groups can get together and exchange things and/or services and engage in economic activity. The groups involved are usually buyers and sellers. A market could consist of a literal retail market or more of a virtual market, like online. There also could be illegal markets, financial and/or auction markets. The parts of a market include an area to sell the goods, sellers and buyers, and the product or objects being sold.

There could be a farmers’ market, a housing market or an online market like craigslist or eBay. I’d much rather be involved in a farmers’ market myself because I can actually interact with the seller and the consumer, like myself, can give feedback and be face-to-face. Ebay is ok, I’ve done a couple transactions on there. There’s a lot of steps along the way so both parties feel secure. The differentiation between the two for them is the human contact or the lack thereof. There are many examples of markets and pretty much it just involves the trade of economic activities between groups of people.

Critical Path

/in /by

Critical Path

https://geniusproessays.com/

Critical Path:

DQR Week 4 Seminar PM

In response to your peers, note the points upon which you agree and diverge regarding a particular methodology and discuss those points. Again, support your position with specific examples from your own experience or from your research.

 

Colton Brannon

The Critical Path (CP) project methodology helps to determine the sequence of dependent tasks allowing project managers to better prioritize, build schedules, and more. Dependent tasks, meaning tasks that are required before another task can begin, can fall into the categories of finish to start, finish to finish, start to start, and start to finish. These phrases identify the order of tasks to be completed and affect the start of each task. A few advantages of this method include easier prioritization, better risk detection, and the ability to adapt. Since it is understood which tasks have to be completed before starting another, they can be prioritized. Additionally, risks can be clear since they know which path the project will be following along. Finally, with CP allows for the schedule to be changed, if necessary, with the ability to see outcomes and make the best decision. Some disadvantages include complexity and applicability. The CP method revolves around many tasks and moving pieces requiring difficult calculations and the ability for human error. On the other hand, this method is not for every project. If there is not a clear structure to completing the project, this method may not be useful (Ramos, 2022).

The Critical Chain (CC) methodology is similar to CP as it focuses on the series of dependent tasks that must be completed for a project to be successful. The CC method, however, focuses on resources to buffer the timeline and therefore determines a success factor on the usefulness of these buffered resources. This method can be useful in reducing the time and cost of a project while allowing for problems to be detected quickly. Advantages include accelerating execution and reducing capital needs while disadvantages may include difficulty to grasp and required dedication. Overall CP and CC are similar, but CC operates with buffers and revolves more strongly around resources (Hlioui, 2020).

The third method agile, allows for continuous customer involvement through incremental delivery of project demands. This method is beneficial when there is uncertainty, unknowns, and room to work. By working with the client often things can be changed quickly to reflect the wants and needs from the customer. Agile advantages include fewer wasted resources, quick feedback, and the ability to experiment or create new ideas. Some of the disadvantages include increased effort due to constant interaction, inability to multitask projects due to constant attention needed on agile, and lack of design or knowledge of the project (Olic, 2020).

The criteria for the methods above can be unique to each situation as the task at hand and knowledge known differs every time. CP is often linked to construction projects as construction have concrete steps that have to be followed to achieve success. For example, the foundation has to be completed before building upon it as these are dependent tasks. CC is similar but can have a wide array of projects as well. Additionally, agile is often considered for IT projects as it allows for creative minds to work and develop new ideas, however, it is moving along to many projects nowadays. Overall, each method must be carefully considered with each task as the usual situation that these methods are used in can differ at any time. If used correctly for the correct situation there is great benefit for the customer and project management team.

 

References

 

Hlioui, O. (2020, December 11). The “Critical Chain Project Management ” approach (CCPM) -. cooens.com. Retrieved September 14, 2022, from https://cooens.com/knowledge-base/the-critical-chain-project-management-approach-ccpm/

Olic, A. (2020, October 28). Advantages and disadvantages of agile project management [checklist] · activecollab. ActiveCollab. Retrieved September 14, 2022, from https://activecollab.com/blog/project-management/agile-project-management-advantages-disadvantages

Ramos, D. (2022, May 5). Advantages & disadvantages of critical path method. Smartsheet. Retrieved September 14, 2022, from https://www.smartsheet.com/content/critical-path-advantages-disavantages

 

Response –

Emily Plante

Picking the right project management methodology is critical for executing a project successfully. There are many different methodologies that have their advantages and disadvantages. Three of these include Critical Path, Agile, and Waterfall. At the very core these methodologies are the same, they are ways of organizing a project’s sequence of events. Essentially, how the project will move from step A to step B (Westland, 2022). It’s their differences that really set them apart.

The waterfall approach is known as the most straightforward methodology. This approach flows down with each step, meaning that one step must be completed before the next one can start. This gives a very clear order of events. However, it does not allow for a lot of additional room for adjustments if needed (Westland, 2022). On the opposite end, the agile approach allows a lot of room for adjustments. This approach could be seen as more casual than the strict step to step approach of the waterfall methodology. An agile approach is fluid, there is an order of steps and what needs to happen to reach each milestone, but the order and timing of these steps is flexible. They can be moved around, sped up, or slowed down if needed (Westland, 2022).

The critical path method falls somewhere in between. The CPM takes a detailed look into each step, the amount of time needed, and compiles it into an estimate of the longest possible amount of time it would take to complete the project (Westland, 2022). It brings together the strictness of the waterfall approach by solidifying the steps and time, but there is room for flexibility as the CPM is the longest amount of time needed. Because of this, steps have the potential to be moved around and still stay within the timeframe (Westland, 2022).

 

 

What methodology is used is very dependent on the project and the project environment. For example, industries where an agile methodology works well is anything in tech, automotive, or music. These industries are always looking for the next big improvement and the agile method allows them flexibility with their projects (Westland, 2022). CPM and waterfall methodologies can both be used for smaller projects that are also very structured, construction for example (Westland, 2022). These projects tend to have a very set order of events and it could be costly for a project to deviate from the set plan. A small housing development would benefit from either method.

A small project I worked on while working in retail was a complete overhaul of the store and its products in between seasons. The waterfall methodology most closely resembled how we got the project done. We would stay after the store closed and follow a set structure of steps to get everything done. First we would work at the front of the store, take down and pack away displays and clothes not included in the new season, then refill that section starting with hanging clothes and moving to folded clothes and displays. From there we would move to the middle section, follow the same steps, and then the back sections of the store. With everyone knowing the exact steps and order it was accomplished efficiently and quickly. There was no wasted time trying to figure out who was working where and what product they needed.

 

Resources:

 

Westland, J. (2022, May 20). Top 10 project management methodologies: An overview. Project Manager. Retrieved September 13, 2022, from https://www.projectmanager.com/blog/project-management-methodology

Response

Research Design

/in /by

Research Design

https://geniusproessays.com/

Research Design:

PSYC515

Research: Research Design Assignment Instructions

Overview

This is the first assignment in your Research Project. The purpose is to scaffold the process of designing and conducting a research study. In this first phase, you will submit a research proposal and survey by completing this form. Your instructor will review this form and provide feedback to let you know if you are approved to collect data using the survey submitted as part of this assignment (you should create your survey at the end of this document).

Instructions

Be sure you have reviewed this module’s assigned readings and presentations before completing this assignment. Of most relevance is the Research Project Overview and Research Project Survey Instructions documents in this week’s Learn section. This assignment is worth 40 points: 36 points for content and 4 points based on format. Each question is worth 2 content points. Format is for completing answers within the assigned sections and for proper format of the survey. Note that until the survey is approved by your instructor you cannot move forward with the future assignments associated with the Research Project. Turning in this assignment late, incomplete, or inaccurately formatted may impact performance on future portions of this project.

· There are two parts to this assignment:

· Research Design: complete the table below by placing answers where indicated (“<ANSWER>”).

· Survey: at the end of this document (where it says <Create Proposed Survey Here> create a proposed survey. It should be formatted to be easy for a person to read and complete. You must create the survey in its entirety within this document – you cannot copy / paste question(s) as an image as distortion may occur (you must retype them). All questions should be the same font and font size. Make sure there is uniformity in appearance and there are no typos.

· You will submit this assignment as a single word document by the due date in Canvas.

 

Research Design Table
Demographic Variable Name of variable: Participant age.
  Levels of variable you will use: 20-50
  Scale of Measurement (nominal, ordinal, or scale): Scale
  Appropriate measure of central tendency and (if appropriate) variability: Mean
Variable of Interest #1 Name of variable and/or scale selected (including citation): Religious Reflections Scale
  How many questions? What are the answer options – e.g., Likert 1 – 5?): Survey enables this study to predict specific categories. The use of a Likert Scale will facilitate the necessary categories in this process. Six questions will be provided with a scale from 1-10.
  How is this variable quantified? What is the potential numerical range and how is it interpreted? (i.e. how do you calculate the variable as a single numerical value to be used in SPSS for data analysis) Notes: if it is only one question, the answer will be similar to what you have as the previous answer; if scale is nominal, numbers are meaningless but necessary for SPSS so you won’t discuss the numbers in your paper but will state them here. In each of the six questions the score for all the questions will be averaged together to present a specific number using SPSS.
  What is its scale of measurement? The scores will range from 0 (not spiritual) to 10 (extremely spiritual).
Variable of Interest #2 Name of variable and/or scale selected (including citation if appropriate): Conscious Reflections
  How many questions? What are the answer options – e.g., Likert 1 – 5?: Quantitative
  How is this variable quantified? What is the potential numerical range and how is it interpreted? (i.e. how do you calculate the variable as a single numerical value to be used in SPSS for data analysis) Notes: if it is only one question, the answer will be similar to what you have as the previous answer; if scale is nominal, numbers are meaningless but necessary for SPSS so you won’t discuss the numbers in your paper but will state them here. In eleven of the questions, a numerical score for each question will be tallied then averaged to provide a specific numerical value using SPSS.
  What is its scale of measurement? Scores will be between 1and 5.

The scale of measurement will be interval.
Research Design Correlational, quasi-experimental, or experimental (since you have 2 variables it will NOT be descriptive): Predictive.
  Justification: Personal spirituality will affect each person’s life based on surroundings, the media, and society.
Research / Alternate Hypothesis (note this is NOT the null hypothesis). **It is common practice in the field to explicitly state the research hypothesis in the paper but statistically test the null hypothesis.
Information will be collected based on each person’s inner reflections of thoughts and feelings.

 
Proposed Target Population (e.g., “friends” on facebook; only women, colleagues at a specific type of business – note you will need 20 participants from this target population, and you cannot use people you do not know due to the educational nature of this study and our IRB exempt status constraints – read the M2 Research Data Collection Instructions for further clarification):
Facebook; Friends.

 
Proposed survey distribution method (e.g., email, facebook, hand out paper surveys at your church, et cet – note you cannot distribute these in public places due to the exempt status of this educational assignment – read the M2 Research Data Collection Instructions for further clarification):
Facebook.

 
 
At the end of this document (starting on the next page), create a proposed survey making sure to include the following components:

· Disclaimer

· Directions to the participant on how to answer the questions (may need directions for each subsection)

· Question(s) related to the Demographic Variable

· Question(s) related to Variable 1

· Question(s) related to Variable 2

 

 

Instructions:

 

This is a survey of spirituality. Please take a moment to answer the following questions. The information that you provide is being collected for research purposes and will not be shared. This information being collected is strictly confidential. In order to participate in this survey, you must be between the age of 20 and 50. Please circle the most appropriate answer that you feel is appropriate for you.

 

Background Questions

 

 

a. What is your Age?

______________________

 

 

 

B. Variable Testing: Reflections of Inner Thoughts & Feelings

 

The following questions are designed to indicate how relevant religion and spirituality is in your life. It will indicate how important God is to you and your family daily. This is indicated by 0, a least amount, and 10, the greatest amount.

 

1. Religion and spirituality are important in my life.

 

0 1 2 3 4 5 6 7 8 9 10

 

None Very Important

 

 

2. Spiritual grow this important.

0 1 2 3 4 5 6 7 8 9 10

 

None Most Important

 

3. I use my relationship with God to answer questions in my life.

0 1 2 3 4 5 6 7 8 9 10

None Very Important

 

 

 

4. Spirituality is a motivating force in my life.

 

0 1 2 3 4 5 6 7 8 9 10

 

No part of my life Very Important

 

 

5. When I think of the things that help me grow and mature as a person.

 

0 1 2 3 4 5 6 7 8 9 10

 

None Very Important

 

6. God is important in my life.

 

0 1 2 3 4 5 6 7 8 9 10

 

No part of my life Very Important Part

 

—————————————————————————————————————————-

 

C. Inner Conscious Thoughts Scale (5-Point Response Scale). Circle One:

 

7. It is important to constantly be learning

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

8. Recognizing details is important.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

9. Everyone one has a voice and opinion.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

10. I value other people’s thoughts and opinions.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

11. My family has taught me that life is a journey and a constant learning process.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

12. I listen and have developed a respect for others.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

13. I feel a connection with strangers

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

14. I think things through before I make a decision.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

15. I have become a valued member of society.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

16. I understand others and their points of view.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

17. I apply my intelligence when encountering a problem.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

18. I understand people of other races.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

19. I listen to others before I make a decision

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

20. Over the duration of my life, I have used God as a means of guidance and spirituality.

 

1 2 3 4 5

 

Strongly Disagree Strongly Agree

 

 

 

 

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.

Page 2 of 2

Healthcare Information Technology

/in /by

Healthcare Information Technology

https://geniusproessays.com/

Healthcare Information Technology:

As a nurse or healthcare professional, it is important to realize that healthcare Information Technology is part of our daily living no matter which side you are on (love it or leave it). Whether as a patient or professional, you will inevitably be exposed to and interact with the system.

Therefore, which ‘side’ you are on ultimately does not matter. You must understand the steps and processes to implementation. The transformation must be embedded both at an individual, organizational, and corporate level. Indeed, it is possible that as a Master prepared healthcare professional, you might be the one responsible for creating a “tech- friendly” environment.

The text and this site explore how to create an engaging informatics culture: Healthcare Information and Management Systems Society. (Note: “Nurse” in this article may be substituted by “Healthcare Professional”).

Evaluate the importance of one of the foundations for Creating an Informatics Culture. Include the following aspects in the assignment:

a) Explore the steps to support Digital Transformation

b) Explain why it is critical for professionals and healthcare organizations to have a collaborative and innovative culture

c) Create a model, using any tool you wish, to initiate an Informatics Culture in a health care organization (examples of models are found here – if you choose one, you must personalize it)

d) This is not a formal paper and there is a 2 page minimum length. Each bullet must be thoroughly explored. At all times, proper sentence structure, grammar, and spelling are required. Grammarly is a free tool to assist you. All references must be placed.

 

 

Global Burden

/in /by

Global Burden

https://geniusproessays.com/

Global Burden:

This discussion focuses on the concept of disease burden, which you will learn about in-depth in Chapter 3 of the eText attached.

For this discussion, in addition to Chapter 3,  please refer to the “Global burden of 87 risk factors in 204 countries and territories” article provided in the Module 2 Learning Resources folder.  Read the article summary and peruse the article.

This is a one-page perusal of both articles to answer the three questions below. 

1) What information presented in this article was most surprising to you about disease burden?

2) Why was that information surprising?

3) In your own words, explain how disease burden is measured and how it is used to define global health.

Global Health Metrics

www.thelancet.com Vol 396 October 17, 2020 1223

Global burden of 87 risk factors in 204 countries and territories, 1990–2019: a systematic analysis for the Global Burden of Disease Study 2019 GBD 2019 Risk Factors Collaborators*

Summary Background Rigorous analysis of levels and trends in exposure to leading risk factors and quantification of their effect on human health are important to identify where public health is making progress and in which cases current efforts are inadequate. The Global Burden of Diseases, Injuries, and Risk Factors Study (GBD) 2019 provides a standardised and comprehensive assessment of the magnitude of risk factor exposure, relative risk, and attributable burden of disease.

Methods GBD 2019 estimated attributable mortality, years of life lost (YLLs), years of life lived with disability (YLDs), and disability-adjusted life-years (DALYs) for 87 risk factors and combinations of risk factors, at the global level, regionally, and for 204 countries and territories. GBD uses a hierarchical list of risk factors so that specific risk factors (eg, sodium intake), and related aggregates (eg, diet quality), are both evaluated. This method has six analytical steps. (1) We included 560 risk–outcome pairs that met criteria for convincing or probable evidence on the basis of research studies. 12 risk–outcome pairs included in GBD 2017 no longer met inclusion criteria and 47 risk–outcome pairs for risks already included in GBD 2017 were added based on new evidence. (2) Relative risks were estimated as a function of exposure based on published systematic reviews, 81 systematic reviews done for GBD 2019, an

Productivity Calculations

/in /by

Productivity Calculations

https://geniusproessays.com/

Productivity Calculations:

Productivity Calculations

Productivity Analysis Assignment
Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points) Assignment Learning Objectives
Use data in columns C & D for the
Data: Calculation Exercises 1a – 6c 1. Calculate single factor and total factor productivity measures
Metric Parent (Domestic) Subsidiary (Less Developed Country) Hint: Use Excel formulas to calculate your answer. 2. Interpret productivity measures and draw appropriate conclusions
Sales (units) 1,850,000 750,000 For Example: To calculate the Parent’s total labor dollars, you multiply labor hours * labor cost 3. Use formulas in Excel
Units Produced 1,425,000 479,586 In Excel, you enter: =C8*C9 4. Use Excel to perform “What-If” Analysis
Labor (hours) 40,000 20,000 The “=” sign tells Excel that you are entering a formula and then you multiply the two cells that contain your data
Labor Cost ($) per hour $14.56 $5.51
Materials Cost ($) $400,259 $201,378
Equipment (Hours) 120,598 30,578
Equipment Cost ($) $1,359,600 $225,000
Fixed Costs ($) $2,000,000 $725,000
Selling Price per Unit $19.99 $19.99 Total points this worksheet = 30 points
Calculation Exercises:
Labor Productivity (units/hour)
1a. Compute the single-factor productivity for labor for the Parent operations in units per hour (enter your formula in cell B20).
Cell B20 must be a formula units/labor hour
1b. Compute the single-factor productivity for labor for the Subsidiary operations in units per hour (enter your formula in cell B23).
Cell B23 must be a formula units/labor hour
1c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per hour
Labor Productivity (units/$)
2a. Compute the single-factor productivity for labor for the Parent operations in units per dollar (enter your formula in cell B31).
Cell B31 must be a formula units/labor $
2b. Compute the single-factor productivity for labor for the Subsidiary operations in units per dollar (enter your formula in cell B34).
Cell B34 must be a formula units/labor $
2c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor labor productivity in units per dollar.
Materials Productivity (units/$)
3a. Compute the single-factor productivity for materials for the Parent operations in units per dollar (enter your formula in cell B42).
Cell B42 must be a formula units/$
3b. Compute the single-factor productivity for materials for the Subsidiary operations in units per dollar (enter your formula in cell B45).
Cell B45 must be a formula units/$
3c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor materials productivity in units per dollar.
Equipment Productivity (units/hour)
4a. Compute the single-factor productivity for equipment for the Parent operations in units per hour (enter your formula in cell B53).
Cell B53 must be a formula units/hour
4b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per hour (enter your formula in cell B56).
Cell B56 must be a formula units/hour
4c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor equipment productivity in units per hour.
Equipment Productivity (units/$)
5a. Compute the single-factor productivity for equipment for the Parent operations in units per dollar (enter your formula in cell B64).
Cell B64 must be a formula units/$
5b. Compute the single-factor productivity for equipment for the Subsidiary operations in units per dollar (enter your formula in cell B67).
Cell B67 must be a formula units/$
5c. Interpret your findings by indicating which of the two entities is more productive in terms of single-factor equipment productivity in units per dollar.
Total-Factor Productivity:
6a. Compute the total-factor productivity (all factors) for the Parent operations in units per dollar (enter your formula in cell B75).
Cell B75 must be a formula units/$
6b. Compute the total-factor productivity (all factors) for the Subsidiary operations in units per dollar (enter your formula in cell B78).
Cell B78 must be a formula units/$
6c. Interpret your findings by indicating which of the two entities is more productive in terms of total-factor productivity in units per dollar.

What-If Analysis

Productivity Analysis Assignment
Total = 55 points: Productivity Calculation Tab (30 points) + What-If Analysis Tab (25 points)
Current Values Use column F for
Data: question 8
Metric Parent (Domestic) Subsidiary (LDC) Parent (Domestic)
Sales (units) 1,850,000 750,000 1,850,000
Units Produced 1,425,000 479,586 1,425,000
Labor (hours) 40,000 20,000 30,000
Labor Cost ($) per hour $14.56 $5.51 $14.56
Materials Cost ($) $400,259 $201,378 $400,259
Equipment (Hours) 120,598 30,578 100,000
Equipment Cost ($) $1,359,600 $225,000 $1,248,000
Fixed Costs ($) $2,000,000 $725,000 $3,500,000
Selling Price per Unit $19.99 $19.99 $19.99
What-If Productivity Values Based on New Data Entered in Column F
Measure Parent Organization
Labor Productivity (units/labor hour) 47.50
Labor Productivity (units/labor $) 3.26
Materials Productivity (units/$) 3.56
Equipment Productivity (units/hour) 14.25
Equipment Productivity (units/$) 1.14
Total-Factor Productivity (units/$) 0.26
Labor
7. Provide one possible explanation how the Parent can be more productive when considering labor productivity in units per hour, but the subsidiary is more productive in units per dollar.)
Parent Equipment Purchase (Part #1)
8. Assume purchase of new equipment at an incremental, one-time fixed cost of $1,500,000 resulting in a reduction in labor hours to 30,000, a reduction in Equipment Hours to 100,000, and a reduction of Equipment Costs to $1,248,000 with all other costs remaining the same. Change the appropriate values in column F above. Answer the questions below by comparing the new productivity value in cells D18 through D23 to the values you calculated on the “Productivity Calculations” worksheet. For example, if the value in D18 on this worksheet (Labor Productivity in units/labor hour) is less than the value for Labor Productivity in units/labor hour for the Parent operations on the “Productivity Calculations” worksheet, then choose “decreased”
Productivity Measure Choose the correct answer for each productivity calculation
Labor Productivity in terms of units/labor hour
Labor Productivity in terms of units/labor $
Materials Productivity in terms of units/Materials Cost ($)
Equipment Productivity in terms of units/hour
Equipment Productivity in terms of units/$
Total Factor Productivity in terms of units/$
Parent Equipment Purchase (Part #2)
9. Calculate Total Revenue prior to any equipment changes using data in cells C6 through C14 above. The formula for Profit is Total Revenue – Total Costs The formula for Total Revenue is Total Units Sold * Selling Price per Unit
Pre Equipment Purchase Total Profit
Post Equipment Purchase Total Profit
10. Summarize your observations concerning how the potential new equipment purchase will impact each of the productivity values and total revenue. Provide a recommendation whether to purchase the equipment and also provide supporting evidence for your recommendation.

image1.png