Question: Need help calculating the TLC for China, bit lost here. Please use excel This is all the information I was given, any help would be

Need help calculating the TLC for China, bit lost here. Please use excel

This is all the information I was given, any help would be greatly appreciated

Need help calculating the TLC for China, bit lost here. Please use

\begin{tabular}{lrc} \hline Given Information & Variables & UOM \\ \hline Number of SKU's & 120 & Units \\ Different Types of Panels & 15 & Units \\ Weekly Demand/SKU & 10 & Units \\ Weeks Per Year & 50 & Weeks \\ Cost of Quality & 20% & Percent \\ Inventory In Transit & 5.1 & Weeks \\ Opportunity Cost & 20% & Percent \\ Service Level & 99% & Percent \\ Standard Deviation & 5 & Units \\ Different Types of Panels & 15 & Types \\ \hline \end{tabular} \begin{tabular}{lrrr} \hline \multicolumn{2}{c}{ China Fully Assembled Costs } & & \\ \hline Description & Costs & UOM \\ \hline Fully Assembled backpack (FOB) & $64.50 & \\ Shipping Cost & $1.48 & \\ Merchandise Processing Fee (MPF) & $2.00 & \\ Tariff & $10.64 & \\ \hline Cost Per Bag & $78.62 & USD \\ \hline \end{tabular} Total Landed Cost (TLC) - China Fully Assembled Unit Cost (fully assembled in China) Units Sold Cost of Goods Sold (COGS) $0 USD Unit Holding Cost Units In Transit Inventory In Transit Cost $0USD Units in Safety Stock Safety Stock Cost Supply Chain Costs Total Annual Landed Cost (TLC) $0 USD TLC / Week TLC / Unit COGS / TLC Tied-Up Capital USD \begin{tabular}{lrc} \hline Given Information & Variables & UOM \\ \hline Number of SKU's & 120 & Units \\ Different Types of Panels & 15 & Units \\ Weekly Demand/SKU & 10 & Units \\ Weeks Per Year & 50 & Weeks \\ Cost of Quality & 20% & Percent \\ Inventory In Transit & 5.1 & Weeks \\ Opportunity Cost & 20% & Percent \\ Service Level & 99% & Percent \\ Standard Deviation & 5 & Units \\ Different Types of Panels & 15 & Types \\ \hline \end{tabular} \begin{tabular}{lrrr} \hline \multicolumn{2}{c}{ China Fully Assembled Costs } & & \\ \hline Description & Costs & UOM \\ \hline Fully Assembled backpack (FOB) & $64.50 & \\ Shipping Cost & $1.48 & \\ Merchandise Processing Fee (MPF) & $2.00 & \\ Tariff & $10.64 & \\ \hline Cost Per Bag & $78.62 & USD \\ \hline \end{tabular} Total Landed Cost (TLC) - China Fully Assembled Unit Cost (fully assembled in China) Units Sold Cost of Goods Sold (COGS) $0 USD Unit Holding Cost Units In Transit Inventory In Transit Cost $0USD Units in Safety Stock Safety Stock Cost Supply Chain Costs Total Annual Landed Cost (TLC) $0 USD TLC / Week TLC / Unit COGS / TLC Tied-Up Capital USD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Using the attached information WITHOUT excel and showing your work, PLEASE help me with the 2 following questions. This relates to my Biochemistry class. Standard Deviation assistance requested....

Written in Java. Please help. Any information would be greatly appreciated. Even shelling of the code would be beneficial if you cannot understand the whole thing. Thank you!!!!!!!!!!!!!!!!!! Example...

Please analysis the case study must including identification of issues, situational analysis, identification of recommendations, financial risk analysis, total cost analysis, supplier evaluation and...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy generating firm, who needs to present his recommendation to the company Board regarding a proposed investment in a new...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

1. Daniel Dimwit sees an advertisement for a toaster oven at Target for the price of $49.00. When he gets to Target they are all sold out. Sears has the same toaster oven for $60.00. Can Mr. Dimwit...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

A sales invoice totaling Rs 35,000 and dated January 14 has discount terms of 2/10, n/30. If it is paid January 23 and if paid January 27, what would be the entry to record this transaction? Record...

Q8. The complex that exists as a pair of enantiomers is (a) trans-[Co(HNCHCHNH)Cl]+ (c) [Pt(PPh)(Cl)(Br)(CH)] (b) cis-[Co(NH,),C] (d) [Co(H,NCH,CH,NH,),]3+

When does the auditor decide about the overall importance of each internal control component of compliance

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Whom do you call when you have exciting news or when youre feeling down? What makes this person a good listener? Are you a good listener in return when this person calls you?

Consider the examples of listening styles weve given here. Do you favor a particular listening style? Are you able to adopt different styles in different situations?

4. Try smiling (genuinely) more than you usually doand with people you might not usually smile at. See what happens. Do you feel differently about yourself and others? Do others respond with more...