Question

Company A is preparing its Production Plan for the next three months. In the table below...

Company A is preparing its Production Plan for the next three months. In the table below you have the cost of production, demand and maximum production capacity for each month.

Month 1

Month 2

Month 3

Production Cost per unit

$11

$17

$13

Demand

10,000

15,000

20,000

Max. Prod. Capacity

20,000

10,000

15,000

Company A’s warehouse can hold up to 10,000 units and it cost of carrying inventory is equal to 1% of production cost per unit in the ending inventory. Also, Company A has the option of renting a warehouse which can hold up to another 10,000 units for $6 per unit in the ending inventory. The company has no beginning inventory to start with and would like to end the three month period with zero ending inventory

Create LP Model ans Solve

Business   Operations-Management   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

We need to consider the production per month as the decision variable Pi The ending inventory can be denoted by IEi and beginning variable as IBi. Then our objective function is

Minimize Z where Z = 11P1 + 17P2 + 13P3 + 0.01*(11IE1 + 17IE2 + 13IE3)

Subject to constraints

P1 <= 20000

P2 <= 10000

P3 <= 15000

IEi = IB(i+1)

IB1+ P1 >= 10000

IB2 + P2 >= 15000

IB3 + P3 >= 20000

IB1 = 0

IE3 = 0

IEi >= 0

The model is shown below on excel

The formulas are shown below

The solver parameters are shown below

The result is shown below. The production plan should be 20000, 10000, 15000 and total cost of 586950

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A company that produces chairs has obtained a demand forecast for the next three months. To...
A company that produces chairs has obtained a demand forecast for the next three months. To meet the demand, the company can produce chairs using regular production time, overtime, and using a subcontractor. The demand and projected capacities for three production options are in the following table: Month 1 Month 2 Month 3 demand (units) 25000 35000 45000 regular capacity 35000 30000 20000 overtime capacity 5000 5000 5000 subcontractor capacity 7500 2500 3500 The company can produce chairs at a...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 12,000 April 14,000 May 11,500 June 10,000 Wright maintains an ending inventory for each month in the amount of one times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $4 per unit and are paid for in the month after production. Labor cost is $8 per unit and is paid for in...
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory,...
Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time and overtime, subcontracting and backorders. The plan must wind up with no units in ending inventory in Period 6. Regular time capacity is 150 units per month. Overtime capacity and subcontracting capacity are 20 units per month each. Overtime cost is $30 per unit, subcontracting cost is 40 per unit, and backorder cost is $20 per unit, inventory holding cost is $5...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 5,000 April 10,000 May 9,000 Jun 6,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $3 per unit and is paid...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 13,000 April 15,000 May 12,500 June 11,000 Wright maintains an ending inventory for each month in the amount of one and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $5 per unit and are paid for in the month after production. Labor cost is $9 per unit and is paid...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:   March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:   March 20,000   April 22,000   May 19,500     June 18,000   Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid...
A firm need to produce the following number of units during the next three months; month...
A firm need to produce the following number of units during the next three months; month 1, 200 units; month 2, 300 units; month 3, 300 units. For each unit produced during months 1 and 2, a $13 variable cost is incurred; for each unit produced during month 3, a $12 variable cost is incurred. The inventory cost is $0.5 for each unit in stock at the end of a month. The cost of setting up for production during a...
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months...
Given that beginning inventory level is 960 units, total forecasted demand over the next 12 months is 13,400 units, and desired ending inventory level at the end of the 12th month is 1,000 units, what is the cost of production per month if a level strategy is used  and per unit cost of production is $32? (round to the nearest integer)
A company currently has 500 items in inventory. The demand for the next 2 months is...
A company currently has 500 items in inventory. The demand for the next 2 months is 900 and 1200 units. Assuming a level production rate of 1000 units per month, determine the ending inventory at the end of the second month. a. 300 b. 400 c. 500 d. 600
. Kaprelian Company reported the following information about the production and sale of its only product...
. Kaprelian Company reported the following information about the production and sale of its only product during the first month of operations: Selling price per unit                                                                      $300 Sales                                                                                           $480,000 Direct materials used                                                               $220,000 Direct labor                                                                               $200,000 Variable factory overhead                                                        $60,000 Fixed factory overhead                                                             $80,000 Variable selling and administrative expenses                       $20,000 Fixed selling and administrative expenses                            $10,000 Ending inventory, Direct Materials                                                    0 Ending inventory, Work-in-process                                                   0 Ending inventory, Finished Goods                                      400 units Under variable costing, the variable manufacturing cost of goods...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT