The Charlotte Roadway Shop was approved Capital funding to build a new concept machine in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Charlotte Roadway Shop was approved Capital funding to build a new concept machine in the listed project years. Please review the attached data and present your findings addressing the cost per machine and how you, the Shop Supervisor of Cost & Quality would develop the strategy for the teams to identify inefficiencies and make recommendations to improve the quality of work and productivity of resources to continue producing the machines internally versus purchasing provided the most recent purchase price remains the same but overall materials to produce internally are expected to increase by 6%. The threshold for purchasing is 65%. Year Purchase Price Budget $2,860,000 Project '18 $475K ea. Status I Complete Complete Complete (5) Project '20 $2,970,000 $515K ea. Project '21 $2,640,000 $525K ea. For this exercise, distribute percentage of Wage Additives evenly on completed machines. *Additives are overhead charges added to Capital project wages and materials. **All Wages & Overtime Additives - 69% QTY to Complete 11 9 8 TUON 1 5 Period 1 1 31 91 10 11 1 12 1 13 1 14 1 15 1 16 1 17/1 18 1 19 1 201 21 1 22 1 8 Fiscal YeaPosting Date Document Date Document Object 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 PASA fx Fiscal Year SHEET 1 1/23/2018 1/23/2018 1/23/2018 1/24/2018 1/24/2018 1/24/2018 1/25/2018 1/25/2018 1/25/2018 1/29/2018 1/29/2018 1/29/2018 1/30/2018 1/30/2018 1/30/2018 1/31/2018 1/31/2018 1/31/2016 1/31/2018 1/31/2018 1/31/2018 type 1/23/2018 ZO 1/23/2018 ZQ 1/23/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/25/2018 ZQ 1/25/2018 20 1/25/2018 ZQ 1/29/2018 ZO 1/29/2018 20 1/29/2018 ZQ 1/30/2018 20 1/30/2018 20 1/30/2018 20 1/31/2018 20 1/31/2018 20 1/31/2018 ZQ 2/2/2018 20 2/2/2018 20 2/2/2018 20 Number Styles Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft ARRITAK Cells ValiCOArea Crcy CO area currency 1.176.73 USD 93.40 USD 143.19 USD 53.76 USD 677.17 USD 82.47 USD 54.81 USD 4.35 USD 6.67 USD 0.25 USD 0.03 USD 0.02 USD 32.74 USD 2.60 USD 3.98 USD 24.92 USD 1.98 USD 3.03 USD 37.04 USD 4.98 USD 169.56 USD 31 31 41 5 1 26 1 27 1 Period Fiscal Yea Posting Date Document Date Document Object tvoe 2/2/2018 ZQ 1/2/2019 WE 1/2/2019 20 1/2/2019 ZQ 1/2/2019 20 1/2/2019 ZQ 1/2/2019 ZQ 1/2/2019 ZQ 1/3/2019 ZQ 1/3/2019 20 1/3/2019 ZQ 1/9/2019 WA 1/14/2019 ZO 1/14/2019 ZQ 1/14/2019 ZQ 1/16/2019 20 1/17/2019 20 1/17/2019 20 1/17/2019 20 1/24/2019 ZQ 1/24/2019 ZQ 28 29 30 31 1 32 1 33 1 34 1 35 1 36 1 37 1 38 1 39 1 40 1 41 1 42 1 43 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 X 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 SHEET 1 fx Fiscal Year 1/31/2018 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/3/2019 1/3/2019 1/3/2019 1/9/2019 1/14/2019 1/14/2019 1/14/2019 1/16/2019 1/17/2019 1/17/2019 1/17/2019 1/24/2019 1/24/2019 G H Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Wages Shopcraft PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mater PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate Val/COArea Crcy CO area currency 0.70 USD 26,803.00 USD 506.58 USD 61.65 USD 40.20 USD 2.34 USD 29.53 USD 3.59 USD 123.76 USD 9.82 USD 15.06 USD -29,547.00 USD -1.78 USD -65.23 USD -3.86 USD 1.61 USD 53.01 USD 3,15 USD 2.48 USD 325.05 USD 15.19 USD The Charlotte Roadway Shop was approved Capital funding to build a new concept machine in the listed project years. Please review the attached data and present your findings addressing the cost per machine and how you, the Shop Supervisor of Cost & Quality would develop the strategy for the teams to identify inefficiencies and make recommendations to improve the quality of work and productivity of resources to continue producing the machines internally versus purchasing provided the most recent purchase price remains the same but overall materials to produce internally are expected to increase by 6%. The threshold for purchasing is 65%. Year Purchase Price Budget $2,860,000 Project '18 $475K ea. Status I Complete Complete Complete (5) Project '20 $2,970,000 $515K ea. Project '21 $2,640,000 $525K ea. For this exercise, distribute percentage of Wage Additives evenly on completed machines. *Additives are overhead charges added to Capital project wages and materials. **All Wages & Overtime Additives - 69% QTY to Complete 11 9 8 TUON 1 5 Period 1 1 31 91 10 11 1 12 1 13 1 14 1 15 1 16 1 17/1 18 1 19 1 201 21 1 22 1 8 Fiscal YeaPosting Date Document Date Document Object 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 PASA fx Fiscal Year SHEET 1 1/23/2018 1/23/2018 1/23/2018 1/24/2018 1/24/2018 1/24/2018 1/25/2018 1/25/2018 1/25/2018 1/29/2018 1/29/2018 1/29/2018 1/30/2018 1/30/2018 1/30/2018 1/31/2018 1/31/2018 1/31/2016 1/31/2018 1/31/2018 1/31/2018 type 1/23/2018 ZO 1/23/2018 ZQ 1/23/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/24/2018 ZQ 1/25/2018 ZQ 1/25/2018 20 1/25/2018 ZQ 1/29/2018 ZO 1/29/2018 20 1/29/2018 ZQ 1/30/2018 20 1/30/2018 20 1/30/2018 20 1/31/2018 20 1/31/2018 20 1/31/2018 ZQ 2/2/2018 20 2/2/2018 20 2/2/2018 20 Number Styles Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft PROJECT 18 ADDITIVES PROJECT 18 Wages Shopcraft ARRITAK Cells ValiCOArea Crcy CO area currency 1.176.73 USD 93.40 USD 143.19 USD 53.76 USD 677.17 USD 82.47 USD 54.81 USD 4.35 USD 6.67 USD 0.25 USD 0.03 USD 0.02 USD 32.74 USD 2.60 USD 3.98 USD 24.92 USD 1.98 USD 3.03 USD 37.04 USD 4.98 USD 169.56 USD 31 31 41 5 1 26 1 27 1 Period Fiscal Yea Posting Date Document Date Document Object tvoe 2/2/2018 ZQ 1/2/2019 WE 1/2/2019 20 1/2/2019 ZQ 1/2/2019 20 1/2/2019 ZQ 1/2/2019 ZQ 1/2/2019 ZQ 1/3/2019 ZQ 1/3/2019 20 1/3/2019 ZQ 1/9/2019 WA 1/14/2019 ZO 1/14/2019 ZQ 1/14/2019 ZQ 1/16/2019 20 1/17/2019 20 1/17/2019 20 1/17/2019 20 1/24/2019 ZQ 1/24/2019 ZQ 28 29 30 31 1 32 1 33 1 34 1 35 1 36 1 37 1 38 1 39 1 40 1 41 1 42 1 43 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 X 2019 2019 2019 2019 2019 2019 2019 2019 2019 2019 SHEET 1 fx Fiscal Year 1/31/2018 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/2/2019 1/3/2019 1/3/2019 1/3/2019 1/9/2019 1/14/2019 1/14/2019 1/14/2019 1/16/2019 1/17/2019 1/17/2019 1/17/2019 1/24/2019 1/24/2019 G H Capital Project Cost element name PROJECT '18 ADDITIVES PROJECT '18 Wages Shopcraft PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mater PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT 18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT '18 Roadway Machine Mate PROJECT '18 ADDITIVES PROJECT 18 Roadway Machine Mate Val/COArea Crcy CO area currency 0.70 USD 26,803.00 USD 506.58 USD 61.65 USD 40.20 USD 2.34 USD 29.53 USD 3.59 USD 123.76 USD 9.82 USD 15.06 USD -29,547.00 USD -1.78 USD -65.23 USD -3.86 USD 1.61 USD 53.01 USD 3,15 USD 2.48 USD 325.05 USD 15.19 USD
Expert Answer:
Related Book For 
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
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...
-
Let (x, y) = x 4 2x 2 + y 2 6y. (a) Find the critical points of and use the Second Derivative Test to determine whether they are a local minima or a local maxima. (b) Find the minimum value of ...
-
Fiberworks Company is a manufacturer of fiberglass toy boats. The company has recently implemented a standard cost system and has designed the system to isolate variances as soon as possible. During...
-
A company is planning to produce and sell a new line of computers. The fixed cost will be $360,000 and it will cost $850 to produce each computer. Each computer will be sold for $1150. a. Write the...
-
ZeeZee's Construction Company has the opportunity to select one of four projects (A, B, C, or D) or choose the null (do-nothing) alternative. Each project requires a single initial investment and has...
-
Revenue and production budgets. (CPA, adapted) The Scarborough Corporation manufactures and sells two products: Thingone and Thingtwo. In July 2009, Scarboroughs budget department gathered the...
-
Keeley and Roy are concerned about their financial future and meeting their goals. They are 38 years old with twin girls, Abigail and Laryssa age 8. Keeley is a public relations account executive...
-
The following adjusted revenue and expense accounts appeared in the accounting records of Pashi, Inc., an accrual basis taxpayer, for the year ended December 31, Year 2. Revenues Net sales $3,000,000...
-
Between the Originalist approach and the Living tree doctrine, which approach do you think is strongest? Why? What are some benefits and pitfalls?
-
Vector A has a magnitude of 10 cm and vector B has a magnitude of 7 cm. The angle between the vectors is 30 degrees. Find: the magnitude of B x A (use material from chapter 1). Use the right-hand...
-
1. Two point charges 9 and 92 are located a distance L from the origin, along the x and y axes, respectively (see Fig. 1 below). a. Calculate the magnitude of the electrostatic force between the two...
-
2. For a bug crawling on a spinning record: r = btand 0 = wt where b and ware positive constants. Solve for the acceleration in polar coordinates.
-
A 75 kg person wearing snowshoes stands on snow. If the snow will collapse when the pressure exceeds 2000 Pascals, what is the minimum surface area of EACH snowshoe required?
-
6. An object with mass m is shot up with speed v, experiences gravity and a quadratic air resistance force: F = - cv. i) Solve for the height h; the mass reaches going upward in terms of v, for the...
-
Wrote a WebGL program that displays the graph of a bivariate function: z = f (x, y) for (x,y) in D=[0,1]x[0,1]. f(x, y) = el-0.04(80a-40)+(90y-45))) cos(0.15(80x 40) + (90y 45)) The following...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
Exhibit 8.26 presents the separate financial statements at December 31, 2018, of Prestige Resorts and its 80%-owned subsidiary Booking, Inc. Two years earlier on January 1, 2017, Prestige acquired...
-
Holmes Corporation is a leading designer and manufacturer of material handling and processing equipment for heavy industry in the United States and abroad. Its sales have more than doubled, and its...
-
Firms often enter into transactions that are peripheral to their core operations but generate gains and losses that must be reported on the income statement. A gain labeled peripheral by one firm may...
-
Find the input-output differential equation relating \(v_{o}\) and \(v_{i}(t)\) for the circuit shown below. w R R Vo v(t) R L
-
Consider the following circuit where \(i_{i}(t)\) is the input current and \(i_{o}(t)\) is the output current. (a) Obtain the State-Variable Matrix model \((A, B, C, D)\) for the circuit. (b) Obtain...
-
(a) For the following circuit find the State-Variable Matrix model (A, B, C, D) where \(v_{o}\) is the output voltage and \(v_{i}\) is the input voltage. (b) Also, find the input-output differential...
Study smarter with the SolutionInn App