On the cities worksheet, click cell e13. depending on the city, you will either take a shuttle to/from the airport or rent a car. insert an if function that compares to see if yes or no is located in the rental car? column for a city. if the city contains no, display the value in cell f2. if the city contains yes, display the value in the rental car total (f4). copy the function from cell e13 and use the paste formulas option to copy the function to the range e14: e18 without removing the border in cell e18.

In its 2016 annual report, caterpillar inc. reported the following (in millions): 2016 2015 sales $38,537 $47,011 cost of goods sold 28,309 33,546 as a percentage of sales, did caterpillar's gross profit increase or decrease during 2016? select one: a. gross profit increased from 26.8% to 28.6% b. gross profit decreased from 28.6% to 26.5% c. gross profit increased from 71.4% to 73.2% d. gross profit decreased from 73.2% to 71.4% e. there is not enough information to answer the question.

The gomez company, a merchandising firm, has budgeted its activity for december according to the following information: • sales at $500,000, all for cash. • merchandise inventory on november 30 was $250,000. • the cash balance at december 1 was $20,000. • selling and administrative expenses are budgeted at $50,000 for december and are paid for in cash. • budgeted depreciation for december is $30,000. • the planned merchandise inventory on december 31 is $260,000. • the cost of goods sold represents 75% of the selling price. • all purchases are paid for in cash. the budgeted cash disbursements for december are:

During the year, the delph company had no beginning or ending inventories and it started, completed, and sold only two jobs—job d-75 and job c-100. it provided the following information related to those two jobs: job d-75: molding fabrication total direct materials cost $ 375,000 $ 325,000 $ 700,000 direct labor cost $ 200,000 $ 160,000 $ 360,000 machine-hours 15,000 5,000 20,000 job c-100: molding fabrication total direct materials cost $ 300,000 $ 250,000 $ 550,000 direct labor cost $ 175,000 $ 225,000 $ 400,000 machine-hours 5,000 25,000 30,000delph had no overapplied or underapplied manufacturing overhead during the year. assume delph uses a plantwide overhead rate based on machine-hours.1-a. compute the predetermined plantwide overhead rate.1-b. compute the total manufacturing costs assigned to job d-70 and job c-200.1-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 1-d. what is delph's cost of goods sold for the year? assume delph uses departmental overhead rates based on machine-hours.2-a. compute the predetermined departmental overhead rates.2-b. compute the total manufacturing costs assigned to job d-70 and job c-200.2-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 2-d. what is delph's cost of goods sold for the year?