Question

In: Accounting

Northern Illinois Manufacturing reported the following results from last year’s operations: Sales (1,325,000 units) $ 15,900,000...

Northern Illinois Manufacturing reported the following results from last year’s operations:

Sales (1,325,000 units)

$ 15,900,000

Variable Expenses:

   Direct Materials

1,801,800

   Direct Labor

5,450,580

   Manufacturing OH

2,053,750

   S & A

2,112,000

   Total Variable

11,418,130

Contribution Margin

4,481,870

Fixed Expenses

   Manufacturing OH

757,700

   S & A

1,136,800

   Total Fixed

1,894,500

Net Operating Income

$ 2,587,370

Total operating assets at the end of the year are $20,700,000. The total operating assets at the end of last year was $19,800,000.

The company tracks its internal business process performance and reports the following data for this year:

Inspection time

0.6 days

Wait time (from order to start of production)

14.5 days

Process time

3.7 days

Move time

1.7 days

Queue time

4.3 days

Budgeted information for Northern Illinois is based on the following information:

           

Sales – Units

1,300,000

Sales Price

$12 per unit

Direct materials

$1.50 per unit

Direct labor

$3.60 per unit

Variable OH

$1.50 per unit

Variable S & A

$1.60 per unit

Fixed OH

$750,000

Fixed S & A

$1,125,000

The following standard cost card is for the variable manufacturing for one unit of production:

Std Quantity

Std Price

Std Cost

Direct materials

2.00 lbs

0.75 per pound

1.50

Direct labor

0.20 hrs

18.00 per hour

3.60

Variable OH

1.50 per unit

1.50

During the year, the company purchased and used 2,772,000 pounds of material. The company worked 302,810 hours at a rate of $18 per hour.

The company’s minimum return is 10%.

This assignment requires several items to be completed using an Excel spreadsheet. Please prepare the items in the order given with the number of the requirement or your Excel spreadsheet.

1. Determine the ROI and RI for last year.

2. Determine last year’s throughput time, MCE, and delivery cycle time.

Please complete in excel.

Solutions

Expert Solution

1. Determine the ROI and RI for last year

Calculation of ROI (Return of Investment):

ROI = 2,587,370 / 1,98,00,000

= 13%

Calculation of RI (Residual Income):

RI = Operating Income - (Minimum required return * Operating Assets)

= 2,587,370 / (10% * 1,98,00,000)

= 607,370

B)

Determine last year’s throughput time, MCE, and delivery cycle time:

Calculation of Throughput time:

The throughput time of a product formula is calculated by adding the four steps of the manufacturing process: process time, inspection time, move time, and Queue time.

Throughput time = 3.7 days + 0.6 days + 1.7 days + 4.3 days

= 10.3 days

Calculation of MCE (Manufacturing cycle Efficiency):

Value added time as a percentage of throughput time is called manufacturing cycle efficiency.

Value Added Time = Process time

MCE = 3.7 days / 10.3 days = 36%

Calculation of Delivery Cycle time:

The amount of time from when an order is received from a customer to when the completed order is shipped is called delivery cycle time.

Delivery Cycle time = Wait time + Throughput time

= 14.5 days + 10.3 days

= 24.8 days


Related Solutions

Westerville Company reported the following results from last year’s operations:
  Westerville Company reported the following results from last year’s operations:       Sales $ 1,000,000   Variable expenses   300,000           Contribution margin   700,000     Fixed expenses   500,000           Net operating income $ 200,000           Average operating assets $ 625,000           This year, the company has a $120,000 investment opportunity with the following cost and revenue characteristics:       Sales $ 200,000     Contribution margin ratio   60 % of...
Westerville Company reported the following results from last year’s operations: Sales $ 1,500,000 Variable expenses 500,000...
Westerville Company reported the following results from last year’s operations: Sales $ 1,500,000 Variable expenses 500,000 Contribution margin 1,000,000 Fixed expenses 700,000 Net operating income $ 300,000 Average operating assets $ 1,000,000 At the beginning of this year, the company has a $200,000 investment opportunity with the following cost and revenue characteristics: Sales $ 300,000 Contribution margin ratio 60 % of sales Fixed expenses $ 132,000 The company’s minimum required rate of return is 10%. What is the residual income...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 720,000...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 720,000 Contribution margin 680,000 Fixed expenses 470,000 Net operating income $ 210,000 Average operating assets $ 875,000 At the beginning of this year, the company has a $350,000 investment opportunity with the following cost and revenue characteristics: Sales $ 560,000 Contribution margin ratio 70 % of sales Fixed expenses $ 336,000 The company’s minimum required rate of return is 15%. Required 1. What is the...
Westerville Company reported the following results from last year’s operations:   Sales $ 1,200,000       Variable expenses 420,000...
Westerville Company reported the following results from last year’s operations:   Sales $ 1,200,000       Variable expenses 420,000       Contribution margin 780,000       Fixed expenses 600,000       Net operating income $ 180,000       Average operating assets $ 600,000     This year, the company has a $137,500 investment opportunity with the following cost and revenue characteristics:   Sales $ 220,000   Contribution margin ratio 60 % of sales   Fixed expenses $ 99,000 The company’s minimum required rate of return is 20%. rev: 04_28_2016_QC_CS-49731 1. value: 1.00...
Westerville Company reported the following results from last year’s operations: Sales $ 2,300,000 Variable expenses 670,000...
Westerville Company reported the following results from last year’s operations: Sales $ 2,300,000 Variable expenses 670,000 Contribution margin 1,630,000 Fixed expenses 1,170,000 Net operating income $ 460,000 Average operating assets $ 1,437,500 At the beginning of this year, the company has a $287,500 investment opportunity with the following cost and revenue characteristics: Sales $ 460,000 Contribution margin ratio 50 % of sales Fixed expenses $ 161,000 The company’s minimum required rate of return is 15%. 6. What is the ROI...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 720,000...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 720,000 Contribution margin 680,000 Fixed expenses 470,000 Net operating income $ 210,000 Average operating assets $ 875,000 At the beginning of this year, the company has a $350,000 investment opportunity with the following cost and revenue characteristics: Sales $ 560,000 Contribution margin ratio 70 % of sales Fixed expenses $ 336,000 The company’s minimum required rate of return is 15%. 1. What is the residual...
Ch 11f Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable...
Ch 11f Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 680,000 Contribution margin 720,000 Fixed expenses 440,000 Net operating income $ 280,000 Average operating assets $ 875,000 At the beginning of this year, the company has a $300,000 investment opportunity with the following cost and revenue characteristics: Sales $ 480,000 Contribution margin ratio 80 % of sales Fixed expenses $ 336,000 The company’s minimum required rate of return is 15%. 1. What is...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 680,000...
Westerville Company reported the following results from last year’s operations: Sales $ 1,400,000 Variable expenses 680,000 Contribution margin 720,000 Fixed expenses 440,000 Net operating income $ 280,000 Average operating assets $ 875,000 At the beginning of this year, the company has a $300,000 investment opportunity with the following cost and revenue characteristics: Sales $ 480,000 Contribution margin ratio 80 % of sales Fixed expenses $ 336,000 The company’s minimum required rate of return is 15%. 1.  If the company pursues the...
Westerville Company reported the following results from last year’s operations: Sales $ 1,800,000 Variable expenses 740,000...
Westerville Company reported the following results from last year’s operations: Sales $ 1,800,000 Variable expenses 740,000 Contribution margin 1,060,000 Fixed expenses 700,000 Net operating income $ 360,000 Average operating assets $ 1,200,000 This year, the company has a $400,000 investment opportunity with the following cost and revenue characteristics: Sales $ 600,000 Contribution margin ratio 60 % of sales Fixed expenses $ 288,000 The company’s minimum required rate of return is 10%. 8. If the company pursues the investment opportunity and...
Westerville Company reported the following results from last year’s operations:   Sales $ 2,000,000       Variable expenses 640,000...
Westerville Company reported the following results from last year’s operations:   Sales $ 2,000,000       Variable expenses 640,000       Contribution margin 1,360,000       Fixed expenses 860,000       Net operating income $ 500,000       Average operating assets $ 1,250,000     This year, the company has a $250,000 investment opportunity with the following cost and revenue characteristics:   Sales $ 400,000   Contribution margin ratio 70 % of sales   Fixed expenses $ 220,000 The company’s minimum required rate of return is 10%. 6. What is the ROI...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT