Download the spreadsheet for problem $16\mathrm{.}9$ from the website for this textbook. Write formulas to calculate the total depreciation expense and to display the correct values in the following three columns: Age, Depreciation Rate, and Depreciation Expense. $($HINT: You will need to use the VLOOKUP and MATCH, or XLOOKUP functions to do this. You may also want to read the article $$Double$-$Teaming in Excel,$$ by Judith K$.$ Welch, Lois S$.$ Mahoney, and Daniel R$.$ Brickner, in the November $2005$ issue of the Journal of Accountancy, from which this problem was adapted.$)$

$16\mathrm{.}10$ Answer all the following multiple$-$choice questions.

In terms of quality control measures, scrap and rework costs are part of $.$

prevention costs

inspection costs

internal failure costs

external failure costs

Which part of the throughput formula provides information about the impact of equipment downtime on overall productivity?

productive capacity

productive processing time

yield

None of the above

Which of the following is most likely the cost driver for accounts payable expenses associated with processing supplier invoices?

number of different parts purchased

total price of purchases

number of suppliers used

number of purchases made

All of the metrics listed above

Move tickets are a control procedure designed to reduce the risk of $.$

loss or destruction of production data

theft of inventory

disruption of operations

inappropriate allocation of overhead costs

At which stage of the production process can accountants contribute to significantly reducing the cost of goods sold?

product design

planning and scheduling

production operations

None of the above

MRP$-$II would most likely be used by a company that produces $.$

different grades of milk $($e$.$g$.,$ whole, $2\%,$ and skim$)$

toner cartridges for laser printers

toys based on a new movie

All of the above

None of the above

In terms of quality control measures, the costs associated with issuing credit memos to customers who return defective products is part of $.$

prevention costs

inspection costs

internal failure costs

external failure costs

None of the above

Which control procedure would be most effective in reducing the risk of over$-$ or underproduction?

reviewing all changes to master data

activity$-$based costing

production planning systems

computer$-$integrated manufacturing

reports that highlight the components of throughput

Please answer this and please give formala's for the current age and depreciation expense. Thank you.