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

Dirichlet process mixture models, The nonparametric Bayesian inference appr...

The nonparametric Bayesian inference approach to using the finite mixture distributions for modelling data suspected of the containing distinct groups of observations; this approac

Quatitative methods, An oil company is considering whether or not to bid fo...

An oil company is considering whether or not to bid for an offshore drilling contract. If they bid, the value would be $600m with a 65% chance of gaining the contract. The company

Method of moments, Method of moments   is the procedure for estimating the...

Method of moments   is the procedure for estimating the parameters in a model by equating sample moments to the population values. A famous early instance of the use of the proced

Describe law of likelihood, Law of likelihood : Within framework of the sta...

Law of likelihood : Within framework of the statistical model, a particular set of data supports one statistical hypothesis or assumption better than another if the likelihood of t

Function of Power, In an experiment, power is a function of 1. The number o...

In an experiment, power is a function of 1. The number of variables being measured and the beta level 2. The effect size, internal validity and the beta level 3. The number of part

Public network, This is given by common network e.g. Phone Company. The pub...

This is given by common network e.g. Phone Company. The public networks are those networks, which are given by common carriers. It can be a telephone company or an other organizati

Friedman''s two-way analysis of variance, The distribution free or techniqu...

The distribution free or technique which is the analogue of the analysis of variance for the design with two factors. It can be applied to data sets which do not meet the assumptio

Describe prior distribution, Prior distributions : The probability distribu...

Prior distributions : The probability distributions which summarize the information about a random variable or parameter known or supposed at a given time instant, prior to attaini

Dorfman scheme, An approach to investigations designed to recognize a parti...

An approach to investigations designed to recognize a particular medical condition in the large population, usually by means of a blood test, which might result in the considerable

Pascal''s triangle, Pascal's triangle  is an arrangement of numbers describ...

Pascal's triangle  is an arrangement of numbers described by Pascal in his Traité du Triangle Arithmétique published in the year 1665 as 'The number in each cell is equal to in the

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