Management report based on quantitative method of analysis

I/INTRODUCTION This report based on quantitative method of analysis to examine manufacturing figures and to find solutions to fulfil the contract at minimum cost. II/ANALYSED DETAILS 1. Minimise the cost: How much to buy in - how much to produce? Both vats of type A and type B take 2 hours to dye a quantity of fibre that can eventually be turned sufficient fibre into yarn to make a metre of standard width cloth. We …

…B take 2 hours to turn sufficient fibre into yarn such that one metre of standard width cloth can be made. There are 600 hours available for vats of type A and 800 hours available for vats of type B so there are 1400 hours available for vats of both types. Suppose every week we can make X metres, buy in Y metres of yarn 2*X <= 1400 4*X <=1280 5*X <=1700 X, Y>=0 Minimise 15*X+21*Y EXCEL SOLVER