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 ...
-
Rank the following compounds in order of increasing acidity. Dont look at a table Of PKa data to help with your answer. (a) Benzoic acid, p-methyl benzoic acid, p-chlorohenzoic acid (b)...
-
DemiGod Shipping Company forecasts a 10% increase in its sales over the year 2019. Its assets and liabilities, at the end of 2018, amount to $20 billion and $7 billion respectively. Sales for this...
-
Indicate the specific internal accounting control objectives in (a) hiring, (b) preparing the payroll, and (c) paying the payroll.
-
As a part of the audit of Ren Gold Manufacturing Company, a nonpublic company, management requests basic financial statements and separately, the same basic financial statements accompanied by...
-
A truck leaves Denver (elevation 5280 ft) on a day when thetemperature is 80F and the barometric pressure is 24.8 in Hg. Ittravels over Vail Pass (elevation 10600 ft) where the temperatureis 62F. The...
-
Lunatics, an e-commerce sports company wants to buy Rowdy Trading Cards at a cost of $504 million. Rowdy will operate for 20 years. They expect annual cash flows from operations to be $70.1 million...
-
1 bren offends her essay by saying that she hopes her readers grow smart at a younger age than she did alternatively write a paragraph describing something you worried about that actually did happen...
-
On Dec. 1 5 , Sheffield Company discounted at Sunshine Bank a $ 8 , 7 0 0 ( maturity value ) , 1 3 2 - day note dated Sept. 1 0 . Sunshine s discount rate was 1 0 % . ( Use Days in a year table. )...
-
Ineza 7 Natete makes and sells two types of shoes, Plain and Fancy. Data concerning these products are as follows: Plain Fancy Unit selling price $ 2 0 . 0 0 $ 3 0 . 0 0 Variable cost per unit 1 2 ....
-
Engine Builders Motor Company exports and rebuilds automobile engines that have been damaged or are in need of extensive repair. The rebuilt engine is purchased by auto shops, large motor pools in...
-
Discuss how a firm can use the concept of elasticity to set its prices so as to achieve the highest revenue possible.
-
Montoure Company uses a perpetual inventory system. It entered into the following calendar - year purchases and sales transactions. Date Activities Units Acquired at Cost Units Sold at Retail January...
-
What are earnings before interest and taxes for 2018? Sales COGS Interest Dividends Depreciation Cash Receivables Current liabilities Inventory Long-term debt Net fixed assets Tax rate 20103 2017...
-
Is it a breach of fiduciary duty for a director of a real estate investment trust (REIT) negotiating a joint venture on behalf of the REIT with another director for the development of a portfolio of...
-
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...
-
List the six IT business objectives.
-
How is IT contributing to the success of the on-demand and shared economies?
-
Name four disruptive business models and describe what they offer to their customers.
Study smarter with the SolutionInn App