I’ve been able to find the optimal solution and resulting profit with excel solver. But can’t figure out how to set up the problem with POM QM
Q: dinars annually, find the following: break-even point (quantities), break-even point (values),…
A:
Q: 3. What is ABC Classification? 4. What is JIT? 5. What is the Kanban System?
A: Inventory management is the process of ordering, storing, using, and selling goods. This comprises…
Q: dentify and discuss the theories of leadership and motivate which of these offers an adequate…
A: Leadership theory studies the qualities of good leaders. Psychologists analyze and develop…
Q: The hierarchy of components, their description, and the quantity of each needed to make one unit of…
A: The elements or components hierarchy generally focuses on developing meaningful relationships…
Q: A linear programming computer package is needed. of a of customers make reservations via phone.…
A: Given data is Day Minimum employees needed Monday 75 Tuesday 55 Wednesday 50 Thursday 70…
Q: I will give an upvote if you follow my instructions. thank you. please skip if you have already done…
A: The question is related Classification of Cost. It means the grouping of costs according to their…
Q: The current spot exchange rate is E$/£ = 1.32 and the 3-month forward rate is F$/£ = 1.26. Based on…
A: A spot exchange rate is a price at which an individual derives a currency in exchange for another so…
Q: The master production schedule (MPS) specifies: Select one: None of the mentioned When the finished…
A: Master production schedule often called MPS can be stated as the term that is used to describe the…
Q: The current values of sales of a product in a company are as follows: November - 22, December -…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: What exactly is an evaluation plan?
A: As the roadmaps are used to facilitate the progress in the journey, same as the evaluation plan…
Q: Discuss the concepts of internal and external supplychain integration and explain why each of these…
A: The term supply chain refers to the entirety of the process by which an organization obtains the…
Q: How the design of blackberry phone looks like? 2-Is the design of blackberry phone user friendly or…
A: Blackberry, which was the pioneer in mobile-based technologies with its best selling original…
Q: What is JIT?
A: Just in Time is an inventory management system whose objective is to produce or to procure products…
Q: The manager of a Burger Doodle franchise wants to determine how many sausage biscuits and ham…
A:
Q: Explain the Zero-base bud geting approach.
A: Zero-base budgeting was first introduced by Robert S. McNamara during his time as Secretary of…
Q: How did the requirements prioritization activity go? What were the issues and challenges? How can…
A: Requirement prioritization is used to set requirements in a project so that engineers and…
Q: Question 9 Shortening (crashing) the schedule goal is to reduce the project duration with a increase…
A: Note- Hi! Thank you for the question As per the honour code, We’ll answer the first question since…
Q: Ms. Math must supplement her diet with at least 80 mg of calcium and at a minimum of 17 mg of iron.…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Describe the advantages of the strategies tie to outcome and experiences described in question 1 in…
A: The given case study is about a resort offering several accommodation options. The resort has…
Q: What are the Importance of quality to the national interest of any country?
A: The term quality can be understood as fulfillment of certain prescribed standards. A quality product…
Q: How does reed hastings deal with motivating people and with conflict in the work place
A: Motivation is needed in every organization and it is the motive of the employee which drives the…
Q: Consider the transportation table below. Unit costs for each shipping route are in dollars.…
A: Least cost method is used to find the total cost of transportation of goods from source to…
Q: SA now exports more raw copper than it produces or imports, as criminals drive demand for stolen…
A: The macro factors are the set of components that exist in the business environment. These factors…
Q: In personal selling and sales management inputs and outputs are not always same- Explain why? Please…
A: Personal selling is also known as face-to-face selling in which one person who is the salesman tries…
Q: Find the basic initial solution to the following transportation problem using the northwest corner…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: What is ABC Classification?
A: For companies that deal with large volumes of inventory, it’s useful to find a method to classify…
Q: Evaluate the ways in which time and quality can affect the cost of a project
A: Time: earlier the time taken for construction of a project better it is because the project can be…
Q: When will the project be completed?
A: Project network diagram is the diagram that visually represent the project activities and their…
Q: Question - what is process selection and facility layout ?
A: Definitions Process selection: - When there are various processes available to execute to reach the…
Q: A small bagel stand known as Andres by the Sea offers drive-thru service to customers in Sants…
A:
Q: 1. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: the optimal Q and TC given the following information: D = 3,000 liters Selling price per liter = $45…
A:
Q: Temperature is used to measure the output of a production process. When the process is in control,…
A: Control charts are also known as process-behaviour charts. It is a statistical process that helps in…
Q: The supply chain management opportunity called postponement involves delaying deliveries to prevent…
A: Inventory management is described as the process of managing or handling inventory. It acts to…
Q: Using the provided template, show the steps to get the solution. During each four-hour period, the…
A: Find the given details below: Given details: Starting 4 hours of 8-hour shift Midnight -…
Q: Explain how the task oriented and relation oriented behaviour related to effective leadership in an…
A: To be determined: how the task oriented and relation oriented behaviour related to effective…
Q: A manufacturer produces lots of a canned food product. Let p denote the proportion of the lots that…
A: Since, the (a) and (b) part has already been correctly solved, I have solved the (c) part in the…
Q: What would a manager do if they noticed they received a damaged product after they signed the…
A: Shipping claims are important to be understood by both, the buyer and the vendor. Because for…
Q: GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 2. During the winter WeeMow…
A: Let, R = Number of residential jobs C = Number of commercial jobs Objective function: Maximize Z =…
Q: If Julia clears at least $1,000 in profit for each game after paying all her expenses, she believes…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Is this statement true or false? And why? “Because strategy informs a tactical plan, operational…
A: Strategy: Strategy is defined as it is an overall direction of the company/business…
Q: What potential affect, if any, can your organization’s strategic plan play in their selection of…
A: Implementation is a term that is not specific to EHR systems, it refers to integrating a…
Q: Supppose that customers are asked to rate the quality of the service provided at a busy service…
A: a. Reliability, Assurance, Tangibles, Empathy, and Responsiveness;- These all are the…
Q: 17. Services differ from manufactured products in four ways. Intangibility, Inseparability,…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Describe the many kinds of programmes.
A: A computer program is a set of instructions to perform a particular task. A computer program is used…
Q: List the interrelated components of the performance management process and. explain how the poor…
A: Performance management:- The performance management process is designed to ensure that desired…
Q: Choose the best answer. The Production Planning Hierarchy: Box "C" A B CD Strategic Planning…
A: STRATEGIC PLANNING: Strategic planning in production can be defined as an overall planning which is…
Q: On August, a light business bought $3600 worth of lamps. At the beginning of September, the store…
A: The cost of goods sold is calculated with the help of following formula Cost of Goods Sold =…
Q: GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 1. Southern Sporting Goods…
A: Let, B = Units of basketball to be produced F = Units of Football to be produced Objective…
Q: 1. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from…
A: Objective Functions and Constraints: Based on the given details, the objective…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.n additional equipment (AE) costing$3,500,000 will be needed at the end of year 3. At the end of seven(7) years, the original equipment, IE, will have no resale value butthe supplementary equipment, AE, can be sold for $50,000. A workingcapital of $1,350,000 will be needed.The project is forecast to generate sales of agri-products over theseven years as follows:Year 1 70,000 unitsYear 2 100,000 unitsYears 3-5 250,000 unitsYears 6-7 325,000 unitsA sale price of $150 per unit for the first two years is expected andthen decline to $90 per unit thereafter as the newness of the productloses some sheen. The variable expenses will amount to 30% of salesrevenue. Fixed cash operating expenses will amount to $1,100,000 peryear.The company falls in the 25% tax category for ordinary income and 40%tax category for capital gain.The initial equipment is depreciated as per the 7-year MACRS systemand the additional equipment is depreciated on a straight-line basis.In the event of a negative taxable…Define the decision variables ,Formulate the objective function, Formulate the constraints Sears Investment has $250,000 available to invest in a 12-month commitment. The money can be placed in Treasury notes yielding an 8% return or in municipal bonds at an average rate of return of 9%. Bank regulations require diversification to the extent that a t least 50% of the investment be placed in Treasury notes. Because of defaults in such municipalities as California and Texas, it is decided that no more than 40% of the investment be placed in bonds. How much should Sears Investment invest in each security so as to maximize its return on investment?
- A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.14. Stephanie, the supply chain analyst of Nestle is asked to present an expansion plan for thecompany. The plan is either to construct a plant, open a distribution center, or do nothing. Fromthe plant construction, the company will gain 80,000Php if the market turns favorable, loss of10,000 if average, and loss of 50,000 if unfavorable. From opening a distribution center, thecompany will gain 40,000Php if favorable, gain 20,000Php if average, and loss of 30,000Php ifunfavorable. And if the decision is do nothing, the company will gain nothing regardless of themarket turnout. Then, he was able to determine further the probability of occurrence of eachtype of market. The probability of occurrence is 60%, 25%, and 40%, respectively. He also foundout that he can buy the information on what will really happen to the market for 2,000Php.a. What should be the analyst’s decision?b. How much gain or loss will he expect for the company?c. Should he buy the perfect information? Why or why not?d.…Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal 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 Current Inventory Men’s $120 20 Women’s 90 30 The company charges monthly inventory at the rate of 2% of the production cost based on the inventory levels at the end of the month. The company would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this problem as a linear programming model so that a production schedule can be established in order to minimize production and inventory costs and satisfies the labor-smoothing,…
- Prepare a Master Production Schedule (MPS) for an Agri-Chemical company in Malawi given the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are as follows:Week Customer Orders1 522 353 204 12Use a production lot size of 75 units and no beginning inventory.CVP Analysis Lawn Master Company, a manufacturer of riding lawn mowers, has a projectedincome for the coming year as follows:Sales $46,000,000Operating expenses:Variable expenses $32,200,000Fixed expenses 7,500,000Total expenses 39,700,000Operating profit $ 6,300,000Required1. Determine the breakeven point in sales dollars.2. Determine the required sales in dollars to earn a before-tax profit of $8,000,000.3. What is the breakeven point in sales dollars if the variable expenses increases by 12%?Northwest Pipe (NP) makes water pipe. NP is planningproduction for the next seven months, March through September.Th e forecast demands (in thousands of feet) are, respectively, 40,60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe permonth using regular-time production, at a cost of $1.25 per foot.Th ey can make up to an additional 15,000 feet using overtimeproduction at a cost of $1.50 per foot. Any pipe made in onemonth and sold in a later month incurs an inventory holding costof $0.15 per foot, per month. NP expects to end February with5000 feet of pipe and would like to plan to end September with10,000 feet in inventory. NP would like to plan their productionschedule to minimize total cost during the next seven months. (a) Formulate an LP to minimize total costs.(b) Set up and solve the problem on a spreadsheet.(c) What is the optimal solution? Explain the rationale for thesolution
- A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4 and again in period 8, as can be seen from the following forecasts: Period 1 2 3 4 5 6 7 8 9 Total Forecast 190 230 260 280 210 170 160 260 180 1,940 The department now has 20 full-time employees, each of whom can produce 10 units of output per period at a cost of $6 per unit. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager is considering a plan that would involve hiring two people to start working in period 1, one on a temporary basis who would work only through period 5. This would cost $500 in addition to unit production costs. a. What is the rationale for this plan?A machine shop has an order for 12 000 pcs of a machine part that requires anti-corrosive properties. Chromium steel alloy that cost Php. 95.00/kg or Nickel steel alloy that cost Php. 65.00/kg may be used. The weight per piece, production rate per day and tool bit replacement cost for Cr-alloy are: 0.25 kg, 75 pcs and Php. 1 600.00 for every 400 pcs produced. The respective date for Ni-alloy are 0.3 kg, 50 pcs and Php. 1 800.00 for every 300 pcs produced. If the charge for the labor and other operating cost is Php. 450.00/day, with all other expenses being the same, determine which material should be used.USCA Oil is a privately-held firm, owned by three families. They have two plants in the US (one in Dallas and one in Indianapolis) and one plant in Canada (Edmonton). They also have acquired a small lab in Grand Rapids, Michigan. Except for one item, all the items below can potentially cause a principal-agent problem. Choose the item that does not cause such a problem. 1. Expanding their NPD group, the managers in Indianapolis plant are hiring two highly educated engineers. 2. The manager of the Dallas plant is hiring a new HR Director. 3. To organize lab operation in Michigan, the owners have asked the previous manager of the Edmonton's plant to become the manager of their newly-acquired lab. 4. One of the owning families plans to sell half of its existing stocks to the other two families, with equal shares. #2 is not correct