Problem
Listed below is to used for calculations for the excel part. Also the template is in the attachment to fill out for excel.
Robo-Control Technologies Inc. manufactures robotic controllers in Division A, a country with a 30% income tax rate, and transfers them to Division B, a country with a 40% income tax. An import duty of 15% of the transfer price is paid on all imported products. The import duty is not deductible in computing taxable income. The controller's full cost is $1,500 and variable cost is $1,000; they are sold by Division B for $2,000. The tax authorities in both countries allow firms to use either variable cost or full cost as the transfer price.
Part I: Analyze the effect of both full-cost and variable-cost transfer pricing methods on cash flows using a spreadsheet program such as Excel.
Part II: Make your recommendation as to how the organization should proceed, being sure to justify your recommendation with examples form this Resources, and/or additional research.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.