Explain the differences between identification, authentication, and authorization.

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
   
   
   
   
   

Do you think the numerous state agencies in Texas reflect democracy in action, or do they work against the ideal of democracy? Give reasons for your answer.

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

Prepare a summary report of Migros Ticaret A.Ş. retail company which will open new stores in Bulgaria consisting of the following components .

1. An overview of economic conditions that might affect start-up costs and financing alternatives for the proposed global business enterprise.
2. A description (and estimate of amounts) of the necessary start-up costs.
3. A synopsis of financing alternatives that might be used in this situation.
4. Recommend actions that might be taken to obtain financing for the proposed global business enterprise.  Provide evidence to support your recommendations.

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

I'm working with using recursion to find the sum and the min of these two arrays respectively. So far what I have gives the correct answers when they run, however when I use a test code on them they fail because they cannot handle out of bounds points, for example if int[] sumMe = { } or if the position is set to the last number "89" in the array. I kinda know what I'm supposed to tell it but not how to properly implement it, if you could help be adjust the code to catch these out of bounds instances I'd very much appreciate it.
I'll put the failed messages for each of these under the test code I put down in case it helps.


public class test {
    public static void main(String[] args) {
        int[] sumMe = { 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89 };
        System.out.printf("Array Sum: %d\n", arraySum(sumMe, 0));


        int[] minMe = { 0, 1, 1, 2, 3, 5, 8, -42, 13, 21, 34, 55, 89 };
        System.out.printf("Array Min: %d\n", arrayMin(minMe, 0));
    }
    public static long arraySum(int[] data, int position) {
        if (position <= data.length && position >= 0) {
            if (data.length - 1 == position) {
                return data[position];
            }
            else {
                return data[position] + arraySum(data, position + 1);
            }
        }
        return 0;
    }

    public static int arrayMin(int[] data, int position) {
        int min;
        int i;
        min = data[position];
        for (i = 0; i < data.length; i++) {
            if (min > data[i]) {
                min = data[i];
                arrayMin(data, i++);
            }
        }
        return min;
    }
}

Failed test in arrayMin:

java.lang.AssertionError: ArrayMin must be able to handle position of
Expected :89
Actual :1

Failed test in arraySum:

java.lang.ArrayIndexOutOfBoundsException: Index 0 out of bounds for length 0

Please I need more explanation and details for this question.

A nurse manager in an urgent care clinic must develop a weekly schedule for nursing staff. Nurses in the clinic work four days a week with three consecutive days off. The staff requirement is twenty nurses each day. Solve this problem using Excel Solver.

If a temperature scale were bassed on the freezing point (5.5 degrees Celsius) and boiling point (80.1 degrees Celsius) of benzene, and the temperature difference between these two points was divided into 50 units called degrees X, what would be the freezing and boiling points of water in degrees X?

The Caribbean needs sustainable development.What is the extent to which it is feasible for the Caribbean to practice sustainable tourism?

What are the three main steps used for the recognition of egg, which contributes as a barrier to cross-species fertilization in sea urchin.

In addition to the molecular orbital treatment of H2, the ground state can be treated by the so-called valence bond (Heitler-London) approach, where individual covalent bonds are combined to form an antisymmetric wave function with spins up and down. Look up this approach and compare the results with the simple MO treatment in terms of bond energy (kJ/mol) and bond distance (pm).