Please step by step answer on number 12 on how to do it using Excel and show all formulas, answer the questions almost as if it is for dummies thank you.

c. Fo.b. destination, freight collect and allowed d. F.o.b. origin, freight prepaid and charged back e. F.o.b. origin, freight collect If the pricing policy is such that a firm's customers pay for the freight, should the supplying firm consider such costs in making warehouse location, transporta- tion service selection, and similar decisions? 11. Davis Steel Distributors is planning to set up an additional warehouse in its dis- tribution network. Analysis of item-sales data for its other warehouses shows that 25 percent of the items represent 75 percent of the sales volume. The com- pany also has an inventory policy that varies with the items in the warehouse. That is, the first 20 percent of the items are the A items and are to be stocked with an inventory turnover ratio of 8. The next 30 percent of the items, or B items, are to have a turnover ratio of 6. The remaining Citems are to have a turnover ratio of 4. There are to be 20 products held at the warehouse with sales on the ware- house forecasted to be $2.6 million annually. What dollar value of average inven- tory would you estimate for the warehouse? 12. Beta Products is planning to add another warehouse. Ten products from the entire line are to be stored in the new warehouse. These products will be the A and B items. All C items are to be served out of the plant. Forecasts of annual sales that are expected in the region of the new facility are 3 million cases (A, B, and C items). Historical data show that 30 percent of the items account for 70 percent of the sales. The first 20 percent of the entire line are designated as A items, the next 30 percent as B items, and the remaining 50 percent as C items. Inventory turnover ratios in the new warehouse are projected to be 9 for A items and 5 for B items. Each inventory item, on the average, requires 1.5 cubic feet of space. Product is stacked 16 feet high in the warehouse. What effective storage space is needed in square feet excluding aisle, office, and other space requirements? 13. An analysis of the product line items in the retail stores of the Save-More Drug chain shows that 20 percent of the items stocked account for 65 percent of the dollar sales. A typical store carries 5,000 items. The items accounting for the top 75 percent of the sales are replenished from warehouse stocks. The remainder is shipped directly to stores from manufacturers or jobbers. How many items are represented in the top 75 percent of sales? 14. The costs associated with producing, distributing, and selling a domestically pro- duced automotive component to Honda in Japan can be summarized as follows: Cost Type Purchased materials Manufacturing labor Overhead Transportation Cost per Unit, $ 25 10 5 Varies by shipment size 8 Sales