Mango & Associates expects the below departments to make the following income for the upcoming year. Dept. M Dept. N Dept. O Dept. P Dept. T Total Sales $ 67,000 $ 37,000 $ 60,000 $ 46,000 $ 32,000 $ 242,000 Expenses Avoidable 11,800 38,800 23,600 16,000 41,400 $ 131,600 Unavoidable 53,400 15,000 4,600 31,800 12,600 $ 117,400 Total expenses 65,200 53,800 28,200 47,800 54,000 249,000 Net income (loss) $ 1,800 $ (16,800 ) $ 31,800 $ (1,800 ) $ (22,000 ) $ (7,000 ) Recompute & prepare departmental income statements (which should include a combined total column) for Mango & Associates taking each of the following separate scenarios into consideration. Part 1 Mango & Associates' management decided to get rid of departments with expected net losses. Part 2 Mango & Associates' management decided to get rid of departments with sales dollars that are less than avoidable expenses.

What is the duration of a 10-year bond with a coupon rate of 6%, paid annually, and a yield to maturity of 11%?

On January 1, Year 1, a contractor agrees to build on the customer’s land a bridge that is expected to be completed at the end of Year 3. The bridge is a single performance obligation to be satisfied over time. The contractor determines that the progress toward completion of the bridge is reasonably measurable using the input method based on costs incurred. The contract price is $4,000,000, and initial expected total costs of the project are $2,400,000.

^ this is the question form the professor and I did the answers for year 1-2-3 :

Year 1
By the end of Year 1, 25% [$600,000 ÷ ($600,000 + $1,800,000)] of the total expected costs have been incurred. Using the input method based on costs incurred, the contractor recognizes 25% of the total expected revenue ($4,000,000 contract price × 25% ) = $1,000,000 and cost of goods sold $2,400,000.× 25%) = $600,000. The difference between these amounts is the gross profit for Year 1.

Revenue $1,000,000, Cost of goods sold $600,000 , Gross profit (1,000,000 – 600,000) =$400,000. The gross profit in Year 1 of $400,000 also may be calculated as total expected gross profit from the project of $1,600,000 ($4,000,000 - $2,400,000) times the progress toward completion of the contract of 25%.

Year 2
By the end of Year 2, total costs incurred are $1,800,000 ($600,000+ $1,200,000). Given that $1,200,000 is expected to be incurred in the future, the total expected cost is $3,000,000 ($1,800,000 + $1,200,000). The change in the total cost of the contract must be accounted for prospectively. By the end of Year 2, 60% ($1,800,000 ÷ $3,000,000) of expected costs have been incurred.
Thus, $2,400,000 ($4,000,000 × 60%) of cumulative revenue and $1,800,000 ($ 3,000,000 × 60%) of cumulative cost of goods sold should be recognized for Years 1 and 2.
Because $1,000,000 of revenue and $600,000 of cost of goods sold were recognized in Year 1, revenue of $1,400,000 ($2,400,000 cumulative revenue - $1,000,000) and cost of goods sold of $1,200,000 ($1,800,000 cumulative cost of goods sold - $600,000) are recognized in Year 2.
Revenue
$1,400,000
Cost of goods sold
1,200,000
Gross profit -- Year 2
$200,000*
* The gross profit in Year 2 of $200,000 also may be calculated as the cumulative gross profit for Years 1 and 2 of $600,000 [($4,000,000 - $3,000,000) × 60%] minus the gross profit recognized in Year 1 of $400,000.

Year 3
At the end of Year 3, the project is completed, and the total costs incurred for the contract are $2,900,000 ($600,000 + $1,200,000 + $1,100,000). Given $2,400,000 of cumulative revenue and $1,800,000 of cumulative cost of goods sold for Years 1 and 2, $1,600,000 ($4,000,000 contract price - $2,400,000) of revenue and $1,100,000 ($2,900,000 total costs - $1,800,000) of cost of goods sold are recognized in Year 3.

Revenue
$1,600,000
Cost of goods sold
1,100,000
Gross profit -- Year 3
$500,000
NOTE: (1) The total gross profit from the project of $550,000 ($400,000 + $200,000 + $500,000) equals the contract price of $4,000,000 minus the total costs incurred of $2,900,000. (2) When progress toward completion is measured using the cost-to-cost method, as in the example above, the cost of goods sold recognized for the period equals the costs incurred during that period.

NOW : I need the answer for this question:

An entity may not be able to estimate the degree of completion of a project at the end of the first year, perhaps because this is the first time such a project has been undertaken by the firm. In that case, how much revenue would the firm recognize in that year if significant costs have been incurred in the construction process?

The Aluminum Association reports that the average American uses 56.8 pounds of aluminum in a year. A random sample of 50 households is monitored for one year to determine aluminum usage. If the population standard deviation of annual usage is 12.4 pounds, what is the probability that the sample mean will be each of the following?

a. More than 59 pounds

b. More than 57 pounds

c. Between 56 and 57 pounds

d. Less than 53 pounds

e. Less than 48 pounds

(Round the values of z to 2 decimal places. Round your answers to 4 decimal places.)

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.