A company faces the following demand during the next 3 weeks: week 1, 20 units; week 2, week are as follows: week 1, S13; week 2, S14; week 3, S15. A holding cost of $2 per unit is a of week 1, the company has 5 units on hand. Determine how to minimize the cost of meetin $560.) After solving the problem, use the SolverTable to see what happens to the decision variable in increments of 5 units How much lower would the total not cost ho? and at what rate of
Q: Consider the following problem. Maximize Z = 5x1 + 3x2 + 4x3, Subject to 2x1 + x2 + x3 ≤ 20 3x1 + x2…
A: Maximize Z = 5x1 + 3x2 + 4x3,Subject to2x1 + x2 + x3 ≤ 203x1 + x2 + 2x3 ≤ 30andx1 ≥ 0, x2 ≥ 0, x3 ≥…
Q: The hospital controller was looking at the latest productivity report for the ICU. She noticed that…
A: Find the given details below: Given details:Total paid hours3887hoursWorked hours3499hoursPay…
Q: Consider a project consisting of the following tasks: Task Duration (weeks) Dependencies A 6 – B 5 –…
A: Here, each task is given with the duration data and dependencies, I would draw an activity-on-arc…
Q: Discuss the relationship between Economic Order Quantity and Just-In-Time inventory system. Which…
A: 1. Economic Order Quantity (EOQ):The optimal order quantity (EOQ), which is a traditional inventory…
Q: Professional Benefits for a project management course. Organizational Benefits for a project…
A: Project managementThis can be defined as a scientific approach to managing projects for an…
Q: What is the importance of stress and aggression management
A: Organizations consist of several employees who work together for the fulfillment of the…
Q: Scenario 10: Busy Times Your grandparents are visiting from out of town and are excited to see your…
A: Staffing is the process of selecting the right candidate for a suitable position with the right…
Q: 2. Block Commodities has gathered the following information concerning rock salt deliveries (tons)…
A: The forecast is an estimation of future events so that risk faced by the company will be reduced and…
Q: Global Construction Company is planning construction of five dormitory buildings in four different…
A: Linear programming is mathematical technique that is uses set of linear equations to arrive at an…
Q: The Custom Bike Company has set up a weighted scoring matrix for evaluation of potential projects.…
A: Find the given details below: Given details:CriteriaWeightProjectProject 1Project 2Project…
Q: Directions: You were chosen to work as the country's risk management planner for the various tourism…
A: "It is crucial to protect tourists' safety and wellbeing in the fast-paced environment of the…
Q: A tax advisor is able to serve 4 customers per hour on a walk-in basis. An average of 3 customers…
A: For this question, first I would determine the utilization, From this Ref data, I could answer the…
Q: A shop makes coffees to order with a separate person working at each of the steps. Assume an 8 hour…
A: A coffee shop has the folllowing 4 process steps to serve the customer:1 person works at each…
Q: Please do not give solution in image formate thanku. Markland First National Bank of Rolla utilizes…
A: A processing facility is a facility where raw materials are gone through various transformation…
Q: Jefferson Company’s demand for its only product exceeds its manufacturing capacity. The company…
A: Find the given details below: Given details:Actual run time this week6,106minutesMachine time…
Q: Determine whether the given simplex tableau is in fina form. If so, the solution the associated…
A: Solution :From the given data :xyzuvpconstant305110262130101880702146
Q: 2. Bjorn and Thor are plumbers who have been scheduled to work on the construc tion of a new school…
A: As per the question data, here, we can understand that Thor is responsible for tasks 3, 4, 6, and 7,…
Q: Which one (1) of the following is considered a "hazard" for insurance purposes? A claims-free…
A: Getting around the insurance world includes evaluating many aspects that affect risk and potential…
Q: How do organizations categorize risks based on their severity and likelihood of occurrence?
A: The proactive management of risks that might have an influence on an organization's objectives and…
Q: Assume you are the manager of a shop that assembles power tools. You have just received an order for…
A: A Material Requirement Plan is a comprehensive document that outlines the specific materials needed…
Q: How can a shared service delivery model benefit the employees and management of an organization?
A: Shared services are a good way for businesses to keep providing good public services when there are…
Q: A company finds the following information about its customers and their locations: X coordinate 20 Y…
A: The following information about the customers and their locations are…
Q: The desired distance for Flextronchip customers is 0.2 mm between two adjacent pins. Any deviation…
A:
Q: The sensitivity range of c₁ (profit per x₁, bowls) in the Beaver Creek Pottery example was 25 ≤ c₁…
A: The problem is sensitivity analysis.Sensitivity Analysis:Sensitivity analysis is a technique used in…
Q: Use the information in Scenario 9.9 to determine the average pantry space occupied by cat food if…
A:
Q: A manager must make a decision on shipping. There are two shippers, A and B. Both offer a two-day…
A: Holding cost per unit per year=410* (0.39*156)Holding cost for 410 units per day=410*…
Q: suppose that Motorola uses the normal distribution to determine the probability of defects and the…
A: THE PROCES DISTRIBTUION GARPH IS AS ABOVE The process mean is 10 and the process S.D is 0.16So ,(…
Q: Please do not give solution in image format thanku According to ethics surveys, which of the…
A: Ethics surveys are important instruments for comprehending the complex dynamics of ethical behaviour…
Q: What tools or frameworks are commonly used by organizations to visualize and track their risk…
A: Organizations confront a variety of risks in the dynamic world of contemporary business, risks that…
Q: The difference between expected payoff under certainty and expected payoff under risk is the OA.…
A: A key idea in decision theory and economics is the contrast between anticipated payoffs under…
Q: Which employee engagement strategy is based on a company showing employees that their suggestions…
A: In today's competitive business landscape, fostering a highly engaged workforce has become a…
Q: You are calculating the cost to send a shipment through consolidation to get it to the end customer.…
A: Total cost of shipment= shipper to consolidator truckload cost+ consolidator cost+ consolidator to…
Q: Please do not give solution in image formate thanku. You chose to interview the office manager,…
A: The fleet management system is an administrative approach that helps the companies in organizing as…
Q: Why is there a need for there to be so much automation in the modern world?
A: Organizations function in an environment that keeps on changing. With technological upgradations,…
Q: How can organizations benefit from integrating Artificial Intelligence into their risk management…
A: A risk management framework helps the organization to identify the risks that can impact the…
Q: QUESTION 39 The image below is a correct representation of business process model Process Process 2…
A: The business model is a plan that is prepared by the company for successful operations of business…
Q: Topic: Threats and controls of the disbursement cycle Lourdes works at the manufacturing company…
A: A flowchart is a diagrammatic step-by-step representation of a process or a system. It helps in an…
Q: Which of the following is an example of a marketer exhibiting the ethical value of citizenship?…
A: Marketing ethics are fundamental in determining a company's reputation, consumer trust, and overall…
Q: Please do not give solution in image formate thanku. 3. Kings Department Store has 625 rubies, 800…
A: Linear programming is important for an organization as it helps in the proper allocation of…
Q: what are the steps
A: To solve the expression 224.56 - 19.95 / 0.79, follow the order of operations (PEMDAS/ BODMAS) :1.…
Q: Actual run time this week 6,106 minutes Machine time available per week 8,600 minutes Actual run…
A: Actual run time this week =6106 miles Machine time available per week =8600 minutes Actual run rate…
Q: Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and…
A: The labor productivity will be unchanged in both cases, The demand value will be increased by 55%
Q: Gabrielle Foley, owner of Pet Paradise, is opening a new store in Columbus, Ohio. Her major concern…
A: A project has 8 activities with 3 time estimates:ActivityImmediate PredecessorOptimistic…
Q: A museum of natural history opened a gift shop that operates throughout the year. Top-selling…
A: Annual demand (D) = 200Ordering cost (S) = $5Holding cost per unit (H) = 5
Q: What is the appropriate decision if a minimax regret approach is used?
A: s1s2s3d1100000300000d2800005500025000d3550005500055000
Q: Two methods are used to predict how many customers will call in for help in the next four days. The…
A: Mean Absolute Error - measures the average magnitude of the errors between the actual and predicted…
Q: Income at the law firm of Smith and Jones for the period February to July was as follows: February…
A: 1. Calculate the forecast for February using the initial forecast and trend adjustment of 0:Forecast…
Q: With reference to the relevant theory and the information ion the attached, provide an analysis of…
A: The Mayo Clinic's reputation as a preeminent healthcare facility is founded on its unwavering…
Q: 5. Step 5: Organize the Message The fifth step in the planning of a business message is organizing…
A: The structure of a message is crucial to guaranteeing clarity and comprehension in the context of…
Q: In the basic EOQ model, a monthly demand of 50 units, an ordering cost of $100, and a holding cost…
A: Monthly demand = 50 units Ordering cost = $ 100Holding cost = $ 3/unit per year
acc
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 10 images
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?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?Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
- Jays Office Supplies sells Printers, which it orders from Brands mart Inc in . Because of shipping and handling costs, each order must be for 5 printers. Because of the time it takes to receive an order, the company places an order every time the present stock drops to 5 Printers. It costs $50 to place an order. It costs the company $500 in lost sales when a customer asks for a Printer and the warehouse is out of stock. It costs $100 to keep each Printer stored in the warehouse. If a customer cannot purchase a Printer when it is requested, the customer will not wait until one comes in but will go to a competitor. The following probability distribution for demand for Printer has been determined: Questions 1.Simulate CWD 's ordering and sales policy for 20 weeks 2. Compute the average cost of the policy PLEASE NOTE I SENT THIS IN ALREADY BUT I REALIZED I LEFT OUT SOME VITAL INFORMATION AND AGAIN THIS IS NOT FROM ANOTHER SITE.Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…
- Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…A warehouse can store up to 100 units of a particular item. In each of the next N days weneed to determine the number of units to sell and then the number of units to buy. Sellingin each day precedes buying so that the maximum amount that can be sold is the initialinventory at the beginning of the day. The maximum amount that can be bought is limitedby the capacity minus the amount in inventory after selling takes place. Inventory can beheld overnight in the warehouse, provided the total number of units held does not exceed thewarehouse capacity. At the beginning of day 1, before selling takes place, there are 40 unitsof inventory in the warehouse. Suppose that pnand cnare the per unit selling and buyingprices, respectively, for each day n = 1, . . . , N . Formulate an LP in general form to determinethe amount to be sold and bought each day to maximize total profit. Make sure you havedefined your variables clearly. PLEASE provide steps on how you solved so I understand why the answer…Product X is made of 2 units of Y and 3 of Z. Y is made of 1 unit of A and 2 units of B. Z is made of 2 units of A and 4 units of C. Lead Time of X is 1 week: Y - 2 weeks; Z – 3 weeks; A – 2 weeks; B – 1 week; and C – 3 weeks. Scheduled receipt on week 5 are: A = 250 and Z = 135. If 150 units of X are needed in week 10 & 100 units in week 12, develop a planning schedule showing when each item should be ordered and in what quantity. Use lot for lot except for Y & C which requires minimum of 400 units. Determine the timing of planned release of component Z for the order of 150 units.