Purchase Solution

Total costs for each division and the sales price

Not what you're looking for?

Ask Custom Question

As part of an effort to increase sales and profit margin. Music Makers' management is adopting a transfer pricing plan. The copying and packaging departments have been placed under divisional managers. As an incentive to cut costs, each division is expected to earn a gross margin of 10% on its divisional costs. The copying division will sell its output to the corporation. the company expects to produce and sell 535,000 units per month, and the maximum it is willing to pay to the packaging division for the units is $1,075,000.

Variable manufacturing costs per unit in the copying division include $.70 for materials, $.09 for labor, and $.04689 for overhead. Fixed costs in the copying division are $268,000 per month. Variable manufacturing costs per unit in the packaging division include $.20 for materials, $.11 for labor, and $.04 for overhead. Fixed costs in the packaging division are $76,000 per month.

Required:
Use a spreadsheet to determine the total costs for each division and the sales price each division will need to charge to earn a 10% gross margin. The sales price can be calculated as total cost / (1-profit margin).

Provide data for the copying division in column B and the packaging division in column C. Captains should appear in column A. Enter headings in row 1, the number of units to produce in row 2, and gross profit margin in row 3. In row 4, enter a heading "variable costs per unit." Then enter variable unit costs in row 8. Calculate total variable costs in row 9. Enter fixed cost in row 10. Calculate total manufacturing costs in row 11. Calculate the price including required margin in row 12. In the following rows, calculate the total price of the products transferred from the packaging division to the corporation and the amount under (over) the maximum transfer price of $1,075,000. Use cell references and formulas where possible. Use appropriate formatting throughout.

If you were manager of the copying division, what price would you want for the units sold to the packaging division? If you were manager of the packaging division, what price would you want to pay for the goods purchased from the copying division?

How would your answer change if the gross margin expected of each division were 8%?

Purchase this Solution
Solution Summary

The solution explains the use of spreadsheet in calculating total costs for each division and the sales price

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Advance costing for management's decisions - Amazon Beverage

    The corporate marketing group has furnished the following price-demand relationship for the finished product: Sales Volume Total sales Revenue Sales Price per case 400,000 equivalent cases $8,000,000

  • Cost Accounting Question

    The red cars have manufacturing costs of $12,500 each for variable and $5,000 each for fixed costs. The division's total fixed manufacturing costs are $25,000,000 at the normal volume of 5,000 units.

  • Lowest acceptable transfer price

    The calculation of transfer price is Transfer price = Variable cost + contribution margin lost on outside sales In this case, the variable costs for new casting are Variable production cost $12 Boxing and shipping $1 Total variable cost = $13 Because

  • Transfer Pricing: Minimum and Maximum

    expenses 7.50 Total costs $66.25 Desired return 13.75 Sales price $80.00 Division A is operating at 80 percent of its 500,000 unit capacity.

  • Transfer pricing

    For 1,000 units which would be from existing sales, the transfer price should be the variable cost + contribution margin since this is lost when sales are made internally The price should be $215 Total cost for 15,000 units is 14,000 X 125 + 1,000

  • Simon Hinson Co: Assess company net income for changes in Go

    Assume that the Ronin Division increased sales by $100,000, the Gordon Division sales remained the same, and there was no change in fixed costs. 1. Calculate the net income amounts for each division and the total company. 2.

  • Transfer Price

    Reference: 12-18 Suppose that Division A has ample idle capacity to handle all of Division B's needs without any increase in fixed costs and without cutting into sales to outside customers.

  • The Assembly division of Canadian Car Company: Transfer pricing

    The Assembly division has been buying batteries from outside sources for $130 each. a. Should the Electrical division manager accept the offer? Explain. Yes it should accept the offer as the relevant costs are less than the transfer price.

  • Cost-Volume-Profit Analysis, Pricing Decisions

    Each Colby Steak dinner sells for $22.00 each. What is the budgeted total variable cost? 6) The New Product, Inc is looking to achieve a net income of 15 percent of sales.

View More Related Solutions