Due to COVID 19, the Purchase department of the company decided change the supplier of the material if the IQR of prices is more than RO. 20, and if IQR prices is less than RO. 20, the company will continue the same way of purchase of material. If the IQR goes beyond 50, company decided to produce the component itself rather than buying it from outside. You are required to suggest suitable measures to management.

Due to COVID 19, the Purchase department of the company decided change the supplier of the material if the IQR of prices is more than RO. 20, and if IQR prices is less than RO. 20, the company will continue the same way of purchase of material. If the IQR goes beyond 50, company decided to produce the component itself rather than buying it from outside. You are required to suggest suitable measures to management.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

3. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold 4. Format columns I, J, and K as currency with two decimal places. 5. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.a) What was the total Profit for Online Sales? b) Sort the results by Date Sold (A/Z). * so apparently I need to learn to use the VLOOKUP to find a product on the first page and be able to get the Product Price and Cost from the second page. The following formula is NOT working - =VLOOKUP(D4, ProductTable!A:B, 2,FALSE). I need an EXACT…
Another issue to research when purchasing ahome is that of points and mortgage interestrates. Usually paying higher points results in alower mortgage interest rate. The question forthe homebuyer is: Should I pay higher points fora lower mortgage interest rate, or pay lowerpoints for a higher mortgage interest rate? Theanswer to that question depends on manyfactors, one of which is the amount of time thehomeowner plans on staying in the home.Consider two typical situations for a 30-year,$100,000 mortgage. Option 1 offers an annualmortgage interest rate of 8.25% and a loanorigination fee of 3.5 points. Option 2 offers anannual interest rate of 8% and a loan originationfee of 4points. What is the total amount paid, including points, after 3 years for each option? ( Round your answers to the nearesr cent.) Option 1:Option 2:
Please assist with the below. Please do not use handwriting I have a hard time reading hand written work. Also please provide explanations
3. (5.7.12) On June 2, 2010 USA Today reported a story from Bloomberg News that said that the total price tag for the project to build the new F-35 Joint Strike Fighter would be 65% higher than the original $232 billion estimate. The cost now is estimated to be $382 billion. The total cost of each plane would be $112.4 million, up 81% from the original $62 million. The cost to produce each plane would be $92.4 million, about 85% higher than the original estimate of $50 million. a. Check the arithmetic to see that the three percentage increases reported are correct. b. Can you explain how the project cost can have increased by just 65% when the overall total per plane increased by 81% and the construction cost alone increased by almost 85%?
Kolkmeyer Manufacturing Company is considering adding two machines to its manufacturing operation. This addition will bring the number of machines to nine. The president of Kolkmeyer asked for a study of the need to add a second employee to the repair operation. The arrival rate is 0.05 machines per hour for each machine, and the service rate for each individual assigned to the repair operation is 0.4 machines per hour. Mention the queuing model that can be implemented for the analysis (notation of Kendall) and why that model was chosen
Refer to the production possibilities curves for Chairland and Tableland. Chairland can produce 36 chairs per day and no tables, or 18 tables table per day and no chairs. Tableland can produce 40 chairs per day and no tables, or 40 tables per day and no chairs. If the two countries split the difference between the buyer's willingness to pay for tables and the seller's willingness to accept, in terms of the number of chairs for 1 table, the terms of trade will be . (Enter your response rounded to one decimal place.) Country Quantity per day Opportunity cost of chairs Opportuity cost of tables Tableland 40 chairs, 40 tables 1 table 1 chair Chairland 36 chairs, 18 tables 1/2 table 2 chairs
32. A hardware company sells a lot of low-cost, highvolume products. For one such product, it is equallylikely that annual unit sales will be low or high. Ifsales are low (30,000), the company can sell theproduct for $20 per unit. If sales are high (70,000),a competitor will enter and the company will be ableto sell the product for only $15 per unit. The variablecost per unit has a 20% chance of being $10, a 60%chance of being $11, and a 20% chance of being $12.Annual fixed costs are $20,000.a. Use simulation to estimate the company’s expectedannual profit.b. Find a 95% interval for the company’s annualprofit, that is, an interval such that about 95% ofthe actual profits are inside it.c. Now suppose that annual unit sales, variable cost,and unit price are equal to their respective expectedvalues—that is, there is no uncertainty. Determinethe company’s annual profit for this scenario.d. Can you conclude from the results in parts a and cthat the expected profit from a simulation is…