Hinkel rotary engine- excel -production planning problem

Assignment Help Business Management
Reference no: EM1365591

Hinkel Rotary Engine- Excel -Production Planning Problem

Hinkel Rotary Engine, Ltd., produces four- and six- cylinder models of automobile engines. The firm's profit for each four-cylinder engine sold during its quarterly production cycle is $1,800 - $50X1, where X1 is the number sold. Hinkel makes $2,400 - $70X2 for each of the larger engines sold, with X2 equal to the number of six-cylinder engines sold. There are 5,000 hours of production time available during each production cycle. A four-cylinder engine requires 100 hours of production time, whereas six-cylinder engines take 130 hours to manufacture. Formulate this production planning problem for Hinkel. How do you set this problem up in Excel to find the optimal solution?

Reference no: EM1365591

Questions Cloud

Design of experiments : Why would you want to use Design of Experiments rather than Multiple Regression? In other words, what situations are more suited for DOE and which ones more suited to Multiple Regression?
Write a note on qualification and curriculum authority : Goverment-led training initiatives-Write a note on 'Qualification and Curriculum Authority (QCA)' and 'National Vocational Qualifications (NVQs)'.
Show types of power : From an organizational behavior perspective, power is the capacity to influence the behavior of others. Power relationships are the medium within which business is conducted.
Power in organizations : we ponder this animal called "POWER" in organizations, contemplate and discuss for a moment the statement. It's not what you know, it's who you know?
Hinkel rotary engine- excel -production planning problem : Hinkel Rotary Engine, Ltd., produces four- and six- cylinder models of automobile engines.
Training and development misconceptions : Training is not valuable. It doesn't teach information that help managers drive the business. It is an expense - not an investment and anyone can be a trainer. Give me some PowerPoints and I'm ready to go. Anyone can get up there and talk for an ho..
What would be the best way to contact the hiring manager : What would be the best way to contact the hiring manager? By mail, email or by phone? Explain and support your selection and how would you explain that you know about this position without identifying your friend?
Addresses resistance to change : How can Jorge deal with the employees' resistance to change, to enable him to move the change process along
Employee retention rates in car dealer industry : Prepare a summary of your findings. Comment on whether attrition rates in the retail industry are higher than other industries and explain why. Properly cite your sources in your paper.

Reviews

Write a Review

Business Management Questions & Answers

  Analyzing degree of alignment values and organizations

Explain the differences and analyze the degree of alignment between your values and the organizations values as reflected by the organizations??s plans and actions?

  Balanced scorecard-use to assess employee performance

balanced Scorecard-Use to assess employee performance and How reliable will it be and how do we create such measures?

  Question about debt and equity mix

What are the main factors that go into determining the right mix of equity and debt and If debt is always cheaper than equity, why have equity?

  Tuition reimbursement as employee benefit

New professional opportunities you believe this degree affords to employees - types of careers peopl with the degree often

  Define work teams and how used around the office to complete

Explain how you use team work around the office to complete tasks with your co-workers. Please support your answer with examples from the sources and the web.

  Kant’s ethical theory

In view of the economic crisis existing in the United States and the rise in unemployment, some legislators have considered a policy that would require companies laid off, or rooting for their H-1 workers against dismissal or dismiss all other Americ..

  Explain does the threat of shareholder resolutions make

Explain Does the threat of shareholder resolutions make a company act more socially responsible?

  Forbearance

When a firm chooses not to react against a competitor's threat is called forbearance. A concept, closely aligned with forbearance is co-opetition; which refers to the combination of both competition and cooperation.

  Organizational design

Consider a company you have worked for in the past , evaluate its organizational design at your time of employment

  Explain the core of organized crime activity is labor

Explain The core of organized crime activity is labor racketeering and business racketeering and money laundering

  Question related to decision making problem

Identify a real-world decision-making problem that is appropriate for a decision support system or expert system and provide a brief description of the overall project.

  Laissez-faire leadership appropriate in which situation

Are there circumstances where laissez-faire leadership might be appropriate? (What are they?)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd