SHOW WORK ON EXCEL STEPS BY STEPS.

m 4-17 (Algorithmic) de Compony man from four components. any manufactures, sembles, and rebuilds materar una c components: trama, a motor. O 30tors, and metal strat de motors from an outside supplies, but the frames were and stress nay teen purchase costs per unit are shown rdioton Component Manufacturing Cost Purchase Cost about on maalauren by the c top ou called a master is er test e re a rbune si cu Frame Support Strap $39.00 $12.50 $9.50 $55.00 $18.00 $10.50 Three carments are involved in the production of these capacity (in hours) for the three departments are as follows bonents. The time t o r each methachoenen Department Component Cutting Milling Shaping Frame Support 1.5 1.9 2.8 Strap Capacity (hours380 450 700 a Formulate and solve a linear programming model for woman of Bact component should be manufactured and a sh u FM number of frames manufactured F - number of frames purchaser SM - number of supports manufacturer SP number of supports purchased TM number of straps manufactured " P umber of straps purchased SM SML F1, FF, SM, ST, TM, TP 23 If regred, round your answers to the nearest le number. If an imant is zo', erter o Manufacture Purchase Frames Supports ung you answer in the redrest diar, b. Whet is the total cost of the manufacturing and punna sing plan when required, required, uns you are owe cecrel places c. How many hours of production lite are used in each department Hours of broduction Department time used hou's Cutting hours Milling hours Shaping were the reaso How much should Frandet be willing to pay for an actional hour of time in the shaping depart frared, read you amount is zero, entero" m 4-17 (Algorithmic) de Compony man from four components. any manufactures, sembles, and rebuilds materar una c components: trama, a motor. O 30tors, and metal strat de motors from an outside supplies, but the frames were and stress nay teen purchase costs per unit are shown rdioton Component Manufacturing Cost Purchase Cost about on maalauren by the c top ou called a master is er test e re a rbune si cu Frame Support Strap $39.00 $12.50 $9.50 $55.00 $18.00 $10.50 Three carments are involved in the production of these capacity (in hours) for the three departments are as follows bonents. The time t o r each methachoenen Department Component Cutting Milling Shaping Frame Support 1.5 1.9 2.8 Strap Capacity (hours380 450 700 a Formulate and solve a linear programming model for woman of Bact component should be manufactured and a sh u FM number of frames manufactured F - number of frames purchaser SM - number of supports manufacturer SP number of supports purchased TM number of straps manufactured " P umber of straps purchased SM SML F1, FF, SM, ST, TM, TP 23 If regred, round your answers to the nearest le number. If an imant is zo', erter o Manufacture Purchase Frames Supports ung you answer in the redrest diar, b. Whet is the total cost of the manufacturing and punna sing plan when required, required, uns you are owe cecrel places c. How many hours of production lite are used in each department Hours of broduction Department time used hou's Cutting hours Milling hours Shaping were the reaso How much should Frandet be willing to pay for an actional hour of time in the shaping depart frared, read you amount is zero, entero