Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

# system of control Consider an (s, Q) system of control for a single item and with normally distributed forecast error. The managementwish to have an expected number of stockout occasions per year equal to N. The following model represents suchcontrol system where the cost function is minimized subject to the constraint given on the number of stockout occasionsper year.Q ADTC(k , Q) k L vr2 Qsubject toDpu (k ) NQThe two simultaneous equations that Q and K must satisfy if the management wishes to minimize the total expectedcosts of replenishment and carrying inventory subject to the expected number of stockout occasions per year being N areQpu (k ) ND12 AD 2N LQ 1vr Dfu (k )The characteristics of the item under consideration are:A= \$5 r= 0.16/yr v= \$2/unit D= 1000 units/year L= 80 units N= 0.5/yearUsing Microsoft Excel find the followingsa) Simultaneous best (Q, K) pairs and the associated total cost for this policy.b) If the policy is changed to be B1-costing at B1 = \$100, what are the best (Q, k) pairs and the associated totalcost?Note that,1- fu(k) and pu (k) can be found using the Excel function NORM.DIST2- The inverse cumulative normal distribution function that finds k can be found using the Excel functionNORM.S.INV.3- Stop iterating at two decimal numbers accurate resultsThe Excel sheet should be submitted as a hard copy with your solution of this assignment, and a soft copy of the Excelsheet should be submitted electronically using Electronic Assignment Submission https://fis.encs.concordia.ca/eas/1Problem 2Consider a family of four items with the following characteristicsA= \$100, r= 0.2/ yearItem i DiVi (\$/year) ai (\$)1 100,000 52 20,000 53 1,000 21.54 300 5a) Using the iterative algorithm given in the class find appropriate values of the cycle time T1 and the integermultiplier associated with each item i.b) Suppose that we restricted attention to the case where every item is included in each replenishment of thefamily. What does this says about the multipliers? Find the best value of T1.c) Find the cost difference in the answers to part a and b.Problem 3The Steady-Milver Corporation produces ball bearings. It has a family of three items, which run consecutively, do nottake much time for changeovers. The characteristics of the items are as follows:Item i ID Di Raw Value Value after ai (\$)(units/year) material added production(\$/unit) (\$/unit) vi (\$/unit)1 BB1 2000 2.50 0.50 3.00 52 BB2 1000 2.50 0.50 3.00 23 BB3 500 1.60 0.40 2.00 1The initial setup cost for the family is \$30. Management has agreed on an r value of 0.10\$/\$/yr. Production rates aresubstantially larger than demand rates.a) What are the preferred production quantities of the three items?b) Raw material for product BB1 is acquired from a supplier distinct from that for the other two products. Supposethat the BB1 supplier offers an 8 percent discount on all units if an order of 700 or more is placed. ShouldSteady-Milver take the discount offer?N NA a1 ai / ni T1 ( 1 n)i i Ni 2 i 2Note that the total cost is C Di viT1 2 i 22Problem 4Consider five products produced in the same machine. Various data are given in the table.Product 1 2 3 4 5Demand per week 900 1000 1000 500 1500Production rate per week 13,000 15000 11000 9000 18,000Setup time in weeks 0.0071 0.0214 0.0142 0.0142 0.0071Ordering costs 25 25 5 10 50Holding cost per unit and week 2 1 5 3 4a) Check whether the independent solution is feasible or not. Find the total cost, is it a lower bound or theoptimal cost?b) Use a cyclic schedule with a common cycle. Determine batch quantities and the total cost.c) Assuming a power of two multipliers policy, use Doll and Whybark iterative algorithm to find afeasible convergent solution. How far is this solution from the cost obtained in part a?

system of control

Consider an (s, Q) system of control for a single item and with normally distributed forecast error. The management
wish to have an expected number of stockout occasions per year equal to N. The following model represents such
control system where the cost function is minimized subject to the constraint given on the number of stockout occasions
per year.
TC(k , Q) k L vr
2 Q
subject to
D
pu (k ) N
Q
The two simultaneous equations that Q and K must satisfy if the management wishes to minimize the total expected
costs of replenishment and carrying inventory subject to the expected number of stockout occasions per year being N are
Q
pu (k ) N
D
1
Q 1
vr Dfu (k )
The characteristics of the item under consideration are:
A= \$5 r= 0.16/yr v= \$2/unit D= 1000 units/year L= 80 units N= 0.5/year
Using Microsoft Excel find the followings
a) Simultaneous best (Q, K) pairs and the associated total cost for this policy.
b) If the policy is changed to be B1-costing at B1 = \$100, what are the best (Q, k) pairs and the associated total
cost?
Note that,
1- fu(k) and pu (k) can be found using the Excel function NORM.DIST
2- The inverse cumulative normal distribution function that finds k can be found using the Excel function
NORM.S.INV.
3- Stop iterating at two decimal numbers accurate results
The Excel sheet should be submitted as a hard copy with your solution of this assignment, and a soft copy of the Excel
sheet should be submitted electronically using Electronic Assignment Submission https://fis.encs.concordia.ca/eas/
1
Problem 2
Consider a family of four items with the following characteristics
A= \$100, r= 0.2/ year
Item i DiVi (\$/year) ai (\$)
1 100,000 5
2 20,000 5
3 1,000 21.5
4 300 5
a) Using the iterative algorithm given in the class find appropriate values of the cycle time T1 and the integer
multiplier associated with each item i.
b) Suppose that we restricted attention to the case where every item is included in each replenishment of the
family. What does this says about the multipliers? Find the best value of T1.
c) Find the cost difference in the answers to part a and b.
Problem 3
The Steady-Milver Corporation produces ball bearings. It has a family of three items, which run consecutively, do not
take much time for changeovers. The characteristics of the items are as follows:
Item i ID Di Raw Value Value after ai (\$)
(\$/unit) (\$/unit) vi (\$/unit)
1 BB1 2000 2.50 0.50 3.00 5
2 BB2 1000 2.50 0.50 3.00 2
3 BB3 500 1.60 0.40 2.00 1
The initial setup cost for the family is \$30. Management has agreed on an r value of 0.10\$/\$/yr. Production rates are
substantially larger than demand rates.
a) What are the preferred production quantities of the three items?
b) Raw material for product BB1 is acquired from a supplier distinct from that for the other two products. Suppose
that the BB1 supplier offers an 8 percent discount on all units if an order of 700 or more is placed. Should
N N
A a1 ai / ni T1 ( 1 n)
i i N
i 2 i 2
Note that the total cost is C Di vi
T1 2 i 2
2
Problem 4
Consider five products produced in the same machine. Various data are given in the table.
Product 1 2 3 4 5
Demand per week 900 1000 1000 500 1500
Production rate per week 13,000 15000 11000 9000 18,000
Setup time in weeks 0.0071 0.0214 0.0142 0.0142 0.0071
Ordering costs 25 25 5 10 50
Holding cost per unit and week 2 1 5 3 4
a) Check whether the independent solution is feasible or not. Find the total cost, is it a lower bound or the
optimal cost?
b) Use a cyclic schedule with a common cycle. Determine batch quantities and the total cost.
c) Assuming a power of two multipliers policy, use Doll and Whybark iterative algorithm to find a
feasible convergent solution. How far is this solution from the cost obtained in part a?

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?