Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Clicking “Solve” and then “Keep the Solver Solution” yields the following spreadsheet, as shown in the article:
Finally, adjusting the total amount of labor hours and dollars and re-running the Solver yields the final spreadsheet depicted in the
article:
c. Rerun the Solver program to determine the effect of the following actions on income (print out the results of each
option):
• double market share limitations for all three products
• Double market share limitations for all three products plus the following constraint: sauce case sales cannot exceed
50% of the sum of soup and casserole case sales
14.9 EXCEL PROBLEM
Download the spreadsheet for problem 14.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 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).
Solution is on next page:
Depreciation expense formula: =VLOOKUP(J5,$A$4:$D$14,MATCH(H5,$A$4:$D$4,0))
- explanation of formula:
CASE 14-1 The Accountant and CIM
Examine issues of the Journal of Accountancy, Strategic Finance, and other business
magazines for the past three years to find stories about current developments in factory
automation. Write a brief report that discusses the accounting implications of one
development: how it affects the efficiency and accuracy of data collection and any new
opportunities for improving the quality of performance reports. Also discuss how the
development affects the risks of various production cycle threats and the control
procedures used to mitigate those risks.
