Options cost great lakes automotive same amount of money

Assignment Help Operation Management

Reference no: EM131268528

Great Lakes Automotive (GLA) is considering producing, in-house, a gear assembly that it currently purchases from Delta Supply for $6 per unit. GLA estimates if it chooses to manufacture the gear assembly, it will cost $23,000 to set up the process and then a marginal cost of $3.82 per unit for labour and materials.

a. At what sales volume would these options cost GLA the same amount of money?

b. Assume now that GLA will be able to sell the new gear for the same price it buys it from Delta supply (i.e. $6/unit). Let S = sales forecast of the number of gears that can be sold and X = the number of gears produced. Write an (algebraic/mathematical) expression for the profit in terms of these two variables (or parameters) X and S. Hint: The actual sales will be the smaller of X and S.

c. Formulate a spreadsheet model that will give the profit in part b for any values of the two parameters, X and S. Use the Excel goal seek command (Data > What-If-Analysis > Goal Seek) to calculate the break-even point found in part a. How many gears should GLA make when S = 9,000 gears and when S = 12,000 gears? What are the corresponding profits? (Hint: Your spreadsheet needs to incorporate the following logic: X = 0 if S < BEP and X = S if S > BEP, where BEP = break-even-point.)

Reference no: EM131268528

Questions Cloud

Find the service level : Unsold copies are sold to a recycler for $0.50 per copy. Assume the demand for newspaper in the neighborhood is normally distributed with mean of 100 and std. dev. Of 15. Find: Service level. How many copies should the retailer buy every day to maxim..

Explain how to find pareto efficiency : Explain how to find pareto efficiency? Give an example of a problem with multiple utility functions.

Discuss the validity of each statement : Discuss the validity of each statement. If the statement is always true, explain why. If not, give a counterexample- If a cost function is linear, then the marginal cost is a constant.

Discuss the validity of each statement : Discuss the validity of each statement. If the statement is always true, explain why. If not, give a counterexample- Marginal profit is equal to marginal cost minus marginal revenue.

Options cost great lakes automotive same amount of money : Great Lakes Automotive (GLA) is considering producing, in-house, a gear assembly that it currently purchases from Delta Supply for $6 per unit. GLA estimates if it chooses to manufacture the gear assembly, it will cost $23,000 to set up the process a..

Plus-minus grading system at a university : Test at α =.05 and 0.10 the hypothesis that a majority (more than 50%) of students favor the plus/minus grading system at a university if in a random sample of 500 students, 265 favor the system?

Use differentials to estimate volume of the fiberglass shell : A cube with 10-inch sides is covered with a coat of fiberglass 0.2 inch thick. Use differentials to estimate the volume of the fiberglass shell.

Confidence interval for the population mean weight : A sample of 25 items yields = 50.0 grams and s = 2.5 grams. Assuming a normal distribution, construct a 99 percent confidence interval for the population mean weight.

Determine the transmissibility coefficients for your system : PETE 2060 Fall 2016 Project: Flow in a 1-D reservoir. Determine the transmissibility coefficients for your system and solve it. Present the results (i.e. pressure distribution in the reservoir) at three different time instances of 10, 30, and 90 da..

User Account

All Pages