Category: Operations Management homework help

 You have been promoted to a senior role, and the CEO has asked you to speak to

 You have been promoted to a senior role, and the CEO has asked you to speak to the staff about modeling exemplary leadership, using an example of a person from your own background or professional career. Describe the exemplary leader you will present to the staff, providing specific details about their behaviors relative to styles such as exemplary leadership, ethical leadership, moral leadership, and Collins’s model of level leadership.
Submission: APA, 2 paragraphs
 

I chose Real Estate as a topic. You will have to explain in the introduction how

I chose Real Estate as a topic. You will have to explain in the introduction how it is related to the hospitality and tourism industry. The rest of it should be done in the points as stated in the document below. 

To describe how global organizations define and measure performance at the    in

To describe how global organizations define and measure performance at the    individual, group/unit and organizational levels
https://www.klipfolio.com/resources/articles/what-is-a-key-performance-indicator
To understand the legal/regulatory, cultural and economic forces impacting performance management strategies/programs
https://www.forbes.com/sites/jackzenger/2017/02/16/the-6-vital-elements-of-effective-performance-management-systems/#fd2b082618e9
Write 1-2 paragraph reflection and opinion on this.

A bank is attempting to determine where its assets should be invested during the

A bank is attempting to determine where its assets should be invested during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rate of return on each type of investment is known to be: bonds, 10%; home loans, 16%; auto loans, 13%; personal loans, 20%. To ensure that the bank’s portfolio is not too risky, the bank’s investment manager has placed the following three restrictions on the bank’s portfolio: a) The amount invested in personal loans cannot exceed the amount invested in bonds. b) The amount invested in home loans cannot exceed the amount invested in auto loans. c) No more than 25% of the total amount invested may be in personal loans. The bank’s objective is to maximize the annual return on its investment portfolio. Formulate an LP that will enable the bank to meet this goal

The Basis of Power and Influence [WLOs: 1, 2] [CLOs: 1, 2, 3, 4]
Prior to beginn

The Basis of Power and Influence [WLOs: 1, 2] [CLOs: 1, 2, 3, 4]
Prior to beginning work on this discussion forum, please read Chapter 14 in your Kinicki and Soignet (2022) textbook, and the article Dynamics of Power in the Workplace by Orta (2015).
In an initial post of at least 300 words, and citing at least two required scholarly sources, describe the five sources of power in organizations: legitimate, reward, coercive, expert, and referent. Explain how the source of a leader’s power affects the amount of influence the leader has. Identify the influence tactics that are best aligned with each source of power. Then, think about one of your recent professional positions, and describe the source of your power and how you used your power to influence others in the organization.

 
Develop a 12-15 slide PowerPoint presentation that covers all major areas of y

 
Develop a 12-15 slide PowerPoint presentation that covers all major areas of your assignment. 
Be sure to address the following:
Site/organization
Needs assessment results
Project topic
Project goals
Project outcome (or anticipated outcome if not implemented)
How was your project received by stakeholders? (It was thought of as a good idea, likely a good project, but would also be costly – around 500k or more to develop, take 18 to 24 months, and would replace the current workers so they don’t want to push or support this do that right now). 
If you implemented your project, how will it be sustained? If it is not sustainable, how will the one-time implementation make a difference? (It is software, and would be sustained through regular software updates and making sure it stays up with or ahead of other similar software competitors. The development is of course a one-time thing, then just normal updates). 
If you did not implement your project, how did you perform a hand-off for the next steps? (There was no hand-off, the company will not go to implement this, so the research, the presentation, and the data will stay with me until I find the right company or right investors). 
Ultimately, what did you learn from this project? (I learned that hospitals and clinics are losing money, there is a need for proper billing, AI would be superior to human coders, and AI is advancing, and those who do not embrace it will likely run the risk of being replaced by it). 
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. Use at least 4-5 peer-reviewed articles for the assignment (Likely many of the same from the previous assignment). Make sure to include detailed speaker notes. 
This assignment uses a rubric. Please review the rubric before beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance. 

 
1
Excel HW1 Instructions
MIS303 Fall 2022
Introduction and Objectives:
(Indivi

 
1
Excel HW1 Instructions
MIS303 Fall 2022
Introduction and Objectives:
(Individual Assignment 35 points)
You have been hired as a consultant to a retail store. The total revenue for the store comes
from the sales of a mixture of 3 different products (Products A, B and C). You are provided with
historical sales data for three products. You must first make some conclusions regarding sales
for the year 2019. Then, you need to decide how much of each product to order the year 2020.
Lastly, you will make a recommendation on the appropriate mixture and pricing of products to
stock for the coming year.
Spreadsheets are one of the most commonly used software tools in corporations because they
are so easy to work with and so adaptable to a regular work task. This assignment is intended
to use a spreadsheet application such as Microsoft Excel as a reporting, data analysis and
decision support system in a retail operation. You are to follow the instructions to complete and
submit the assignment as individuals. No collaboration or co-working is allowed.
Tasks:
Simply put, you must do the following:
1. (2 pts) Download the file Excel Assignment.xlsx from the Blackboard assignment link.
Make sure you use right click on the link, save target / link as, so you can rename the
file. Name it with your FirstName_LastName_ HW1.xlsx. For instance, a student named
John Doe should have the Excel file saved as John_Doe_ HW1.xlsx for his assignment.
2. Follow the instructions below and complete the data reporting tasks in worksheet tabs A,
B and C. Leave worksheet tabs D, E, F to the next HW please. Do not alter any
information on it yet, or it will cause incorrect data to start your HW2.
3. Submit the Excel file back to the Blackboard Excel HW1 link.
Detailed instructions for each section / worksheet tab are provided below.
A. Sales Records (21 pts, 3 points per question)
1. Format the sales records dataset as a table. Make sure the table columns are wide
enough to fit the column contents.
2. Sort the sales records by Region first in a custom order of Midwest, East, West, South.
In the same Region group, sort the records then by ProdID in alphabetical order.
3. Add a new column at the right of ProdID, and name it Price. Use vLookUp function in
the Price column. For each sales record, use the ProdID as lookup value to find and
return the product price. The product prices are provided in the B. Summary worksheet.
You can use the data range of B8:E10 from the B. Summary worksheet as the table
array in making the vLookUp function.
4. Add a new column at the right of UnitsSold, and name it SubTotal. The subtotal of each
sales record should be the product of price and units sold (Price * UnitsSold).
5. Add a new column at the right of SubTotal, and name it Discount. This company
provides 8%of the subtotal amount as discount to all sales made in the West region. In
the other
2
regions, the company offers 10% of the subtotal amount as discount to Holiday sales in
December. The other sales records that are not in West and not in December receive $0
discount. The two discounts cannot be stacked – none of the order can take both West
region and the holiday discounts at the same time. Use a nested IF function for the
Discount column to show the correct discount for each sales record. (Hint: you can make
separate IF function for the two conditions, and then apply one into the other as value if
false.)
6. Add a new column at the right of Discount, and name it Discount Amount. This is equal to
Discount*SubTotal.
7. Add a new column at the right of Discount Amount, named OrderTotal. The order total of
each sales record will be the difference between subtotal and the discount amount
(SubTotal –Discount Amount).
B. Summary (8 pts)
1. Enter your name, last 3 digits of student ID, and section number in the cells provided in
this worksheet.
Your name: Your name here!
Last 3 digits of Student Id: xxx
Section: DL2
2. The total number of units sold in 2019 for the three products can be found on your
B_Summary worksheet (C8:C10). You need to fill out all the yellow or green boxed cells
according to the requirements below:
– Calculate estimated number of units to be sold for all three products in 2020 (in D8:D10)
as a percentage increase from the 2019 numbers. We will assume that the 2020 sales
will keep the same increase rate as that of 2019, which is 14% in as specified in Cell D3.
– Calculate the revenues (G8:G10) and costs of goods sold (H8:H10) for each products
based on 2020 data (D8:D10). Where Revenue is Units Sold * Unit Price and COGS is
Units Sold * Unit Cost.
– Total Revenue is the sum of the revenues for all three products for 2020
– Total COGS is the sum of the COGS for all three products for 2020.
– Gross Profit = Total Revenue – Total COGS
– Salaries is 12% of Total Revenue
– Advertising is 4% of Total Revenue
– Miscellaneous expenses are 1% of Total Revenue
– Total Operating Expense = Salaries + Advertising + Miscellaneous
– Earning Before Taxes = Gross Profit – Total Operating Expense
– Calculate Taxes based on tax rate of 25% of Earning Before Taxes
– Net Profit = Earnings Before Taxes – Taxes
C. Business Graph (4 pts)
In this worksheet, create a Pie Chart showing the percentage of each product’s contributing to
the total profitability (based on Gross Profit, not Revenue).
You need to calculate the forecasted individual profits (Revenue – COGS) generated by selling
product A, B, and C for 2020, based on the data in the B. Summary worksheet. In the cells with
3
Yellow background color, use formulas that refer to the B. Summary worksheet. DO NOT
SIMPLY ENTER THE VALUES.
Requirements for the chart:
– The Business Graph should have a meaningful Chart Title.
– It should display percentages for each products’ profit contributing to the total company
profit on each pie section.
– There should be a proper legend below the chart.
Submission
Leave worksheet tabs D, E, and F alone here please!!! Do not alter any data or information on
them yet. These are the sheets we will work on in HW2.
When you are done with worksheet tabs A, B and C. Save the Excel file again, and close it as
well as the Excel program on your computer. Go to the Blackboard, upload and submit the
completed file back to the Excel HW1 link.

what expenses and costs facing today’s air industry. Evaluate what the current f

what expenses and costs facing today’s air industry. Evaluate what the current fuel costs do to the industry, how they affect the ticket prices and the patrons’ flying occurrences. 

 
Scenario
As a team manager, you have recently completed training on profession

 
Scenario
As a team manager, you have recently completed training on professional growth and leadership, which you will need to turn around and implement with your team members. You are directly responsible for a team of 10 employees, and you will be creating a growth development plan for each member of your current team as well as future professional development plans for your team as a whole.
Instructions
As part of your team development plan, you will need to complete each of the following deliverables in one document.
1. Team assessment and reflection on the findings.
For your team assessment, each member was given an EI assessment; the results are as follows:
Name: John
Self-Awareness: Low
Self-Management: Medium
Social-Awareness: High
Relationship Management: High
Name: Samantha
Self-Awareness: High
Self-Management: Low
Social-Awareness: Medium
Relationship Management: Low
Name: Alex
Self-Awareness: Medium
Self-Management: High
Social-Awareness: Low
Relationship Management: Low
Name: Bada
Self-Awareness: Low
Self-Management: Medium
Social-Awareness: Medium
Relationship Management: Medium
Name: Anthony
Self-Awareness: Medium
Self-Management: High
Social-Awareness: High
Relationship Management: High
Name: James
Self-Awareness: Medium
Self-Management: Medium
Social-Awareness: High
Relationship Management: High
Name: Kelly
Self-Awareness: Low
Self-Management: Medium
Social-Awareness: Medium
Relationship Management: High
Name: Cassie
Self-Awareness: High
Self-Management: Low
Social-Awareness: Low
Relationship Management: Medium
Name: Mary
Self-Awareness: Low
Self-Management: Low
Social-Awareness: Low
Relationship Management: Low
Name: Fatima
Self-Awareness: High
Self-Management: High
Social-Awareness: High
Relationship Management: High
1.Reflect on the findings for your team. In what areas does your team have strengths based on this assessment? In what areas does your team have weaknesses based on this assessment? What are the opportunities for growth and development for each of your team members, and why did you identify these areas for growth and development?
2.Create a list of Social Awareness strategies for your team. How would you incorporate these into your team strategy? Identify any team members who could be a mentor to other members. How would you incorporate mentoring and modeling into your plan? What sort of training/support might these mentors need?
3.Prepare a self-management strategy for the following individual team members: Samantha, Bada, and Fatima. How would these strategies differ and why?
4.Develop a relationship management strategy for the following individual team members: Alex, Cassie, and John. How do these strategies differ and why?
5.Develop a time management plan for your entire team as a whole. How would these plans differ per team member (individual versus team), and why?
6.Reflect on how your personal learning and growth development impacts you as a leader to the team. How does self-awareness enable you to be more effective?

 
In this assignment, you will analyze the Cost-of-Living Index and Groceries In

 
In this assignment, you will analyze the Cost-of-Living Index and Groceries Index for seven United States cities. You will then create a scatterplot to represent the relationships between the variables. In the end, you will describe the implications of your analysis in your Paper. You may choose any seven United States cities you wish.
Go to the Northern America: Current Cost of Living Index by CityLinks to an external site. webpage and follow the directions below to get started:
Identify seven cities and note the “Cost of Living Index” and “Groceries Index” values.
In your Excel spreadsheet or tool of your choice, develop a table with three columns with the following titles:

City
Groceries Index (independent variable)
Cost of Living Index (dependent variable)

Enter details for all seven cities under these column headers. You will then have a table with seven rows representing each city in one row.
Now, insert or draw a scatterplot of the above data set.
Display the regression line (also called the trend line, linear model, or line of best fit). To do so in Excel, select anywhere in the scatterplot. Select the plus sign, and at the bottom of Chart Elements, select “Trend line.”
Display the equation for the trend line and R2 value on the graph. To do so in Excel, right-select the trend line. Review the options on the right of the chart under “Format Trendline…” and scroll to the bottom to select the boxes for “Display Equation on chart” and “Display R-squared value on chart” options.
In your paper,
Provide the URL and complete an APA reference for the URL. For assistance formatting your reference list, refer to APA: Formatting Your References ListLinks to an external site. resource.
Provide the table with your data and your spreadsheet of the graph with the equation and R2 value. For assistance on when and how to use tables, refer to Tables, Images, & AppendicesLinks to an external site. resources.
Assess the relationship between the Groceries Index and the Cost of Living Index in the cities you studied. How do these indices help you identify the best and worst cities in the list regarding cost?
Summarize how this week’s visualization and probability tools helped you in your analysis.
The Identifying Relationships Between Variable paper
must be two to three double-spaced pages in length (not including title and references pages, charts or tables), and formatted according to APA StyleLinks to an external site. as outlined in the Writing Center’s APA Formatting for Microsoft WordLinks to an external site. resource.
must include a separate title page with the following:

title of paper in bold font

Space should appear between the title and the rest of the information on the title page.

student’s name
name of institution (The University of Arizona Global Campus)
course name and number
instructor’s name
due date

must utilize academic voice. Review the Academic VoiceLinks to an external site. resource for additional guidance.
must include an introduction and conclusion paragraph.

Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & ConclusionsLinks to an external site. as well as Writing a Thesis StatementLinks to an external site., refer to the Writing Center resources.

must use at least one credible source in addition to the course text.

The Scholarly, Peer-Reviewed, and Other Credible SourcesLinks to an external site. table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
To assist you in completing the research required for this assignment, review Quick and Easy Library ResearchLinks to an external site. tutorial, which introduces the University of Arizona Global Campus.

must document any information used from sources in APA Style as outlined in the Writing Center’s APA: Citing Within Your PaperLinks to an external site. guide.
must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.

Review the APA: Formatting Your References ListLinks to an external site. resource in the Writing Center for specifications.