A leading manufacturing company has 2 main product lines, Traditional and Modern with unit sales prices for $340 and $440 respectively. Manufacturing overhead are applied as $544.025 per direct labor hour.
|
Traditional |
Modern |
Total |
|
|
Sales in units |
10000 |
10000 |
20000 |
|
Beginning finished goods |
$ 480,000.00 |
$ 600,000.00 |
$ 1,080,000.00 |
|
Direct Material |
$ 2,000,000.00 |
$ 3,500,000.00 |
$ 5,500,000.00 |
|
Direct Labor |
$ 370,370.00 |
$ 185,186.00 |
$ 555,556.00 |
|
Ending Finished Goods |
$ 480,000.00 |
$ 600,000.00 |
$ 1,080,000.00 |
|
Overhead breakdown in percentage |
|
|
Machining |
52.02% |
|
Assembly |
26.59% |
|
Material Handling |
6.94% |
|
Inspection |
14.45% |
|
Total |
100.00% |
|
Products |
||
|
Cost Pool for 2018 |
Traditional |
Modern |
|
Direct Labor Hours |
2000 |
1000 |
|
Machine Hours |
30000 |
60000 |
|
Assembly Hours |
12000 |
11000 |
|
Material Handling Parts |
10 |
20 |
|
Inspection Hours |
1000 |
1500 |
|
Projections 2019 |
Products |
|
|
Ending Inventory in Dollars |
$ 260,000.00 |
$ 440,000.00 |
|
Sales in Units |
10200 |
9800 |
Material, Labors and overhead are expected to increase by 10% each in 2019
Unit sales prices for both products are expected to increase by $10 each in 2019
Percentage of overhead remains the same in 2019.
The cost drivers units are staying the same in 2019.
There are two clients with special orders for Traditional. The two clients ordered the same number of units.
You tracked their COGS by their extra number of specifications per month in 2018.
|
Client one in 2018 |
# of specifications |
COGS |
|
Jan |
85 |
$ 45,000.00 |
|
Feb |
65 |
$ 32,000.00 |
|
Mar |
110 |
$ 55,000.00 |
|
Apr |
160 |
$ 78,000.00 |
|
May |
65 |
$ 36,000.00 |
|
Jun |
37 |
$ 34,000.00 |
|
Jul |
29 |
$ 19,000.00 |
|
Aug |
37 |
$ 21,000.00 |
|
Sep |
68 |
$ 39,000.00 |
|
Oct |
81 |
$ 51,000.00 |
|
Nov |
48 |
$ 36,000.00 |
|
Dec |
124 |
$ 74,000.00 |
|
Total |
909 |
$ 520,000.00 |
|
Client two in 2018 |
# of specifications |
COGS |
|
Jan |
75 |
$ 25,000.00 |
|
Feb |
55 |
$ 15,000.00 |
|
Mar |
120 |
$ 45,000.00 |
|
Apr |
150 |
$ 60,000.00 |
|
May |
55 |
$ 30,000.00 |
|
Jun |
34 |
$ 25,000.00 |
|
Jul |
27 |
$ 15,000.00 |
|
Aug |
33 |
$ 20,000.00 |
|
Sep |
61 |
$ 35,000.00 |
|
Oct |
77 |
$ 45,000.00 |
|
Nov |
42 |
$ 25,000.00 |
|
Dec |
116 |
$ 60,000.00 |
|
Total |
845 |
$ 400,000.00 |
Calculate the fixed cost and variable cost components of COGS for the two clients using the lease squares regression method. Show your work and write out the regression model equations for each client.
Discuss the two clients COGS in terms of fixed cost and variable cost according to special specifications.
In: Operations Management
Construct and Interpret a Product Profitability Report, Allocating Selling and Administrative Expenses
Naper Inc. manufactures power equipment. Naper has two primary
products—generators and air compressors. The following report was
prepared by the controller for Naper's senior marketing management
for the year ended December 31:
| Generators | Air Compressors | Total | |||||
| Revenue | $4,200,000 | $3,000,000 | $7,200,000 | ||||
| Cost of goods sold | 2,940,000 | 2,100,000 | 5,040,000 | ||||
| Gross profit | $1,260,000 | $900,000 | $2,160,000 | ||||
| Selling and administrative expenses | 610,000 | ||||||
| Income from operations | $1,550,000 | ||||||
The marketing management team was concerned that the selling and administrative expenses were not traced to the products. Marketing management believed that some products consumed larger amounts of selling and administrative expense than did other products. To verify this, the controller was asked to prepare a complete product profitability report, using activity-based costing.
The controller determined that selling and administrative
expenses consisted of two activities: sales order processing and
post-sale customer service. The controller was able to determine
the activity base and activity rate for each activity, as
follows:
| Activity | Activity Base | Activity Rate | ||
| Sales order processing | Sales orders | $65 | per sales order | |
| Post-sale customer service | Service requests | $200 | per customer service request | |
The controller determined the following activity-base usage
information about each product:
| Generators | Air Compressors | |||
| Number of sales orders | 3,000 | 4,000 | ||
| Number of service requests | 225 | 550 | ||
a. Determine the activity cost of each product for sales order processing and post-sale customer service activities.
| Sales Order Processing Activities Cost |
Post-sale Customer Service Activities Cost |
||
| Generators | $ | $ | |
| Air Compressors | |||
| Total | $ | $ |
Feedback
a. Calculate for each product:
Activity-Base Usage x Activity Rate = Activity Cost. Add both costs
to obtain the total for each activity.
Learning Objective 5.
b. Use the information in (a) to prepare a complete product profitability report dated for the year ended December 31. Calculate the gross profit to sales and the income from operations to sales percentages for each product. Round percentages to two decimal places. Enter all amounts as positive numbers.
| Naper Inc. | |||
| Product Profitability Report | |||
| For the Year Ended December 31 | |||
| Generators | Air Compressors | Total | |
| Revenues | $ | $ | $ |
| Cost of goods sold | |||
| Gross profit | $ | $ | $ |
| Sales order processing | $ | $ | $ |
| Post-sale customer service | |||
| Total selling and administrative expense | $ | $ | $ |
| Income from operations | $ | $ | $ |
| Gross profit as a percentage of sales | % | % | |
| Income from operations as a percentage of sales | |||
In: Accounting
Cuneo Company’s income statements for the last 3 years are as follows:
|
Cuneo Company |
|
Income Statements |
|
For the Years 1, 2, and 3 |
|
1 |
Year 1 |
Year 2 |
Year 3 |
|
|
2 |
Sales |
$1,000,000.00 |
$1,200,000.00 |
$1,700,000.00 |
|
3 |
Less: Cost of goods sold |
(700,000.00) |
(700,000.00) |
(1,000,000.00) |
|
4 |
Gross margin |
$300,000.00 |
$500,000.00 |
$700,000.00 |
|
5 |
Less operating expenses: |
|||
|
6 |
Selling expenses |
(150,000.00) |
(220,000.00) |
(250,000.00) |
|
7 |
Administrative expenses |
(50,000.00) |
(60,000.00) |
(120,000.00) |
|
8 |
Operating income |
$100,000.00 |
$220,000.00 |
$330,000.00 |
|
9 |
Less: |
|||
|
10 |
Interest expense |
(25,000.00) |
(25,000.00) |
(25,000.00) |
|
11 |
Income before taxes |
$75,000.00 |
$195,000.00 |
$305,000.00 |
| Required: | |
| 1. | Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) |
| 2. | Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) |
Labels and Amount Descriptions
Refer to the list below for the exact wording of an account title within your income statement.
| Labels | |
| Add | |
| Add operating expenses | |
| Less | |
| Less operating expenses | |
| Amount Descriptions | |
| Administrative expenses | |
| Contribution margin | |
| Cost of goods sold | |
| Gross margin | |
| Income after taxes | |
| Income before taxes | |
| Interest expense | |
| Operating income | |
| Sales | |
| Selling expenses | |
| Total |
Common-Size Income Statement
1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 2 |
|
1 |
Year 2 |
Percent of Year 1 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 3 |
|
1 |
Year 3 |
Percent of Year 1 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
In: Accounting
Use the following information for Delta Corporation to answer question 1: (20 marks total)
|
Year |
20X1 |
20X2 |
|
Net sales |
$1,500,000 |
$1,656,598 |
|
Cost of goods sold |
675,000 |
745,469 |
|
Depreciation |
270,000 |
298,188 |
|
Interest paid |
43,600 |
44,000 |
|
Cash |
127,500 |
140,811 |
|
Accounts receivable |
450,000 |
496,980 |
|
Inventory |
525,000 |
579,809 |
|
Net fixed assets |
1,800,000 |
1,987,918 |
|
Accounts payable |
375,000 |
414,150 |
|
Notes payable |
45,000 |
50,000 |
|
Long-term debt |
500,000 |
500,000 |
|
Common stock |
1,000,000 |
1,000,000 |
|
Retained earnings |
982,500 |
1,241,368 |
|
Tax rate |
35% |
35% |
|
Dividend payout |
30% |
30% |
1. Delta has 600,000 common shares outstanding. The firm is projecting a 20% increase in net sales for the coming year (20X3). Delta uses the percentage of sales approach to plan for its financing needs. In using this approach, the firm assumes that cost of goods sold, all assets (current and fixed), and accounts payable will all remain a constant percentage of sales. Depreciation expense is assumed to be 15% of net fixed assets, while notes payable and long-term debt will remain at the same level as 20X2. The interest rate charged on notes payable and long-term debt is also expected to remain the same. The firm will aim to maintain its dividend payout of 30% for the foreseeable future.
a. Construct the pro-forma Statement of Comprehensive Income and Statement of Financial Position for Delta Corporation for 20X3. Calculate the external financing needed (EFN) for 20X3. Round all your numbers in the pro-forma statements to the nearest dollar.
b. Based on its 20X2 information, what is Delta’s capital intensity ratio? Round your answer to four decimal places. (1 mark)
c. What is Delta’s full capacity sales if it is currently operating at 80% capacity (20X2)? Round your answer to the nearest integer. (1 mark)
d. Recalculate the firm’s external financing needed (EFN) for 20X3 if Delta is only operating at 80% capacity. Assume that if the 20X3 net sales is lower than full capacity sales, then the net fixed assets in 20X3 will be the same as the net fixed assets in 20X2 (i.e., assume that the firm will purchase just enough fixed assets to cover depreciation expense for 20X3). Interpret this EFN number.
e. What is Delta’s internal growth rate for 20X2? Round your final answer in percentage to two decimal places.
f. What is Delta’s sustainable growth rate for 20X2? Round your final answer in percentage to two decimal places.
g. Assume that Delta is operating at 100% capacity. Calculate the EFN for the firm if it wants to grow its sales by 100% for 20X3. Interpret this EFN number.
In: Accounting
1) What is the fixed cost, marginal cost, average total cost, average variable cost and average fixed cost of the following cost function? .
2) What is the level of output that minimizes AVC? (in other words, what is the level of output that corresponds to the minimum of AVC?)
In: Economics
What are cost drivers? How do cost drivers relate to cost pools? What are some cost pools? Name two or three different cost drivers for each of these cost pools.
What are value-added processes? How do you determine if a process adds value? How does identifying value-added processes help a company run more efficiently and effectively?
In: Accounting
In: Economics
Calculate the peak cooling load from an EAST facing wall. No interior or exterior shades, no floor carpeting , medium construction
Windows: ¼ in double glass with air gap and aluminum frame
Window area = 300 ft2
Wall: 4-in Concrete + R-5 Insulation+ ½ in. gypsum wall board
Gross Wall Area = 1200 ft2
Location: Miami, Florida
Indoor Temperature = 70 oF
In: Mechanical Engineering
Examine the competitiveness of your firm’s home country in a particular sector(eg Oil and Gas, Construction etc) in the light of Porter's Diamond Model. Identify a specific cluster (a city or region) in the home country where chosen industry is competitive and give your recommendation to further improve the competitiveness of that cluster by benchmarking with one of the best clusters (Stuttgart, Germany for Automotive cluster) in the world for same industry
In: Economics
Which of the following situations would most likely be resolved in a correspondence audit?
A. verification of a taxpayer's qualifications for the EITC
B. The determination whether 23 of a construction company's workers are employees or independent contractors
C. Whether a particular transaction resulted in capital gain or ordinary income
D. Review of all tax records of an S Corporation (sales of $20 million and 40 employees) for the past three years
In: Accounting