A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The firm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000.Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, maybe expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?

A Make-or-Buy DecisionTriple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The firm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000.Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, maybe expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

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.
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.
At the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.
A company is operating in two unrelated businesses. The first one is making common salt, which is sold in one kilogram consumer packs. The second business is making readymade garments. The owner of the businesses has decided to implement Materials Requirement Planning (MRP) in one of the two businesses, which is likely to give him greater benefit. Assuming that the current turnover and profits of both the units are comparable, compare the relative benefits and limitations of Materials Requirement Planning (MRP) for these two businesses.
Aqua Man Company manufactures and sells a single product. Planned and actual production in its first year of operation was 100,000 units. Planned and actual costs for the year were as follows: Manufacturing Non-manufacturing Variable P600,000 P500,000 Fixed P400,000 P300,000 The company sold 85,000 units of product at a selling price of P30 per unit. Using absorption costing, the company’s operating profit was Select one: a. P1,020,000 b. P975,000 c. P900,000 d. P750,000
Hayworth Corporation has Just segmented last year's income statement into its ten product lines. The chief executive officer (CEO) is curlous as to what effect dropping one of the product lines at the beginning of last year would have had on overall company profit. What is the best number for the CEO to look at to determine the effect of this elimination on the net operating income of the company as a whole? Multiple Choice the product line's sales dollars the product line's contribution margin the product line's segment margin the product line's segment mergin minus an allocated portion of common fixed expenses
Assume that a customer in the small contractor target market segment buys an electric drill on average every two years (or every 0.5 year) for $200, when the gross margin on the drill averages 40 percent. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet 3. What is a 1 percent change in market share worth to the manufacturer if it represents 150,000 customers? Round your answers to the nearest dollar. 50 percent customer retention rate case: $ fill in the blank 4 75 percent customer retention rate case: $ fill in the blank 5 4. What do you conclude? If customer retention can be increased from 50 to 75 percent through better value chain performance, the economic payoff is .
Consider a manufacturer of perfume who is about to expand production capacity to make a new product. Three alternative production processes are available. The following table shows the estimated profits (in $) for these processes for each of the three possible demand levels for the product. Alternatives States of Nature Low demand Moderate demand High demand A 100,000 350,000 900,000 B 150,000 400,000 700,000 C 250,000 400,000 600,000 Based on the above information, what would be the amount of regret, if alternative production process B is selected by the manufacturer and suppose that the level of demand turns out to be low?
How much is the total cost of producing 150 grams of honey if the company uses the least squares method?
You are brand manager at Arrow Cosmetics and responsible for Silkskin body lotion. Silkskin's annual contribution is currently $2.1 million. The R&D department has just developed a new Aloe Vera-based body lotion formula. You must decide whether you want to change the formula for the Silkskin lotion or stay with the old one . The variable costs will be slightly higher for the new formula ($7.00 per bottle), but you guess that an increase in sales might compensate for the higher costs. You plan on selling the new Silkskinfor $ 12.00 per bottle. You can imagine three annual sales scenarios: 600,000 , 300,000 and 200,000 units sold, which you estimate the chances to be 30, 40, and .30, respectively. 1. Under which scenario (s) would you introduce the new Silkskin? 2. Would you introduce the new formula? 3.Imagine a market research firm that provides perfect information. In other words , if the firm tells you that annual sales will be "x", then sales will in fact be x. What is…
You are asked to help your boss deciding who is considering whether to make or buy a part fora top most demanding product of the company.Your company can make the component for $40 per unit or buy it for $50 per unit from vendor.If the Company decides to make the component, it will require 4 hours of machine time tomake each part. The company has 2,000 hours of machine time available per month. Shouldthe company make or buy the component? How many max parts company can make?________________________________________________________________
You have two design options for your new line of high-resolution monitors for Computer-Aided Design (CAD)workstations. The production run is for 110,000 units. Design option A has a .90 probability of yielding 65good monitors per 100 and a .10 probability of yielding 70good monitors per 100. This design will cost $1,000,000. Design option B has a .80 probability of yielding 65good units per 100 and a .20 probability of yielding 60good units per 100. This design will cost $1,350,000. Good or bad, each monitor will cost $75. Each good monitor will sell for $150. Bad monitors are destroyed and have no salvage value. We ignore any disposal costs in this problem. Demonstrate how decision trees can be used in order to choose the design option based on the above situation. Calculate the expected monetary value (EMV) of each option and determine which option you will propose.