Fraser Co. is considering a change to its cost structure. Below is the data relating to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Fraser Co. is considering a change to its cost structure. Below is the data relating to the current structure as well as the proposed change. Current Structure Proposed Structure Unit Sales Sales Price Per Unit Total Variable Costs (based on 20,000 units) Total Fixed Costs 1.) Prepare a CVP Statement for each cost structure. Incorporate cell references and formulas where indicated. You can instantly create the CVP Statement for the Proposed Structure, by copying and pasting your completed CVP Statement for the Current Structure. Make sure all highlighted areas are completed. Try to avoid the headings when copying. You want to keep the Proposed Structure heading. 20,000 Unit Sales 20,000 100 Sales Price Per Unit $ 100 $ 400,000 $900,000 Total Variable Costs (based on 20,000 units $700,000 Total Fixed Costs $600,000 CVP Statement - Current Structure CVP Statement - Proposed Structure Total Per Unit % of Sales Type a Label Here Type a Label Here formula cell reference formula cell reference formula formula Type a Label Here formula formula formula Type a Label Here cell reference Type a Label Here formula 18 2.) Use the Contribution Margin technique to calculate the Breakeven point in units and dollars for each scenario. You can save time again by 19 copying from one section to the next. Be careful with the headings. Breakeven Units - Current Structure Breakeven Units - Proposed Structure 20 21 cell reference cell reference 22 cell reference formula formula 23 cell reference 24 Breakeven Sales Dollars - Current Structure Breakeven Sales Dollars - Proposed Structure 25 26 27 cell reference 28 cell reference cell reference cell ref formula formula %D %3D nce 29 30 31 3.) Compare the Net Operating Income and Breakeven calculations for both scenarios. What happened to the breakeven point and why? 32 Type response here 33 34 35 36 37 41 Compute the Dearee of Oneratina Levergge for both scenarios Save time aggin 30 37 4.) Compute the Degree of Operating Leverage for both scenarios. Save time again. Degree of Operating Leverage - Current Structure Degree of Operating Leverage - Proposed Structure 38 39 cell reference cell reference 40 cell reference formula formula %3D 41 cell reference 42 43 5.) Use the Degree of Operating Leverage to determine how a 10% 44 increase in sales will impact Net Income. 45 Proposal cell reference cell reference cell reference cell reference 46 Current 47 Degree of Operating Leverage 48 LABEL 49 Net Income Impact 50 Old Net Income 51 LABEL formula formula cell reference cell reference formula formula 52 New Net Income formula formula 53 Fraser Co. is considering a change to its cost structure. Below is the data relating to the current structure as well as the proposed change. Current Structure Proposed Structure Unit Sales Sales Price Per Unit Total Variable Costs (based on 20,000 units) Total Fixed Costs 1.) Prepare a CVP Statement for each cost structure. Incorporate cell references and formulas where indicated. You can instantly create the CVP Statement for the Proposed Structure, by copying and pasting your completed CVP Statement for the Current Structure. Make sure all highlighted areas are completed. Try to avoid the headings when copying. You want to keep the Proposed Structure heading. 20,000 Unit Sales 20,000 100 Sales Price Per Unit $ 100 $ 400,000 $900,000 Total Variable Costs (based on 20,000 units $700,000 Total Fixed Costs $600,000 CVP Statement - Current Structure CVP Statement - Proposed Structure Total Per Unit % of Sales Type a Label Here Type a Label Here formula cell reference formula cell reference formula formula Type a Label Here formula formula formula Type a Label Here cell reference Type a Label Here formula 18 2.) Use the Contribution Margin technique to calculate the Breakeven point in units and dollars for each scenario. You can save time again by 19 copying from one section to the next. Be careful with the headings. Breakeven Units - Current Structure Breakeven Units - Proposed Structure 20 21 cell reference cell reference 22 cell reference formula formula 23 cell reference 24 Breakeven Sales Dollars - Current Structure Breakeven Sales Dollars - Proposed Structure 25 26 27 cell reference 28 cell reference cell reference cell ref formula formula %D %3D nce 29 30 31 3.) Compare the Net Operating Income and Breakeven calculations for both scenarios. What happened to the breakeven point and why? 32 Type response here 33 34 35 36 37 41 Compute the Dearee of Oneratina Levergge for both scenarios Save time aggin 30 37 4.) Compute the Degree of Operating Leverage for both scenarios. Save time again. Degree of Operating Leverage - Current Structure Degree of Operating Leverage - Proposed Structure 38 39 cell reference cell reference 40 cell reference formula formula %3D 41 cell reference 42 43 5.) Use the Degree of Operating Leverage to determine how a 10% 44 increase in sales will impact Net Income. 45 Proposal cell reference cell reference cell reference cell reference 46 Current 47 Degree of Operating Leverage 48 LABEL 49 Net Income Impact 50 Old Net Income 51 LABEL formula formula cell reference cell reference formula formula 52 New Net Income formula formula 53
Expert Answer:
Answer rating: 100% (QA)
Since there are multiple parts to the question I have answered the first four Part 1 The CVP structu... View the full answer
Related Book For
Managerial accounting
ISBN: b010ikdqzm
10th Edition
Authors: Carl S. Warren, James M. Reeve, Jonathan E. Duchac
Posted Date:
Students also viewed these general management questions
-
Memory Media Inc. is considering a change to activity-based product costing. The company produces two products, CDs and DVDs, in a single production department. The production department is estimated...
-
Digital Storage Concept Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The...
-
The Snedecker Corporation is considering a change in its cash-only policy. The new terms would be net one period. Based on the following information, determine if the company should proceed or not....
-
Multiple Choice 1. Which of the following concepts are pervasive in the application of generally accepted auditing standards, particularly the standards of field work and reporting? a. Internal...
-
The following are the average weekly losses of work- hours due to accidents in 10 industrial plants before and after a certain safety program was put into operation: 45 and 36, 73 and 60, 46 and 44,...
-
At December 31, MediStat Precision Instruments owes $52,000 on Accounts Payable, Salaries Payable of $12,000, and Income Tax Payable of $10,000. MediStat also has $300,000 of Bonds Payable that were...
-
What would be a forensic accounting certification of the NACVA? a. CFE b. Cr.FA c. CFFA d. FCPA e. CFF
-
You have been assigned to the first audit of the Chicago Company for the year ending March 31, 2011. Accounts receivable were confirmed on December 31, 2010, and at that date the receivables...
-
Cash-generating unit (adopted from Wiley publication) Sydney Ltd reported the following assets in its statement of financial position at 30 June 2020: Assets Carrying Amount Plant $570 000 Land 300...
-
Find an online interview with a person that identifies themselves with a particular minority group in the workforce. Some examples of groups are, but not limited to: EAL, visible minorities, ethnic...
-
A country has a surplus in the trade in goods of US$ 5 0 billion, a deficit in the income account ( ( PLRE ) ) of US$ 1 0 billion, and a deficit in the trade in services of US$ 2 5 billion....
-
Please solve using Regression analyiss, not the high low method Sales Price 5.5 VC 2.13 Fixed costs 704991.95 . Based on the product line income statement for the most recent month: What is the marg...
-
Given the following information, what is the required equity down payment? . Acquisition price: $800,000 Loan-to-value ratio: 75% Total upfront financing costs: 3%
-
You work for an appellate court judge. He gives you the trial record for an unusual criminal case and explains that he would like you to discuss specific questions that are below. Specifically, one...
-
Ginny Trueblood is considering an investment, which will cost her $120,000. The investment produces no cash flows for the first year. In the second year, the cash inflow is $35,000. This inflow will...
-
The serenity of a Caribbean sunrise contrasted sharply with Doug's thoughts as he pondered the challenges of the coming week. Doug and his new bride Charlene were at the end of a weeklong Caribbean...
-
Health information exchange (HIE) includes _____. Question 39 options: Directed, query-based, and consumer-mediated exchanges Directed, telehealth, and query-based exchanges Problem list, e\directed...
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
Mini-Gym Company manufactures and sells outdoor play equipment. Mini-Gym uses activity-based costing to determine the cost of the sales order processing and the customer return activity. The sales...
-
What would happen to net income if the activities noted in Eye Opener 11 were allocated to products for financial statement reporting and the inventory increased?
-
The following information is for Cool Wave Skateboards, Inc.: Determine the contribution margin for a. Big Kahuna Skateboards and b. EastRegion. East West Sales Volume (units) Big Kahuna Easy Rider...
-
Question: While drunk, the driver of a subway car plows into the back of the car ahead of him, killing a passenger. It was against the rules for the driver to be drunk. Is the subway authority liable...
-
Acting as an undisclosed principal, William Zeckendorf employed agents to purchase the land in New York on which the United Nations headquarters was ultimately built. Can you find any other examples...
-
Consider the hospitals nonfinancial goals. What financial effect will occur if the hospital does work toward those goals?
Study smarter with the SolutionInn App