Can you please help me solve this using Excel Solver? Thank you!

outside supplier. Manufacturing and purchase costs per unit are shown. LetFMFPSMSPTMTP=numberofframesmanufactured=numberofframespurchased=numberofsupportsmanufactured=numberofsupportspurchased=numberofstrapsmanufactured=numberofstrapspurchased FM,FP,SM,SP,TM,TP0. b. What is the total cost of the manufacturing and purchasing plan? When required, round your answer to the nearest dollar. $ c. How many hours of production time are used in each department? d. How much should Frandec be willing to pay for an additional hour of time in the shaping department? $ e. Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this o Why or why not? The input in the box below will not be graded, but may be reviewed and considered by your instructor. outside supplier. Manufacturing and purchase costs per unit are shown. LetFMFPSMSPTMTP=numberofframesmanufactured=numberofframespurchased=numberofsupportsmanufactured=numberofsupportspurchased=numberofstrapsmanufactured=numberofstrapspurchased FM,FP,SM,SP,TM,TP0. b. What is the total cost of the manufacturing and purchasing plan? When required, round your answer to the nearest dollar. $ c. How many hours of production time are used in each department? d. How much should Frandec be willing to pay for an additional hour of time in the shaping department? $ e. Another manufacturer has offered to sell frames to Frandec for $45 each. Could Frandec improve its position by pursuing this o Why or why not? The input in the box below will not be graded, but may be reviewed and considered by your instructor