Flora Co sells bunches of fresh flowers which have a limited shelf life so forecasting sales demand is extremely important for maximising profits. Quarter 1 Quarter 1 contains a national holiday and as a result sales of a particular red flower are usually very high. Sales of the red flower will depend on market conditions. After the national holiday there will be no demand for the red flowers and they will be thrown away. Flora Co must decide whether to purchase 250 bunches, 400 bunches or 500 bunches of the red flowers from its supplier for re-sale to its customers. The following payoff table has been produced: Market conditions Poor Good Excellent Expected value Probability 0.20 0.25 0.55 Number of bunches to be bought from supplier 400 $900 $3,900 $3,900 250 $2,400 $2,400 $2,400 $2,400 $3,300 500 ($100) $2,900 $4,900 $3,400
Q: In Quarter 2 what is the expected value at outcome A (before the cost of the delivery van)? $
A: Here, I am given the decision tree, Based on whether the demand is good or bad, the final profit…
Q: What are the different types of negotiation and how do I decide which one to adopt?
A: The ability to reach agreements or settle disputes between persons with divergent interests or…
Q: In the context of system reliability, explain the terms Mean Time Between Failures (MTBF) and Mean…
A: System reliability is a key concept in engineering, statistics, and systems analysis that refers to…
Q: Describe the technology behind barcode scanners and their role in inventory management.
A: Supply chain is an integral part of an organization. There are several intermediaries whose movement…
Q: 1. Why is necessary to identify and include stakeholders in a project? List several methods that you…
A: Effective communication and teamwork are essential to the success of any endeavor in the complicated…
Q: Evaluate the internal environment’s impact on achieving the Apple INC. strategy
A: To evaluate the internal environment's impact on achieving Apple Inc.'s strategy, we will further…
Q: Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the…
A: Here we find a forecast line that best fits the data points representing the actual. Best fit means…
Q: A manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are…
A: A tracking signal is a statistical measure that is used to evaluate the accuracy of a forecast. It…
Q: "Responsibility for Conflict", more specially the the idea of open dialogue in public spaces. As…
A: Conflict management is the process of handling the problems that arise in the organization by…
Q: a. Find the mix of standard and deluxe golf bags to produce per week that maximizes weekly profit…
A: For this question, I would first formulate the LP, then, I would solve this LP using the 2-phase…
Q: In operations research, how does duality help in solving integer programming problems?
A: According to the concept of duality in integer programming, each issue can be approached from two…
Q: Formulate the problem. b. Find solutions for companies using simplex tables. (Stopped at iteration…
A: For this question, first I will formulate the LP, and then, I will solve this LP using 2 phase…
Q: Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the…
A: Find the Given details below:Cabinetmaker 1Cabinetmaker 2Cabinetmaker 3Hours required to complete…
Q: A manufacturer of cat towers wishes to locate a super assembly facility to meet their cat tower…
A: Find the Given details below: Given details:Sources/MarketsTransportation…
Q: In what ways does the role of an Agile Coach differ from a Scrum Master in agile project…
A: Agile coach is a team member and professional who guides the team regarding agile principles,…
Q: Explain the concept of data transformation in data management. How can organizations effectively…
A: Data transformation is a fundamental component of good data management, where raw and frequently…
Q: A rancher is mixing two types of foods, Brand X and Brand Y, for his cattle. Each serving for cattle…
A:
Q: Describe the challenges and benefits of implementing remote printing solutions for enterprises
A: Before we move on to understanding the challenges and benefits of implementing remote printing…
Q: Based on the following sensitivity report, what would be the change in the objective function value…
A: A sensitivity report is a tool used by the organization to understand the impact of changes in the…
Q: Compare the Wilson approach with the Just-In-Time (JIT) inventory system, highlighting their…
A: Wilson ApproachThe Wilson approach, also known as the Economic Order Quantity (EOQ) model, is a…
Q: Typically George Heinrich yearly uses 1500 of a certain sub assembly part that has an annual holding…
A: Yearly demand (D) = 1500 unitsAnnual Holding Cost = $45 per unitPer Order Cost = $150Error in…
Q: Today’s Electronics specializes in manufacturing modern electronic components. It also builds the…
A: Find the given details below: AlternativesOutcomesLarge Facility $ 550,000 $…
Q: A bank has an average of 10 customers per hour arriving into the system, and it takes an average of…
A: Given that:
Q: The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest party…
A: A moving average is a statistical calculation used to analyze data over a specific period of time by…
Q: What role do lead times play in the implementation of the Wilson approach in supply chain…
A: The Wilson EOQ (Economic Order Quantity) model is a fundamental tool in supply chain management used…
Q: Conduct a mathematical analysis of the Wilson EOQ model and its practical applicability in…
A: A well-known inventory management method known as the Economic Order Quantity (EOQ) model aids…
Q: Describe the role of digital asset management (DAM) systems in organizing and preserving digital…
A: Digital asset management is the process or systematic approach and software solution for storing,…
Q: What is the upper control limit for the most appropriate control chart? 0.1889 36812 0.2566 11402…
A: Control charts are also known as process-behavior charts. It is a statistical process that helps in…
Q: Question 4 If the response rate you would obtain by mailing all your customers (i.e., no model RR)…
A: Response rates help the organization determine the performance of a marketing campaign for the…
Q: Explain the concept of master data management (MDM) and its significance in maintaining consistent…
A: Organizations consist of several departments that work together to fulfill a common organizational…
Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…
A: Actual demand for 8 periods along with 2 different forecasts are provided below:
Q: First line supervisors are responsible for directing the day-to-day activities of operative…
A: Managers are classified into various types as per the organizational level of hierarchy where they…
Q: Investigate the use of sustainability metrics in project analysis. How can projects be evaluated not…
A: Sustainability metrics play a crucial role in assessing projects not only for financial success but…
Q: Discuss the application of reliability-centered maintenance (RCM) in optimizing maintenance…
A: Reliability-centered maintenance has wide application in optimizing maintenance strategies for…
Q: .If x and y denote the number of dryer machines to be shipped to warehouse A and warehouse B…
A: Linear programming optimizes the allocation of resources such that the costs are minimized and…
Q: Explain the concept of reorder point within the Wilson approach and its role in inventory control
A: The Wilson approach, also known as the Economic Order Quantity (EOQ) model, is a principle used in…
Q: 2. Six jobs must be processed through machine A and then machine B as shown below. The processing…
A: Gantt Chart displays the time required to process the jobs in the order of 1 to 6 machines as per…
Q: (Please use the format in the other Spreadsheet Image) Model Inc. has to transport 100 bags of Type…
A: One of the core ideas or domains in supply chain and logistics management is the…
Q: Owners of a local restaurant are concerned about their ability to provide quality service as they…
A: Capacity is the capacity of an individual/machine to give a yield in a given time/asset.…
Q: A catering company prepared and served 250 meals at an anniversary celebration last week using 8…
A: Meals servedNo. of workersAnniversary2508Wedding2303
Q: Describe the challenges and benefits of implementing blockchain technology in supply chain…
A: SCM is a strategic approach to integrating supply and demand in the market. It involves several…
Q: Conduct a comprehensive comparative analysis between the Wilson approach and the ABC analysis method…
A: Both the Wilson EOQ approach and the ABC analysis method are essential tools in inventory…
Q: How does the role of a Product Owner in Agile methodologies differ from a traditional Project…
A: Even though the terms project manager and product owner are sometimes used interchangeably, both…
Q: Apply Lean Management to a workplace you are familiar with. Your aim will be to Reduce any kind of…
A: Lean management, a rigorous approach, emphasizes raising value and cutting waste in business…
Q: Table 3: Number of incorrect bills issued at checkout (50 observations) Number of Number of…
A: One of the important tools among all the tools of quality management is the process control charts.…
Q: Refer to the SPC % defective chart: Based on the principles of out of control patterns that we…
A: The above chart is a Statistical Process Control Chart(SPC) which is depicting the percentage of…
Q: What is project analysis, and why is it a critical phase in project management? How does it…
A: Within the field of project management, project analysis plays a crucial role as the compass that…
Q: 49) A company produces two types of tables, T1 and T2. It takes 2 hours to produce the parts of one…
A: Linear programming helps us to find the optimal solution/best outcome, with the given…
Q: Compute the Service Quality Indicator by finding the weighted sum of errors as a percentage of total…
A: Here, let me state the given data table, I will determine the Service quality indicator % in the…
Q: Provide examples of industries that have successfully implemented the Wilson approach for inventory…
A: Inventory optimization is a critical aspect of operations management, aiming to strike a balance…
Step by step
Solved in 4 steps with 3 images
- 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.)Flora Co sells bunches of fresh flowers which have a limited shelf life so forecasting sales demand is extremely important for maximising profits. Quarter 1 Quarter 1 contains a national holiday and as a result sales of a particular red flower are usually very high. Sales of the red flower will depend on market conditions. After the national holiday there will be no demand for the red flowers and they will be thrown away. Flora Co must decide whether to purchase 250 bunches, 400 bunches or 500 bunches of the red flowers from its supplier for re-sale to its customers. The following payoff table has been produced: Market conditions Poor Good Excellent Expected value Probability 0.20 0.25 0.55 Number of bunches to be bought from supplier 400 $900 $3,900 $3,900 250 $2,400 $2,400 $2,400 $2,400 $3,300 500 ($100) $2,900 $4,900 $3,40013 Pam’s demand for hats is normally distributed with mean 500 and standard deviation 100. She sells her hats for $50 each and buys hats for $10 each, and anything she can't sell by the end of the year, the wholesaler will buy for $5 each. How many hats should she order for next year to maximize profit?
- Dan’s Independent Book Store is trying to decide on how many copies of a book to purchase at the start of the upcoming selling season. The book retails for $28.00. The publisher sells the book to Dan at $20.00. Dan can dispose of all of the unsold copies of the book at 50% off the retail price, at the end of the season. Dan estimates that demand for this book during the season is Normal with a mean of 1000 and a standard deviation of 250. Question 1: What is the quantity that Dan should order to maximize his expected profit?3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $12 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $1 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 15 pounds. a) What is the cost of underestimating demand for each pound? b) What is the overage cost per pound? c) How many pounds of oyster should she order each day? d) What is the stockout risk for this order size?Cynthia Knott's oyster bar buys fresh Louisiana oystersfor $5 per pound and sells them for $9 per pound. Any oysters notsold that day are sold to her cousin, who has a nearby grocery store,for $2 per pound. Cynthia believes that demand fo llows the normaldistribution, with a mean of I 00 pounds and a standard deviation of15 pounds. How many pounds should she order each day?
- A book and paper store distributes one specialized monthly magazine. When looking at the sales the last years, they have concluded that the demand for each issue of the magazine will be normally distributed with an expected sale of 250 and a standard deviation of 100. The purchase price for the magazine is $20. and the sales price is $50.The store has an agreement with a second -hand store that buys unsold magazines for $5 each. How many magazines should the store buy of each issue?Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases thepencils for 6 cents each and sells them for 20 cents each. There is a two-monthlead time from the initiation to the receipt of an order. The store accountantestimates that the cost in employee time for performing the necessary paperworkto initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lostprofit plus an additional 20 cents per pencil, which represents the cost of loss ofgoodwill.b. Find the simultaneous optimal values of Q and R.Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases thepencils for 6 cents each and sells them for 20 cents each. There is a two-monthlead time from the initiation to the receipt of an order. The store accountantestimates that the cost in employee time for performing the necessary paperworkto initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lostprofit plus an additional 20 cents per pencil, which represents the cost of loss ofgoodwill.d. What is the safety stock for this item at the optimal solution?
- A distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sells them for 20 cents each. There is a two-month lead time from the initiation to the receipt of an order. The store accountant estimates that the cost in employee time for performing the necessary paperwork to initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lost profit plus an additional 20 cents per pencil, which represents the cost of loss of goodwill.a. Find the optimal value of the reorder point R assuming that the lot size used is the EOQ.b. Find the simultaneous optimal values of Q and R.c. Compare the average annual holding, setup, and stock-out costs of the policies determined in parts (a) and (b).d. What is the safety stock for this item at the optimal solution?3. Gursoy is selling Christmas trees. She purchases trees for $10 and sells for $25 each. The number of trees she can sell is normally distributed with a mean of 100 and standard deviation of 30. How many trees should Gursoy purchase?