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…
Forecasting: 1. How does the number of periods in moving average affect the responsiveness of the forecast? 2. Contrast the terms sales and demand. 3. KA commercial bakery has recorded sales (in dezens) for three products, as shown below: Blueberry MuHins Cinnamon Buns Day Cupcakes 30 18 45 34 17 26 32 19 27 34 23 35 2 22 30 23 48 23 29 34 36 25. 20 29 24 14 10 31 26 18 35 31 11 27 47 28 26 27 37 34 13 14 31 24 15 33 33 22 a. Predict orders for the following day for cach of the products using an appropriate naive method. b What should the use of sales data instead of demand imply. RNN N N N H.NM p
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
Company A is a start up company that sells shapewear. They do not have production but instead has a supplier. Create a spreadsheet model for Company A that will be able to maximize profit or maximize profit while minimizing costs. Hint: can be through ads, lowering the cost of packaging, best selling product vs low selling product, etc. (get creative)
Cyberdyne Systems creates a Professional version of its machine learning software. By disabling some of the features in the Professional version it can create a Home version. Both versions have zero marginal cost. Cyberdyne Systems faces two customer segments which it cannot distinguish between and each is interested in buying at most one version. The RPs of each segments for each version are displayed below. Business Home Buyers Professional Version | Home Version Segment Size $20 $10 30 70 $80 $20 Each customer will choose the software that gives her the highest surplus. 3. Now suppose that Cyberdyne has a competitor who also sells a product, which is an alter- native to Cyberdyne's. The Business customers have an RP of $10 for this product, while Home Buyers have an RP of $15. The competitor firm is selling its product for a price of $10 and will not change it regardless of Cyberdyne's actions. What prices should Cyberdyne set to maximize revenue? You may assume that customers will…
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
I need expert advice please especially with the graph. The table below shows monthly data collected on production costs and on the number of units produced over a twelve month period. Month Total Production Costs Level of Activity(Units Produced) July $230,000 3,500August 250,000 3,750September 260,000 3,800October 220,000 3,400November 340,000 5,800December 330,000 5,500January 200,000 2,900February 210,000 3,300March 240,000…
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,…