Questions
A leading manufacturing company has 2 main product lines, Traditional and Modern with unit sales prices...

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...

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...

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...

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...

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...

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

Consider the following two taxes: 1) a state imposes a 10 cent tax on every gallon...

Consider the following two taxes: 1) a state imposes a 10 cent tax on every gallon of gasoline sold in the state to pay for road maintenance and improvements, and 2) a state imposes an additional 1% income tax on all state residents to pay for the construction of 50 new soccer fields throughout the state. Which of these two taxes is more consistent with the benefits-received principle? Why?

In: Economics

Calculate the peak cooling load from an EAST facing wall. No interior or exterior shades, no...

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...

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...

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