4. Assume that ABC Power Tools from question 1 sells Item 1 through a typical home improvement retailer that has a finished goods warehouse, retailer DC, and a retail store. The days of supply and the inbound freight cost at each stage of the supply chain are given below. All other holding costs are the same as before. Compute the total inventory carrying cost of Item 1 at each stage, and express your answers in both dollar amounts and percentages. I Days of supply Inbound freight Finished Goods W/h Retail DC 45 25 30 30 Retail Store 15 35

There are three factories located at AR, IN, and TX respectively. From these locations, a certain commodity is to be delivered to each of the two warehouses situated at A and B. The revenue per commodity item is $10. The weekly demand of the warehouse A and B are respectively 50 and 35 units of the commodity while the production capacity of the factories at AR, IN, and TX are respectively 28, 22, and 35 units. The cost of transportation per unit is given as belows.   Cost Warehouse A Warehouse B AR 5 3 IN 6 6 TX 2 4   To maintain a good relationship with all the factories, warehouse B requires that it receives at least 40% of its product from factory in TX. Realize that it is making good profit in warehouse A, AR requires that at least 35% of its product shipped to warehouse A. Formulate (without solving) a linear programming problem to maximize the profit.

3. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold 4. Format columns I, J, and K as currency with two decimal places. 5. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.a) What was the total Profit for Online Sales? b) Sort the results by Date Sold (A/Z).  * so apparently I need to learn to use the VLOOKUP to find a product on the first page and be able to get the Product Price and Cost from the second page. The following formula is NOT working - =VLOOKUP(D4, ProductTable!A:B, 2,FALSE).  I need an EXACT…

Tim Smunt has been asked to evaluate two machines. After some investigation, he determines that they have the costs shown in the following table: He is told to assume that: 1. The life of each machine is 3 years. Machine A Machine B Original Cost Labor per year $15,000 $20,000 $2,200 $4,000 Maintenance per year Salvage value $4,600 $1,000 $2,400 $7,500 2. The company thinks it knows how to make 8% on investments no more risky than this one. 3. Labor and maintenance are paid at the end of the year. • The NPV for Machine A: The NPV for Machine B: Using the net present value as the basis of comparing the machines, Tim should recommend:

The new city water company that you have researched charges homeowners based on how much water they use in thousands of gallons. The company progressively charges at a higher rate the more water that is used. Cost of Water Bill (dollars) 240 230 220 210 190 180 170 160 110 Water Usage (in thousands of gallons) 11. Based on the graph above, how much does the city charge when a homeowner uses the following number of gallons of water: a) 1700 gallons of water b) 2000 gallons of water c) 7000 gallons of water 12. Finish filling in the following piece-wise equation below that describes the chart based on the graph 50 if 0 < x <2 5x+50 y = if 6≤x≤8 30x 140