The following are BAC Bhd.’s year end statement of financial position and statement of profit and loss for 2016 and 2017:
2017 ($) |
2016 ($) |
2017 ($) |
2016 ($) |
||
Non Current Assets: |
total non current liabilities |
410769 |
372931 |
||
Gross Non Current assets |
317,503 |
232,179 |
current liabilities |
||
Less accumulated depreciation |
54,045 |
34,187 |
short term borrowings |
288798 |
296149 |
Net Non Current assets |
263,458 |
197,992 |
A/P |
636318 |
414611 |
Current Assets: |
accruals |
106748 |
103362 |
||
cash and equivalents |
208323 |
102024 |
total Current libilities |
1031864 |
814122 |
A/R |
690294 |
824979 |
total liabilities |
1442633 |
1187053 |
inventories |
942374 |
715414 |
shareholder equity |
||
total Current assets |
1840991 |
1642417 |
common stock(100000 sahres) |
550000 |
550000 |
total assets |
2104449 |
1840409 |
retaines earning |
111816 |
103356 |
noncurrent liabilities |
total shareholder equity |
661816 |
653356 |
||
long term debt |
410769 |
372931 |
total liabilities and share holder equity |
2104449 |
1840409 |
2017 ($) |
2016 ($) |
|
Sales |
2,325,967 |
2,220,607 |
(-) Cost of goods sold |
1,869,326 |
1,655,827 |
Other expenses |
287,663 |
273,870 |
Total operating costs excluding depreciation and amortization |
2,156,989 |
1,929,697 |
Depreciation and amortization |
25,363 |
26,341 |
Total operating costs |
2,182,352 |
1,956,038 |
EBIT |
143,615 |
264,569 |
(-) Interest expense |
31,422 |
13,802 |
EBT |
112,193 |
250,767 |
(-) Taxes (30%) |
33,658 |
75,230 |
Net income |
78,535 |
175,537 |
Related items:
2017 Total dividends paid $70,075 , Stock price per share $15.60
2016 Total dividends paid $15.60 , Stock price per share $21.80
Required:
In: Accounting
Contribution Format | |||
2016 | 2017 | 2018 | |
Sales | $ 135,987 | $ 177,866 | $ 232,887 |
Variable expenses | |||
Cost of sales | 88,265 | 111,934 | 139,156 |
Fulfillment | 14,095 | 20,199 | 27,222 |
Marketing | 7,233 | 10,069 | 13,814 |
Technology and content | 8,042.50 | 11,310 | 14,418.50 |
Total variable expenses | 117,636 | 153,512 | 194,610 |
Contribution margin | $ 18,351 | $ 24,354 | $ 38,277 |
Fixed expenses | |||
Fulfillment | 3,524 | 5,050 | 6,805 |
Technology and content | 8,042.50 | 11,310 | 14,418.50 |
General and admin | 2,432 | 3,674 | 4,336 |
Other | 167 | 214 | 296 |
Total fixed expenses | 14,165 | 20,248 | 25,856 |
Operating income | $ 4,186 | $ 4,106 | $ 12,421 |
calculate the contribution margin ratio , break even dollar sales, margin of safety (dollars) safety margin % of sales
In: Accounting
Prepare the adjustment entry as of 30/06/2012 under the following
E. According to the balance sheet, the inventory was $223,500. At the end of the financial year stock take, you have been advised that the inventory value is only $210,000.
F. On 30/06/2012, the company aged receivables which have a total of $306,400. The company estimated 2% of 90 days receivable and 10% of over 90 days will not be able to be collected.
Aged Receivable Summary 30/6/2013 |
||||
Total Due |
0-30 days |
31-60 days |
61-90 days |
91-120 days |
$311,400 |
$220,000 |
$60,000 |
$18,000 |
$16,400 |
In: Accounting
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data:
Product | Demand Next year (units) |
Selling Price per Unit |
Direct Materials |
Direct Labor |
|||
Debbie | 52,000 | $ | 17.00 | $ | 4.50 | $ | 2.80 |
Trish | 44,000 | $ | 6.50 | $ | 1.30 | $ | 1.40 |
Sarah | 37,000 | $ | 26.00 | $ | 6.74 | $ | 4.90 |
Mike | 40,800 | $ | 12.00 | $ | 2.20 | $ | 3.50 |
Sewing kit | 327,000 | $ | 8.20 | $ | 3.40 | $ | 1.05 |
The following additional information is available:
The company’s plant has a capacity of 114,750 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products.
The direct labor rate of $7 per hour is expected to remain unchanged during the coming year.
Fixed manufacturing costs total $540,000 per year. Variable overhead costs are $4 per direct labor-hour.
All of the company’s nonmanufacturing costs are fixed.
The company’s finished goods inventory is negligible and can be ignored.
Required:
1. How many direct labor hours are used to manufacture one unit of each of the company’s five products?
2. How much variable overhead cost is incurred to manufacture one unit of each of the company’s five products?
3. What is the contribution margin per direct labor-hour for each of the company’s five products?
4. Assuming that direct labor-hours is the company’s constraining resource, what is the highest total contribution margin that the company can earn if it makes optimal use of its constrained resource?
5. Assuming that the company has made optimal use of its 114,750 direct labor-hours, what is the highest direct labor rate per hour that Walton Toy Company would be willing to pay for additional capacity (that is, for added direct labor time)?
In: Accounting
Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided for seniors—home nursing, Meals On Wheels, and housekeeping. Data on revenue and expenses for the past year follow:
Total | Home Nursing | Meals On Wheels | House- keeping |
|||||
Revenues | $ | 924,000 | $ | 262,000 | $ | 405,000 | $ | 257,000 |
Variable expenses | 470,000 | 120,000 | 195,000 | 155,000 | ||||
Contribution margin | 454,000 | 142,000 | 210,000 | 102,000 | ||||
Fixed expenses: | ||||||||
Depreciation | 70,000 | 8,800 | 40,500 | 20,700 | ||||
Liability insurance | 43,900 | 20,900 | 7,400 | 15,600 | ||||
Program administrators’ salaries | 115,000 | 40,200 | 38,500 | 36,300 | ||||
General administrative overhead* | 184,800 | 52,400 | 81,000 | 51,400 | ||||
Total fixed expenses | 413,700 | 122,300 | 167,400 | 124,000 | ||||
Net operating income (loss) | $ | 40,300 | $ | 19,700 | $ | 42,600 | $ | (22,000) |
*Allocated on the basis of program revenues.
The head administrator of Jackson County Senior Services, Judith Miyama, considers last year’s net operating income of $40,300 to be unsatisfactory; therefore, she is considering the possibility of discontinuing the housekeeping program.
The depreciation in housekeeping is for a small van that is used to carry the housekeepers and their equipment from job to job. If the program were discontinued, the van would be donated to a charitable organization. None of the general administrative overhead would be avoided if the housekeeping program were dropped, but the liability insurance and the salary of the program administrator would be avoided.
Required:
1-a. What is the financial advantage (disadvantage) of discontinuing the Housekeeping program?
1-b. Should the Housekeeping program be discontinued?
2-a. Prepare a properly formatted segmented income statement.
2-b. Would a segmented income statement format be more useful to management in assessing the long-run financial viability of the various services?
In: Accounting
Exercise
Assume your Company sells to merchandisers in three different states—Oregon, Texas and Colorado The following profit analysis by state was prepared by the company:
Oregon Texas Colorado
Revenue 4,500,000 4,000,000 4,000,000
Cost of Goods Sold 2,500,000 2,000,000 2,000,000
Gross profit 2,000,000 2,000,000 2,000,000
Selling Expenses 500,000 700,000 700,000
Net profit 1,500,000 1,300,000 1,300,000
Following are the fixed portion within the costs provided above:
Fixed manufacturing Costs 300,000 500,000 1,000,000
Fixed Selling and Admin Costs 300,000 200,000 400,000
Now, Management believes it could increase state sales by 20%, without increasing any of the fixed costs, by spending an additional $50,000 per state on advertising. No change in inventories.
In: Accounting
Mercer Asbestos Removal Company removes potentially toxic asbestos insulation and related products from buildings. There has been a long-simmering dispute between the company’s estimator and the work supervisors. The on-site supervisors claim that the estimators do not adequately distinguish between routine work such as removal of asbestos insulation around heating pipes in older homes and nonroutine work such as removing asbestos-contaminated ceiling plaster in industrial buildings. The on-site supervisors believe that nonroutine work is far more expensive than routine work and should bear higher customer charges. The estimator sums up his position in this way: “My job is to measure the area to be cleared of asbestos. As directed by top management, I simply multiply the square footage by $2.50 to determine the bid price. Since our average cost is only $2.46 per square foot, that leaves enough cushion to take care of the additional costs of nonroutine work that shows up. Besides, it is difficult to know what is routine or not routine until you actually start tearing things apart.” |
To shed light on this controversy, the company initiated an activity-based costing study of all of its costs. Data from the activity-based costing system follow: |
Activity Cost Pool | Activity Measure | Total Activity | |
Removing asbestos | Thousands of square feet | 1,000 | thousand square feet |
Estimating and job setup | Number of jobs | 500 | jobs |
Working on nonroutine jobs | Number of nonroutine jobs | 100 | nonroutine jobs |
Other (costs of idle capacity and organization-sustaining costs) |
None | ||
Note: The 100 nonroutine jobs are included in the total of 500 jobs. Both nonroutine jobs and routine jobs require estimating and setup. |
Costs for the Year | ||
Wages and salaries | $ | 407,000 |
Disposal fees | 800,000 | |
Equipment depreciation | 96,000 | |
On-site supplies | 56,000 | |
Office expenses | 300,000 | |
Licensing and insurance | 490,000 | |
Total cost | $ | 2,149,000 |
Distribution of Resource Consumption Across Activities |
Removing Asbestos | Estimating and Job Setup | Working on Nonroutine Jobs | Other | Total | ||||||
Wages and salaries | 50 | % | 10 | % | 30 | % | 10 | % | 100 | % |
Disposal fees | 70 | % | 0 | % | 30 | % | 0 | % | 100 | % |
Equipment depreciation | 40 | % | 5 | % | 20 | % | 35 | % | 100 | % |
On-site supplies | 60 | % | 25 | % | 15 | % | 0 | % | 100 | % |
Office expenses | 15 | % | 35 | % | 20 | % | 30 | % | 100 | % |
Licensing and insurance | 25 | % | 0 | % | 60 | % | 15 | % | 100 | % |
Required: |
1. |
Perform the first-stage allocation of costs to the activity cost pools. |
2. | Compute the activity rates for the activity cost pools. |
3. |
Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system. (Round the "Average cost" to 2 decimal places.) |
a. | A routine 1,000-square-foot asbestos removal job. | |
b. | A routine 2,000-square-foot asbestos removal job. |
c. | A nonroutine 2,000-square-foot asbestos removal job. |
In: Accounting
Complete the problems below on process costing and variance
analysis.
Part 1: You must prepare two process costing cost reports – one
using the weighted average method and one using the fifo
method.
Morgan Clay Products manufactures clay molded pottery on an
assembly line. Its standard costing system uses two cost
categories, direct materials and conversion costs. Each product
must pass through the Molding Department and the Finishing
Department. Direct materials are added at the beginning of the
production process. Conversion costs are allocated evenly
throughout production.
Data for the Assembly Department for August 2017 are:
Work in process, beginning inventory: 2600 units
Direct materials (100% complete)
Conversion costs (35% complete)
Units started during August 715 units
Work in process, ending inventory: 520 units
Direct materials (100% complete)
Conversion costs (55% complete)
Costs for August:
Standard costs for Assembly:
Direct materials $18 per unit
Conversion costs $35.50 per unit
Work in process, beginning inventory:
Direct materials $12,600
Conversion costs $8250
Part 2A: Variance Problem
Castleton Corporation manufactured 36,000 units during March. The
following fixed overhead data relates to March:
Actual Static Budget
Production 36,000 units 34,000 units
Machine-hours 6,960 hours 6,800 hours
Fixed overhead costs for March $164,700 $156,400
Compute the fixed overhead variances.
Part 2B: Variance Problem
Russo Corporation manufactured 21,000 air conditioners during
November. The overhead cost-allocation base is $34.50 per
machine-hour. The following variable overhead data pertain to
November:
Actual Budgeted
Production 21,000 units 23,000 units
Machine-hours 12,700 hours 13,800 hours
Variable overhead cost per machine-hour:
$34.00 $34.50
Compute the variable overhead variances.
In: Accounting
1. Discuss the arguments for and against cost allocation
2. What are the differences between revenue and capital expenditures? In your explanation, discuss the accounting procedures for each type of expenditure.
In: Accounting
Schrader Cellars uses the FIFO method in its two department process costing system: Fermenting (grape sorting is part of the fermentation process) and Packaging. Direct materials (grapes) are added at the beginning of the fermenting process and at the end of the packaging process (bottles). Conversion costs are added evenly throughout each process. Data from the month of March for the Fermenting Department are below:
Beginning work in process inventory:
Units in beginning work in process inventory 3,000 gallons
Materials costs $122,000
Conversion costs $7,000
Percentage complete with respect to materials 100%
Percentage complete with respect to conversion 50%
Units started into production during the month 5,000 gallons
Materials costs added during the month $250,000
Conversion costs added during the month $30,000
Ending work in process inventory:
Units in ending work in process 2,000 gallons
Percentage complete with respect to materials 100%
Percentage complete with respect to conversion 75%
REQUIRED:
In: Accounting
The difference between the actual variable overhead cost and the standard variable overhead cost for the actual volume of the overhead activity base is known as the
Select one:
A. variable overhead efficiency variance.
B. fixed overhead budget variance.
C. variable overhead spending variance.
D. fixed overhead volume variance.
In: Accounting
shareholders contributed 60 grand.
land was purchased for 40 grand
I borrowed 18 grand from a bank
I provided services on credit for 16 grand which should be paid
back to me in a year.
I paid 11 grand for operating expenses.
I paid a grand cash dividends to shareholders.
place the appropriate amounts in the corresponding T accounts: cash, accounts receivable, land, notes payable, common stock (shareholders equity), service revenue and operating expenses.
what is the revenue amount on the income statement? what is the operating expenses on the income statement? what is the net income on the income statement?
is there a beginning retained earnings balance?
on the statement of retained earnings, what is the net income,
dividends and ending retained earnings?
on the balance sheet : what are the cash assets, account receivable assets and land asset? what is the total in assets? what is the liability amount for notes payable? for equity, what is the amount of common stock? what is the amount of retained earnings? what is the total liability and equity?
In: Accounting
Explain the usefulness of a flexible budget in specific business cases. Give a real example of a flexible budget in an organization
In: Accounting
Use the following data to prepare a common-size comparative income statement for Old Mill Corporation on December 31, 2016. Round percentages to one-tenth percent.
2016 |
2015 |
|
Net sales |
$1,151,000 |
$1,350,000 |
Expenses: |
||
Cost of goods sold |
$980,000 |
$860,000 |
Selling and general expenses |
290,000 |
230,000 |
Interest expense |
59,000 |
59,000 |
Income tax expense |
71,000 |
53,000 |
Total expenses |
$1,400,000 |
$1,202,000 |
Net income |
$110,000 |
$148,000 |
In: Accounting
Exercise 19-19 EPS; stock dividend; nonconvertible preferred stock; treasury shares; shares sold; stock options; convertible bonds [LO19-5,19-6, 19-7, 19-8, 19-9] On December 31, 2017, Berclair Inc. had 480 million shares of common stock and 5 million shares of 9%, $100 par value cumulative preferred stock issued and outstanding. On March 1, 2018, Berclair purchased 24 million shares of its common stock as treasury stock. Berclair issued a 5% common stock dividend on July 1, 2018. Four million treasury shares were sold on October 1. Net income for the year ended December 31, 2018, was $750 million. The income tax rate is 40%. Also outstanding at December 31 were incentive stock options granted to key executives on September 13, 2013. The options are exercisable as of September 13, 2017, for 30 million common shares at an exercise price of $56 per share. During 2018, the market price of the common shares averaged $70 per share. In 2014, $62.5 million of 8% bonds, convertible into 6 million common shares, were issued at face value. Required: Compute Berclair’s basic and diluted earnings per share for the year ended December 31, 2018(Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)
In: Accounting