The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience, the demand for bananas is expected to be 100, 150, 200, or 250 pounds with the following probabilities: 100lbs 0.20; 150lbs 0.25, 200lbs 0.35, 250lbs 0.20. The bananas cost the store $.45 per pound and are sold for $.85 per pound. Any unsold bananas at the end of each week are sold to a local zoo for $.30 per pound. Use your knowledge of decision analysis to model and solve this problem in order to recommend how many pounds of bananas the manager should order each week
Q: Determine the optimal allocation of jobs to machines that will maximize total profit. The following…
A: An assignment problem is a technique to find the combinations of the optimal solution to the…
Q: A time standard was set as 0.20 hour per unit based on the 50th, unit produced. Assume the task has…
A: Learning Rate = 90% Time Standard set as 0.20 hours based on 50th unit
Q: In the case of any enterprise resource planning system, what is the optimal testing strategy?
A: The optimal testing strategy for an enterprise resource planning system is a combination of various…
Q: Use Prim's algorithm to find the minimum weighted spanning tree for the graph in figure K. Fill in…
A: Minimum spanning tree: Graph/route containing all the vertices (nodes) with minimum number of edges…
Q: Quality Management Your line manager has become increasingly concerned about the product and service…
A: A p chart is used when observations can be placed into yes/no category decisions such as good or…
Q: Four samples of three observations each have been taken, with actual measurements (in centimetres)…
A: Firstly Calculating X bar: X bar is the the Average of Observations in an Sample. Sample 1 =…
Q: ncorrect Question 7 After you finish speaking at a business law conference, an eager fan asks you…
A: Introduction Business law also termed as mercantile law or commercial law is a set of rules and…
Q: Bjorn and Thor are plumbers who have been scheduled to work on the construction of a new school…
A: Given Gantt Chart-
Q: An ethical statistical consultant would not always
A: Ethical statistical practices are the set of guidelines and principles that govern the proper…
Q: Possible results include expanding the project's goals or adding unnecessary features. Explain the…
A: The outcomes of a project are always preplanned and determined and on the basis of the outcomes,…
Q: (a) A fruit grower has 150 acres of land available to raise two crops, A and B. It takes one day to…
A: To find: The number of acres of each fruit should be planted to maximize profit. Given: The amount…
Q: What are some of the challenges that a corporation would have to overcome in order to accomplish the…
A: Corporations may encounter complex and challenging task when combining a defined brand strategy…
Q: The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast…
A: Given that: Week Guests (X) Bar sales (Y) 1 16 320 2 12 275 3 18 390 4 14 320 Total 60…
Q: Using data from yearly surveys and surveys paid for by suppliers of agile products, can you provide…
A: Introduction- Agile Product is a customer-driven way to deal with characterizing, fabricating, and…
Q: Darren Mack owns the "Gas n' Go" convenience store and gas station. After hearing a marketing…
A: Given-
Q: 1. Solve the following LP Models. (a) A fruit grower has 150 acres of land available to raise two…
A: Linear programming is one of the mathematical techniques that is widely used by companies. This…
Q: Why Purchasing must Become Supply Management ? What is Classifying Purchasing Materials…
A: The field of supply chain management and the question above is connected. Although supply chain…
Q: MNCs also may be exposed to risk from the inappropriate use of technology by all EXCEPT O a…
A: From the standpoint of operations management, MNCs could be exposed to various hazards related to…
Q: 4. Discuss Porter's five generic strategies.
A: Organizations work to develop a competitive edge in operations management so they may distinguish…
Q: Following are the observations (in minutes) for four elements of a task. Element 1 1234 2 3 Element…
A: Observe time is the average of cycle. It is calculate with following formula Observe time = Total…
Q: illustrate an organizational chat l Chart General Manager | Resident Manager | Director of…
A: General Manager |…
Q: has recently added a new product to their offerings. Manufacturing reports that production is going…
A: Given- Time to manufacture first unit (T1) = 500 hoursTime to manufacture second unit (T2) = 375…
Q: Go to the Jersey Mike's website Franchise Investment - Sub Sandwich Opportunity - Jersey Mike's Subs…
A: 1. Costs associated with opening a Jersey Mike's franchise location: Opening a Jersey Mike's…
Q: Labor unions were created to protect its members from subjective and unpredictable treatment by…
A: An association of various people protecting their interests and rights concerning their employment…
Q: For a workforce of 1,700 full-time employees who work 40 hours per weeks and 850 part-time employees…
A: Here, full-time cost per hour is given for each component and part-time cost per hour is given for…
Q: How can CRM, ERP, and EAI help businesses?
A: Customers continued patronage is crucial to any company's ability to keep its profit margins stable…
Q: A small assembly line for the assembly of power steering pumps needs to be balanced. Precedence…
A: Precedence diagram-
Q: true or false Building scenarios is a tool to help with concept generation.
A: Scenario planning is a strategic management tool that involves envisioning and developing multiple…
Q: illustrate an organizational chat The chart shows a clear chain of command, with the General…
A: General Manager…
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: x = number of month
Q: Use the six sigma themes to explain to the quality manager how your team will ensure that the…
A: Six Sigma is characterized as a management strategy used to uphold the required level of quality in…
Q: How do we arrive at the " Net Delivered Cost of Purchases?" What is an "allowance" and why would a…
A: "Net purchases" can be defined as the value of all purchases after deducting all costs. A sales…
Q: a) What is the value of x? x= 155.56 mm (round your response to two decimal places). b) What is the…
A: A quality feature can be said to satisfy the target value or a normal deviation within the range…
Q: 5 Feasibility Study Title ( Non-Food Product) with explanation
A: A feasibility study can be defined as an assessment and examination of an undertaking or framework…
Q: Outline if adaptive or predictive projects have been more fruitful in the long run, and provide…
A: The project management strategy adopted is one of several variables that affect a project's success.…
Q: Station 1 Machine A 30 min/unit Note: Station 1 Machine B 30 min/unit Station 2 14 min/unit Station…
A: Ans) Bottleneck is a operation which is slowest operation. In Parallel Station 1 takes time below:…
Q: Gestat, inc uses a kanban system in its automobile production facility in Germany. This facility…
A: Given- Processing time per part= 150 secondsContainer size = 30 partsAverage waiting time per…
Q: Why have enterprise resource planning (ERP) solutions become so critical to the IT infrastructures…
A: Enterprise Resource Planning (ERP) can be defined as software that enables organizations to use a…
Q: The results of inspection of DNA samples taken over the past 10 days are given below. Sample size is…
A: Given data-
Q: What is the difference between structured approach and semi-structured approach when collecting…
A: Structured and semi-structured approaches are two different methods of collecting data. The main…
Q: The postmaster of a small western town receives a certain number of complaints each day about mail…
A: Formulae used: For C Chart UCL= C¯ + z×C¯ LCL= C¯ - z×C¯ Standard deviation =C¯
Q: Chapter 11 discusses the components that create an organizational culture along with the various…
A: The above-given question is regarding organizational culture and its effect before moving ahead…
Q: 14. Which of the following is NOT a corner point? (b) (3, 1) (a) (1,3) (c) (0,6) (d) (6,0) 15. Let…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: What is the crossover point in miles between the hybrid vehicle and the alternative vehicle from a…
A: For Hybrid vehicle, Purchase Cost = 18000 Operating Cost = Operating Cost per mile*No. of miles =…
Q: Element 1 2 3 4 Performance Rating 80% 75 120 105 1 0.51 1.51 0.86 1.11 Click here for the Excel…
A: Formula for calculating the Average cycle time Average cycle time = Total observationNumber of…
Q: Why do companies choose inflexible processes?
A: Processes in a business are of different natures running in different capacities. Every series of…
Q: The number of accidents in a manufacturing plant has increased every year. Most accidents are due to…
A: The BEST first step when applying systemic thinking to solve the problem of increasing accidents in…
Q: You are given the quarterly demand (in units) of a product for Year 1 through Year 7. It has been…
A: Year 1 Quarter 1 Period = 1 Year 1 Quarter 2 2 Year 1 Quarter 3 3 Year 1 Quarter 4…
Q: What are the drawbacks of global strategy if John is to pursue Reduction in adaption to cultural…
A: See the question above about the possible adverse effects of a worldwide strategy for John's…
Q: Provide an explanation for the operation of predictive analytics and a scenario in which it might be…
A: Predictive analytics is the utilization of data, statistical algorithms, and machine learning…
The produce manager at the local Pig & Whistle grocery store must determine how many pounds of bananas to order weekly. Based upon past experience, the demand for bananas is expected to be 100, 150, 200, or 250 pounds with the following probabilities: 100lbs 0.20; 150lbs 0.25, 200lbs 0.35, 250lbs 0.20. The bananas cost the store $.45 per pound and are sold for $.85 per pound. Any unsold bananas at the end of each week are sold to a local zoo for $.30 per pound. Use your knowledge of decision analysis to model and solve this problem in order to recommend how many pounds of bananas the manager should order each week
Step by step
Solved in 2 steps with 2 images
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
- It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.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%.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.
- Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
- 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.)Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.