Find the minimum cost of meeting the schedule

Assignment Help Operation Management

Reference no: EM13968156

Formulate and solve on spreadsheet and please be in details, if possible provide screen shots.

A local high-tech company is determining its assembly schedule for the next 6 months. Assembly cost per drone is $100. In addition, if drones are to be assembled, there is a setup cost of $12000 per month. At the end of each month, there is a holding cost of $25 per unit left in inventory. No more than 200 drones can be stored in inventory at any point in time. Monthly demands for units are projected to be as follows: 140 in month 1; 175 in month 2; 175 in month 3; 146 in month 4; 169 in month 5; and 200 in month 6. At the beginning of month 1, 20 completed drones are in inventory. Finally, this company can complete up to 325 units per month. Formulate and solve an integer programming model to find the minimum cost of meeting the schedule.

Reference no: EM13968156

Questions Cloud

Difference of stop signs and traffic signals at intersection : Discuss the difference of stop signs and traffic signals at an intersection in terms of set up time, batch size, inventory, variability, through put and queue time. When is a traffic signal more efficient, when is a stop sign?

Self-reflection is only one aspect of critical thinking : Self-reflection is only one aspect of critical thinking that can have a positive impact on a researcher’s ability to understand difficult problems. However, when it comes to interpreting the data from a survey or an interview, self-reflection will pl..

Daily demand for product-how many units should be ordered : The daily demand for a product is 17 units with a standard deviation of 2.6 units. The review period is 30 days with a lead time of 14 days. Management has a set policy of satisfying 95% of demand from items in stock. At the beginning of the review p..

Serious disease doccurs with a frequency : The serious disease Doccurs with a frequency of 0.1% in a certain population. The disease is diagnosed by a method that gives the correct result with probability 0.99. Mr. Smith goes to test for the disease and the result turns out to be positive. Si..

Find the minimum cost of meeting the schedule : A local high-tech company is determining its assembly schedule for the next 6 months. Assembly cost per drone is $100. In addition, if drones are to be assembled, there is a setup cost of $12000 per month. At the end of each month, there is a holding..

Minimize the sum of ordering and carrying costs : A manager receives a forecast for next year. Demand is projected to be 550 units for the first half of the year and 980 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. determine a..

What will the additional cost of the optimal plan be : Transportation table and solve for the minimum-cost plan: PERIOD 1 2 3 Demand 550 700 750 Capacity Regular 500 500 500 Overtime 50 50 50 Subcontract 120 120 100 Beginning inventory 100 Costs Regular time $ 62 per unit Overtime $ 82 per unit Subcontra..

Schedule production when the projected on-hand inventory : Prepare a master production schedule for industrial pumps in the manner of the following table. Use the MPS rule to "schedule production when the projected on-hand inventory would be less than 10 without production." Suppose that a production lot siz..

User Account

All Pages