The US has threatened new trade tariffs on beer, chocolate, and olives from the European Union, as part of a long-running row over subsidies to plane maker Airbus.
The US Trade Representative said it was considering duties on 30 products worth $3.1bn (£2.5bn) in trade every year.
It has already put 15% to 25% tariffs on $7.5bn worth of other EU goods as part of the dispute.
The EU warned it would damage firms on both side of the Atlantic.
And UK Trade Minister Liz Truss said she was disappointed by the move, warning against the use of "tit-for-tat" tariffs.
The row centres on EU subsidies given to Airbus before 2004, which Washington says created an unfair advantage over the US aircraft manufacturer Boeing.
Last year, the World Trade Organization (WTO) ruled the subsidies were illegal and allowed the US to levy tariffs on EU goods, including aircraft, wines, and cheese.
But it is now considering a parallel case involving illegal support for Boeing, which could see the EU imposing duties later this year.
The US said pastry and cakes, gin, cashmere clothes and hardware products could all be in the firing line for new tariffs, affecting exporters across the continent.
In a statement the EU said Washington was going beyond what was allowed by the WTO.
"It creates uncertainty for companies and inflicts unnecessary economic damage on both sides of the Atlantic," it added.
"This is particularly the case as companies are now trying to overcome the economic difficulties in the aftermath of the Covid-19 crisis."
Questions: (Your answers should not exceed 400 words).
In: Economics
Once a pinnacle of luxury clothing found only in high-end fashion stores, by 2006 cashmere sweaters, which typically sold for hundreds of dollars, could be found in big box stores for as little as $20. The reason for this substantial price drop: increased production and competition from China. The cashmere industry has been around for centuries. Historically, however, Chinese and Mongolian herders exported the raw fiber to Europe, where it was spun and converted into clothing. Beginning in the 1980’s, China made a charge toward industrialization and the market economy. One area of rapid growth was the textile industry.
To increase production of cashmere wool, the number of wool-producing goats in Inner Mongolia, home to a vast grassland that the animals can graze on, increased tenfold, from 2.4 million in 1949 to 25.8 million in 2004. This dramatically increased the production of cashmere in China, but not without its consequences. One of the biggest problems, however, is that goats are devastating to the topsoil. The combination of pointy hooves and a voracious appetite leads to a rise in desertification. That is, turning grassland to desert. Over a 5-year period, “the Gobi Desert expanded in size by an area larger than the Netherlands.”
A consequence of this desertification is an increase in dust storms. Over the last several decades, the number and size of dust storms originating in China has grown dramatically. These storms impose a tremendous external cost on the regions through which they travel. One storm, “forced 1.8 million South Koreans to seek medical help and cost the country $7.8 billion in damage to industries such as airlines and semiconductors.” Another storm was so large it traveled around the entire world, causing damage in the US, Europe, and Africa.
In: Economics
A regression model to predict Y, the state-by-state 2005 burglary crime rate per 100,000 people, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies per 1,000 people, X3 = 2004 federal expenditures per capita, and X4 = 2005 high school graduation percentage. Predictor Coefficient Intercept 4,304.4610 AgeMed -26.903 Bankrupt 20.8921 FedSpend -0.0312 HSGrad% -29.1815 (a) Write the fitted regression equation. (Round your answers to 4 decimal places. Negative values should be indicated by a minus sign.) yˆ =_____ + _____ AgeMed + _______ Bankrupt + _____ FedSpend + ______ HSGrad%
(b-1) The 2005 state-by-state crime rate per 100,000
increases by about 27 as the state median age increases.
decreases by about 27 as the state median age increases.
(b-2) The 2005 state-by-state crime rate per 100,000
decreases by about 21 for every 1,000 new bankruptcies filed.
increases by about 21 for every 1,000 new bankruptcies filed.
(b-3) The 2005 state-by-state crime rate per 100,000
decreases by 0.0312 for each dollar increase in federal funding per person.
increases by 0.0312 for each dollar increase in federal funding per person.
(b-4) The 2005 state-by-state crime rate per 100,000
decreases by about 29 for each 1% increase in high school graduations.
increases by about 29 for each 1% increase in high school graduations.
(c) Would the intercept seem to have meaning in this regression?
Yes No
(d) Make a prediction for Burglary when X1 = 30 years, X2 = 5.0 bankruptcies per 1,000, X3 = $5,723, and X4 = 80 percent.
(Round your answers to 4 decimal places.)
Burglary Rate $_______
In: Statistics and Probability
Do a case study of Northeastern Airlines.
Northeastern Airlines is a regional airline serving nine cities in the New England states as well as cities in New York, New Jersey, and Pennsylvania. While nonstop flights are available for some of the routes, connecting flights are often necessary. Northeastern Airlines Service Area The network shows the cities served and profit in U.S. dollars per passenger along each of these routes. The routes from ?Boston-to-Providence and from Providence-to-Boston make only $ 9 per passenger profit after all expenses. To service these cities, Northeastern operates a fleet of sixteen 122-passenger Embraer E-195 jets. These jets, which were first introduced by Embraer in late 2004, have helped Northeastern Airlines remain profitable for a number of years. However, in recent years, the profit margins have been falling, and Northeastern is facing the prospect of downsizing their operations. Management at Northeastern Airlines has considered several options to reduce cost and increase profitability. Due to Federal Aviation Administration regulations, the company must continue to serve each of the nine cities. How they serve these cities, however, is up to the management at Northeastern. One suggestion has been made to provide fewer direct flights, which would mean that a city served by Northeastern might only have direct flights to one other city. The company plans to hire a marketing analytics consultant to determine how demand would be impacted by longer flights with more connections, and to forecast the demand along each of the routes based on a modified flight operations map. Before hiring the consultant, the company would like to first determine the most profitable (on a profit per passenger basis) way to continue serving all of the cities.
In: Advanced Math
A regression model to predict Y, the state-by-state 2005 burglary crime rate per 100,000 people, used the following four state predictors: X1 = median age in 2005, X2 = number of 2005 bankruptcies per 1,000 people, X3 = 2004 federal expenditures per capita, and X4 = 2005 high school graduation percentage.
| Predictor | Coefficient |
| Intercept | 4,286.0597 |
| AgeMed | -26.986 |
| Bankrupt | 18.5775 |
| FedSpend | -0.0280 |
| HSGrad% | -28.5624 |
(a) Write the fitted regression equation. (Round your answers to 4 decimal places. Negative values should be indicated by a minus sign.)
yˆy^ = + AgeMed + Bankrupt + FedSpend + HSGrad%
(b-1) The 2005 state-by-state crime rate per 100,000
| increases by about 27 as the state median age increases. | |
| decreases by about 27 as the state median age increases. |
(b-2) The 2005 state-by-state crime rate per 100,000
| decreases by about 19 for every 1,000 new bankruptcies filed. | |
| increases by about 19 for every 1,000 new bankruptcies filed. |
(b-3) The 2005 state-by-state crime rate per 100,000
| decreases by 0.028 for each dollar increase in federal funding per person. | |
| increases by 0.028 for each dollar increase in federal funding per person. |
(b-4) The 2005 state-by-state crime rate per 100,000
| decreases by about 29 for each 1% increase in high school graduations. | |
| increases by about 29 for each 1% increase in high school graduations. |
(c) Would the intercept seem to have meaning in this regression?
| No | |
| Yes |
(d) Make a prediction for Burglary when X1= 34 years, X2= 7.2 bankruptcies per 1,000, X3= $5,044, and X4= 84 percent.
Burglary Rate
rev: 09_26_2016_QC_CS-62964, 09_20_2017_QC_CS-1011
In: Statistics and Probability
China is seen as a global powerhouse in manufacturing, though the products that are made in China are often assumed to be lacking quality and creativity. Certainly, the “Made in China” label is attached to these negative assumptions. In turn, the high-volume-low-quality stigma of Chinese products is a difficult one to break. In Shanghai, however, there is a design firm that is trying to overcome the longstanding Chinese approach to mass manufacturing, and is imitating Western product design.
The introduced you to the Neri and Hu design firm, which was started in 2004 by Lyndon Neri and Rossana Hu. Both Neri and Hu were born and educated in Western countries and eventually moved to China. Their design firm is aimed at helping young designers enter the international market with new and uniquely designed products that oppose the stereotypes of being “made in China.” The ultimate goal is to show the world that China is capable of producing original ideas that are competitive in the international market.
Interestingly, toward the end of the video, Hu says, “Having a lot of international infiltration into the Chinese culture, I think that’s how China can grow into its next identity.” In Shanghai, the city where the firm is located, there has clearly been an infiltration of Western culture, with Western brands and stores. Although China is a communist country, it has embraced the free market economy. This may either strengthen or weaken the Chinese brand.
In: Operations Management
Review the income statements on the Absorption Statement and Variable Statement panels, then complete the following table. The company’s sales price per unit is $75.00, and the number of units in ending inventory is 4,000.
|
Item |
Amount |
|---|---|
|
Number of units sold |
|
|
Variable sales and administrative cost per unit |
|
|
Number of units manufactured |
|
|
Variable cost of goods manufactured per unit |
|
|
Fixed manufacturing cost per unit |
Absorption costing does not distinguish between variable and fixed costs. All manufacturing costs are included in the cost of goods sold.
|
Saxon, Inc. |
|
Absorption Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,200,000.00 |
|
|
2 |
Cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Cost of goods manufactured |
800,000.00 |
|
|
5 |
Ending inventory |
(160,000.00) |
|
|
6 |
Total cost of goods sold |
640,000.00 |
|
|
7 |
Gross profit |
$560,000.00 |
|
|
8 |
Selling and administrative expenses |
305,000.00 |
|
|
9 |
Income from operations |
$255,000.00 |
Under variable costing, the cost of goods manufactured includes only variable manufacturing costs. This type of income statement includes a computation of manufacturing margin.
|
Saxon, Inc. |
|
Variable Costing Income Statement |
|
For the Year Ended December 31 |
|
1 |
Sales |
$1,200,000.00 |
|
|
2 |
Variable cost of goods sold: |
||
|
3 |
Beginning inventory |
$0.00 |
|
|
4 |
Variable cost of goods manufactured |
560,000.00 |
|
|
5 |
Ending inventory |
(112,000.00) |
|
|
6 |
Total variable cost of goods sold |
448,000.00 |
|
|
7 |
Manufacturing margin |
$752,000.00 |
|
|
8 |
Variable selling and administrative expenses |
240,000.00 |
|
|
9 |
Contribution margin |
$512,000.00 |
|
|
10 |
Fixed costs: |
||
|
11 |
Fixed manufacturing costs |
$240,000.00 |
|
|
12 |
Fixed selling and administrative expenses |
65,000.00 |
|
|
13 |
Total fixed costs |
305,000.00 |
|
|
14 |
Income from operations |
$207,000.00 |
Whenever the units manufactured differ from the units sold, finished goods inventory is affected. In analyzing income from operations, such increases and decreases could be misinterpreted as operating efficiencies or inefficiencies. Each decision-making situation should be carefully analyzed in deciding whether absorption or variable costing reporting would be more useful.
All costs are controllable in the long run by someone within a business. For a given level of management, costs may be controllable costs or noncontrollable costs.
The production manager for Saxon, Inc. is worried because the company is not showing a high enough profit. Looking at the income statements on the Absorption Statement panel and the Variable Statement panel, he notices that the net income is higher on the absorption cost income statement. He is considering manufacturing another 10,000 units, up to the company’s capacity for manufacturing, in the coming year. He reasons that this will boost net income and satisfy the company’s owner that the company is sufficiently profitable. Although the total units manufactured changes, assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same. Complete questions (1)-(4) that follow. If the answer is zero, enter "0".
1. Use the income statements on the Absorption Statement and Variable Statement panels to complete the following table for the original production level. Then prepare similar income statements at a production level 10,000 units higher and add that information to the table. Assume that total fixed costs, unit variable costs, unit sales price, and the sales levels are the same at both production levels.
|
Income From Operations |
|||
|---|---|---|---|
|
Original |
Original |
Additional |
Additional |
|
Production |
Production |
10,000 |
10,000 |
|
Level-Absorption |
Level-Variable |
Units-Absorption |
Units-Variable |
2. What is the change in net income from producing 10,000 additional units under absorption costing?
3. What is the change in net income from producing 10,000 additional units under variable costing?
For planning and control purposes, managers often compare planned and actual contribution margin. Variable costing is used as a basis for such analyses.
Examine the following contribution margin data, and then complete the Contribution Margin Analysis panel.
|
Saxon, Inc. |
||
|
Contribution Margin Data Schedule |
||
|
Actual |
Planned |
|
|
Sales |
$1,200,000 |
$1,190,000 |
|
Variable cost of goods sold |
$448,000 |
$462,000 |
|
Variable selling and administrative expenses |
240,000 |
154,000 |
|
Total |
$688,000 |
$616,000 |
|
Contribution margin |
$512,000 |
$574,000 |
|
Number of units sold |
16,000 |
14,000 |
|
Per unit: |
||
|
Sales price |
$75.00 |
$85.00 |
|
Variable cost of goods sold |
28.00 |
33.00 |
|
Variable selling and administrative expenses |
15.00 |
11.00 |
Contribution margin analysis focuses on explaining the differences between planned and actual contribution margins, considering the quantity factor and the unit price factor.
After reviewing the data on the Contribution Margin Data panel, complete the following contribution margin analysis. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
|
Saxon, Inc. |
|
Contribution Margin Analysis |
|
For the Year Ended December 31 |
|
1 |
Planned contribution margin |
||
|
2 |
Effect of changes in sales: |
||
|
3 |
Sales quantity factor |
||
|
4 |
Unit price factor |
||
|
5 |
Total effect of changes in sales |
||
|
6 |
Effect of changes in variable cost of goods sold: |
||
|
7 |
Variable cost quantity factor |
||
|
8 |
Unit cost factor |
||
|
9 |
Total effect of changes in variable cost of goods sold |
||
|
10 |
Effect of changes in selling and administrative expenses: |
||
|
11 |
Variable cost quantity factor |
||
|
12 |
Unit cost factor |
||
|
13 |
Total effect of changes in selling and administrative expenses |
||
|
14 |
Actual contribution margin |
I got some of the work done just struggling with the rest
In: Accounting
write a half page clear and concise summary of the article and what you learned new and gleaned on the article.
The compliance revolution after the passage of the Sarbanes-Oxley Act of 2002 (SOX) was accomplished in large part with the help of the internal control framework of the Committee of Sponsoring Organizations of the Treadway Commission (COSO).
COSO’s framework became part of a worldwide movement to enhance periodic accounting and reporting of financial results. Coupled with the global convergence to IFRS, this should provide for a new age of financial information reliability and comparability.
In the past few years, COSO has remained active, providing new guidance regarding monitoring, enterprise risk management (ERM), enhanced board oversight, and quantifying risk appetites for corporate America. In December, COSO released an exposure draft and several related discussion questions that convert the 20-year-old COSO model to an upgraded and enhanced 2.0 version. The ED is available at coso.org. The previous model has been effective since SOX was signed into law in July 2002, but clearly needed updating and modifying for relevance to today’s business environment.
Changes in the business and operating environment that drove this change noted by COSO are as follows:
Expectations for governance oversight.
Globalization of markets and operations.
Changes in business models.
Demands and complexities in laws, rules, regulations, and standards.
Expectations for competencies and accountabilities.
Use of, and reliance on, evolving technologies.
Expectations relating to preventing and detecting corruption.
Audit committee chairmen and their members need to invest time to
consider the new ED, which is scheduled to be issued in final form
in the first quarter of 2013. The complete package of materials
will include the framework, a document with more information on
internal control over external financial reporting, and a document
on evaluation tools. Audit committees should consider the following
during this interim exposure and finalization period:
Ensure that audit committee members read the COSO executive summary and related discussion questions. Encourage those with a greater appetite to read the 150-plus pages of the new framework.
Develop a plan with the CFO, internal audit department, and independent accounting firm over the remaining months in 2012 to discuss the impact the new ED will have on the registrant.
Provide to the full corporate board of directors summary reports of the key concepts in the ED and how they may affect the company in future years.
Consider other COSO guidance for monitoring compliance with internal accounting controls and ERM, as well as how the audit committee is integrating this new guidance to provide a comprehensive assessment of the regulation.
Ensure that the audit committee members understand the new codification set forth in the ED.
Since the audit committee is a key component to the control
environment of any corporation, members should consider the five
embedded principles applicable to the “control environment.” COSO
describes those as follows:
Demonstrate commitment to integrity and ethical values.
Exercise oversight responsibility.
Establish structure, authority, and responsibility.
Demonstrate commitment to competence.
Establish accountability.
The updated COSO framework will provide refreshed objectives. It
will increase focus on operations, compliance, and nonfinancial
reporting objectives. Accordingly, the audit committee will need to
educate itself about the enhanced framework. Audit committees
should spend time with the CFO, accounting department, internal
audit, and external audit management to translate the new 2.0 model
into actionable and measurable enhancements in the company. This
will strengthen resistance to fraud, material weaknesses, and
significant errors in financial reporting.
Tips From the Audit Committee Chair
Olivia Kirtley is a nonexecutive director for U.S. Bancorp and Papa John’s International. She is also the chair of the audit committee of both companies. She was the AICPA’s first chairman from business and industry. She offers the following tips for efficient and effective operation of audit committees:
The audit committee should have both high expectations and robust processes for receiving information relating to the period under review on all critical areas, including significant issues, judgments, and transactions. It should receive written materials in advance of the meeting, setting forth all the important matters so that the meeting can focus on the most significant issues, whether these are revenue recognition, accounting for unusual transactions, or other matters. It is up to the CFO to be proactive in understanding the expectations of the audit committee and in developing the package of materials to be provided to committee members.
The audit committee and, particularly, its chair should develop a good working relationship with the CFO, seeking frank discussions about issues and challenges. This can be done by encouraging dialogue when important issues arise, and not just at general meetings. In addition, the chair should have a premeeting call to review materials and discuss matters that the committee should focus on during its meeting. The chair can ask any questions not evident from the advance meeting materials that may require additional review or work, allowing finance staff to prepare for questions that are likely to arise at the meeting. This helps build a collaborative, trusting relationship.
The audit committee discussions will be held with both the external auditors and the CFO in the room, so it is an opportunity to gain and test the views of both. In addition to its responsibilities with respect to the financial statements, the committee also has a role in mergers-and-acquisitions activity. It should focus on the results of due diligence on issues such as the internal control environment at the target company; planned timelines for the integration of systems and reporting; IT security and controls; and risk management processes. In short, it will need to consider anything that could impact the integrity of financial reporting and controls.
Interim financial reports are just as important, as are annual statements for investors, analysts, debt holders, and others, so the audit committee should follow its basic processes to oversee this and related disclosures. Although the review procedures by the external auditors are limited for interim reports, they still provide a level of review that is quite valuable through inquiry and the review of significant issues and transactions, and the audit committee members should discuss their findings and observations.
Audit committees should perform their review before the company releases the interim financial reports, which would include not only discussions with external and internal auditors, but also reviewing significant issues and judgments for the period with management. The audit committee should be satisfied that any communications between the company and analysts, or others, is consistent with these discussions, and that the company issued reports regarding financial matters and disclosures.
Beyond the Financial Statements: The Evolving Role of Public Company Auditors
Changes in the role served by public company auditors could include expanded communication with audit committees and more involvement with earnings releases, according to a report by the Center for Audit Quality.
The CAQ, which is affiliated with the AICPA, held a workshop with investors, buy-side analysts, auditors, audit committee members, and preparers on March 12 in New York City. Participants discussed how the auditor’s role could evolve to meet investors’ needs, focusing on information management communicates outside of audited financial statements.
Investors said non-GAAP disclosures are increasingly important in their decision-making process. They would like more consistency in non-GAAP measures reported by management from period to period in management discussion and analysis (MD&A) and earnings releases. Investors also desire comparability in non-GAAP key performance indicators across companies in specific industries. There was agreement at the workshop that the consistency should be driven by industry groups at the outset “although adoption of a more formal framework by the SEC ultimately may be needed,” according to the CAQ report. Some participants said “regulated” disclosures could become less flexible and candid.
More auditor involvement with MD&A is unnecessary, investors said, but a majority would like some level of auditor involvement with earnings releases. Although participants said public reporting by the auditor would be unnecessary, a majority supported a requirement for the auditor to read the earnings release and thoroughly discuss the contents with the audit committee. Such reviews currently are recognized as a best practice, but they are not required.
The feedback was consistent with 2011 workshop results in which investors expressed a desire for streamlined and balanced reporting with content focused on effectively communicating companies’ financial results rather than complying with regulatory requirements. Participants also said education is needed to close the expectation and information gap by helping capital market participants understand the role of auditors and the checks and balances in the financial reporting system. In response, the CAQ intends to expand its education programs and collaborative efforts accordingly.
“We hope to advance further consideration of these issues by all interested parties through publication of this workshop summary and through continued dialogue with stakeholders and policymakers,” said CAQ Executive Director Cindy Fornelli. “It is vitally important that investors understand and continue to trust the work that auditors perform—and have confidence in our financial reporting system and the checks and balances that underlie the system.”
In: Accounting
ACCY 207
EXCEL ASSIGNMENT #2
Spring 2018
CHECK FIGURES: What If #1: NOI $630,000
Increase in NOI $180,000
REQUIREMENTS:
Use the data in the posted problem for this Excel assignment. For the Year Ended December 31, 2017 prepare a Contribution Income Statement for CedarWorks using the following format for your data block page:
|
CedarWorks |
|||||
|
For the Year Ended December 31, 2017 |
|||||
|
Operating results: |
Original |
What If #1 |
What If #2 |
What If #3 |
|
|
Unit selling price |
$3,000.00 |
$ |
$ |
$ |
|
|
Variable cost per unit |
$2,100.00 |
$ |
$ |
$ |
|
|
Contribution margin per unit |
$ 900.00 |
$ |
$ |
$ |
|
|
Annual fixed costs |
$900,000 |
$ |
$ |
$ |
|
|
Volume sold (in units) |
1,500 |
||||
|
Increase (decrease) |
|||||
|
Proposed changes: |
What If #1 |
What If #2 |
What If #3 |
||
|
Increase (Decrease) in Volume (in units) |
$ |
$ |
$ |
||
|
Increase (Decrease) in Unit Sales Price |
$ |
$ |
$ |
||
|
Increase (Decrease) in Variable Cost Per Unit |
$ |
$ |
$ |
||
|
Increase (Decrease) Fixed Cost |
$ |
$ |
$ |
||
|
Target Profit |
$ |
$ |
$ |
||
There are three What If problems in the data file. Input the changes in your excel file under the Proposed changes section of the file (see above). If it is a decrease to one of these items then show the decrease in parenthesis. If there is no new data (no change to that item) to type into the cell then just type in 0. Remember each change is independent of the others. You will use formulas in the Operating results area to adjust the original data for the changes under the Proposed changes area to calculate the new what if data. Make sure you are using formulas and cell references in your formulas between the two sections to calculate the new data.
See the next page for the Analysis format for your spreadsheet.
GENERAL INFORMATION:
There will be two spreadsheets in your workbook as follows: Data Block (above) and Contribution Income Statement format illustrated below:
|
Original Data |
What If #1 |
||||
|
Units |
Units |
||||
|
Last Year |
1,500 |
Proposed: |
? |
||
|
Total |
Per Unit |
Total |
Per Unit |
||
|
Sales |
$4,500,000 |
3,000.00 |
$ ? |
$ ? |
|
|
Less variable expenses |
3,150,000 |
2,100.00 |
? |
? |
|
|
Contribution margin |
1,350,000 |
900.00 |
? |
$ ? |
|
|
Less fixed expenses |
900,000 |
? |
|||
|
Net income |
$ 450,000 |
$ ? |
|||
|
Contribution Margin Ratio |
30% |
? 0% |
|||
|
Breakeven point in Dollars |
$3,000,000 |
$ ? |
|||
|
Breakeven Point in Units |
1,000 |
? |
|||
|
Margin of Safety |
$ 1,500,000 |
$ ? |
|||
|
Operating Leverage |
3.0 |
? 0.0 |
|||
|
Increase (Decrease) in NOI after proposed changes: |
$ ? |
||||
All amounts must be either cell referenced from the data block page or supported by formulas! This includes the amounts in the Original Data columns.
Add additional columns next to What If #1 for What If #2, and What If #3 using the same format above as for What If #1. Separate each column in some manner so it is easy to read. You don’t have to use highlighting, but could use borders instead or some other way based on your preferences. Just be sure it is professional and easy to read.
You will need to use formulas to calculate Contribution Margin Ratio, Breakeven Points, Margin of Safety, and Operating Leverage. You must use a Data Block area and cell reference the appropriate data from the Data Block page to the income statement and/or use formulas. You should cell reference last year’s per unit data also and use this information to calculate the original total column. It should not just be typed into the Contribution Income Statement directly. Don’t forget to show dollar signs and percentages as per the format above. Add a heading to the Contribution Income Statement. Your heading should have the company name, the name of the statement, and the time period it covers (For the Year Ended December 31, 2017). You should use cell references from your data block page for all proposed changes in the “What If Analysis” section. Do not type in changes directly to the Contribution Income Statement.
Save your work frequently! Do not be the next person telling horror stories about lost work! Back up your work.
SAVING YOUR FILE:
Save your file according to the following name format:
Original data file: (Your Last Name, First Name Initial) Excel#2.
For Example: SmithJExcel2.xls or SmithJExcel2.xlsx (depending on which version of Microsoft you are using).
SUBMISSION OF YOUR EXCEL ASSIGNMENT:
Put a footer on each page in the bottom right-hand corner which includes your name and ZID#.
Before submitting your Excel assignment, check the Print Preview to make sure your Income Statement is centered (horizontally) in the page and you have included the footer.
You will submit your file to Bb. Your file should contain the following items:
1. Data Block
2. Contribution Margin Income Statement
Please be sure what you turn in is a unique product. You may work together, but you must each do your own spreadsheet. Do NOT turn in duplicate spreadsheets. We will assume you cheated and you both (or all) will get a zero for the assignment.
DO NOT WAIT TO THE LAST MINUTE TO START THIS PROJECT!
Excel #2
Problem and Data
CedarWorks manufactures playground equipment from Northern White Cedar wood which is free of all chemical additives and never splinters. The current manufacturing process is heavily labor intensive, so the company is studying ways to improve profits given that it currently has a significant amount of unused capacity. CedarWorks contribution margin income statement for the month of December 31, 2017 is given below:
Total Per Unit
Sales $4,500,000 $3,000
Variable expenses 3,150,000
Contribution margin 1,350,000
Fixed expenses 900,000
Net operating income $ 450,000
What If #1:
1. The company is studying the effect on its financial statements of purchasing some new equipment which would allow it to automate a large portion of its operations. Since direct labor costs will decline, variable costs would decrease by $900.00 per unit. However, total fixed costs would increase by $2,250,000. The volume of sales is expected to increase by 600 units if the new equipment is purchased. If the company operates in an industry that is sensitive to changes in the economy, do you think CedarWorks should purchase the new equipment. Explain.
What If #2:
2. As an alternative, rather than purchasing the new equipment, the president is thinking about changing the company’s marketing method. Under the new method, the president is proposing that CedarWorks pay its sales people a 5% commission on sales and decrease the monthly fixed salary by $420,000. Paying the sales force commissions is also expected to increase sales volume by 20% (or 300 units) each month. Do you agree with the president’s proposal? Explain.
What If #3:
3. Management is currently in contract negotiations with the labor union. If the negotiations fail and the company does not buy the equipment (part 1) or change the company’s marking method (part 2), direct labor costs will increase by 10% (or $90 per unit) and fixed costs will increase by $25,000 per month. If these costs increase, how many units will the company have to sell to earn a profit of $1,000,000.
In: Accounting
Which of the following statements about receptor potentials is FALSE?
A. They are changes in the resting membrane potential of a sensory cell in response to a stimulus.
B. The receptor potential spreads from the cell body of a sensory cell to the axon hillock, where action potentials can be generated
C. One receptor potential always prompts the release of a neurotransmitter that induces an associated neuron to generate an action potential.
D. They must be converted into action potentials to travel long distances.
E. They are graded membrane potentials that can be depolarizing or hyperpolarizing.
In: Biology