Lights Aglow makes desk lamps and floor lamps, on which the profits are $2.65 and $4.67, respectively. The company has 1200 hr of labor and $4200 for materials each week. A desk lamp takes 0.8 hr of labor and $4 for materials; a floor lamp takes 1.0 hr of labor and $3 for materials. What production policy maximizes profit? How, if at all, do the maximum profit and optimal production policy change if Lights Aglow wants to produce at least 150 desk lamps and 200 floor lamps per week?

Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40   a)  Generate the Answer Report using SOLVER in EXCEL.  Then, clearly answer what is the optimal solution?  What is the resulting profit? b) Generate the Sensitivity Report for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints.  Include units in your interpretations.

A company has $11,270 available per month for advertising. Newspaper ads cost $180 each and can't run more than 21 times per month. Radio ads cost $570 each and can't run more than 34 times per month at this price. Each newspaper ad reaches 7200 potential customers, and each radio ad reaches 7800 potential customers. The company wants to maximize the number of ad exposures to potential customers. Use n for number of Newspaper advertisements and r for number of Radio advertisements. subject to Maximize P - 21 <34 <$11, 270 Enter the solution below. If needed, round ads to 1 decimal palace and group exposure to the nearest whole person. Number of Newspaper ads to run is Number of Radio ads to run is Maximum target group exposure is people