Plan a factory schedule for an extended period of time

Assignment Help Applied Statistics
Reference no: EM131745384

Linear Programming Approach to Aggregate Planning

Introduction

In the class we have dealt with meeting the demand by managing the inventory (by ordering from outside or producing our own items) for a single period of time. In this case study, you are going to use linear programming as a tool to extend what you have learnt about inventory models and to plan a factory schedule for an extended period of time (3 months).

Aggregate planning is an approach that is used to provide a plan for the production process, in advance of 2 to 18 months, so that the management has an idea about the required resources (raw materials, man power, inventory space, etc.) that are needed to produce their products at minimum operational costs.

The quantities of produced (regular and overtime), outsourced, backlogged and held in inventory items, and the number of hired and fired workers in each periods, for each period, are need to be decided in advance.

In order to apply aggregate planning approach, the followings are needed:

- Information about the available resources and their capacities.

- Demand forecast for the planning period.

- Different costs involved, such as unit regular time cost, unit over time cost, shortage cost, inventory cost, etc.

- And other organizational policies that affect the planning.

Case Study Description -

A steel company operates a foundry. The foundry casts three types of steel rolls that are machined in its machine shop. Machined rolls are used by other companies in their mills to manufacture various products. At the beginning of each quarter, the companies prepare their monthly needs of steel rolls and submit them to the foundry. The foundry manager then draws a production plan that is essentially constrained by the machining capacity of the shop. The foundry can directly purchase the rolls at a premium price from outside sources. A comparison between the cost per roll when acquired from the foundry and its outside purchase price is given in Table 1. Unit shortage cost is shown in Table 1 as well.

The processing time for each roll type is shown in Table 2. The estimated demand for the rolls is shown in Table 3.

Table 1.

Steel Roll
Type

Regular Time
Cost ($ per roll)

Over Time Cost
($ per roll)

Outsourcing Cost
($ per roll)

Shortage Cost
($ per roll)

Holding Cost
($ per roll per
month)

1

90

100

108

90

4

2

130

135

145

130

5

3

180

188

194

180

6

Reference no: EM131745384

Questions Cloud

Problem on univariate data classifications : Univariate Data Classifications Classify each data set as categorical, discrete, or continuous. A random sample of Hudson River ferry trips is obtained.
Time required for associate to fill an order for shipment : Find a confidence interval for the average time required for an associate to fill an order for shipment.
Discuss governments to help aid the poverty issues : Foreign aid money is being allocated to governments to help aid the poverty issues. These governments are using the money elsewhere to line their own pockets
Institutions have method of providing loans and aides : International lending institutions have method of providing loans and aides and each one of them have huge challenge in their approach
Plan a factory schedule for an extended period of time : you are going to use linear programming as a tool to extend what you learnt about inventory models and to plan a factory schedule for an extended period of time
Define altruistic behavior in our communities : what are the implications of this in terms of increasing altruistic behavior in our communities
About the business planters : Business Planters helps new businesses get started. Consumers are projected to spend a lot on Internet purchases during the next three years.
Construct a frequency distribution for the given data : Psychology and Human Behavior A random sample of patrons visiting the Rena Branston Gallery in San Francisco was obtained, and each was asked the type.
Define anticipates a medium effect size : This power researcher plans to conduct a study to compare two groups. Based on previous research, she anticipates a medium effect size

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

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