Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I NEED AN EXPLANATION HOW THE ABOVE THREE COLUMNS CALCULATED????? WHERE DID THESE NUMBERS COME FROM????? Williams Inc. produces a single product, a part used
I NEED AN EXPLANATION HOW THE ABOVE THREE COLUMNS CALCULATED????? WHERE DID THESE NUMBERS COME FROM?????
Williams Inc. produces a single product, a part used in the manufacture of automobile transmissions. Known for its quality and performance, the part is sold to luxury auto manufacturers around the world. Because this is a quality product, Williams has some flexibility in pricing the part. The firm calculates the price using a variety of pricing methods and then chooses the final price based o that information and other strategic information. A summary of the key cost information follows. Williams expects to manufacture and sell 58,500 parts in the coming year. While the demand for Williams's part has been growing in the past 2 years, management is not only aware of the cyclical nature of the automobile industry, but also concerned about market share and profits during the industry's current downturn Total Costs $ 4,663,000 838,650 2,328,875 658,495 343,000 22, 333,000 58,500 Variable manufacturing Variable selling and administrative Facility-level fixed overhead Fixed selling and administrative Batch-level fixed overhead Total investment in product line Expected sales (units) Required: I. Determine the price for the part using a markup of 39% of full manufacturing cost. 2, Determine the price for the part using a markup of 20% of full life-cycle cost. 3, Determine the price for the part using a desired gross margin percentage to sales of 41% 4. Determine the price for the part using a desired life-cycle cost margin percentage to sales of 28% 5. Determine the price for the part using a desired before-tax return on investment of 13% 6. Determine the total contribution margin and total operating profit for each of the methods in requirements 1 through 5 Complete this question by entering your answers in the tabs below 1. $174.2816 ($7,334,875 139/58,500 2. $181.1696 ($8,832,020 x 1.20)58,500 3. $212 5127 $125.38251 0.41) 4. $209.6871 $150.97471 0.28) 5. $200.6001 $150.97470.3287) Where: 03287 ($22,333,000 0.13)/(58,500x $150.9747) Total investment in product line Expected sales (units) 22,333,e00 58,580 Total variable costs $5,501,650$4,663,000 838,650 Total fixed costs 3,330,3702,328,875658,495343,008 7,334,875$4,663,0002,328,875343,e00 Total manufacturing cost Total selling and administrative 1,497,145 = 838,650 + 658,495 8,832,020 Total life cycle cost Per unit manufacturing cost Per unit life cycle cost 125.38257,334,875/58,588 150.97478,832,826/58,580 Desired Rate contribution Gross Operating for Markup Price Method Margin $2,860,599 $181.1696 5,096,772 $3,263,547 $212.51276,930,343$5,897,118 6,765,845$4,931,828 $4,400,231 Profit Margin Markup on full manufacturing cost Markup on life cycle costs $174.2816 $ 4,693,824 39% 1,363,454 20% 1,766,402 Price to achieve desired GM % 41 .0000% 3,599,973 Price to achieve desired LCC % 28 , 0088% 3,434,675 Price to achieve desired ROA of 13% $ 6,233,456 32. 8700% $200.6001 2,903,086 Contribution margin and gross margin computed after price is rounded to 4 decimal placesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started