Currently, customers are responsible for paying the shipping costs. The sales team suggests that customers really dislike paying shipping costs, and that offering "free shipping" instead of the 1% discount would likely increase sales. Create a formula for the "Sales with Free Shipping" column that subtracts the "Shipping Cost" from the "Sales" only if the "Expanded Order Type" is Extra Large, XX Large, or XXX Large. Copy the formula down to all the rows. What would total 2012 sales have been if the company had offered free shipping instead of the 1% discount (rounded to 2 decimal places)?

while setting up his new office, an attorney ordered thick, frieze carpets for the floor. however, the building inspector had him remove the expensive carpeting. the building inspector stated that according to federal regulations, the office must be wheelchair accessible as it is a public area. he further explained that since wheelchairs do not maneuver well in thick, frieze carpeting, the carpets had to be removed and be replaced with smooth-textured carpets that do not restrict wheelchair maneuverability. this scenario illustrates how a company is influenced by the component of its specific environment.

Which of the following is a problem for the production of public goods?

James albemarle created a trust fund at the beginning of 2016. the income from this fund will go to his son edward. when edward reaches the age of 25, the principal of the fund will be conveyed to united charities of cleveland. mr. albemarle specified that 75 percent of trustee fees are to be paid from principal. terry jones, cpa, is the trustee. james albemarle transferred cash of $500,000, stocks worth $400,000, and rental property valued at $250,000 to the trustee of this fund. immediately invested cash of $360,000 in bonds issued by the u. s. government. commissions of $7,900 are paid on this transaction. incurred permanent repairs of $9,000 so that the property can be rented. payment is made immediately. received dividends of $8,000. of this amount, $3,000 had been declared prior to the creation of the trust fund. paid insurance expense of $4,000 on the rental property. received rental income of $10,000. paid $8,000 from the trust for trustee services rendered. conveyed cash of $7,000 to edward albemarle.