Question 23 1 pcs 4 4 Use the information below to answer SIX questions. A manufacturer sells two types of products. Product 1 is sold at a price of $ 40 per unit and product 2 at a price of $50 per unit. Four units of raw materials and 1 labor Hour are needed to manufacturer one unit of product 1. Ten units of raw materials and 4 labor hours are need to manufacture one unit of product 2. The unit variable cost for product 1 is $30, and for product 2 is $20. A total of 15,000 units of raw material and 10,000 labor hours are available. If any product 1 is produced, a setup cost of $20,000 is incurred; if any product 2 is produced, a setup cost of $35,000 is incurred. Using Excel, we get the following optimal solution (screenshot) which maximizes the manufacturer's profit. B D 2 Product 1 Product 2 3 Selling price/unit $40 $50 4 Variable cost/unit $30 $20 5 Fixed cost (setup) $20,000 $35,000 6 Labor hours/unit 1 7 Raw Material/unit 10 8 Production plan, constraints on capacity 9 Product 1 Product 2 10 Rent equipment (0/1) 11 Units produced # 3750 12 3750 0 13 Logical upper limit 14 Constraints on resources Available Resource used 15 10000 3750.00 16 Labor hours 15000 15000.00 17 Raw Materials 18 Outputs 19 Revenue $150,000 20 Variable cost $112,500 21 Fixed cost for equipment $20,000 22 Profit Hide 1 0 0 C LOO Sto sharing $50 $20 $35,000 4 10 4 Product 2 0 0 C 3. Selling price/unit $40 4 Variable cost/unit $30 5 Fixed cost (setup) $20,000 6 Labor hours/unit 1 7 Raw Material/unit 8 Production plan, constraints on capacity 9 Product 1 10 Rent equipment (0/1) 1 11 Units produced # 3750 12