Develop an algebraic linear programming model, Advanced Statistics

Assignment Help:

Duck Lovers Unlimited (DLU) Inc. assembles specially configured light jet aircrafts for airborne duck hunting. The quarterly demand forecasts for the upcoming fiscal year are:

Quarter:                      1                        2                      3                  4               

Forecast (units):         11                       17                     8                  15

It takes an average of 2500 direct labor hours to assemble each aircraft. Currently, 48 full-time production workers are employed by DLU, working a single 8-hour shift each day. As of now, there is no inventory of completed or semi-finished units. Demand backlogging is possible, but 20% of backlogged demand eventually turns out to be lost sales, representing an opportunity loss of $80,000 per unit (aircraft). Under-time or overtime work may be resorted to, the latter being restricted to 4 hours per day for each worker. The average regular time labor wage rate is $10/hour, with a 50% premium for overtime work. Finished goods inventory holding costs are $16,000/unit/year and backordering costs are estimated to be $9,500/quarter for each aircraft. The inventory holding and backlogging costs, if any, are charged to end-of-quarter finished goods inventories and backorders, respectively. The workforce size can be varied through hires or layoffs (done at the beginning of any quarter) at $3,200 or $3,000, respectively, per worker. For simplicity, assume that there are about 500 regular-time hours in a typical quarter. Material and overhead costs per aircraft amount to $20,000. 

(a) Using the information given above, develop a minimum-cost, 4-quarter aggregate sales and operations plan (SOP) for DLU, such that the workforce size is constant throughout the year (after initial hires or layoffs, as necessary), allowing no overtime, backorders, lost sales or part-time employees. Summarize your SOP in a tabular format shown below and compute the resulting total relevant cost for the next fiscal year.

Demand          Production      Ending Inventory        Workforce

Quarter      (Units)                (Units)                (Units)                 (No. of Workers)

      1               11

      2               17

      3                8

      4               15                                                                                                   _

(b) In order to cope with demand uncertainty, DLU management has decided on a safety stock policy, requiring that at the end of each quarter, the planned finished goods inventory be at least 10% of that quarter's demand forecast. Repeat part (a) with this policy in effect.

(c) Removing all restrictions outlined in part (a), but with the safety stock policy (b) in effect, develop an algebraic linear programming model ( i.e. clearly define all decision variables used and formulate the objective function and all constraints) for determining the optimal SOP for DLU. Solve this model using Excel/Solver, showing the optimal aggregate plan and the resulting minimum total relevant cost for the next fiscal year.


Related Discussions:- Develop an algebraic linear programming model

Matching, Matching is the method of making a study group and a comparison ...

Matching is the method of making a study group and a comparison group comparable with respect to the extraneous factors. Generally used in the retrospective studies when selecting

Develop an algebraic linear programming model, Duck Lovers Unlimited (DLU) ...

Duck Lovers Unlimited (DLU) Inc. assembles specially configured light jet aircrafts for airborne duck hunting. The quarterly demand forecasts for the upcoming fiscal year are:

Quota sample, Quota sample is the sample in which the units are not select...

Quota sample is the sample in which the units are not selected at the random, but in terms of a particular number of units in each of a number of categories; for instance, 10 men

Paired availability design, Paired availability design  is a design which c...

Paired availability design  is a design which can lessen selection bias in the situations where it is not possible to use random allocation of the subjects to treatments. The desig

Statistcal computing flow charts for sums, 1. define statistical algorithms...

1. define statistical algorithms 2. write the flow charts for statistical algorithms for sums, squares and products. 3. write flow charts for statistical algorithms to generates ra

Fractional factorial design, Designs in which the information on main effec...

Designs in which the information on main effects and low-order inter- actions are attained by running only the fraction of the complete factorial experiment and supposing that part

Cross-sectional study, A study not involving the passing of time. All infor...

A study not involving the passing of time. All information is collected at the same time and subjects are contacted only once. Many surveys are of this type. The temporal sequence

Residual, regression line drawn as Y=C+1075x, when x was 2, and y was 239, ...

regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Explain human height growth curves, Human height growth curves : The growth...

Human height growth curves : The growth of human height is, in common, remarkably regular, apart from the pubertal growth spurt. The satisfactory longitudinal development curve is

Tests for heteroscedasticity, The Null Hypothesis - H0: There is no heteros...

The Null Hypothesis - H0: There is no heteroscedasticity i.e. β 1 = 0 The Alternative Hypothesis - H1:  There is heteroscedasticity i.e. β 1 0 Reject H0 if nR2 > MTB >

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd