Question

In: Statistics and Probability

During the next four quarters, Dorian Auto must meet (on time) the following demands for cars:...

During the next four quarters, Dorian Auto must meet (on time) the following demands for cars: 4000 in quarter 1; 2000 in quarter 2; 5000 in quarter 3; 1000 in quarter 4. At the beginning of quarter 1, there are 300 cars in stock. The company has the capacity to produce at the most 3000 cars per quarter. At the beginning of each quarter, the company can increase (but not decrease) its production capacity. It costs $100 to increase production capacity by one unit. For example, it would cost $10,000 to increase production capacity from 3000 cars per quarter to 3100 cars per quarter. It also costs $40 per quarter to maintain each unit of production capacity (whether it is used or not). The variable cost of producing a car is $2000. A holding cost of $150 per car is assessed for each quarter’s ending inventory. It is required that at the end of quarter 4, plant capacity must be at least 4000 cars.       

(1) Determine how to minimise the total cost incurred during the next four quarters.

There is a concern that due to rising material and labour costs, the variable cost in the fourth quarter may increase by 10%.

(2) Should you change your production plan if you believe this increase will occur?

(3) What would you do if you believed that there would be a 20% increase in variable costs in the fourth quarter?

Use both MATLAB Optimisation Toolbox and Excel Solver to solve the problems

Solutions

Expert Solution


Related Solutions

During the next four quarters Dorian Auto must meet (on time) the following demands for cars:...
During the next four quarters Dorian Auto must meet (on time) the following demands for cars: 4000 in quarter 1; 2000 in quarter 2; 5000 in quarter 3; 1000 in quarter 4. At the beginning of quarter 1, there are 300 cars in stock. The company has the capacity to produce at the most 3000 cars per quarter. At the beginning of each quarter, the company can increase (but not decrease) its production capacity. It costs $100 to increase production...
During the next four months Capps Shoes Company must meet the following demand for pair of...
During the next four months Capps Shoes Company must meet the following demand for pair of shoes: 2000 shoes in month 1, 3000 shoes in month 2, 4000 shoes in month 3, and 5000 shoes in month 4. At the beginning of month 1, 500 shoes are on hand. This company has 100 workers. A worker is paid $11.5 per hour in month 1, $11 per hour in month 2, $10.5 per hour in month 3, and $10 per hour...
A company must meet (on time) the following demands quarter 1|30 units; quarter 2|20 units; quarter...
A company must meet (on time) the following demands quarter 1|30 units; quarter 2|20 units; quarter 3|40 units. Each quarter, up to 27 units can be produced with regular-time labor, at a cost of $40 per unit. During each quarter, an unlimited number of units can be produced with overtime labor, at a cost of $60 per unit. Of all units produced, 25% are unsuitable and cannot be used to meet demand. Also, at the end of each quarter, 10%...
KPNG Consulting has five projects to consider. Each will require time in the next four quarters...
KPNG Consulting has five projects to consider. Each will require time in the next four quarters according to the table below Project Time in 1st quarter Time in 2nd quarter Time in 3rd quarter Time in 4th quarter Revenue $k A 6 9 3 1 240 B 4 13 6 4 120 C 8 0 8 6 150 D 3 3 1 7 60 E 12 3 4 9 250 Revenue from each project is also shown. Develop a model...
A city government feels that energy production capacity must be expanded to meet anticipated demands for...
A city government feels that energy production capacity must be expanded to meet anticipated demands for energy. Three alternatives sources are being considered. a. A nuclear facility with an investment of $250 million, operating costs of $3 million per year and life of 20 years. b. A coal plant with an investment of $200 million, operating costs of 10 million per year and a life of 20 years. c. A natural gas plant with a cost of $100 million, operating...
A common stock is expected to pay no dividends during the next 7 quarters but at...
A common stock is expected to pay no dividends during the next 7 quarters but at the end of 6th quarter, it is expected to pay DPS of $1.0 and thereafter dividends are expected to be paid quarterly and into indefinite future. The quarterly growth rate of dividends stream is 1.0% and it is expected to stay the same into indefinite future. The required expected rate of return on the common stock is 12% per annum. Find: (i)The current price...
The budgeted sales for the next four quarters are £192,000, £288,000, £288,000 and £336,000 respectively. It...
The budgeted sales for the next four quarters are £192,000, £288,000, £288,000 and £336,000 respectively. It is estimated that sales will be paid for as follows:-75% of the total will be paid in the quarter that the sales were made. Of the balance 50% will be paid in the quarter after the sale was made. The remaining 50% will be paid in the quarter after this. The amount of cash received in the third quarter will be:
Dade Industries makes syringes. The demand for the next four quarters and the cost data are...
Dade Industries makes syringes. The demand for the next four quarters and the cost data are given below. Each employee can produce 100 syringes per quarter. Because of union contract no overtime is permissible. The current work force is 18 workers. Quarter 1 2 3 4 Demand 1500 2000 1800 2500 Hiring costs = $1000/ worker; Layoff costs = $ 700/worker; Regular time wages = $10000/worker/quarter; Inventory holding costs = $2.00/unit/quarter For a level strategy in this manufacturing example: Which...
Describe how Microsoft keep enough inventory quantities on-hand during uncertainties to meet the growing customer demands...
Describe how Microsoft keep enough inventory quantities on-hand during uncertainties to meet the growing customer demands at the same time of reducing inventory costs to provide cost savings to Microsoft
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2...
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows:   Q1   Q2   Q3   Q4   Sales $ 190 $ 210 $ 230 $ 260 Sales for the first quarter of the year after this one are projected at $205 million. Accounts receivable at the beginning of the year were $81 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 50 percent of the next quarter’s forecast sales, and suppliers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT