92 CHAPTER 2 Introduction to Spreadsheet Modeling Break-Even Analysis at SportsExchange Facility Comparison at SportsExchange Sports...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
92 CHAPTER 2 Introduction to Spreadsheet Modeling Break-Even Analysis at SportsExchange Facility Comparison at SportsExchange Sports Exchange is a regional refurbisher of sporting goods equipment. It specializes in upgrad- ing football equipment that it receives from high schools and colleges. Processes used by SportsExchange include sewing pants and jerseys, replacing pads, repairing and painting hel- mets, and replacing laces, snaps, and elastic in pants. The most expensive process for Sports Exchange is painting helmets. Regulations that con- trol worker safety and environmental emissions mandate a paint room that manages fumes effectively. In order to continue in its lucrative business, SportsExchange is required to invest in a new state-of-the-art painting facility. Sports Exchange has identified three manufacturers of turnkey spray booths. The fixed and variable costs associated with each of the three alternatives are presented in Table 1 below: TABLE 1: COSTS ASSOCIATED WITH SPORTSEXCHANGE'S THREE PAINTING ALTERNATIVES Alternative Fixed cost INTERACTIVE CASE A: Enviro-Spray $500,000 B: Spray Center $207,500 C: Crystal Coat $265,000 Variable cost $0.148 $1.321 $0.910 Analysis 38 SportsExchange believes it will need to refinish 200,000 helmets. What is the total cost for each 3 of the alternatives for refinishing that quantity of helmets? Which alternative appears to be the best choice (i.e., lowest total cost)? What alternative appears to the best choice if quantity to refinish increases to 320,000 helmets? The cost accountants at Sports Exchange may have made an error in calculating the fixed costs associated with the Spray Center alternative. They now believe that the fixed costs for the Spray Center alternative should be $150,000. If Sports Exchange expects to refinish 200,000 helmets, which alternative looks the best now? What happens to the relative attractiveness of the Crystal Coat alternative as Spray Center's fixed costs decrease to $150,000? In addition, the cost accountants have revealed that their estimate for Crystal Coat's vari- able cost may be too low. However, they don't know how by much they are off and would like to know how sensitive Crystal Coat is to changes in variable costs, specifically increases in variable costs. Give the cost accountants some assistance here by increasing Crystal Coat's variable costs and describe the changes that occur relative to the other alternatives. 92 CHAPTER 2 Introduction to Spreadsheet Modeling Break-Even Analysis at SportsExchange Facility Comparison at SportsExchange Sports Exchange is a regional refurbisher of sporting goods equipment. It specializes in upgrad- ing football equipment that it receives from high schools and colleges. Processes used by SportsExchange include sewing pants and jerseys, replacing pads, repairing and painting hel- mets, and replacing laces, snaps, and elastic in pants. The most expensive process for Sports Exchange is painting helmets. Regulations that con- trol worker safety and environmental emissions mandate a paint room that manages fumes effectively. In order to continue in its lucrative business, SportsExchange is required to invest in a new state-of-the-art painting facility. Sports Exchange has identified three manufacturers of turnkey spray booths. The fixed and variable costs associated with each of the three alternatives are presented in Table 1 below: TABLE 1: COSTS ASSOCIATED WITH SPORTSEXCHANGE'S THREE PAINTING ALTERNATIVES Alternative Fixed cost INTERACTIVE CASE A: Enviro-Spray $500,000 B: Spray Center $207,500 C: Crystal Coat $265,000 Variable cost $0.148 $1.321 $0.910 Analysis 38 SportsExchange believes it will need to refinish 200,000 helmets. What is the total cost for each 3 of the alternatives for refinishing that quantity of helmets? Which alternative appears to be the best choice (i.e., lowest total cost)? What alternative appears to the best choice if quantity to refinish increases to 320,000 helmets? The cost accountants at Sports Exchange may have made an error in calculating the fixed costs associated with the Spray Center alternative. They now believe that the fixed costs for the Spray Center alternative should be $150,000. If Sports Exchange expects to refinish 200,000 helmets, which alternative looks the best now? What happens to the relative attractiveness of the Crystal Coat alternative as Spray Center's fixed costs decrease to $150,000? In addition, the cost accountants have revealed that their estimate for Crystal Coat's vari- able cost may be too low. However, they don't know how by much they are off and would like to know how sensitive Crystal Coat is to changes in variable costs, specifically increases in variable costs. Give the cost accountants some assistance here by increasing Crystal Coat's variable costs and describe the changes that occur relative to the other alternatives.
Expert Answer:
Answer rating: 100% (QA)
To calculate the total cost for each of the alternatives for refinishing 200000 helmets we can use t... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
4) E-Mart Stores uses people and computerized scanners to add arriving shipments into its inventory and to deduct units sold from its inventory. E-Mart's production function is Q = KL, where Q...
-
The Budapest Company has identified four locations to set up a new production facility. They have determined the fixed and variable costs associated with each location as follows: a. Plot the total...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Vito Co.'s next dividend is expected to be $4.50. Dividend growth is estimated at 20%, 15%, 8% for the following three years, and then stabilize to 2%. How much are you willing to pay to buy one...
-
What is contract administration and who performs it?
-
a. In what way is Carson a surplus unit? b. In what way is Carson a deficit unit? c. How might finance companies facilitate Carson's expansion? d. How might commercial banks facilitate Carson's...
-
Executive compensation is often based on meeting certain targets for revenue growth, earnings, earnings per share, return on assets, or other performance measures. But what if performance is not...
-
The following information (in AOA format) concerns progress at day 40 of an Internet marketing project. Determine if the project is in control based on time and cost to date. If not, what is the cost...
-
Deep Blue manufactures flotation vests in Charleston, South Carolina. Deep Blue's contribution margin income statement for the month ended July 3 1 , 2 0 2 4 , contains the following data: ( Click...
-
1 4 5 6 1 2 QUESTIONS 3) Use reference formulas (VLOOKUP, INDEX/MATCH, XLOOKUP) to find the only transaction date where CUST-001 bought PROD-199 from us this year. Note that your lookup value in this...
-
(iv) The period T is defined so that if t t+T then the "phase" difference in the argument of trig. functions is equal to 27: k (t + T) - k -t = 2. m Using this definition, determine the period of the...
-
The figure depicts Jack-in-the-box: "Jack" is attached inside a box by a spring, as shown. You estimate Jack's mass to be 0.4 kg. As so often happens, a sign tells you the spring constant: k = 166...
-
Tesla Inc. had the following transactions in June 2024: June 1: Issued 1,000 shares of common stock for $100,000. June 5: Purchased raw materials on account for $30,000. June 10: Paid utilities...
-
Tauron Polska Energia S.A. uses a joint process to produce products UUUU1, VVVV1, WWWW1, and XXXX1. Each product may be sold at its split-off point or processed further. Joint processing costs for a...
-
Alphabet Inc. (Google) experienced the following in September 2024: September 2: Acquired a patent for $150,000 in cash. September 8: Purchased office supplies for $2,500 on account. September 15:...
-
12 1 2 The system temperature starts at 325F and decreases thru number 4 to 142F after the air makes its way to number 3 the air increases to 260F to number 6 as the air passes thru the air decreases...
-
Question Completion Status: Less than half of the time remains Moving to another question will save this response. Question 4 Question 4 of 5 1 points SaveA Rashid Co. purchased a new machine for...
-
Write a paper detailing a geographic information system (GIS) of your own design that would utilize data in an original manner.
-
During 2012, Palo Fiero purchases the following property for use in his manufacturing business: Palo uses the accelerated depreciation method under MACRS, if available, and does not make the election...
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
Phil and Linda are 25-year-old newlyweds and file a joint tax return. Linda is covered by a retirement plan at work, but Phil is not. a. Assuming Phil's wages were $27,000 and Linda's wages were...
-
Might financial value creation be an appropriate goal for not-for-profit businesses? Explain.
-
Richmond Clinic has obtained the following estimates for its costs of debt and equity at various capital structures: What is the firms optimal capital structure? (Hint: Calculate its corporate cost...
-
Describe four indicators commonly used in operating indicator analysis.
Study smarter with the SolutionInn App