the year 2013 is nearly half over J. Q. is told to determine how much the firm is likely to spend for warehousing at each of the eight warehouses for the last six months in 2013. Do this work for him.

Please show work

2012 Figures 2013 Figures Units Shipped Warehouse Costs Units Shipped Warehouse Costs 5 Months 5 Months Projected Actual Budgeted Actual Costs 12 Months Through 12 Months Through 12 Months 5 Months 12 Months Through 40,228 Boston 6,920 3,061 63,417 27,9157,2003,119 73,00029,416 Jan.-Dec. May 31 Jan.-Dec. May 31 Jan.-Dec. May 31Jan-Dec. 4,035178,000 lan-Dec May 3 anDec May 31 Atlanta 17,4314,080 156,830 35,890 18,000 Chicago 28,104 14,621 246,315 131,618 8,600 980 16,418,883 Los Angeles 16,491 11,431 151,975109,690 ,3334,028 73,015 36,021 30,000 3,100 2,000 17,000 9,000 8,000 15,20 285,000 141,.222 14,900 9,605 93,280 42,616 19,191 3,021 2,016 1,421 804 9,444 4,600 2,116 31,000 17,000 176,000 85,000 56,000 Denver 1005 28,019 Fargo Portland 2,331 51819 23,232 St. Louis 5,921