The data collected in running a machine, the cost of which is Rs 60,000 are given below: Year 1 2 3 4 5 Resale Value 42,000 30,000 20,400 14,400 9,650 Cost of spares 4,000 4,270 4,880 5,700 6,800 Cost of labour 14,000 16,000 18,000 21,000 25,000 Determine the optimum period for replacement of the machine.

The data collected in running a machine, the cost of which is Rs 60,000 are given below: Year 1 2 3 4 5 Resale Value 42,000 30,000 20,400 14,400 9,650 Cost of spares 4,000 4,270 4,880 5,700 6,800 Cost of labour 14,000 16,000 18,000 21,000 25,000 Determine the optimum period for replacement of the machine.

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

Year	1	2	3	4	5
Resale Value	42,000	30,000	20,400	14,400	9,650
Cost of spares	4,000	4,270	4,880	5,700	6,800
Cost of labour	14,000	16,000	18,000	21,000	25,000

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.
Company X is planning to run a project that requires an initial investment of RM 80,000.Operation cost is estimated at RM 20,000 per year starting one year from the start of theproject until its project life. Starting second year onwards, the operation cost is expectedto increase by RM 5,000 from previous year. The project will start to generate its annualincome of RM 70,000 on the second year until fifth year. The salvage value of the projectis RM 50,000 and its project life is five years. a) Construct the cash flow diagram to summarize the above transactions. b) Determine the expected project value at the end of five years. Assume the growth rateis 12%.
Lake Stevens Marina has estimated that fixed costs per month are $350,000 and variable cost per dollar of sales is $0.30 . The selling price per dollar of sales is: $1.00 Determine the effect on the break-even point in sales dollars considering each of the following independently. 1. Total fixed costs increase to $365,000. Break-even point = ÷ = 2. Variable costs decline to $0.25 per sales dollar. Break-even point = ÷ = 3. The anticipated sales volume increases to $1,100,000. Break-even point = ÷ = Comment on the BEPs from the above analyses in questions 1,2,3.
ABC Inc. must purchase a welding machine. The following is known about the machine and about possible cash flows. p=.40 p=.30 p=.30 First cost $40,000 $40,000 $40,000 Annual savings 2,000 5,000 8,000 Annual costs 12,000 8,000 6,000 Actual salvage value 4,000 5,000 6,500 The machine is expected to have a useful life of 8 years. The company has a MARR of 7%. Determine the NPW of the machine.
The Rio Credit Union has $250,000 available to invest in a 12-month commitment and wants to invest all of it. The money can be placed in Brazilian treasury notes yielding an 8% return or in riskier high-yield bonds at an average rate of return of 9%. Credit union regulations require diversification to the extent that at least 50% of the investment be placed in Treasury notes. It is also decided that no more than 40% of the investment be placed in bonds. The aim of the objective function for Rio Credit Union should be to Maximize the objective value. Decision variables: X = $ invested in Treasury notes Y = $ invested in Bonds Objective function (in decimals, eg., .07, NOT 7%): The optimal ROI occurs when: X = Y = (enter your response as a whole number). Optimal ROI value 'Z' = (enter your response as a whole number)
Two currently owned machines are being considered for the production of a part. The capital investment associated with the machines is about the same and can be ignored for purposes of this example. The important differences between the machines are their production capacities and their reject rates. Consider the following machine:Machine A:Production rate=250 parts per hourHours available for the operation= 8 hours per dayPercent defective= 5%Machine B:Production rate=290 parts per hourHours available for the operation= 5 hours per dayPercent defective= 12%The material cost is P12 per part, and all defect-free parts produced can be sold for P30 each. (Rejected parts have negligible scrap value.) For either machine, the operator cost is P45.00 per hour and the variable overhead rate for traceable costs is fiver percent of the operator cost per hour.
Parsa Real Estate Parsa Real Estate is a company that buys and rents real estate. The company is looking into buying an office building for $1M. The building has 10,000 square feet of rentable office space. The company analysts predict that they can rent the office space for $6 per square foot per month, but demand is a function of price in the following way: % Occupied = 2 - 0.2*Rent (Rent is in dollars per square foot per month. Also, at $6.00, Oscar thinks he can fill about 80% of the office space.) The building needs to be maintained (security, insurance, maintenance, etc.), which costs $10,000 per month regardless of occupancy. Also, there is a variable cost of $2 per month for each square foot occupied. Define the return on invested capital as the ratio of the profits (PER YEAR) and the invested capital. You can draw an ROIC tree in the same way that we drew a KPI tree in class. Simply have the ROIC as “the root” of the tree instead of profits. Then answer the following question.…
Chalimbana university farm is about to hire workers for its production of cabbage in a space of 5 months. as a student of farm management, you decide to increase the labour by 2 units at the first output,1 unit in the second and third output, 16 units in the fourth output and 20 units in the fifth output at each production level. The farm then realizes an output of 10,25, 65,30, and 30 in that period. The farm workers got a wage of k40 per month.a. Calculate the following at different level of output.i. marginal product, (MP) ii marginal revenue product (MRP) iii marginal resource cost (MRC)
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. Question Why is the capacity design important?
Design capacity is the ability of the company to produce the quantity of goods and services within a particular period of time when the company have best condition to produce and when the company have unlimited resources. These resource's includes- Men, Machinery, Material etc. It shows the maximum capacity of the company to produce. Effective capacity refers to the ability of the company to produce maximum quantity within a particular period of time to achieve in current production condition and current resources. It shows the real outcome capacity of the firm when the company produce within their own current condition of their production. In design capacity it is assume that the company will produce in best and ideal condition to produce goods and services while in Effective capacity it is assume that company will produce in current operating conditions. In design capacity it is assume that the company have unlimited resource's. It means these resource's include:- Men,…
The Sloan Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitability index for each project? What is the NPV for each project? Complete the following analysis. Do not hard code values in your calculations. You must use the built-in excel function to answer this question. Annual Cash Flows I II 0 $ (51,000.00) $ (14,000.00) 1 $ 24,800.00 $ 7,800.00 2 $ 24,800.00 $ 7,800.00 3 $ 24,800.00 $ 7,800.00 Required Return 10% Profitability index (I)_________________ Profitability index(II)_________________ NPV (I) ______________ NPV (II) ______________
Search for Patterns: Problem No. 1: The first week of chess club had 3 students. The second week had five students. The third week had eight students and the fourth had twelve. If this pattern continues, how many students will show up for the eight week? Problem No. 2: From the given table find the value of n if m = 50. M 1 2 3 4 5 50 N 1 3 5 7 Problem No. 3: What is the unit’s digit in the power of 7 with an exponent of 1999?