Determining the production and inventory plans

Assignment Help Operation Management

Reference no: EM132308315

A manufacturing firm is determining the production and inventory plans for the next three months to maximize profits. The production facility can produce at most 6500 units in one month. The cost of producing one unit in the next three months are respectively 52, 57, and 80 dollars. The cost of carrying one unit of inventory in the next three months are respectively are 3, 5, and 8 dollars. The selling price for the products in the next three months are 80, 72, and 64. Assume that the firm has a starting inventory of 431 units. The demand for the next three months are respectively 5000, 6000 and 7300 units. Build a mathematical formulation that will maximize profit. HINT: Note that this question is different than the previous one. Both the objective function and some of the constraints will need to be modified.

a. Define the decision variables using complete sentences

b. Write down the objective function in words

c. Write down the constraints using complete sentences

d. Express the objective function mathematically using the decision variables defined in part a

e. Express the constraints mathematically using the decision variables defined in part a; see slides for an example.

f. Input the mathematical formulation into an Excel worksheet in an organized fashion. Once done organizing the worksheet then copy paste the table from Excel into Word showing the setup of your worksheet. DO NOT turn in the EXCEL worksheet. All homework answers should be in one file formatted as pdf.

g. What is the optimal solution? (Use solver to determine the solution) h. What is the optimal objective function value? (use solver to determine the optimal objective function value)

Reference no: EM132308315

Questions Cloud

Responsible business enterprises to reduce costs : How does a business ethics program help responsible business enterprises to reduce costs, increase profits, and sustain long-term growth?

Discusses what she calls the fourth level of strategy : 'Everything I need to know about strategy I learned at the national zoo', Liedtka discusses what she calls the 'fourth level of strategy',

Management perceptions of customer expectations : There is often a gap between customer expectations and management perceptions of customer expectations.

One of the steps in the planning process : One of the steps in the planning process is. Maslow's hierarchy of needs is generally accepted and applied in South African businesses for the following reasons

Determining the production and inventory plans : A manufacturing firm is determining the production and inventory plans for the next three months to maximize profits.

Wom related to the integrated marketing communication : Describe the difference between advertising and WoM related to the integrated marketing communication. Describe BMW's brand promise and the brand persona of BMW

Technological effects of the withdrawal of passenger : What are political, economic, social and technological effects of the withdrawal of passenger motor vehicle manufacturing from Australia?

Differences among the dimensions between companies : Differences among the dimensions between companies.and the companies must be in the same industry belongs to the same industry.

Describe maslow and herzberg theories of motivation : Briefly describe Maslow's and Herzberg's theories of motivation. Describe how inventory planning and accuracy can be defined using the Pareto principle.

User Account

All Pages