2) NaserCo Wants to display it products within 10,000 feet square according to the following Data: Cost of each Unit Cost of Other storing extra each Needed space price per of each Unit (in feet) Sales Product cost Unit per unit 5 Unit A 50 80 20 B 3 5 7 115 250 300 90 15 C 180 10 30 D 230 7 8 40 NaserCo decided to 1. Display at least 10 units of each Product A and B. 2. Display at most 20 units of product C and D. 3. the capital prepared for buying is 250000 dinar. Find the Linear programming form of the above problem.
Q: Based on the following sensitivity report, what would be the impact of changing the objective…
A: The 100% rule can be applied to decide if a modification in various objective function coefficients…
Q: What is OEE and also calculate the OEE from the given data in below table.…
A: Given Details: Given Details Shift Length 8 Hrs 480 mins (8*60) Breaks 15 Min (2) 30 Min(1) 60…
Q: Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales…
A: The production and materials purchases budgets for the second quarter is as follows:
Q: Company A produces a product called Gen, which is a type of tyre The following is the information…
A: The detailed solution to the given question is given in Step 2.
Q: A manufacturer produces three models (I, II, and II) of a certain product using raw materials A and…
A: Let assume x1 be the number of units of model I x2 assumed to be the number of units of model II x3…
Q: 1. Identify the missing TPS basic activity: data collection, data editing, data _________, data…
A: 1-Data collection,data editing, data entry, data manipulation, data storage and document production.…
Q: Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost…
A: Given Information: Variable Cells Cell Name Final Value Reduced Cost Objective…
Q: Based on the following sensitivity report, how much should the firm be willing to pay for 76 more…
A: Below is the solution:-
Q: Drypers is one of the leading baby điaper brands in M diapers are proudly made in Malaysia by Vinda…
A: Given that: Pulp = 2070 Kg =2070000 grams SAP = 1007 Kg = 1007000 grams Adhesive Glue =66 Kg =66000…
Q: Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the…
A: Based on the given information, it is clear that Mary is getting commission level 3 commission of…
Q: UST 40,000 (Commerce 5,000; Medicine 15%; AB 20%; Law 5% and others) Average price per computer…
A: Since you have posted multiple questions we will solve the first question for you as per our…
Q: 49,557 B. D F G Cases, Cases, Deaths, Deaths. Use VLOOKUP to add the appropriate Population Values…
A: VLOOKUP is an abbreviation for 'Vertical Lookup.' It's a function that tells Excel to look for a…
Q: Based on the following sensitivity analysis, which of the following products would be considered…
A: Sensitivity analysis or study is a financial representation that defines how target variables are…
Q: B-1. Which is more desirable assuming data are COST Decertaine the course dagram. 90 60 (45) 45 99…
A: Given data: A consultant’s report indicates a 0.20 probability that demand will be low and 0.80…
Q: iven the following information for a product-mix problem with three products and three resources.…
A: Given,
Q: Based on the following sensitivity report, what would be the change in the objective function value…
A: The objective function in straight programming issues is the genuine esteemed function whose worth…
Q: EFE company manufactures and sells boats. The company's management accountant gathered the following…
A:
Q: Explain two named security features that MGMT Mobile Company can implement to enhance the…
A: Introduction: MGMT is the mobile company which offer various service to their customer. They have 10…
Q: Consider the sensitivity report below: CLO3 Variable Cells Final Reduced Objective Allowable…
A: A 'Sensitivity Report' describes how modifications in the coefficients of the objective function…
Q: The Johnny Ho Manufacturing Company inColumbus, Ohio, is putting out four new electronic components.…
A: Formula:
Q: Average price per computer device Php25,000 Average price per Apple device Php30,000 In UST,…
A: The following data is given: Total = 40,000, Commerce= 5000, Medicine= 6000,AB= 8000, Law=2000,…
Q: 9.3. Jean Clark is the manager of the Midtown Saveway Grocery Store. She now needs to replenish her…
A: Maximum likelihood varies from least squares for the most part as far as the rule for assessing…
Q: 2. A company has to minimize its cost = 200X + 300Y, subject to the following constraints: X + Ys 50…
A:
Q: Based on the following sensitivity report, what would be the change in the objective function value…
A: As per Brtleby guidelines, we can only solve one question at a time...Kindly upload the other…
Q: The Johnny Ho Manufact uring Company in Columbus, Ohio, is putting out four new electronic…
A: A Small Introduction about Manufacturing Cost Manufacturing cost is the number of costs of all…
Q: 6. The selling price of sand per cubic meter is Php75, how much is the price of the sand that has a…
A: The above questions are from the topic: Volume The answers to the questions is given below:
Q: QUIZ NO.3 4. Joseph Biggs owns his own ice cream truck and lives 30 miles from a Florida beach…
A: Decision tree: A Decision tree is a quantitative tool in order to aid in decision making processes,…
Q: 2. A computed utility function for a travel in a medium-sized city by automobile, bus and light rail…
A: Given:- U = a - 0.002X - 0.05Y Where, X = Cost of travel (php) Y = Travel Time (minutes)…
Q: If the objective function coefficient for Product_1 were decreased to a value of 3, which of the…
A: There is a sensitivity report given with allowable increase and decrease values for the objective…
Q: Use the transportation model to develop the minimum cost production schedule for the products and…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: construct the oc curve for a single draw N=1,650; n=80 and c=2 for P=0%,0,5%, 1%, 1.5%,2%, 3%,…
A: A graph depicting the percentage of defective goods vs. the chance of acceptance is known as an…
Q: Solve the given standard minimization problem using duality. (You may already have seen some of…
A: Below is the solution:-
Q: The Doan Modianos Manufacturing Company isputting out seven new electronic components. Each…
A: given,
Q: Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: 46. Ford is going to produce a new vehicle, the Pioneer,and wants to determine the amount of annual…
A: EMV is an appropriate criterion for this decision problem Calculation of payoffs and EMVs is shown…
Q: Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost…
A: The objective function value will increase by $87.50
Q: 13 - Holden Corporation produces three products, with costs and selling prices as follows: Product…
A: Given data: Product A Product B Product C Selling price per unit 30 100% 20 100% 15 100%…
Q: Refer to the following sensitivity report: Variable Cells Cell Name Final Value Reduced Cost…
A: Option 1 and 3 both are correct. From the variable cells table, it can be concluded that the…
Q: 9. The Ace Manufacturing Company has orders for three similar products: Orders Product (units) A…
A: Given data is The capacity is more than orders so in the linear programming model there is no need…
Q: 3.4-9. Web Mercantile sells many household products through an on-line catalog. The company needs…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: George Fine, owner of Fine Manufacturing, is consideringthe introduction of a new product line.…
A: In operations management, fixed cost, variable cost incurs when a company start any business or…
Q: Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens…
A: We solve the problem as an integer linear programming problem. The spreadsheet model looks as below:
Q: Required Month Space (Sq. Ft.) Leasing Period Cost per Sq. Fa (Months) Leased 1 $ 65 30,000 20,000…
A: given,
Q: 3. The Energetic Company needs to make plans for the energy systems for a new building. The energy…
A: Given, Electricity- 20 units Water heating- 10 units Space Heating- 30 units
Q: Evaluate the following given the following values: 1. The price of pair of socks is Php 200. How…
A: The above questions are from the topic: Profit and Loss. The answer to the questions are given…
Q: The objective of the Hot Oven is to find a balanced diet with minimum cost. a) Formulate a linear…
A: a) LP Formulation Minimize Cost Z = 0.5BB+2C+B+0.25BE+0.25S s.t. constraints -…
Q: XY Company manufactures and sells LCD monitor at P5000 each. The production officer reported the…
A: The fixed costs are those cost which remains same for all level of activities. Variable costs are…
Q: 12
A: When the value of objective coefficient (OF) is changed from 1.95 to 2 the optimality range is not…
Q: Consider the LP problem in Figure QP2.5 and refer to the Solver sensitivity report in Figure QP2.6.…
A: Given- Sensitivity analysis report-
Q: Maximize z= 5R+8P Subject to R+3/2P≤900 1/2R+1/3P≤300 1/8R+1/4P≤100 R,P ≥ 0 non-binding…
A: [1] - c. 4≤c1≤12 [2] - b. 10/3≤c1≤10
Step by step
Solved in 2 steps
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Millers optimal bid increase or decrease? To study this question, assume that each competitors bid, expressed as a multiple of Millers cost to complete the project, follows each of the following distributions. a. Triangular with parameters 1.0, 1.3, and 2.4 b. Triangular with parameters 1.2, 1.3, and 2.2 c. Use @RISKs Define Distributions window to check that the distributions in parts a and b have the same mean as the original triangular distribution in the example, but smaller standard deviations. What is the common mean? Why is it not the same as the most likely value, 1.3?A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
- Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)You want to take out a 450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a 50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%. a. Determine the amount of each years monthly payment. You should use a lookup table to look up each years monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.). b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, 450000,0,0).An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.
- Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)Confederate Express Service is attempting to determinehow its shipping costs for a month depend on the numberof units shipped during a month. For the last 15 months, thenumber of units shipped and total shipping cost are given inTable 24 (file Ship.xls). Units TotalMonth Shipped Shipping Cost1 300 $1,0602 400 $1,3803 500 $1,6404 200 $7405 300 $1,0606 350 $1,1907 460 $1,5208 480 $1,5809 120 $54010 760 $2,42011 580 $2,20012 340 $1,47013 120 $79014 100 $72015 500 $1,960Based on Carino and Lenoir (1988). BradyCorporation produces cabinets. Each week, Bradyrequires 90,000 cubic feet of processed lumber. Thecompany can obtain lumber in two ways. First, itcan purchase lumber from an outside supplier andthen dry it at the Brady kiln. Second, Brady canchop down trees on its land, cut them into lumber atits sawmill, and then dry the lumber at its kiln. Thecompany can purchase grade 1 or grade 2 lumber.Grade 1 lumber costs $3 per cubic foot and whendried yields 0.7 cubic foot of useful lumber. Grade 2lumber costs $7 per cubic foot and when dried yields0.9 cubic foot of useful lumber. It costs the company$3 to chop down a tree. After being cut and dried,a log yields 0.8 cubic feet of lumber. Brady incurscosts of $4 per cubic foot of lumber it dries. It costs$2.50 per cubic foot of logs sent through the sawmill.Each week, the sawmill can process up to 35,000cubic feet of lumber. Each week, up to 40,000 cubicfeet of grade 1 lumber and up to 60,000 cubic feetof…
- Chris LeBlanc estimates that if he does five hours of research using datathat will cost $175, there is a good chance that he can improve hisexpected return on a $10,000, one-year investment from 6% to 9%. Chrisfeels that he must earn at least $30 per hour on the time he devotes to hisresearch.a. Find the cost of Chris’s research.b. By how much (in dollars) will Chris’s return increase as a result ofthe research?c. On a strict economic basis, should Chris perform the proposed reserach?Integrated Products Corporation (IPC) needs to estimate its PC sales for next year.The most recent six years of revenue data for the company’s line of XT PersonalComputers, and those of the industry, is found in the table below:Year XT PC Sales Revenue($’000,000)All Industry PC Sales Revenue($’000,000,000)1 2.4 4.62 5.9 8.63 15.5 10.74 27.8 14.85 35.9 18.56 38.1 19.4Required:A. Assuming that the sales data above are representative of sales expected nextyear, use time series regression analysis to forecast next year’s sales revenues(there is no seasonal effect).B. Perform a regression analysis between the annual sales revenues of XTPersonal Computers and all industry PC annual sales revenues. What is theforecast for next year’s sales revenue for XT Personal Computers if the estimateof next year’s industry PC sales revenues is $21.9 billion? C. Advise management at Integrated Products Corporation (IPC) which of the twosales estimates from parts A and B above they should use. Justify your…