Music Teachers, Inc., is an educational association for music teachers that has 19,900 members. The association operates from a central headquarters but has local membership chapters throughout the United States. Monthly meetings are held by the local chapters to discuss recent developments on topics of interest to music teachers. The association’s journal, Teachers’ Forum, is issued monthly with features about recent developments in the field. The association publishes books and reports and also sponsors professional courses that qualify for continuing professional education credit. The association’s statement of revenues and expenses for the current year is presented below.
| Music Teachers, Inc. Statement of Revenues and Expenses For the Year Ended November 30 |
||
| Revenues | $ | 3,325,000 |
| Expenses: | ||
| Salaries | 965,000 | |
| Personnel costs | 241,250 | |
| Occupancy costs | 288,000 | |
| Reimbursement of member costs to local chapters | 560,000 | |
| Other membership services | 530,000 | |
| Printing and paper | 352,000 | |
| Postage and shipping | 176,000 | |
| Instructors’ fees | 75,000 | |
| General and administrative | 37,000 | |
| Total expenses | 3,224,250 | |
| Excess of revenues over expenses | $ | 100,750 |
The board of directors of Music Teachers, Inc., has requested that a segmented income statement be prepared showing the contribution of each segment to the association. The association has four segments: Membership Division, Magazine Subscriptions Division, Books and Reports Division, and Continuing Education Division. Mike Doyle has been assigned responsibility for preparing the segmented income statement, and he has gathered the following data prior to its preparation.
a. Membership dues are $100 per year, of which $20 is considered to cover a one-year subscription to the association’s journal. Other benefits include membership in the association and chapter affiliation. The portion of the dues covering the magazine subscription ($20) should be assigned to the Magazine Subscription Division
b. One-year subscriptions to Teachers’ Forum were sold to nonmembers and libraries at $30 per subscription. A total of 3,300 of these subscriptions were sold last year. In addition to subscriptions, the magazine generated $111,000 in advertising revenues. The costs per magazine subscription were $9 for printing and paper and $4 for postage and shipping.
c. A total of 28,100 technical reports and professional texts were sold by the Books and Reports Division at an average unit selling price of $25. Average costs per publication were $4 for printing and paper and $2 for postage and shipping.
d. The association offers a variety of continuing education courses to both members and nonmembers. The one-day courses had a tuition cost of $75 each and were attended by 2,500 students. A total of 1,880 students took two-day courses at a tuition cost of $125 for each student. Outside instructors were paid to teach some courses.
e. Assume that the Occupancy cost could be avoided by eliminating a division. Salary costs and space occupied by division follow:
| Salaries | Space Occupied (square feet) | ||
| Membership | $ | 215,000 | 3,000 |
| Magazine Subscriptions | 154,000 | 1,000 | |
| Books and Reports | 314,000 | 1,000 | |
| Continuing Education | 191,000 | 2,000 | |
| Corporate staff | 91,000 | 3,000 | |
| Total | $ | 965,000 | 10,000 |
Personnel costs are 25% of salaries in the separate divisions as well as for the corporate staff. The $288,000 in occupancy costs includes $56,000 in rental cost for a warehouse used by the Books and Reports Division for storage purposes.
f. Printing and paper costs other than for magazine subscriptions and for books and reports relate to the Continuing Education Division.
g. General and administrative expenses include costs relating to overall administration of the association as a whole. The company’s corporate staff does some mailing of materials for general administrative purposes.
The expenses that can be traced or assigned to the corporate staff, as well as any other expenses that are not traceable to the segments, will be treated as common costs. It is not necessary to distinguish between variable and fixed costs.
Required:
1. Prepare a contribution format segmented income statement for Music Teachers, Inc. This statement should show the segment margin for each division as well as results for the association as a whole.
References
eBook & Resources
In: Accounting
How do you gain and maintain the trust and confidence
of colleagues and external contacts through professional conduct?
Please also explain what not to do such as behaviours that destroy
trust.
In: Accounting
Walton Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2019. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks:
Problem 14-23 Part 1
Required
October sales are estimated to be $390,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget.
The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts.
The cost of goods sold is 70 percent of sales. The company desires to maintain a minimum ending inventory equal to 20 percent of the next month’s cost of goods sold. However, ending inventory of December is expected to be $13,700. Assume that all purchases are made on account. Prepare an inventory purchases budget.
The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the following month. Prepare a cash payments budget for inventory purchases.
Budgeted selling and administrative expenses per month follow:
| Salary expense (fixed) | $ | 19,700 | |
| Sales commissions | 4 | % of Sales | |
| Supplies expense | 2 | % of Sales | |
| Utilities (fixed) | $ | 3,100 | |
| Depreciation on store fixtures (fixed)* | $ | 5,700 | |
| Rent (fixed) | $ | 6,500 | |
| Miscellaneous (fixed) | $ | 2,900 | |
Use this information to prepare a selling and administrative expenses budget.
Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.
Walton borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $29,000 cash cushion. Prepare a cash budget.
In: Accounting
1.Why is it important for an accountant to understand their business and industry as well as managements informational needs in addition to knowing how to generate financial statements?
Note: You may use S&S as the context while answering this question. However, please present your own examples.
2.You are likely using various forms of social media (e.g., Twitter, Facebook). Please explore the idea of how would this non-financial information external to the company be of use? What other nonfinancial information would be useful? Could you think of financial information that is external to the organization that might be useful to management as well?
In: Accounting
the following selected financial statement information is for Stevens Company
December 31
2017 2016 Changes in assets
Current Assets
Cash $ 86,000 $71,000
Accounts receivable 24,000 20,000
Merchandise inventory 20,000 27,000
Prepaid expenses 10,000 8,000
Current Liabilities
Accounts payable 41,000
44,000
Income taxes payable 6,000 11,000
Other data for the Year Ended December 31, 2017
From the income statement:
Net income $146,000
Depreciation expense 32,000
Loss on sale of equipment
9,000
From accounting records:
Capital expenditures 44,000
Required:
a. Using the indirect method, prepare the operating
activities section of the statement of cash flows for Stevens
Company for the year ended December 31, 2017.
b. Calculate the following cash measures:
(1) Operating cash flow ratio (round to
the nearest tenth of a percent).
(2) Capital expenditure ratio (round to
the nearest tenth of a percent).
(3) Free cash flow
In: Accounting
The following facts relate to questions 1 through 10:
The City of Oxford, Mississippi (population just under 24,000) passed a bond issue for $2,500,000, 4.5 percent, semiannual interest, 10 year bonds to finance the construction of a second high school to be called Yoknapatawpha High, named in memory of the Pulitzer Prize winning author, William Faulkner. The State also contributed $110,000 for construction of the gymnasium. The contractor selected then submitted her contract for $2,080,000 to commence on January 2, 2019, with the project’s estimated completion in late 2019.
1. The contractor submitted her signed contract to the City of Oxford. The entry to record the contract in the Debt Services Fund would include a:
A. Debit to Encumbrances—2019, $2,500,000.
B. Debit to Construction Work-in-Progress, $2,080,000.
C. Credit to Encumbrances—2019, $2,080,000.
D. Credit to Encumbrances Outstanding—2019, $2,080,000.
2. The money from the State of Mississippi of $110,000 was received by the City of Oxford’s General Fund. The monies were then transferred from the General Fund to the Capital Project Fund. The entry in the General Fund receiving the grant money from the state would include a:
A. Credit to Program Revenues—Public Education—Capital Grants and Contributions, $110,000.
B. Credit to Revenues, $110,000.
C. Debit to Other Financing Uses—Transfers-out, $110,000.
D. Credit to Other Financing Uses—Transfers-in, $110,000.
3. The entry in the General Fund transferring the state monies to the Capital Projects Fund would include a:
A. Debit to Cash, $110,000.
B. Credit to Cash, $110,000.
C. Debit to Other Financing Sources, $110,000.
D. Credit to Other Financing Uses, $110,000.
4. The entry in the Capital Projects Fund receiving the transferred state monies from the General Fund would include a:
A. Credit to Other Financing Sources, $110,000.
B. Debit to Other Financing Uses, $110,000.
C. Credit to Cash, $110,000.
D. Credit to Grants Receivable, $110,000. 3
5. When the contractor submitted a $700,000 progress billing, the following entry in the Capital Projects Fund would include:
A. Debit to Encumbrances—2019, $700,000.
B. Credit to Cash, $700,000.
C. Debit to Encumbrances Outstanding—2019, $700,000.
D. Debit to Construction-work-in progress, $700,000.
6. Assuming the partial billing was approved for payment and the expenditure and liability (contracts payable) was recorded for $700,000; however, Oxford has a policy of not paying 100 percent, but retaining 20 percent as a retained percentage. The entry in the Capital Projects Fund to record the allowed payment and retained percentage would include:
A. Credit to Cash, $560,000.
B. Debit to Contracts Payable, $560,000.
C. Credit to Contracts Payable—Retained Percentage, $560,000.
D. Debit to Contracts Payable, $140,000.
7. Prior to the receipt of the bond proceeds, Oxford needed funds and went to United Southern Bank to borrow $600,000 in bond anticipation notes (BANs), at 5 percent, which were to be paid back using the proceeds of the $2,500,000 bond issue. The entry at the government-wide level to record the receipt of the bond anticipation notes would include a:
A. Credit to Other Financing Sources—proceeds of BANs, $600,000.
B. Debit to Cash, $1,900,000.
C. Credit to Bonds Payable, $600,000.
D. Debit to Cash, $600,000.
8. Assume the bond issue commences, and the $2,500,000 proceeds are received. Oxford repays the bond anticipation notes in full along with $7,500 in interest. The entry recorded in the Capital Projects Fund to repay the bond anticipation notes would include a:
A. Debit to Other Financing Uses—Retirement of BANs, $600,000.
B. Credit to Cash, $600,000.
C. Debit to Bond Anticipation Notes Payable, $600,000.
D. Debit to Expenses—Interest on Long-term Debt, $7,500.
9. Assume that at the conclusion of the construction project that the total costs totaled $3,200,000. This included some cost overruns. Assuming the high school passes all inspections and the asset is placed into service, the re-class entry to record the Building in the Capital Projects Fund would include:
A. a Credit to Buildings, $3,200,000.
B. a Debit to Buildings, $3,200,000.
C. No entry would be recorded in the Capital Projects Fund.
D. a Credit to Encumbrances—2019, $3,200,000. 4
10. In the Capital Projects Fund, which of the following accounts would be part of the closing entry at the end of the project?
A. Cash.
B. Other Financing Sources—Proceeds of Bonds.
C. Expenses—Interest on Long-term Debt.
D. Construction Work in Progress.
In: Accounting
Tyrene Products manufactures recreational equipment. One of the company’s products, a skateboard, sells for $37. The skateboards are manufactured in an antiquated plant that relies heavily on direct labour workers. Thus, variable costs are high, totalling $25.90 per skateboard, of which 70% is direct labour cost. Over the past year the company sold 43,000 skateboards, with the following operating results: Sales (43,000 skateboards) $ 1,591,000 Variable expenses 1,113,700 Contribution margin 477,300 Fixed expenses 277,500 Net operating income $ 199,800 Management is anxious to maintain and perhaps even improve its present level of income from the skateboards. Required: 1a. Compute the CM ratio and the break-even point in skateboards. (Do not round intermediate calculations. Round your answer to the nearest whole number.) 1b. Compute the degree of operating leverage at last year's level of sales. (Round your answer to 2 decimal places.) 2. Due to an increase in labor rates, the company estimates that variable costs will increase by $1.85 per skateboard next year. If this change takes place and the selling price per skateboard remains constant at $37.00, what will be the new CM ratio and the new break-even point in skateboards? (Round your intermediate calculations and the "Contribution margin" answer to 2 decimal places and other answer to the nearest whole number. ) 3. Refer to the data in (2) above. If the expected change in variable costs takes place, how many skateboards will have to be sold next year to earn the same net operating income, $199,800, as last year? (Do not round intermediate calculations. Round your answer to the nearest whole number.) 4. Refer again to the data in (2) above. The president has decided that the company may have to raise the selling price of its skateboards. If Tyrene Products wants to maintain the same CM ratio as last year, what selling price per skateboard must it charge next year to cover the increased labor costs? (Do not round intermediate calculations. Round your answer to 2 decimal places. ) 5. Refer to the original data. The company is considering the construction of a new, automated plant. The new plant would slash variable costs by 20%, but it would cause fixed costs to increase by 92%. If the new plant is built, what would be the company’s new CM ratio and new break-even point in skateboards? (Round your intermediate calculations and the "Contribution margin" answer to 2 decimal places and other answer to the nearest whole number .) 6. Refer to the data in (5) above. a. If the new plant is built, how many skateboards will have to be sold next year to earn the same net operating income, $199,800, as last year? (Do not round intermediate calculations. Round your answer to the nearest whole number.) b-1. Assume that the new plant is constructed and that next year the company manufactures and sells 43,000 skateboards (the same number as sold last year). Prepare a contribution format income statement. (Input all amounts as positive values except losses which should be indicated by minus sign. ) b-2. Compute the degree of operating leverage. (Round your answer to 2 decimal places.)
In: Accounting
In: Accounting
Pell Corporation's property, plant, and equipment and accumulated depreciation accounts had the following balances at December 31, 2015:
| Property, Plant, and Equipment |
Accumulated Depreciation |
|
|---|---|---|
| Land | $350,000 | $ — |
| Land Improvements | 180,000 | 45,000 |
| Building | 1,500,000 | 350,000 |
| Machinery and Equipment | 1,158,000 | 405,000 |
| Automobiles | 150,000 | 112,000 |
Depreciation method and useful lives:
Transactions during 2016:
Required:
1. Prepare a schedule analyzing the changes in each of the plant assets during 2016. Disregard the related accumulated depreciation accounts.
| PELL CORPORATION | ||||
| Analysis of Changes in Plant Assets | ||||
| For the Year Ended December 31, 2016 | ||||
| Balance 12/31/15 | Increase | Decrease | Balance 12/31/16 | |
| Land | $ | $ | $ | |
| Land improvements | ||||
| Building | ||||
| Machinery and equipment | ||||
| Automobiles | ||||
| Totals | $ | $ | $ | $ |
Feedback
2. For each asset classification, prepare a schedule showing depreciation expense for the year ended December 31, 2016.
| PELL CORPORATION | |||
| Depreciation Expense | |||
| For the Year Ended December 31, 2016 | |||
| Land improvements: | |||
| Total depreciation on land improvements | $ | ||
| Building: | |||
| Total depreciation on building | |||
| Machinery and equipment: | |||
| Cost of machinery and equipment, Balance, 12/31/15 | $ | ||
| Deduct machine sold 3/31/16 | $ | ||
| Depreciation after applying straight-line rate | |||
| Cost of asset purchased 1/2/16 | $ | ||
| Depreciation | |||
| Cost of machine sold 3/31/16 | $ | ||
| Depreciation from 1/1/16 to 3/31/16 | |||
| Total depreciation on machinery and equipment | |||
| Automobiles: | |||
| Total depreciation on automobiles | |||
| Total depreciation expense for 2016 | $ | ||
Feedback
3. Prepare a schedule showing the gain or loss from each asset disposal that Pell would recognize in its income statement for the year ended December 31, 2016.
| PELL CORPORATION | |
| Gain or Loss from Plant Asset Disposals That Would Be Recognized in Income Statement | |
| For the Year Ended December 31, 2016 | |
| Gain or (loss) | |
| Sale of machine 3/31/16: | |
| Selling price | $ |
| Carrying amount of machine sold | |
| Gain on sale | $ |
| Trade-in of automobile 12/31/16: | |
| Carrying amount of trade-in | $ |
| Trade-in allowed | |
| Loss on trade-in | |
| Net gain from asset disposals | $ |
In: Accounting
QUESTION 31
The following financial information is given for Du Pont and Dow for fiscal year 2001:
|
Du Pont |
Dow |
|
|
Closing Stock Price, Feb. 15, 2002 |
44.90 |
30.57 |
|
EPS (actual for 2001) |
4.50 |
-0.46 |
|
EPS (forecast for 2002) |
1.60 |
0.52 |
|
Dividend per share |
1.40 |
1.34 |
|
5 year forecast earnings growth rate |
10.2% |
10.0% |
|
Intrinsic value per share |
103.84 |
33.38 |
Given the Feb. 15 stock prices, Du Pont & Dow have PE ratios (based on year-ahead EPS forecast) of:
| a. |
28.06 & 58.79, respectively |
|
| b. |
9.98 & 58.79, respectively |
|
| c. |
28.06 & 66.46, respectively |
|
| d. |
32.07 & 22.81, respectively |
Following Question 31, given the Feb. 15 stock prices, Du Pont & Dow have dividend yields of:
| a. |
13.72% & 13.40%, respectively |
|
| b. |
3.56% & 1.70%, respectively |
|
| c. |
3.12% & 4.38%, respectively |
|
| d. |
31.11% & 2.58%, respectively |
Following Question 31, given the Feb. 15 stock prices, PE based on actual EPS & 5-year-ahead earnings forecast, Du Pont has a PEG of:
| a. |
3.14 |
|
| b. |
0.98 |
|
| c. |
4.40 |
|
| d. |
2.75 |
Following Question 31, based on PEG, which company seems to be the better investment opportunity?
| a. |
Dow because of the very high PEG |
|
| b. |
Du Pont because of the very high PEG |
|
| c. |
Dow because the PEG is less than the benchmark cutoff of 1 |
|
| d. |
Du Pont because the PEG is less than the benchmark cutoff of 1 |
Following Question 31, based on intrinsic value to share price, Du Pont and Dow are:
| a. |
Du Pont is undervalued but Dow is overvalued |
|
| b. |
Both are undervalued |
|
| c. |
Du Pont is overvalued but Dow is undervalued |
|
| d. |
Both overvalued |
In: Accounting
Activity Rates and Product Costs using Activity-Based Costing
Garfield Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows:
Activity |
Budgeted Activity Cost |
Activity Base |
|
| Casting | $258,500 | Machine hours | |
| Assembly | 188,640 | Direct labor hours | |
| Inspecting | 27,300 | Number of inspections | |
| Setup | 57,000 | Number of setups | |
| Materials handling | 35,260 | Number of loads | |
Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity-base usage quantities and units produced follow:
| Activity Base | Entry | Dining | Total | |||
| Machine hours | 5,480 | 4,860 | 10,340 | |||
| Direct labor hours | 4,720 | 7,070 | 11,790 | |||
| Number of inspections | 1,600 | 500 | 2,100 | |||
| Number of setups | 310 | 70 | 380 | |||
| Number of loads | 650 | 170 | 820 | |||
| Units produced | 10,800 | 5,400 | 16,200 | |||
a. Determine the activity rate for each activity. If required, round the rate to the nearest dollar.
| Activity | Activity Rate | |
| Casting | $ | per machine hour |
| Assembly | $ | per direct labor hour |
| Inspecting | $ | per inspection |
| Setup | $ | per setup |
| Materials handling | $ | per load |
b. Use the activity rates in (a) to determine the total and per-unit activity costs associated with each product. Round the per unit rates to the nearest cent.
| Product | Total Activity Cost | Activity Cost Per Unit |
| Entry Lighting Fixtures | $ | $ |
| Dining Room Lighting Fixtures | $ | $ |
Please explain step by step how you got part B
In: Accounting
Adam Granger operates a kiosk in downtown Chicago, at which he sells one style of baseball hat. He buys the hats from a supplier for $16 and sells them for $22. Adam’s current breakeven point is 20,250 hats per year.
Assume that Adam’s fixed costs, variable costs, and sales price were the same last year, when he made $28,350 in net income. How many hats did Adam sell last year, assuming a 30% income tax rate? (correct answer is 27,700 - already figured out that step)
What was Adam’s margin of safety last year? Margin of Safety $_____
If Adam wants to earn $51,030 in net income, how many hats must
he sell, assuming a 30% tax rate?
# of Hats: _____
How many hats must Adam sell to break even if his supplier
raises the price of the hats to $17 per hat?
# of Hats: _____
Adam has decided to increase his sales price to $23 to offset
the supplier’s price increase. He believes that the increase will
result in a 5% reduction from last year’s sales volume. What is
Adam’s expected net income, assuming a 30% tax rate?
Net Income: $_______
In: Accounting
Consider the following project data: A Shs 4 million feasibility study will be conducted at t =0. If the study indicates potential, the firm will spend Shs 20 million at t= 1 to build a prototype. The best estimate is that there is an 80% chance that the study will indicate potential and 20% chance that it will not. If reception of the prototype is good the firm will spend Sh. 700 million to build a production plant at t=2. The best estimate is that there is a 70% chance that the prototypes’ reception will be poor. If the plant is built, there’s a 60% chance of a t=3 cash inflow of Shs 600 million and a 40% chance of Shs 300 million cash inflow. If the inflow at t=3 is Shs 600 million, there are 30% and 70% chances of Shs 320 million and Shs 180 million inflows respectively at t=4. If the inflow at t=3 is Shs 300 million, there are 80% and 20% chances of Shs 420 million and Shs 280 million inflows respectively at t=4. The plant has a salvage value of Shs 100 million at t=5.
If the appropriate cost of capital is 14% what is the project’s expected NPV?
In: Accounting
In: Accounting
Bluefield has decided to use an ABC costing system and has identified the following detailed information about its cost pools and cost drivers: Activity cost pools Materials handling $56,000 Machine maintenance $17,640 Cost drivers Number of material moves 500 Number of machine hours 42,000 Required: 1. Calculate Bluefield’s activity rate for each cost pool. 2. Determine the amount of overhead assigned to Bluefield’s products if each has the following activity demands: Product A Product B Number of material moves 290 210 Number of machine hours 17,200 24,800
Calculate Bluefield’s activity rate for each cost pool. (Round your final answer for per material moves to nearest dollar amount and per machine hour to 4 decimal places.)
|
Determine the amount of overhead assigned to Bluefield’s products if each has the following activity demands: (Round intermediate calculations to 4 decimal places and your final answers to 2 decimal places.)
| Product A | Product B | ||
| Number of material moves | 290 | 210 | |
| Number of machine hours | 17,200 | 24,800 | |
Show less
|
3.
Gable Company uses three activity cost pools. Each pool has a cost driver. Information for Gable Company follows:
| Activity Cost Pools | Total Cost of Pool | Cost Driver | Estimated Cost Driver | ||
| Machining | $ | 195,920 | Number of machine hours | 63,200 | |
| Designing costs | 50,400 | Number of design hours | 6,000 | ||
| Setup costs | 69,776 | Number of batches | 490 | ||
Required:
1. Compute the activity rate for each activity.
2. Classify each activity as facility, product, batch, or unit level.
Compute the activity rate for each activity. (Round your answers to 2 decimal places.)
|
Classify each activity as facility, product, batch, or unit level.
|
In: Accounting