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.]

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.]

Name: Use the information below to answer the following question(s).Conside
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Use the information below to answer the following question(s).Consider the following spreadsheet for an outsourcing decision model.AB|Outsourcing Decision Model23Data45Manufactured in-houseFixed costUnit variable costS 60,000$ 1307Purchased from sup

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

Suppose that a furniture manufacturer makes chairs, sofas, and tables. Consider the following chart of labor hours required and available. Chair Sofa Table Daily labor available (labor- hours) 3 8 =III 1 2 6 0 The profit per chair is $50, per sofa $40, and per table $80. How many pieces of each type of furniture should be manufactured each day to maximize the profit? Carpentry Finishing Upholstery 6 1 2 720 144 228
In agricultural economics, a “supply response function” describes how supply of a commodity responds to changes in the price of that commodity. Year Seeded Area (hectares) Harvested Area (hectares) Average Yield (kg per ha) Production (tonnes) Price per Tonne ($/tonne) 1966 1,317,000 1,317,000 1,630 2,150,000 65 1967 1,424,000 1,424,000 1,720 2,449,000 60 1968 1,376,000 1,376,000 1,800 2,477,000 48 1969 1,012,000 1,012,000 1,720 1,742,000 46 1970 567,000 567,000 1,465 830,000 52 1971 1,019,000 1,019,000 1,975 2,014,000 50 1972 1,052,000 1,052,000 1,785 1,878,000 68 1973 1,214,000 1,214,000 1,725 2,095,000 158 1974 1,133,000 1,133,000 1,415 1,605,000 147 1975 1,255,000 1,255,000 1,690 2,123,000 130 1976 1,538,000 1,538,000 1,820 2,803,000 103 1977 1,295,000 1,295,000 2,125 2,749,000 98 1978 1,376,000 1,376,000 2,055 2,831,000 133 1979 1,214,000 1,214,000 1,680 2,041,000 170 1980 1,336,000 1,336,000 1,425 1,905,000 203 1981 1,577,900 1,577,900…
Suppose you are the marketing manager of a firm, and you plan to introduce a new product to the market. You have to estimate the first year net profit, which depends on several variables • Sales volume (in units) • Price per unit • Unit cost . Fixed costs Your net profit is net profit = sales volume x (price per unit-unit cost) - fixed cost The fixed cost is $120, 000, but other factors have some uncertainty. Based on your market research, there are equal chance that the market will be slow, ok, or hot. • Slow market the sales volume follows Poisson distribution with mean 50,000 units product, and the average price per unit is $11.00 ● Ok market the sales volume follows Poisson distribution with mean 75,000 units product, the average price per unit is $10.00 Hot market: the sales volume follows Poisson distribution with mean 100,000 units product, but the competition is severe so you expect the average price per unit is just $8.00 No matter what the market type is, your average unit…
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