Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

calculate using EXCEL AND LINGO 3. A company which produces a single product has definite orders for this product over the next six months as

image text in transcribed
calculate using EXCEL AND LINGO
3. A company which produces a single product has definite orders for this product over the next six months as follows: Month 1 2 3 4 5 6 Demand 350 680 475 590 460 390 The company ended the previous month (month 0) with an inventory of 200 units, and the previous month production level was 400 units. The company wishes to end this six-month planning period with an inventory of at least 50 units. It costs $3.50 per unit to increase the production level from one month to the next, and $6.00 per unit to decrease it. The cost of holding inventory from one month to the next is $4.80 per unit per month. No shortages are permitted. In each month. the company wants to produce an integer number of units. The company wishes to minimize the sum of production level change costs and inventory costs over the six-month planning horizon

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Your Money The Missing Manual

Authors: J.D. Roth

1st Edition

0596809409, 978-0596809409

More Books

Students also viewed these Finance questions

Question

3. Define the attributions we use to explain behavior

Answered: 1 week ago