Reapply L Refresh All Properties Edit Links Stocks Geograd Al Sort Filter Consolidate Advanced Text to Flash Remove Columns FHDuplicates Validation From From New Database HTML Text Query J16 Axfx 500 While you mu B D E G H 1 Using Solver for Constraints /10 points 2 3 Austin Enterprises makes and sells three types of phones. Management is trying to determine the most profitabe mi. Sales price, 4 demand, and use of manufacturing inputs follows: 5 6 Standard Premium The company faces the following constraints: 7 Sales Price $ 300 $ 410 S 500 Minimum producton unit 800 800 8 Direct Labor Hours 5,000 9 input requirements per unit Machine Hours (MH) 6.000 10 Direct materials (Cost) $ 30$ 405 80 11 Direct labor hours 12 3.0 1.5 Machine Hours 1.0 1.0 Number of Phones REQUIRED Standard Premium 13 14 Costs What sales mix will optimize profits? 15 Fixed costs 16 Manufacturing $ 200,000 What is the profit NOT this level of sales? 17 Marketing 80,000 1R Administration 120,000 19 20 Variable costs 21 Direct labor cost per hour) 25 22 Factory overhead per MH) 15% 23 Marketing percent of sales price) 24 25 26 22 28 23 30 32 34 35 37 40 42 43 Constrained Resources Regression Analysis Target Profit Absorption vs Variable Costing