Need answers on Excel please.

Problem 1: (p. 668) A small firm produces two types of wooden lamp stands: rounded and angular. Both types require two hand-crafted processes: cutting and smoothing. Rounded lamp stands require 1 hour of cutting and 3 hours of smoothing whereas angular lamp stands require 2 hours of cutting and only 1 hour of smoothing. The firm has 400 man-hours of cutting available each week and 300 man-hours of smoothing. The firm calculates that they make $3 profit on each rounded lamp stand and $4 profit on each angular lamp stand. How many rounded and angular lamp stands should they manufacture each week in order to maximize profit? Problem 2: (p.668) A cookie factory makes two brands of biscuit. A batch of standard biscuits takes 20kg of flour and 2kg of butter, whereas a batch of deluxe biscuits requires 10kg of flour and 5kg of butter. The firm makes a profit of $2 on a batch of standard biscuits and a profit of $6 on a batch of deluxe biscuits. The company has at most 200kg of flour and 40kg of butter available each day. How many batches of standard and deluxe biscuits should the factory produce each day in order to maximize profit? Problem 3: (p. 668) A firm has 1000 man-hours available each week for manufacturing and can spend up to $700 a week on raw materials. They produce on 2 products: tankards and mugs. It takes 2 man-hours to manufacture a tankard and 1 man-hour to manufacture a mug and it costs $1 in raw materials to make either a tankard or a mug. The firm makes $2 profit on each tankard and $1.50 profit on each mug. How many of each product should the firm manufacture each week in order to maximize profits? Problem 4: (p. 671) Hoopers Home Improvements manufacture 4 products: glass doors, windows, patio doors, and solid doors. Each of these uses 5 square meters, 1 square meter, 9 square meters, and 12 square meters respectively of wood and 2, 3, 4, and 1 square meters respectively of glass. It takes 3 man-hours to build a glass door, 2 man-hours for a window, 5 for a patio door, and 10 for a solid door. Altogether 1500 square meters of wood and 1000 square meters of glass are available each week and the 20 employees all work a 40 hour week. Further, to satisfy orders Hoopers will have to make at least 40 glass doors, 130 windows, and 30 patio doors, although because of diminishing popularity they have decided to make at most 10 solid doors. Hoopers estimate the profit on a glass door to be $12, on a window to be $5, on a patio door $15, and on a solid door $10. How many of each product should Hoopers make each week in order to maximize profit? Problem 5: (p. 675) Ballester Electronics supplies each of four computer manufacturers with a particular chip which can be produced at any one of three of their factories. As the factories are in different areas it costs $0.93 to produce a chip at Factory 1, $1.05 at Factory 2, and $1.02 at Factory 3. The monthly production capacity at Factory 1 is 9000 chips, at Factory 2 is 10 000 chips, and at Factory 3 is 8000 chips. Sales forecasts project a monthly demand of 5100, 7200, 8000, and 5800 components for each of the computer manufacturers respectively. Ballester would like to find out how many microchips should be made at each factory to transport to each of the computer manufacturers. The transportation costs per chip are shown below: Factory Company A Company B Company C Company D 1 $0.13 $0.11 $0.09 $0.13 2 $0.16 $0.12 $0.11 $0.17 3 $0.10 $0.14 $0.10 $0.15 How many of each chip should be made at each Factory for shipment to each Company