Question: (A multi-period planning model, 18 points) A company wants a high level, aggregate production plan for the next 5 months. Projected orders for the company's

(A multi-period planning model, 18 points) A company wants a high level, aggregate production plan for the next 5 months. Projected orders for the company's product are listed in the table. Over the 5-month period, units may be produced in one month and stored in inventory to meet some later month's demand. The cost of production in each month is shown in the table. The cost of holding an item in inventory per month is $80 per unit. The maximum number of units that can be held in the inventory is 500. The initial inventory level at the beginning of the planning horizon is zero. The problem is to determine the optimal number of products to produce in each month so that demand is met while minimizing the total cost. Month Demand (units) Production cost ($ per unit) 1200 100 2 1500 105 3 1300 400 115 5 2000 110 95 Implement and solve the LP model from the previous question by Excel or Python, upload your file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the...

Question 2 (20 points): A company wants a high level, aggregate production plan for the next 6 months. Projected orders for the company's product are listed in the table. Over the 6-month period,...

A company wants a high level, aggregate production plan for the next 4 months. Projected orders for the companys product are listed in the table. Over the four months period, units may be produced in...

A company wants a high level, aggregate production plan for the next 6 months. Projected orders for the company's product are listed in the table. Over the 6-month period, units may be produced in...

Problem 1 (Multiperiod planning model) A company wants a high level, aggregate production plan for the next 5 months. Projected orders for the company's product are listed in the table. Over the...

Suppose that a manufacturer produces thirty different models of pencils which have common production processes. Currently, assume that it is the end of December. The manufacturer wants to make an...

2. (50 Points) Suppose that a manufacturer produces thirty different models of pencils which have common production processes. Currently, assume that it is the end of December. The manufacturer wants...

Discussion Questions: (see attachment for information) 1. Develop a forecast to use as a basis for sales and Operations Planning. 2. Develop a S&OP plan by month for fiscal year 2015. Consider the...

1. What action should HITEC Corporation take, if any, with regard to Jim Arnold and Mary Bridge? Justify your answer. 2. What action should the firm take, if any, with respect to Mike Morrison? Why?

Explain 3 research findings about the predictors and consequences of substance abuse in adolescents?

Which principle requires that cost of goods sold be recognized in the same period in which the sale of the related inventory is recorded? Going concern Matching Certainty

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...