Use the information below to answer the following question(s). Consider the following spreadsheet for an outsourcing decision model. A B |Outsourcing Decision Model 2 Data 4 5 Manufactured in-house Fixed cost Unit variable cost |S 60,000 $ 130 7 Purchased from supplier Unit cost S 165 10 11 Demand volume 1,000 12 13 14 Model 15 16 Total manufacturing cost 17 |Total purchased cost 18 19 Difference 20 Decision We assume that the production (demand) volume is normally distributed with a mean of 1,000 and a standard deviation of 100. For the unit cost, select the triangular distribution. It has a minimum value of $150, most likely value of $165, and a maximum value of $190. The number of trials per simulation is equal to 5,000 at a Sim. Random Seed of 1. Run the simulation and answer the following question(s) using the Analytic Solver Platform. [Hint: choose the closest value.]

Interpret and Explain step by step the result.

Quantitative research: A. Emphasizes how a participant in a given setting constructs the world around the participant B. Involves data that are contained in context C. Involves data that have the potential for revealing complexities D. Emphasizes the answer to a specific research quota

Yaster Breakfast Supplies is planning to manufacture and market a new toaster. After conducting extensive market surveys, the research department provides the following estimates: • a weekly demand of 318 at a price of $13 per toaster • a weekly demand of 201 at a price of $16 per toaster The financial department estimates that weekly fixed costs will be $1,399 and variable costs (cost per unit) will be $3. Assume: • the relationship between price and demand is linear • the cost function in linear Use your models to predict the marginal profit when Yaster is producing and selling 271 toasters per week. Round to the nearest cent. $ per toaster

An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…

*NEED HELP WITH 1, 2, and 3*DYNAMIC INVENTORY MODELSPLEASE WALK THROUGH WITH EXCEL IF POSSIBLE, PLEASE!Mohawk Industries builds transmissions for a large automobile manufacturer. One of its transmissionassemblies requires part #HD234, purchased from a supplier within the same industrial park. Because ofthe close proximity of its supplier, the lead me for part #HD234 is negligible.The demand for part #HD234 varies according to the orders received from the automobile manufacturer.The requirements schedule for the next 10 periods is shown below: Period 1 2 3 4 5 6 7 8 9 10 Total Demand 115 50 175 95 150 225 75 70 40 20 1,015 This requirements schedule is considered fairly typical. Furthermore, the cost of placing an order with anearby supplier is $85.00, the purchase cost is $65.00, and the holding cost fracon is 0.01 per period.Mohawk is in the process of assessing different lot-sizing policies. It is interested in several that havebeen suggested.Before it can decide among them,…

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