Excel Assignment #2
(THIS IS AN INDIVIDUAL ASSIGNMENT, SO PLEASE TURN IN YOUR OWN WORK USING YOUR OW
ABC Manufacturing expects to sell 1,025 units of product in 2016 at an average price of $100,000 each based on curr
The Chief Marketing Officer forecasts
Week 3 Assignments
Chapter 6 Discussion Questions
4. Classify of the following expenditures as a deduction for AGI, a deduction from AGI or not
a. Amos contributes to his H.R. 10 plan (i.e., a retirement plan for a self-employed
Week 2 Assignment
Chapter 4 Discussion Questions
8. A Series EE U.S. government savings bond accrues 3.5% interest each year. The bond
matures in three years, at which time the principal and interest will be paid. The bank will pay
the taxpayer at a 3.5%
Week 1 Assignment
Week 1 Assignment
Chapter 1 Questions 1, 3, 5, and 7
1. In the following independent situations, is the tax position of the taxpayer likely to change?
Explain why or why not.
a. John used to make casual purchases and sales of real esta
Week 7 Assignment
3. A law practice was incorporated on January 1, 2015, and expects to earn $25,000 per month
before deducting the lawyers salary. The lawyer owns 100% of the stock. The corporation and
the lawyer both use
Week 6 Assignment
1. Upon the sale or other disposition of property, what four questions should be considered for
income tax purposes?
Is there a realized gain or loss?
If so, is the gain or loss recognized?
If the gain or
Week 5 Assignment
12. Review the advantages and disadvantages of the simplified method for determining the
office in the home deduction.
The major advantage of a simplified method is that the method is much easier to use when trying
4. Explain the purpose of the disabled access credit, and identify several examples of the type of
structural changes to a building that qualify for the credit.
The disabled access credit is designed to encourage small busi
15-17 (20-25 min.) Single-rate method, budgeted versus actual costs and quantities.
= $115,000/50 trips = $2,300 per round-trip
1. a. Budgeted rate = Budgeted indirect costs
Indirect costs allocated to Dark C. Division
= $2,300 per round-tr
19-16 (30 min.) Costs of quality.
The ratios of each COQ category to revenues and to total quality costs for each period are as follows:
Costen, Inc.: Semi-annual Costs of Quality Report
% of Total
13-21 (15 min.) Identifying and managing unused capacity (continuation of 13-18).
The amount and cost of unused capacity at the beginning of year 2011 based on year
2011 production follows:
Exam 2 Review Date of Exam is Thursday, October 16
Be familiar with the purpose of the balanced scorecard
Be able to calculate the revenue and cost effects of the growth component and the pricerecovery component
Know conceptually what th
Dont Let This Educational Opportunity Pass By!
The 2014 Heartland IMA Educational Conference is a great opportunity to learn from
leading accounting and business professionals such as Mr EXCEL Bill Jelen, Colette
Carlson, Dr. Chris Kuehl, Dr. Andrew Urich
Chap. 10: Determine How Costs Behave
Cost estimation: the process of estimating the relation between costs and the cost drivers that
Costs can be directly or indirectly related to a cost driver
Costs and expenditures (payments) can occur at
14-16 (15-20 min.) Cost allocation in hospitals, alternative allocation criteria.
Indirect costs ($11.52 - $2.40) = $9.12
The answers here are less than clear-cut in some cases.
Overhead Cost I
Exam 3 Review Date of Exam is Tuesday, November 11
Know the difference between joint products and byproducts.
Know the difference between joint costs and separable costs.
Know how to allocate joint costs based on sales value at splitoff
20-18 (15 min.) EOQ for a retailer.
D = 26,400 yards per year, P = $165, C = 20% $9 = $1.80 per yard per year
Number of orders per year:
Demand each working day
= 2, 200 yards
=12 orders per year
Transfer Pricing what one subunit charges another subunit of
the same company for goods or services.
Three Types of Transfer Pricing Methods Market Based, Cost
Based (variable or full cost), and Hybrid.
Subunits may be different types of
Chap. 23: Performance Measurement & Compensation
Three common measures of performance for managers of investment centers
Return on investment (ROI) is the most commonly used measure of investment
center performance. It is calculated as:
ROI = Income/In
Analyzing and interpreting information.
Classifying economic events.
Explaining uses, meaning, and limitations of data.
Keeping a systematic chronological diary of events.
Measuring events in dollars and cents.
Preparing accounting repor
Plan One Plan Two
Income before interest and taxes
Income before taxes
Income tax expense
Earnings per share
June 1 Cash
12-19 (25-30 min.) Value-added, nonvalue-added costs.
a. Materials and labor for regular repairs
b. Rework costs
c. Expediting costs caused by work delays
g. Breakdown maintenance of eq
Chap. 11 - Decision Making
Steps in decision making to achieve organizational objectives
Set goals and objectives
- use objective measures where possible
- consider qualitative factors
- tradeoffs between information cost and qual