1) Table below is for a product with 150 unit lot size. The current on-hand inventory is 110 units. The product has a 2-week lead-time and a 12-week planning The forecast and demand for the product are shown in the table below: Week Forecast Customer Orders Projected Avail. Avail. To Promise MPS 2 8. 9 10 11 12 80 80 80 70 70 70 70 70 70 70 70 70 83 78 65 61 49 51 34 17 11 Pla) Given this information, develop a realistic master schedule, complete with ATP logic. P1b) Then explain how you would respond to each of the following customer order requests. Show what the master schedule would look like if the order was accepted. (Assume these are independent requests, and do not have cumulative effects.) • 20 units in Week 3 • 40 units in Week 5 100 unite in 1eolk
Q: may start at 12:01 A.M., 4:01 A.M., 8:01 A.M., 12:01 P.M., 4:01 P.M., and 8:01 P.M. Thus, the vari- ...
A: The excel model of linear programming contains the formulas used in the mathematical model. Based on...
Q: Describe why the methodology for purchasing a small system could differ from purchasing a large syst...
A: A Small Introduction about Purchasing Purchasing is one of the fundamental cycles normal to all o...
Q: What are the major benefits of effective Supply chain management?
A: Supply chain management is the process of organizing and controlling the flow of goods and services ...
Q: The Elon Company manufactures parts for an aircraft company using three computerized numerical contr...
A:
Q: ut the different aspects of careers in supply chain management. Write a few words of explanation for...
A: Transporting a product from its place of origin to its final destination is referred to as supply ch...
Q: 6-23 Barbara Bright is the purchasing agent for West Valve Company. West Valve sells industrial valv...
A:
Q: a.To set clear guidelines as to how the project schedule will be developed, managed and controlled t...
A: A project schedule is a plan which enables the project manager to make schedules about the speed of ...
Q: Amy Lloyd is interested in leasing a new Hónda and has contacted three automobile dealers for pricin...
A: Given-
Q: What is the relationship between the design of a manufacturing process and the firm's strategic comp...
A: Businesses, either manufacturing goods or providing services need to be competitive to market their ...
Q: What is non probability sampling and explain the types of the sample
A: Sampling is the utilization of a subset of the population to address the entire populace or to infor...
Q: Activity 2: Consider the following immediate preceding activity table. Draw the network and calculat...
A: A network diagram is a visual representation of a project which helps to identify the activity relat...
Q: List the disadvantages (min 5 points) of traditional procurement approach and see what are the metho...
A: Note: As per the Bartleby guidelines, only the first question has been answered. Traditional procure...
Q: Max 1A + 2B s.t. 1A S 4 1B S 3 2A + 2B = 10 A, B20 (a) Show the feasible region.
A:
Q: Activity time estimates for a production line design & implementation project at the CBA factory are...
A: Project network is the graphical representation of project activities and their duration to complete...
Q: A furniture manufacturer produces two types of display cabinets, type X and type Y. On a weekly basi...
A:
Q: What is Dr. Joseph Juran's quality philosophies and identify the products and services of him in the...
A: Over the course of his almost seventy-year career, Joseph M. Juran made several contributions to the...
Q: Activity Duration (in weeks) Depends 2 - N. Q 3 5 Q 8. R U 7 R,S V U W 3 U T,V Y 1 W 3 X, Y The tota...
A: ES = maximum (EF of all immediate predecessor) EF = ES + duration Minimum project duration = largest...
Q: How would you determine the productivity of the kitchen staff and waitstaff at Hard Rock?
A: An effective technique to determine the productivity of the kitchen staff and the team of waiters is...
Q: You are moving away from Bloomington and need to load a truck. The items that will go on the truck m...
A: given,
Q: Explain the operations function and the nature of the operations manager's job
A: To determine: The operations function and the nature of the operations manger's job. Operations: Whe...
Q: A project consists of 7 activities and the three time estimates are given below Subject: Operation R...
A: Expected time is the time duration that is estimated by the project manager for the particular activ...
Q: (1) How does John Stuart Mill answer those who might say that people would not always prefer the lif...
A: Mill defines utilitarianism and proposed a theory which was based on the principle that actions ar...
Q: A manufacturer produces bicycles and motorcycles, each of which must be processed through two machin...
A:
Q: 12. manufacturing a. act oriented b. goods oriented c. service d. tangible
A: Manufacturing can be stated as the production of products through the use of workforce or labor, too...
Q: A company begins a review of ordering policies for its continuous review system by checking the curr...
A: SKU means "stock keeping unit" and - as the name proposes - it is a number that retailers allot to i...
Q: In what way do the strengths and weaknesses of qualitative research help us in writing a research pr...
A: You'll almost likely need to produce a convincing research proposal if you're nearing the end of you...
Q: Dolls are fabricated in a process with two resources. The first resource has a capacity of 1.5 dolls...
A: Direct labor is productive labor that is allocated to a specific product, cost center, or work order...
Q: 6-27 Ross White’s machine shop uses 2,500 brackets during the course of a year, and this usage is re...
A: Given- Annual Demand (D) = 2500 bracketsHolding cost (H) = $1.50 per bracket per yearOrdering cost...
Q: To select a reliable forecast technique that you can use to predict the future sales of your bags ba...
A: given,
Q: What is meant by a projects constraints and assumptions?
A: Project management is the management in which different types of skills and equipment are required t...
Q: 1.What is Project Scope 2.Define Project Scope Management 3. Purpose of Project Scope Management
A: Note - Hi! Thank you for the question, As per the honour code, we are allowed to answer three sub-pa...
Q: Which of the following would not normally operate as a service business? a.pet groomer b.lawn care ...
A: A service oriented business is a type of businesses which deliver the value by preforming some kind ...
Q: Case Study-Appraisal It had been one hour since Phil Lee, a long-time professor at Conseco College (...
A: There’s still a stigma surrounding the mental health issues as sharing of medical information about ...
Q: FAMILY BUSINESS DYNAMICS Thomas Sages looked stern and preoccupied upon his return from the funeral...
A: Thomas Sages looked harsh and distracted upon his return from the burial service of his companion Da...
Q: h to basic research
A: 3 types of approach to basic research
Q: . What type of organizational chart is illustrated for McDonald’s? 2. What improvements could you r...
A: given,
Q: “Your next load of groceries may be moved by a modern-day bionic man or woman writes,” The Wall Stre...
A: Workplace injuries are described as the illness and the injuries that take place when an employee ca...
Q: IT Strategy?
A: Originally developed in the early 1990s, business process re-engineering (BPR) is an organizational ...
Q: How does shortage and overage in inventory affect the profitability of the business organization
A: As per Bartleby's guidelines, I have answered the first question for you. Kindly post the remaining ...
Q: PDF Reader Pro Lite File Edit Annotate View PDF Go Tools Bookmarks Window Help i Fri 25 Feb 7:10 PM ...
A: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and s...
Q: What is the new capacity of this process? _____ apples per minute
A: Capacity is the amount that something can be produced.
Q: A large department store operates seven days a week. The manager estimates that the minimum number o...
A: Decision variable: Suppose-X1 be the no. of salespersons having off-days on Monday & TuesdayX2...
Q: Aggregate Planning and Master Scheduling Planners of the company are about to prepare the aggregate ...
A: Find the Aggregate plan below: The required total cost is 51100000 LE.
Q: Find the initial basic feasible solution of the following transportation problem by The Least Cost M...
A: A Small Introduction about Transportation The activity of transport is characterized as the speci...
Q: Next question Jackson (Mississippi). The table below gives the factors that Ken thinks are important...
A: Given-
Q: The following Level 0 MRP information is given for a personal computing system. Using a lead time o...
A: The net material requirement is the amount requiring genuine operations subsequent to allotting the ...
Q: 1. What do you think are the limitations of the Outline/Operations Process Chart? Would you suggest ...
A: A Small Introduction about Process Chart A flowchart is a visual representation of a computation. I...
Q: hat is an orientation program? Why is it important?
A: Orientation is somebody recognizing where they are, the way someone is fronting, or the way somebody...
Q: A Social Project manager is faced with a project with the following activities: Activity-ID ...
A: Given data is
Q: The director of Quality and Reliability department of Philips Semiconductor had received quality iss...
A: Total quality management (TQM) is the ongoing process of identifying and reducing or eliminating pro...
MPS
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 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. 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?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?
- You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPLAccompany makes two products (1&2) each product requires time on two machines (A&B). specification for each product is as follows. Product1 product2 Processing time on Machine A (hrs/unit) 2 2 Processing time on Machine B (hrs/unit) 1 2 Material and labour cost ( ksh/unit) 14 15 Selling price (ksh/unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hours and on machine B is 260 hours. Formulate the linear programme which, when…A linear programming computer package is needed. The Silver Star Bicycle Company will be manufacturing both men's and women's models for its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown. Model Production Costs Labor Requirements (hours) Current Inventory Manufacturing Assembly Men's $120 2.0 1.5 20 Women's $90 1.6 1.0 30 Last month the company used a total of 1,000 hours of labor. The company's labor relations policy will not allow the combined total hours of labor (manufacturing plus assembly) to increase or decrease by more than 100 hours from month to month. In addition, the company charges monthly inventory at the rate of 2% of the…
- Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information.Month1 2 3 4 5 6Demand 160 150 160 180 170 140CapacityRegular 150 150 150 150 160 160Overtime 10 10 0 10 10 10Cost Per UnitRegular time $50Overtime 75Subcontract 80Inventory holding, per month 4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero.Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity = Regularproduction.A consulting firm has four projects to consider. Each project will require time (in days) in the next three months according to the table below. Project Time in first month Time in second month Time in third month Revenue A 6 8 6 22000 B 5 6 8 18000 C 8 7 6 16000 D 5 5 4 15000 Revenue from each project is also shown. There is 20 days’ time available in the first month, 22 days’ time available in the second month, and 22 days’ time available in the third month to do these projects. The management wants to select at most 3 projects. If project B is selected, then project C must also be selected. The objective of the firm is to maximize the total revenue. Formulate an integer optimization model for this problem by defining the decision variables, the objective function and all the constraints.…Mr Sng is a retiree in his late sixties. He has $100,000 to invest. He has no regular source of income and no other assets. He is evaluating between 3 different lump-sum financial products shown in Table 3. All products require a minimum investment sum of $100,000. Monetary returns represent the net gain after one year of investing in the product. For example, if Mr Sng chose to invest in Product B, he may lose $5,000 after one year if the GDP growth is negative. He will earn $8,000 if the GDP growth exceeds 2% at the end of the year. If you were in the shoes of Mr Sng, how would you select the appropriate investment product for a time horizon of one year? (i) Use the Optimistic, Conservative and Regrets payoff analysis approaches. State which product(s) Mr Sng should invest in and what monetary return he can expect from each approach (ii) As you have only enough funds for one product, identify the most appropriate investment product. [Hint: Be sure to consider the…
- ) The following data have been prepared for master production scheduling purposes in IKEA Australia: End product A: Beginning inventory of 60, Period forecast of 10, Lot size of 30, and 30 hours in lot size. End product B: Beginning inventory of 20, Period forecast of 5, Lot size of 20, and 20 hours in lot size. End product C: Beginning inventory of 30, Period forecast of 15, Lot size of 50, and 50 hours in lot size. Capacity: 38 hours/ week (i) Prepare the master production schedule for these items during the next four periods using the Ethan Allen master production scheduling method. (ii) Suppose that the master production schedule is frozen for the next three periods. What specific impact would the policy have on the IKEA's performance?The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers are shown in the table below: Month & Requirement January - 710 February - 1090 March - 880 April - 690 May - 1400 June - 1130 July - 1550 August - 1020 September - 530 October - 390 November - 980 December - 1210 Current inventory is 140 units. Current capacity is 1,030 units per month. The average salary of production workers is $1,150 per month. Material costs $140/unit. Each production worker accounts for 35 units per month. Overtime is paid at time and a half. Any increase or decrease in the production rate costs $40/unit for tooling, setup, and line changes. This does not apply, however, to overtime. Inventory-holding costs are $30 per unit per month. Lost sales are valued at $70 per unit. Compare the costs of level and chase demand production plans using the Agg Plan – Level and Agg Plan – Chase…Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rod is $2,000, and the cost required to set up the production for the 6-cylinder connecting rod is $3,500. Manufacturing costs are $15 for each 4-cylinder connecting rod and $18 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line.Once the line has been set up, the weekly production capacities are 6,000 6-cylinder connecting rods and 8,000 4-cylinder connecting rods. Letx4 = the number of 4-cylinder connecting rods produced next week,x6 = the number of 6-cylinder connecting rods produced next week,s4 = 1 if the production line is set up to produce the 4-cylinder…