Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

2. What is the impact of information systems on organizations?

Answered: 1 week ago

Question

Evaluate the impact of technology on HR employee services.

Answered: 1 week ago