DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

Required:

1-a. Compute the throughput time for each month.

1-b. Compute the delivery cycle time for each month.

1-c. Compute the manufacturing cycle efficiency (MCE) for each month.

2. Evaluate the company’s performance over the last four months.

3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.

3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.

Due to a recession, expected inflation this year is only 4.75%. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 4.75%. Assume that the expectations theory holds and the real risk-free rate (r*) is 3.5%. If the yield on 3-year Treasury bonds equals the 1-year yield plus 1.0%, what inflation rate is expected after Year 1? Round your answer to two decimal places.

The ledger of Cheyenne Corp. on March 31 of the current year includes the selected accounts, shown below, before quarterly adjusting entries have been prepared.

An analysis of the accounts shows the following.

Prepare the adjusting entries at March 31, assuming that adjusting entries are made quarterly. Additional accounts are Depreciation Expense, Insurance Expense, Interest Payable, and Supplies Expense. (Credit account titles are automatically indented when the amount is entered. Do not indent manually.)

Mason Corporation began operations at the beginning of the current year. One of the company’s products, a refrigeration element, sells for $195 per unit. Information related to the current year’s activities follows.

Variable costs per unit:

Direct material $ 20

Direct labor 36

Manufacturing overhead 46

Annual fixed costs:

Manufacturing overhead $ 600,000

Selling and administrative 860,000

Production and sales activity:

Production (units) 24,000

Sales (units) 20,000 ________________________________________

Mason carries its finished goods inventory at the average unit cost of production and is subject to a 30 percent income tax rate. There was no work in process at year-end.

1. Determine the cost of the December 31 finished goods inventory.

2. Compute Mason’s net income for the current year ended December 31

. 3. If next year’s production decreases to 23,000 units and general cost behavior patterns do not change, what is the likely effect on:

a. The direct-labor cost of $36 per unit? • No change • Increase • Decrease

b. The fixed manufacturing overhead cost of $600,000? • No change • Increase • Decrease

c. The fixed selling and administrative cost of $860,000? • No change • Increase • Decrease

d. The average unit cost of production? • No change • Increase • Decreas

A stock costs $80 and pays a $4 dividend each year for three years.

a) If an investor buys the stock for $80 and expects to sell it for $100 after three years, what is the anticipated annual rate of return?

b) What would be the rate of return if the purchase price were $60?

c) What would be the rate of return if the dividend were $1 annually and the purchase price were $80 and the sale price were $100?

Please show how to solve within excel and provide formulas. Thank you.

1A)) A company wants to have $20,000 at the end of a ten-year period by investing a single sum now. How much needs to be invested in order to have the desired sum in ten years, if the money can be invested at 12%? (Ignore income taxes.)

Multiple Choice

• $7,720 A

• $3,539.82 B

• $3,254.68 C

• $6,440 D

1B)) The management of L Corporation is considering a project that would require an investment of $285,000 and would last for 6 years. The annual net operating income from the project would be $115,000, which includes depreciation of $16,000. The cash inflows occur evenly throughout the year. The payback period of the project is closest to (Ignore income taxes.):

Multiple Choice

• 2.2 years A

• 2.3 years B

• 1.9 years C

• 2.5 years D

1C)) J Corporation has gathered the following data on a proposed investment project (Ignore income taxes.):

The company uses straight-line depreciation on all equipment. Assume cash flows occur uniformly throughout a year except for the initial investment.

The simple rate of return for the investment (rounded to the nearest tenth of a percent) is:

Multiple Choice

• 26.1% A

• 17.9% B

• 12.6% C

• 31.2% D

What is the present value of a cash flow stream of $1,000 per year annually for 15 years that then grows at 2.0 percent per year forever when the discount rate is 8 percent? (Round intermediate calculations and final answer to 2 decimal places.)

Vittoria Ltd requires a Statement of Cash Flows to be prepared for the year ended

31 March 2018, the following information has been collected for this purpose.

Question 2 continued:

Additional information:

Vittoria Ltd classifies interest expense and dividends paid as cash outflows from financing activities.

Plant and equipment, with a fair value of $100 000, has been acquired by the issue of

$100 000 worth of fully paid Vittoria Ltd shares to the sellers of the plant and equipment.

During the year, equipment that originally cost $100 000 was sold for $30 000 cash.

Plant and equipment was revalued upwards by $30 000.

A long-term loan of $30 000 was specifically organised for the purchase of plant and equipment costing $30 000.  

Required:

(i) Prepare the general ledger accounts as required in the answer booklet.

(ii) Prepare a statement of cash flows for Vittoria Ltd, for the year ended 31 March 2018, in accordance with NZ IAS 7 Statement of Cash Flows. Vittoria Ltd uses the indirectmethod for the cash flows from operating activities (CFOA) section.  

(iii) Prepare a statement of cash flows for Vittoria Ltd, for the year ended 31 March 2018, in accordance with NZ IAS 7 Statement of Cash Flows. Vittoria Ltd uses the directmethod for the cash flows from operating activities (CFOA) section. Complete the necessary reconciliation, as required by NZ FRS-44, to be included in the notes.

(iv) Explain, by completing the table in the answer booklet, how your answers to (ii) and (iii) above would changeifVittoria Ltd classified interest expense paid as a cash outflow from operating activities.

(v) Vittoria Ltd has provided you with 15 types of cash inflows and cash outflows in the answer booklet and requires you to determine where they should be included in the Statement of Cash Flows in accordance with NZ IAS 7 Statement of Cash Flows. AssumeVittoria Ltd uses the direct method for CFOA.  Hint: Remember certain cash flows have a choice of classification; for these particular cash flows highlight the two choices available.

CFOA = cash flows from operating activities, CFIA = cash flows from investing activities and CFFA = cash flows from financing activities.                                                                                                    

$1 is paid at the end of every year for 50 years. Assume an interest rate of 5% unless otherwise noted.

3. Calculate the value of the annuity at t = 25 using the following methods:

1. Sum up the value of each individual payment

2. Use the annuity formulas

3. Use the excel formulas

4. Accumulate the value from part 1.1

5. Present value the value from part 2.1

For 4, part 1.1 gives total present value of $18.2559. And for 5, part 2.1 gives the total accumulated value of 209.3480 at t = 50.

Do this in excels please. And please show the equation that you using with the instructions given.