14. Keller Construction is considering two new investments. Project E calls for the purchase of earthmoving equipment. Project H represents an investment in a hydraulic lift. Keller wishes to use a net present value profile in comparing the projects. The investment and cash flow patterns are as follows: Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods.

a. Determine the net present value of the projects based on a zero percent discount rate.

b. Determine the net present value of the projects based on a discount rate of 11 percent. (Do not round intermediate calculations and round your answers to 2 decimal places.)

c. If the projects are not mutually exclusive, which project(s) would you accept if the discount rate is 11 percent?

1. What kind of Business problem does 0x( Blockchain solution) solving?  

The following transactions and events took place at MRI Company during its recent calendar-year reporting period.

1. In September 2011, MRI sold $140,000 of merchandise covered by a 180-day warranty. Prior experience shows that costs of the warranty equal 5% of sales. Compute September’s warranty expense and prepare the adjusting journal entry for the warranty.
2. On October 12, 2011, MRI arranged with a supplier to replace MRI’s overdue $10,000 account payable by paying $2,500 cash and signing a note for the remainder.  The note matures in 90 days and has a 12% interest rate.  Prepare the entries recorded on October 12, December 31, and January 10, 2010 related to this transaction.
3. For this calendar year, MRI’s net income is $1,000,000, its interest expense is $275,000, and its income taxes expense is $225,000.  Calculate the Times Interest Earned Ratio. How would you assess the credit risk of this company?

Riverbed Corp operates in the province of Ontario and sells merchandise on which HST must be charged at a rate of 13%. Riverbed uses a perpetual inventory system and has a calendar year end.
Transactions for the business for the month of March are shown below:

1) Prepare the journal entries to record the March transactions of Riverbed Corp.

2) Repeat part (a) assuming that Riverbed now operates in the province of Manitoba where PST is charged at the rate of 8% and GST is at the rate of 5%. Also assume that Riverbed has a perpetual inventory system

SSG Cycles manufactures and distributes motorcycle parts and supplies. Employees are offered a variety of share-based compensation plans. Under its nonqualified stock option plan, SSG granted options to key officers on January 1, 2018. The options permit holders to acquire 7 million of the company’s $1 par common shares for $27 within the next six years, but not before January 1, 2021 (the vesting date). The market price of the shares on the date of grant is $29 per share. The fair value of the 7 million options, estimated by an appropriate option pricing model, is $8.1 per option.

Required: 1. Determine the total compensation cost pertaining to the incentive stock option plan. 2. & 3. Prepare the appropriate journal entries to record compensation expense on December 31, 2018, 2019, and 2020. Record the exercise of the options if all of the options are exercised on May 11, 2022, when the market price is $30 per share.

Chuck Wagon Grills, Inc., makes a single product—a handmade specialty barbecue grill that it sells for $200. Data for last year’s operations follow:

Required:

1. Assume that the company uses variable costing. Compute the unit product cost for one barbecue grill.

2. Assume that the company uses variable costing. Prepare a contribution format income statement for last year.

3. What is the company’s break-even point in terms of the number of barbecue grills sold?

In order to get a good rating, please explain how you arrived at each answer. Thank you.

P. 9-1

Enterprise funds are accounted for like comparable businesses; nevertheless, they have their quirks.

The Green Hills Water District was established on January 1 to provide water service to a suburban development. It accounts for its operations in a single enterprise fund. During the year it engaged in the following transactions:

1. It issued $6,000,000 of revenue bonds.
2. For $4,500,000, it purchased the plant and equipment of the private water company that previously served the area.
3. It incurred $500,000 in costs to improve and expand its plant and equipment.
4. It billed customers for $1.8 million, of which it collected $1.5 million.
5. It billed and collected $200,000 in tap connection fees from developers. The actual cost of the hookups (paid in cash) was $140,000.
6. It incurred the following operating costs (all paid in cash):

• Purchases of water, $850,000
• Labor and contract services, $320,000
• Interest, $80,00
• Supplies and miscellaneous, $60,000

7. It recognized depreciation of $350,000 on its capital assets.

1. Prepare journal entries to record the transactions.
2. Prepare a year-end statement of revenues, expenses, and changes in net position.
3. Prepare a year-end balance sheet.
4. In some jurisdictions, water districts may account for their operations entirely in an enterprise fund or in several funds, as if they were full-service governments. If a water district chose the latter, then it would report all revenues and operating expenditures in its general fund, and it would maintain other funds as appropriate. Describe briefly how the financial statements of the Green Hills Water District would differ if it chose to prepare its financial statements as if it were a full-service government. Be specific (note changes in capital assets, long-term debt, etc.).

ACC 154- Managerial Accounting

Cost-Volume-Profit Analysis Excel Assignment

Introduction:

Congratulations! You have finally been promoted to the position of Division Manager with your long time employer Solar Co., a manufacturer of solar panels.  It is now your responsibility to take the lead for corporate planning, analysis and oversight of the company’s soleproduct- solar panels. Much of the company’s future success or failure rides with your insight and leadership.  

Your analysis for the coming year is extremely challenging given current economic conditions, random government programs and competition from lower cost non-U.S. manufacturers.  You will be required to forecast changes in the company’s fixed and variable costs for 2019 to determine its break even point, and then proceed to completing its Master Budget for 2016 based upon these forecasts.

As a wholly owned subsidiary of a large diversified company, management is under pressure to deliver an increase of 8 % over 2018’s Income Before Taxes.

Situation as of Year-End 2018:

Sales Price:  1 (one) Solar Panel sells for $400.

Sales Volume: 200,000 Solar Panels were sold this past year.

Current capacity: 220,000 units (there is no plan (or budget) to expand operating capacity for 2018)

Fixed Costs:

            ManufacturingOverhead:

                        Facility Rent:$400,000

Management Salaries: $1,200,000

Depreciation, machinery: $40,000

                        Maintenance and repair:  $60,000

                        Other overhead expenses:  $24,000

Selling and Administrative Costs:

Taxes and insurance:  $600,000

Sales salaries:  $180,000

Variable Costs:

Manufacturing Costs:

                        Materials: $180 per Solar Panel

                        Labor:$70 per Solar Panel

                        Employee Benefits: $20 per Solar Panel

                        Utilities:  $5 per Solar Panel

Selling and Administrative Costs:

Delivery expenses:  $60 per Solar Panel

Sales commissions:  $15 per Solar Panel

You have pondered the future for Solar Co. and have identified three very possible scenarios in which your company may have to operate:

Scenario 1:  The government institutes a program to support wind power that makes wind power relatively less expensive than other sources of energy.

Scenario 2:  One of raw materials used to make a solar panel increases dramatically forcing Solar Co. to increase their selling price per unit.

Scenario 3:  The “go green” mantra catches on (supported by government consumer tax credits) increasing demand for the company’s solar panels.

REQUIRED: Cost-Volume-Profit Analysis Current vs Projected

1.  2018 CVP:Using the Excel spreadsheet file perform the following calculations using the information as of the end of 2018:

(8 Points)

1. Contribution Margin
2. Break Even in Units
3. Break Even in Dollars
4. Total Sales
5. Income Before Taxes
6. Margin of Safety in Dollars
7. Margin of Safety in Units
8. Degree of Operating Leverage

2. Projected 2019 CVP:Selectone of the three scenarios on the previous page and then provide the following projected calculations for 2019:

(8 Points)

1. Contribution Margin
2. Break Even in Units
3. Break Even in Dollars
4. Total Sales
5. Income Before Taxes
6. Margin of Safety in Dollars
7. Margin of Safety in Units
8. Degree of Operating Leverage
   
   
   
   
   

Cortez Company is planning to introduce a new product that will sell for $107 per unit. The following manufacturing cost estimates have been made on 20,000 units to be produced the first year: Direct materials $ 800,000 Direct labor 640,000 (= $16 per hour × 40,000 hours) Manufacturing overhead costs have not yet been estimated for the new product, but monthly data on total production and overhead costs for the past 24 months have been analyzed using simple linear regression. The following results were derived from the simple regression and provide the basis for overhead cost estimates for the new product. Simple Regression Analysis Results Dependent variable—Factory overhead costs Independent variable—Direct labor-hours Computed values Intercept $ 110,000 Coefficient on independent variable $ 5.00 Coefficient of correlation .916 R2 .839 Required: a. What percentage of the variation in overhead costs is explained by the independent variable? 83.90% 92.30% 100.70% 75.50% None of the above b. What is the total overhead cost for an estimated activity level of 60,000 direct labor-hours? $410,000 $420,000 $400,000 $430,000 None of the above c. How much is the variable manufacturing cost per unit, using the variable overhead estimated by the regression (assuming that direct materials and direct labor are variable costs)? $82.00 $90.00 $98.00 $74.00 None of the above d. What is the expected contribution margin per unit to be earned during the first year on 20,000 units of the new product? (Assume that all marketing and administrative costs are fixed.) $25.00 $28.00 $30.00 $23.00 None of the above e. What is the manufacturing cost equation implied by these results? Total cost = $640,000 + ($5.00 × Number of units) Total cost = $110,000 + ($107.00 × Number of units) Total cost = $110,000 + ($16.00 × Number of units) None of the above Next Visit question mapQuestion 3 of 5 Total3 of 5

if a person has 0 withholding allowances do they still get a withholding subtracted from their paycheck?

Common-Sized Income Statement

Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages.

a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive numbers.

b. The company is managing the cost of manufacturing product   than the industry, and has slightly   selling and administrative expenses relative to the industry. The combined impact causes net income as a percent of sales to be   than the industry average.

Income statements and balance sheets data for Virtual Gaming Systems are provided below.

Required:

1. Calculate the following risk ratios for 2018 and 2019: (Round your answers to 1 decimal place.)

Receivables turnover ratio,Inventory turnover ration, Current ration and Debt to equity ratio.

2. Calculate the following profitability ratios for 2018 and 2019: (Round your answers to 1 decimal place.)

Gross profit ratio, Return on assets, Profit margin and Asset turnover

The Directors of Lolipop Ltd are currently considering two mutually exclusive investment projects. Both projects are concerned with the purchase of new plant. The following data are available for each project

Project A Project B

$'m

Cost( immediate outlay ) 100 60

Expected annual net profit (loss)

Year 1 29 18

Year 2 (1) (2)

Year 3 2 4

Estimated residual value of the plant 7 6

The minimum expected return by the shareholders is 10%. the Industrial average cost of capital is 12%. The company uses the straight line method of depreciation for all non-current (fixed )assets when calculating profit. Neither project would increase the working capital of the business. The business has sufficient funds to meet all capital expenditure requirements . The company expects to pay a total constant dividend of $ million per year for the next three ( 3) years.

Required

a) Calculate for each project

1. Accounting Rate of Return

2. The PayBack period

3. The NPV

4. The approximate IRR

Advise the directors which project should be undertaken

b) State which method of investment appraisal in (a) above you consider to b e most appropriate for calculating investment projects and why

c) Explain three (3) factors that may affect the dividend policy of Lolipop Ltd

Suppose that you are the manager of a local deli. Give an example of each of the following decisions that you might have to make and identify three factors that would be relevant to each decision:

1. Special order.
2. Make or buy.
3. Keep or drop.

1.  XYZ Company, a manufacturer of computer peripheries, assembles a particular product line at a wholly owned facility in Singapore. The product is designed at XYZ’s headquarters in the United States, but the different components used in the assembly process are manufactured throughout Asia and shipped to Singapore for final assembly. Some of the components are manufactured in multiple locations, so the customer can actually designate where XYZ should source the components. The final product is assembled in Singapore and then shipped via Emery Freight to customers throughout Asia. XYZ Singapore does not buy any components from the United States, but it invoices all of the components purchased from Asian suppliers in U.S. dollars. In addition, it sells the product to Asian customers in U.S. dollars. However, all of its expenses in Singapore are paid in Singapore dollars. Most of the key marketing decisions are made by the U.S. marketing staff, although the Singapore staff acts as a liaison with Emery Freight personnel and deals with the local workers, most of whom come from Sri Lanka on short-term work visas.

     XYZ prefers to translate the results of their Singapore subsidiary into dollars using the current rate method. What is the advantage to XYZ of using the current rate method? As their auditor, what do you think of their decision? If their decision is wrong and they should be using the temporal method, is it possible for them to change?