I have a mock project for work that I'm struggling with and could really use your help Note, attached pic has the table I'm not sure where to post this on the internet but here we are, thanks for any help guidance Also, time is of the essence I need your help in preparing a study to localize our luxury product Alpha to the country of Rica Rica's currency (abbreviated RIC) has weakened considerably in the past year against the U S dollar (USD) causing the profit translation of our revenue from our Rica sold units to degrade significantly The leadership team has requested that we find a way to mitigate this currency volatility One way is to better match the currency of our costs to the currency of our revenue As our sales in Rica constitute a larger mix of the total global sales of our multi vehicle portfolio going forward, localizing Alpha and creating some RIC cost exposure may help balance our overall currency portfolio and minimize the profit impact of volatile currency movements Your analysis should provide a profit impact sensitivity analysis using the range of RIC USD provided below Your profit impact analysis should focus on a decision analysis for the localization alternative The U S sourcing location is in our present Business Plan Provide an incremental view to our Business Plan shown in $ Millions The localization alternative will have no impact on our sales revenue, so all the data that I have sent over is cost related There is no need to include revenue in the incremental decision analysis Given the tight timing on this request, assume a One Period Analysis for this study (i e , calculate the profit impact for one year only) At a later date, with better data and an aligned cost of capital, we will analyze the entire fiveyear product cycle Bryan from the Corporate Economics team suggested that we study a three point range for RIC USD (5 1, 6 1, and 7 1) As you will see, there are trade offs with the localization alternative Let me know your recommendation based on the available data And let me know other risks or concerns (financial and non financial) Manufacturing Source U S Rica Sales Location U S Rica U S Rica Annual Sales (Units) 55,000 45,000 55,000 45,000 Investment (Mils) $ 600 N A 1,000 Contribution Cost Impact (Per Unit) Material Cost $ (20,500) $ (20,000) $ (18,500) $ (18,000) Freight (1,000) (2,500) (2,500) (1,000) Variable Labor (1,600) (1,600) (800) (800) Duty Tax (100) (10,000) (800) (3,000) Total Contribution Margin Impact $ (23,200) (34,100) $ (22,600) (22,800) Exchange Rate (RIC USD) N A N'A 6 0 a 6 0 a Note All costs shown are in USD Exchange rate used to convert Rica based costs to USD is shown a All costs (incl investment) in Rica localization scenario are sourced in RIC

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 06, 2024

I have a mock project for work that I'm struggling with and could really use your help. Note, attached pic has the table. I'm not

I have a mock project for work that I'm struggling with and could really use your help. Note, attached pic has the table. I'm not sure where to post this on the internet...but here we are, thanks for any help/guidance. Also, time is of the essence:

I need your help in preparing a study to localize our luxury product Alpha to the country of Rica. Rica's currency (abbreviated RIC) has weakened considerably in the past year against the U.S. dollar (USD) causing the profit translation of our revenue from our Rica sold units to degrade significantly. The leadership team has requested that we find a way to mitigate this currency volatility. One way is to better match the currency of our costs to the currency of our revenue. As our sales in Rica constitute a larger mix of the total global sales of our multi-vehicle portfolio going forward, localizing Alpha and creating some RIC cost exposure may help balance our overall currency portfolio and minimize the profit impact of volatile currency movements.

Your analysis should provide a profit impact sensitivity analysis using the range of RIC:USD provided below.

Your profit impact analysis should focus on a decision analysis for the localization alternative. The U.S. sourcing location is in our present Business Plan. Provide an incremental view to our Business Plan shown in $ Millions.
The localization alternative will have no impact on our sales revenue, so all the data that I have sent over is cost related. There is no need to include revenue in the incremental decision analysis.
Given the tight timing on this request, assume a One Period Analysis for this study (i.e., calculate the profit impact for one year only). At a later date, with better data and an aligned cost of capital, we will analyze the entire fiveyear product cycle.
Bryan from the Corporate Economics team suggested that we study a three-point range for RIC:USD (5:1, 6:1, and 7:1).

As you will see, there are trade-offs with the localization alternative. Let me know your recommendation based on the available data. And let me know other risks or concerns (financial and non-financial).

Manufacturing Source U.S. Rica Sales Location U.S. Rica U.S. Rica Annual Sales (Units) 55,000 45,000 55,000 45,000 Investment (Mils) $ 600 N/A 1,000 Contribution Cost Impact (Per Unit) Material Cost $ (20,500) $ (20,000) $ (18,500) $ (18,000) Freight (1,000) (2,500) (2,500) (1,000) Variable Labor (1,600) (1,600) (800) (800) Duty & Tax (100) (10,000) (800) (3,000) Total Contribution Margin Impact $ (23,200) (34,100) $ (22,600) (22,800) Exchange Rate (RIC:USD) N/A N'A. 6.0 a/ 6.0 a/ Note: All costs shown are in USD. Exchange rate used to convert Rica based costs to USD is shown. a/ All costs (incl. investment) in Rica localization scenario are sourced in RIC