What exactly do you interpret they are asking for the Units & Rations section? To me, the cases/pallets and pallets/containers are already answered above. Then how does one determine the total cost of the oranges in the container? I would not think the SUM function. The numbers in the cells I placed based on the information. The actual words are the given problem.

Naranja International, located in South Africa, offers oranges at a purchase price of $1.03 per pound. First, the oranges need to be shipped to the USA via waterway. The ocean freight costs are $3,500 per container and the import duties from South Africa are 3% of the value of shipped oranges. Once arriving at the port of Long Beach, California, drayage costs are $275 per container. You momentarily store the oranges at a local warehouse at a rate of $6.00 per pallet. The container is picked up the next day and travels intermodal (through a motor carrier} to your facility at a cost of $160 per container. Upon arrival at your facility, you've calculated costs of $6.00 per pallet for receiving and quality. Based on historical averages, 2% of your container of oranges will spoil and 3% will be wasted in transport. The administrative costs to successfully manage a relationship between your organization and Naranja International are estimated at 9% ofthe value of a container of shipped oranges. These costs account for the intricacies of dealing with an offshored supplier on a different continent, with a different language and culture than what is found at Smoothie City headquarters. Each case of oranges is 25 pounds, with 40 cases per pallet and 15 pallets per container. Using the dataifrom the "INFORMATION" sheet, you will input cost information for both Naranja International and LB Family Farms. First, put given Units 8: Ratios information into the tables. Use formulas to fill out the remainder of the Units 81 Ratios tables. For example, multiply the weight per case by the number of cases per pallet to find the weight per pallet. UNITS & RATIOS Case 1 pounds PaHet 1 pounds Container 1 pounds Cases/Pallet 40 cases/paiiet Pallets/Container 15 pallets/container Totai Cost of Oranges in Container COSTS GIVEN 'L UNITS GIVEN '1. Unit Cost per pound Ocean Freight per container immnrs nun\"- ...t+.....r,,...l..n mmmmmm 25.00 1,000.00 15,000.00 1,000.00 15,000.00 15,000.00 PALLETIZE J