D E F G H 1 J A B 1 Apple (Asia) 3-month plan 2 Revenue Minimum Production 5.000 Production Levels 3 4 Power Mac G4 5 Powerbook G4 6 iMac 7 iBook Production Production Cost Hours $ 2.625 8 $ 3.750 10 $ 1.500 7 $ 2.250 5 $ 3.750 $ 5.000 $ 2.500 $ 3.125 Market Demand 25.000 15.000 25.000 15.000 5.000 5.000 5.000 8 9 Used Hours Budget (hours) 10 300.000 11 12 13 Production Cost Budget (money) $0 $158.250.000 14 15 16 17 18 Revenue Production Cost Profit $0 $0 $0 13 14 2 8 15 9 After your success in the manufacturing plant in Ireland, Apple decided to send you to China factory that serves Asia. Use the information in the Data to answer the following questions. Consider the data from the 'Data' sheet of this workbook. Consider the profits for each product (revenue - cost per product) and decide production levels by prioritizing the products according to their profits (also known as Patrick's way). What would be the production level of Power Mac G4? Use the Solver tool to find the optimal production levels with the given constraints. What is the profit in the optimal production? The brilliant newly graduated assistant, who did not take BUS 101 course, suggested that the Apple should produce exactly 80% of the market demand for each item. (Suppose use can use unlimited overtime!) How much overtime should Apple use to satisfy this production plan? (You are not supposed to think about the cost of overtime for this part!) If the hourly fee of overtime is $15, does Apple have enough budget to fund this b) production plan? (Choose Yes or No! The marketing department reports that for price change less than $300, every $100 drop in the price of any product increases the market demand by 3500 units and vice versa (i.e. elasticity = 35). Price and price change values should be integers! Use the Solver tool to find the optimal production levels with the given constraints. The board approved a change only in the price of Powerbook G4. What is the new price of Powerbook G4 in the optimal production? 16 4 17 2 18 10 19 4 20 D E F G H 1 J A B 1 Apple (Asia) 3-month plan 2 Revenue Minimum Production 5.000 Production Levels 3 4 Power Mac G4 5 Powerbook G4 6 iMac 7 iBook Production Production Cost Hours $ 2.625 8 $ 3.750 10 $ 1.500 7 $ 2.250 5 $ 3.750 $ 5.000 $ 2.500 $ 3.125 Market Demand 25.000 15.000 25.000 15.000 5.000 5.000 5.000 8 9 Used Hours Budget (hours) 10 300.000 11 12 13 Production Cost Budget (money) $0 $158.250.000 14 15 16 17 18 Revenue Production Cost Profit $0 $0 $0 13 14 2 8 15 9 After your success in the manufacturing plant in Ireland, Apple decided to send you to China factory that serves Asia. Use the information in the Data to answer the following questions. Consider the data from the 'Data' sheet of this workbook. Consider the profits for each product (revenue - cost per product) and decide production levels by prioritizing the products according to their profits (also known as Patrick's way). What would be the production level of Power Mac G4? Use the Solver tool to find the optimal production levels with the given constraints. What is the profit in the optimal production? The brilliant newly graduated assistant, who did not take BUS 101 course, suggested that the Apple should produce exactly 80% of the market demand for each item. (Suppose use can use unlimited overtime!) How much overtime should Apple use to satisfy this production plan? (You are not supposed to think about the cost of overtime for this part!) If the hourly fee of overtime is $15, does Apple have enough budget to fund this b) production plan? (Choose Yes or No! The marketing department reports that for price change less than $300, every $100 drop in the price of any product increases the market demand by 3500 units and vice versa (i.e. elasticity = 35). Price and price change values should be integers! Use the Solver tool to find the optimal production levels with the given constraints. The board approved a change only in the price of Powerbook G4. What is the new price of Powerbook G4 in the optimal production? 16 4 17 2 18 10 19 4 20
