Requirements for Project.
A company produces three types of switches – S1, S2,
and S3 – and supplies them to a retailer. It is
contractually obligated to meet the demands of the retailer for each
type of switch. Because of limited capacity the company may not have
sufficient machining, assembly, and finishing time available to
satisfy the entire demand in each period through in-house
production alone. Contractual obligation requires the company to make
up the shortfall in production by procuring it from an external
supplier at higher costs. The company aims to meet the retailer’s
demands at minimum cost.
LP Formulation:
|
Task 1: Formulate |
Specifically, you must define the decision variables, objective
function, and constraints in your LP model using the following
parameters:
In each time period, for each product :
-
is the demand (number of units required) for product .
-
is the cost (in dollars) for producing each unit of product .
-
is the cost (in dollars) for procuring each unit of product from
the external supplier. -
is the machining time (in minutes) required to produce each unit of
product . -
is the assembly time (in minutes) required to produce each unit of
product . -
is the finishing time (in minutes) required to produce each unit of
product .
Further, assume that:
-
hours of machining time is available for regular run.
-
hours of assembly time is available for regular run.
-
hours of finishing time is available for regular run.
LP Parameter Estimation:
You must now use available data to estimate the parameters of the LP
formulated in Task 1.
Estimation of , , , and :
The CSV file “production.csv” contains 15,000 records with
6 columns: SerialNo, ProductCode, MachineTime,
AssemblyTime, FinishTime, and Cost. SerialNo
is a unique identifier assigned to each unit produced by the company;
ProductCode specifies the product type; MachineTime,
AssemblyTime, and FinishTime specify the time (in
minutes) taken by each process (machining, assembly, and finishing)
to produce a unit; the last attribute, Cost, specifies the
cost (in dollars) of producing the unit in-house.
|
Task 2: Use the data from the “production.csv” file to |
Specify your parameter estimates in the table below. Round all
estimates to 1 decimal place.
|
Estimates |
Product |
||
|
Parameters |
S1 |
S2 |
S3 |
|
Machine Time |
|||
|
Assembly |
|||
|
Finish Time |
|||
|
Production |
Estimation of demand
The CSV file “demand.csv” contains the retailer’s sales
data for the three switches over the last 52 time periods. For
example, the first row shows that 463 units of S1 were sold in
time period 1, and the last row shows that 629 units of S3
were sold in time period 52.
|
Task 3: Use |
In your report, please present the estimates for time period 53 in
the following format:
|
Product |
S1 |
S2 |
S3 |
|
Demand () in |
The cost of procuring each product from the external supplier is
specified below:
|
Product |
S1 |
S2 |
S3 |
|
Procurement |
$ 185 |
$230 |
$300 |
Optimal LP Solution:
|
Task 4: Solve |
Report the minimum cost achievable, number of units of each product
type to be produced in-house, the number of units of each product
type to be procured from the external supplier, and the resources
used during production in the following format:
|
Minimum cost |
|
Number of units |
S1 |
S2 |
S3 |
|
Produced |
|||
|
Procured from |
|
Resources used |
Minutes used |
|
MACHINE TIME |
|
|
ASSEMBLY TIME |
|
|
FINISH TIME |
Sensitivity Analysis:
|
Task 5. Perform By how much does the total production cost change as the demand At most how much should the company be willing to pay to Increase the availability of machining time by one hour during Increase the availability of finishing time by one hour during Increase |
Quality Control
The CSV file “quality.csv” contains 5 columns containing
data from quality control tests run on 1500 batches of items
produced. The first column Quality specifies whether a batch
is of good quality or poor quality; the next four
columns Test1, Test2, Test3, and Test4
contain numerical values representing the measurements on four
quality control tests.
|
Task 6: Use the data from “quality.csv” to train and test a |
Specify the rules that you obtained in Task 6 in the canonical form:
IF …. THEN …
Present the classification accuracy of this set of rules for the
training and test sets set in the form:
Results with training data: Accuracy = ……%
|
Number of |
Actually Poor |
Actually Good |
|
Predicted Poor |
||
|
Predicted Good |
Results with test data: Accuracy = …….%
|
Number of |
Actually Poor |
Actually Good |
|
Predicted Poor |
||
|
Predicted Good |
Optional: You may also try using other classifiers for
this classification task and comment on the results.
The post Requirements for Project appeared first on My Assignment Online.