QUESTION #2 - Total Cost Analysis Now you have an idea of the competitiveness of Primo...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6644a46bd4ca3_5716644a46bce8cb.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6644a46c52826_5726644a46c4a8b3.jpg)
Transcribed Image Text:
QUESTION #2 - Total Cost Analysis Now you have an idea of the competitiveness of Primo Caf's Vietnamese supplier and one of the Taiwanese suppliers for JDM. So, the next estimate is the total cost to ship product from Asia to the U.S. You realize that this is a little tricky-JDM's warehouse is in Palo Alto, close to the port in California. However, Primo Caf's warehouse is in Grand Rapids- with intermodal (rail and truck) costs from California to Michigan. Marco asks Frank where JDM's customers are located. Are most in the western U.S. or nationwide? Frank digs up the customer list and finds that there are customers in most of the 48 contiguous states. However, 90% of its sales are in California, Oregon, Washington, Arizona and Nevada (primarily Las Vegas). You look up Primo Caf's Family Man sales by region... you find that 60% of its sales are west of the Mississippi River. Would Primo Caf save money if they used a regional warehouse model (Palo Alto and Grand Rapids) for Family Man? Below are the logistics costs from the Vietnamese supplier (for simplicity) to Palo Alto and Grand Rapids, using a weighted average customer base of Denver, Colorado for Family Man's western U.S. sales: Conversions Price/Family Man Family Man cubic feet (cube) Family Man / Container Family Man/Pallet Pallets/Container Palo Alto $ 12.00 $ 1.5 1600 32 50 Grand Rapids 12.00 1.5 1600 32 50 Shipping Costs To Port of Export / container $ 200 $ 200 To U.S. Port / Container $ 3,200 3,100 Duties (% value of price) 5% 5% Port Handling Fee (% value of price) Transportation to Warehouse / Container Warehouse Charges / Pallet (pick & pack) Transportation Cost to Denver / pallet 4% 3% 200 1,200 $ 75 $ 60 63 $ 58 Apply the total cost analysis framework presented in class (Week 8) to complete the questions below. Complete all calculations in the excel file provided that you will upload with your exam. 1. Given the assumptions above, what are the total costs for shipping Family Man product from the Vietnamese supplier to Denver, Colorado: a. Through the Palo Alto warehouse b. Through the Grand Rapids warehouse 2. What additional information would you like to know? 3. What is your recommendation to Elise to support Family Man's western U.S. customers? Why? A B C D E F G H I 2 Palo Alto Warehouse 3 Conversions 4 Price/Family Man $ 12.00 Costs Per Unit FM Pallet Container Cost Drivers 5 Family Man cubic feet (cube) 1.5 Price 6 Family Man / Container 1600 7 Family Man / Pallet 32 Shipping Costs To Port of Export 8 Pallets/Container 50 To U.S. Port 9 Shipping Costs 10 To Port of Export / Container $ 200 11 To U.S. Port/Container $ 3,200 Duties Port Handling Trans Costs to Whse 12 Duties (% value of price) 5% Warehouse Charges 13 Port Handling Fee (% value of price) 14 Transportation to Warehouse/Container 4% Trans to Denver 15 Warehouse Charges/Pallet (pick & pack) 16 Transportation Cost to Denver/Pallet sssssss $ 200 Total $0.00 $0.00 $0.00 $ 75 $ 63 17 18 19 Grand Rapids Warehouse 20 Conversions 21 Price/Family Man $ 12.00 22 Family Man cubic feet (cube) 1.5 Price 23 Family Man / Container 1600 Shipping Costs 24 Family Man / Pallet 25 Pallets/Container 26 Shipping Costs 32 To Port of Export 50 To U.S. Port 27 To Port of Export / Container 28 To U.S. Port/Container 29 30 Duties (% value of price) Port Handling Fee (% value of price) 31 Transportation to Warehouse/Container 32 Warehouse Charges / Pallet (pick & pack) 33 Transportation Cost to Denver/Pallet 34 FM Costs Per Unit Pallet Container Cost Drivers 200 3100 Duties Port Handling Trans Costs to Whse 5% Warehouse Charges 3% Trans to Denver 1200 Total $0.00 $0.00 $0.00 60 58 QUESTION #2 - Total Cost Analysis Now you have an idea of the competitiveness of Primo Caf's Vietnamese supplier and one of the Taiwanese suppliers for JDM. So, the next estimate is the total cost to ship product from Asia to the U.S. You realize that this is a little tricky-JDM's warehouse is in Palo Alto, close to the port in California. However, Primo Caf's warehouse is in Grand Rapids- with intermodal (rail and truck) costs from California to Michigan. Marco asks Frank where JDM's customers are located. Are most in the western U.S. or nationwide? Frank digs up the customer list and finds that there are customers in most of the 48 contiguous states. However, 90% of its sales are in California, Oregon, Washington, Arizona and Nevada (primarily Las Vegas). You look up Primo Caf's Family Man sales by region... you find that 60% of its sales are west of the Mississippi River. Would Primo Caf save money if they used a regional warehouse model (Palo Alto and Grand Rapids) for Family Man? Below are the logistics costs from the Vietnamese supplier (for simplicity) to Palo Alto and Grand Rapids, using a weighted average customer base of Denver, Colorado for Family Man's western U.S. sales: Conversions Price/Family Man Family Man cubic feet (cube) Family Man / Container Family Man/Pallet Pallets/Container Palo Alto $ 12.00 $ 1.5 1600 32 50 Grand Rapids 12.00 1.5 1600 32 50 Shipping Costs To Port of Export / container $ 200 $ 200 To U.S. Port / Container $ 3,200 3,100 Duties (% value of price) 5% 5% Port Handling Fee (% value of price) Transportation to Warehouse / Container Warehouse Charges / Pallet (pick & pack) Transportation Cost to Denver / pallet 4% 3% 200 1,200 $ 75 $ 60 63 $ 58 Apply the total cost analysis framework presented in class (Week 8) to complete the questions below. Complete all calculations in the excel file provided that you will upload with your exam. 1. Given the assumptions above, what are the total costs for shipping Family Man product from the Vietnamese supplier to Denver, Colorado: a. Through the Palo Alto warehouse b. Through the Grand Rapids warehouse 2. What additional information would you like to know? 3. What is your recommendation to Elise to support Family Man's western U.S. customers? Why? A B C D E F G H I 2 Palo Alto Warehouse 3 Conversions 4 Price/Family Man $ 12.00 Costs Per Unit FM Pallet Container Cost Drivers 5 Family Man cubic feet (cube) 1.5 Price 6 Family Man / Container 1600 7 Family Man / Pallet 32 Shipping Costs To Port of Export 8 Pallets/Container 50 To U.S. Port 9 Shipping Costs 10 To Port of Export / Container $ 200 11 To U.S. Port/Container $ 3,200 Duties Port Handling Trans Costs to Whse 12 Duties (% value of price) 5% Warehouse Charges 13 Port Handling Fee (% value of price) 14 Transportation to Warehouse/Container 4% Trans to Denver 15 Warehouse Charges/Pallet (pick & pack) 16 Transportation Cost to Denver/Pallet sssssss $ 200 Total $0.00 $0.00 $0.00 $ 75 $ 63 17 18 19 Grand Rapids Warehouse 20 Conversions 21 Price/Family Man $ 12.00 22 Family Man cubic feet (cube) 1.5 Price 23 Family Man / Container 1600 Shipping Costs 24 Family Man / Pallet 25 Pallets/Container 26 Shipping Costs 32 To Port of Export 50 To U.S. Port 27 To Port of Export / Container 28 To U.S. Port/Container 29 30 Duties (% value of price) Port Handling Fee (% value of price) 31 Transportation to Warehouse/Container 32 Warehouse Charges / Pallet (pick & pack) 33 Transportation Cost to Denver/Pallet 34 FM Costs Per Unit Pallet Container Cost Drivers 200 3100 Duties Port Handling Trans Costs to Whse 5% Warehouse Charges 3% Trans to Denver 1200 Total $0.00 $0.00 $0.00 60 58
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
In what year did it become necessary for Social Security to supplement payments with funds from the Trust Fund in order to give beneficiaries 100 % of the benefits they were promised? 2034 1995 2009...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Columbus Custom Carpentry is a small, successful company. Recently, though, labor costs per unit have risen faster than gross revenue per unit.In your role as the HR manager, you are expected to...
-
Craps is a dice game in which two fair dice are cast. If the roller shoots a 7 or 11 on the rst roll, he or she wins. If the roller shoots a 2, 3, or 12 on the rst roll, he or she loses. (a) Compute...
-
You are a newly hired analyst at a large Wall Street investment bank and your direct supervisor has in-formed you that Arnies Army (the acquirer) has engaged your firm to analyze the prospect of...
-
Calculate the theoretical air-fuel ratio on a mass and mole basis for the combustion of ethanol, C2H5OH.
-
Why is it importantto have comparable accounting methods between companies?
-
Information related to Mingenback Company for 2017 is summarized below. Total credit sales .............. $2,500,000 Accounts receivable at December 31 ...... 875,000 Bad debts written off...
-
Woody Corporation has the following information for the current month: Units started 100,000 units Beginning Work in Process: (35% complete) 20,000 units Normal spoilage (discrete) 3,500 units...
-
15. The proportion of people who respond to a certain mail-order solicitation is a continuous random variable X that has the density function: f(x) = {0 By finding the cumulative distribution...
-
What risk factors of intimate abuse of people with disabilities did Julie display? What do you believe are some short-term and long-term consequences Julie faced in her relationship with Rick? Please...
-
es A manufactured product has the following information for August. Direct materials Direct labor Overhead Units manufactured Total manufacturing costs Standard Quantity and Cost 2 pounds per unit...
-
What are some risk factors associated with intimate abuse of the elderly? What risk factors did Marjorie display? Did Marjorie's case display any warning signs of abuse or neglect? Please provide...
-
A specific honey fungus measuring 2.4 miles (3.8 km) across inthe Blue Mountains in Oregon is thought to be the largest livingorganism on Earth. These fungi belongs tothe Armillaria genus, which is...
-
The system shown in the schematic represents a model two-story building: Take m = 1 104 kg, m = 3 104 kg, k = 4 105 N/m, k = 2 105 N/m a) Derive the equations of motion of the system and represent...
-
Consider the 70 households that purchased a DVD player, 48 households are satisfied with their purchase and 22 households are dissatisfied. Suppose two households are randomly selected from the...
-
Where are the olfactory sensory neurons, and why is that site poorly suited for their job?
-
List three performance measures for each of the four perspectives in the balanced scorecard.
-
What method of pricing interdivisional sales best achieves the objective of: (1) fairness to each division; (2) measuring divisional performance; (3) motivation for cost control; (4) maintaining...
-
What are four methods of establishing prices for interdivisional transfers of goods or services?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App