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

Gaussian process, The generalization of the normal distribution used for th...

The generalization of the normal distribution used for the characterization of functions. It is known as a Gaussian process because it has Gaussian distributed finite dimensional m

Probability, show all the ways in which 3 games of football can be conclude...

show all the ways in which 3 games of football can be concluded(it can be a win W,a loss L,or a draw X)

Bayesian confidence interval, Bayesian confidence interval : An interval of...

Bayesian confidence interval : An interval of the posterior distribution which is so that the density of it at any point inside the interval is greater than that of the density at

Design matrix, It is used generally for the matrix which specifies a statis...

It is used generally for the matrix which specifies a statistical model for a set of observations. For instance, in a one-way design with the three observations in one group, tw

Lagrange multipliertest, The Null Hypothesis - H0:  There is autocorrelatio...

The Null Hypothesis - H0:  There is autocorrelation The Alternative Hypothesis - H1: There is no autocorrelation Rejection Criteria: Reject H0 (n-s)R 2 > = (1515 - 4) x (0.

Infant mortality rate, Infant mortality rate is the ratio of the number of...

Infant mortality rate is the ratio of the number of deaths during the calendar year among the infants under one year of age to the total number of live births during that particul

Decision tree, The graphic representation of the alternatives in a decision...

The graphic representation of the alternatives in a decision making problem which summarizes all the possibilities foreseen by the decision maker. For instance, suppose we are give

Baddeley''smetric, Baddeley'smetric : A manner of measuring the 'error' in ...

Baddeley'smetric : A manner of measuring the 'error' in the image processing technique or method. The metric is derived using the fundamental theory from the stochastic geometry an

Generalized additive models, Models which make use of the smoothing techniq...

Models which make use of the smoothing techniques such as locally weighted regression to identify and represent the possible non-linear relationships between the explanatory and th

Explain lancaster models., Lancaster models : The means of representing the...

Lancaster models : The means of representing the joint distribution of the set of variables in terms of the marginal distributions, supposing all the interactions higher than a par

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