Exam 15: Optimization Analytics

Use the table below to answer the following questions). Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following question. -According to the linear optimization model, what is the total number of ScarCTs produced?

Use the table below to answer the following questions). Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following question. -According to the linear optimization model, what would be the total time spent for packaging the Invazen models?

Use the table below to answer the following questions). Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following question. -According to the Sensitivity Report, by how much should the unit profit on ScarCT be increased in order for its production to be feasible?

Use the table below to answer the following questions). Qualis Investments is a private limited business that manages personal financial portfolios. The company manages six mutual funds and has a client that has acquired $750,000 from an inheritance. Characteristics of the funds are given in the table below. Qualis Mutual Fund Data Expected Annual Return Risk Measure 1 Qualis Low-priced Stock Fund 7.23\% 11.87 2 Qualis Multinational Fund 8.42\% 12.62 3 Qualis Mid-cap Stock Fund 6.66\% 13.72 4 Qualis Mortgage Fund 2.72\% 3.37 5 Qualis Income Equity Fund 8.89\% 8.4 6 Qualis Balanced Fund 3.50\% 6.91 The company recommends that no more than $300,000 be invested in any individual fund, and that at least $80,000 be invested in each of the mid-cap stock and mortgage fund. The total amount invested in the low-priced and multinational funds are at least 35% of the total investment. The client would like an average return of at least 6%. Assume that X1- X6 represent the dollar amounts invested in funds 1 through 6, respectively. -Due to decreasing profits, if the production of Graystone surfboards is stopped, compute the total profit the firm can earn.

According to the Sensitivity Report, which of the following is true if the capacity at Atlanta is increased by 230 units?

Use the table below to answer the following questions). Remington Textiles has a mill that produces three types of fabrics on a make-to-order basis. The mill operates on a 24/7 basis. The key decision facing the plant manager is about the type of loom needed to process each fabric during the coming 12 weeks to meet demands for the three fabrics and not exceed the capacity of the looms in the mill. Two types of looms are used: Jaquard and Northrop. Jaquard looms can be used to make all fabrics and are the only looms that can weave certain fabrics, such as plaids. Demands, variable costs for each fabric, and production rates on the looms are given in the table below. The mill has 10 Northrop looms and 2 Jaquard looms. Any fabrics that cannot be woven in the mill because of limited capacity will be purchased from an external supplier, finished at the mill, and sold at the selling price. In addition to determining which looms to use to process the fabrics, the manager also needs to determine which fabrics to buy externally. Remington Textiles Data Fabric Demand Jaquard Northrop Capacity Capacity Mill Cost Outsourcing yards) yards/hour) yards/hour) \/ yard) Cost \/ yard) 1 50,000 5.6 0 0.53 0.81 2 62,000 5.2 4.8 0.6 0.85 3 35,000 4.8 4.5 0.71 0.84 Answer the following questions using a linear optimization model. -According to the model, what is the total amount of Fabric 1 to be produced on Jaquard?

Use the table below to answer the following questions). Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following question. -According to the linear optimization model, what would be the total time spent for assembling the Invazen models?

Use the table below to answer the following questions). Pickson Luthiers Corporation makes four models of electric guitars, ScarCT, Dela Mort, Warax, and Invazen. Each guitar must flow through five departments, assembly, painting, sound testing, inspection, and packaging. The table below shows the relevant data. Production rates are shown in units/hour. ScarCT is assembled elsewhere). Pickson wants to determine how many guitars to make to maximize monthly profit. Pickson Luthiers Corporation Data Guitar Model Selling price/Unit Variable cost/Unit Min Sales Max Sales ScarCT 750.00 660.00 0 2500 Dela Mort 788.00 680.00 0 2000 Warax 800.00 700.00 100 1000 Invazen 850.00 800.00 80 500 Production rates units/hour) ScarCT Dela Mort Warax Invazen Hours Available Assembly - 35 25 20 220 Painting 35 20 15 10 220 Sound Testing 20 10 20 18 220 Inspection 10 12 8 5 220 Packaging 9 10 5 8 220 Use a linear optimization model based on the data to answer the following question. -According to the linear optimization model, what would be the total time spent for sound testing the Warax model?