Questions
Quantitative Methods in BUSN Solve this problem using Excel Solver 1. Devos Inc. is building a...

Quantitative Methods in BUSN

Solve this problem using Excel Solver

1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel:

  1. We want to figure out how many rooms of each type to build based on maximizing revenue if we fill up the hotel. We expect to charge $190 for a suite that is non-smoking and $140 for a budget room that is non-smoking. Smoking room customers for both suites and budget rooms will have to pay an additional $20 per night.
  2. We can spend up to $7,500,000 on construction of our hotel. The cost to build a non-smoking budget room is $12,000. The cost to build a non-smoking suite is $15,000. It is $3,000 additional for a smoking room of either type for smoke detectors and sprinklers.
  3. We require that the number of budget rooms be at least 1.5 times the number of suites, but no more than 3 the number of suites.
  4. There needs to be at least 80 suites, but no more than 200.
  5. Industry trends recommend that smoking rooms should be less than 50% of the non-smoking room and in addition, we require our builder gives us at least 4 smoking rooms.

Answer the following using your Solver answers:

  1. How many of each room type should be built, and what would the revenue be for a night when our hotel was fully booked?
  2. Without re-running Solver, what happens to our revenue if we get an additional $1,500,000 for building? Explain in words how you got this answer without re-running solver. Over what amount of construction costs can you use this procedure?
  3. Over what range of room price can our budget non-smoking rooms vary over for us to get the same answer for the quantity of each type of room?

In: Operations Management

What is wrong with the strategy of trying to market to everyone? Isn't it true that...

What is wrong with the strategy of trying to market to everyone? Isn't it true that the bigger the market the larger will be our sales? What does everyone think about such an argument? Why do you feel that way?

In: Operations Management

Alan used to follow a libertarian leadership style. He recently decided to become stricter toward productivity...

Alan used to follow a libertarian leadership style. He recently decided to become stricter toward productivity targets as a result of the fluctuations in the market. He does this in order to make his team more task oriented. Please explain why is this an example of situations shaping how leaders behave.

In: Operations Management

Advocate for the importance of integrating unstructured, outdoor play into elementary schools a as a way...

Advocate for the importance of integrating unstructured, outdoor play into elementary schools a as a way of improving children’s health and wellness and the overall school learning environment.

a) Why is outdoor play important for children's development, health, and wellness

b) Discuss how many children are not meeting movement guideline requirements, and provide an overview of how things have changed in society leading to less outdoor play opportunities for children. How has outdoor play changed over time? What factors have caused this shift in less outdoor free play opportunities for children.

c) Finally, outline a plan for incorporating unstructured, outdoor play into Primary Schools. (Integration of outdoor loose play; outdoor classroom days; integrating learning into outdoor spaces etc/). Include stakeholders in plan (parents, community, staff, school, children/youth)

In: Operations Management

How critically is Marketing research in Business set up? Which of Marketing Mix needs MR the...

How critically is Marketing research in Business set up?

Which of Marketing Mix needs MR the most?

What are the Advantages and Disadvantages of MR?

In: Operations Management

1. What may affect your decision-making in project management? 2. How do you adjust a project...

1. What may affect your decision-making in project management?

2. How do you adjust a project if you don’t have resources when you need them?

3. How do you incorporate lessons learned from project management into future projects?

In: Operations Management

1) Determine the Corporate Strategy of GE. Be specific and make sure that you list the...

1) Determine the Corporate Strategy of GE. Be specific and make sure that you list the industries that GE is in

2) Relate your assessment to its sources of competitive advantage.

3) Evaluate the current performance of GE and determine how you would change the corporate strategy of GE.

In: Operations Management

In the time of crisis, such as the one we are currently facing in the shape...

In the time of crisis, such as the one we are currently facing in the shape of COVID-19, what are some of the qualities that leaders and managers must possess? You may talk about the traits that would come in handy during such times, behaviors that might be potent in troubled times, display of emotions (i.e., what emotions should managers and leaders display in front of those whom they manage and lead), what role would emotional intelligence play? Be detailed in your approach and give reasons for your assertions.

In: Operations Management

Appraise Caterpillar Inc.’s corporate data, competitors, and associated business information. Document background information to include previous...

    • Appraise Caterpillar Inc.’s corporate data, competitors, and associated business information.
    • Document background information to include previous and current strategic management of Caterpillar Inc.
  • Assess the strengths and weaknesses of strategic management of Caterpillar Inc., based on your analyses, and provide information in a presentation to Caterpillar Inc. leadership.

Recommend strategic management actions to ensure future success in a presentation to Caterpillar Inc. leadership

In: Operations Management

Determine the Corporate Strategy of GE and relate it to its sources of competitive advantage. Provide...

Determine the Corporate Strategy of GE and relate it to its sources of competitive advantage. Provide at least 8 examples

In: Operations Management

Post a written response (approx. 250 words) in response to the following questions. When should the...

Post a written response (approx. 250 words) in response to the following questions. When should the policy process be reevaluated and at what point should a policy be terminated? Can you identify any previous policies that were terminated and what impact the termination of the policy may have had on the organization or community as a whole?

In: Operations Management

Define and describe the following five concepts with at least 3 sentences: formal deviance, informal deviance,...

Define and describe the following five concepts with at least 3 sentences: formal deviance, informal deviance, arguments for drug testing, arguments against drug testing, and sport ethic.

In: Operations Management

If you've ever worked at a job with other people, you've heard things like this: We...

If you've ever worked at a job with other people, you've heard things like this: We need younger people with more energy here; or he's getting too old for this. It doesn't seem unfair to recognize that we humans really do get old, and as that happens, our bodies and our minds sometimes start to fail. So why can't the workplace just accept that? What's wrong with a company wanting younger, more energetic, more creative employees?

In: Operations Management

What principles should the information security analyst apply in order to develop appropriate acceptable use policies...

What principles should the information security analyst apply in order to develop appropriate acceptable use policies for the client? Make sure you address confidentiality, integrity, and availability of information, as well as each of the following questions:

1-What should users generally be allowed to do with their computing and network resources? When and why would each example be allowable?

2-What should users generally be prohibited from doing with their computing and network resources? When and why would each example require prohibition?

3-When and why should users be aware of acceptable use policies and how can organizations keep track of these policies?

In: Operations Management

Business and Politics The concept of being in business and in politics is not new to...

Business and Politics The concept of being in business and in politics is not new to most countries, especially the United State. Moreover, many would agree that government should be run more like a business, limiting expenses while making efficient use of scarce resources. However, with each election, there seem to be several stories which arise incriminating either those running and/or in-office as having committed ethical violations (if not criminal activities) in order to acquire financial gains for themselves or their families. Other benefits that occur are those which allow the elected to remain in office, to be re-elected. In this week’s assignment, you are asked to research the topic of ethics in politics, or business and politics. Find a specific story that interests you (and hopefully me), and discuss what makes this an ethical case study. What are the important issues that pertain to this story and what should happen to the guilty? Finally, tell me what can be done to prevent this from occurring in the future.

In: Operations Management