The Questions

Based on the knowledge you acquired from the reading assignments and the information provided in the attached file, answer the following questions - it is required that you show the calculations for how you arrived at the answers.

1. Calculate the cost of each option. You must show all of your work in an Excel spreadsheet.
2. Which style would you recommend and why?

Let There be Light-1 (1).pdf . , , . . . feet Wide by 8.5 feet high by 40 feet long. The rate for a partial container is 50-cents / cubic foot. Extra \"usable\" space could be sold to other companies to maximize the utilization of the containers. Then the container would be loaded on a ship. It takes 22 days to load and transport the lampshades to the foreign port. Costs for ocean transportation: The ocean rates from Oakland to the foreign port in Asia were $22 per ton (a ton is 2,000 pounds). However, the ocean conference that sets rates also had a rule that considered density or bulkiness of the freight. If the freight was light weight, the rule was that every 40 cubic feet would be charged for as if it were an actual ton. (That is, a load that took up 2 feet by 1 foot by 40 feet (equals 2 x l x 40 : 80 cubic feet) would be treated as if it weighed 2 tons or 4,000 pounds. even if it actually weighed only 400 pounds! You'll need to calculate freight costs both ways to see which rule applies. The ocean carrier will charge the higher rate. Insurance costs: The ocean portion of the shipping requires the shipper to buy insurance on the freightt The insurance costs 2% of the value of the shipmentt The Let There Be Light has decided to insure the value of the lampshades and the boxes being used to ship the lampshades., The carrying cost for inventory is lS-percent per year. Use other concepts from Supply Chain Cost to Serve Analysis to determine most effective solution. You must show your calculations. Use the accompanying matrix to organize your analysis, 1. Calculate the cost of each option. You must show a_ll of your work in an Excel spreadsheet. 2 Which style would you recommend and why? ME>QQ to Oct 25 9:4709 9| X Let There be Light-1 (1).pdf 100% 3 / 3 TT ... Expand sidebar Style A Lamp Shade Style B Lamp Shade Style C Lamp Shade Units Units Units Cost/Per Needed Total Cost Cost/Per Needed Total Cost Cost/Per Needed Total Cost 1 Production 2 Box Cartons/Container Shades/Container 4 Full Containers 4a Shades/Partial 4b Cartons/Partial 5 Land Freight 5a Full Containers 5b Partial Inventory CC-Land Insurance 8 Ocean Freight Inventory CC- 9 Ocean TOTAL COST Oct 25 9:47 5