Presented below is Trident Company's Income Statement prepared on the traditional (functional) basis: Requirement 1: Replace...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Presented below is Trident Company's Income Statement prepared on the traditional (functional) basis: Requirement 1: Replace the two unknown amounts (?) in A. and B. as directed. To find the unknown for B, you will have to complete Requirement 2. Then, complete the totals on the income statement. Trident Company Income Statement For the Year Ended December 31, 2016 Sales $350,000 Cost of Goods Sold $60,000 Direct Materials (variable) Direct Labor (variable) Manufacturing Overhead (mixed) 52,500 64,000 176,500 173,500 Gross Margin Operating Expenses Commissions (variable) 21,000 A. Multiply the HIGHEST digit entered above Shipping (variable) above by 1,000 and enter here enter the result 90,000 Advertising (fixed) Billing (mixed) Sales and Administrative Salaries (fixed) ? B. Complete Requirement 2 below and insert result 60,000 Total Operating Expenses Net Operating Income (Loss) 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum E Wrap Text AY H Calibri -11 A A General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center - $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E G H K M P Q 40 41 Selling price per unit is $14 and variable manufacturing overhead is $1 per unit. All variable expenses in the company 42 vary in terms of units sold. There was no change in beginning or ending inventories. Trident's plant capacity is 40,000 43 units per year. 44 Sales in Units Billing Costs 45 Requirement 2: 46 Billing costs for the past 5 years, along with total units sold follows: Year 2014 23,850 3,375 47 2013 22,000 3,156 48 2012 21,000 3,033 49 2011 22,750 3,290 50 2010 23,000 3,309 51 Use the high-low method to calculate the following: Show your work in this area: 52 ANSWER: 53 a. Variable billing cost per unit 54 55 56 b. Total fixed billing costs 57 58 c. Total cost equation for billing costs 59 60 61 d. Determine the total number of units currently being sold. Then determine total billing costs for that level- sales. 62 63 Insert your answer for 2)d. in the income statement above in the blank provided for Billing (Unknown B) 64 65 66 The company has been operating at a loss for several years. Management is trying to determine what it can do to 67 make next year profitable. 68 69 Requirement 3: 70 Redo Trident's 2016 income statement in contribution format, showing both a total column and a per unit column in the space provided below. 71 You MUST use formulas and cell refereces in the income statements in Requirements 3 and 5 to earn full credit. 72 Hint: You will need to calculate the variable and fixed components of Manufacturing Overhead (MOH) and billing. 73 74 Total Units Amount 75 Per Unit Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 86 Contribution Margin 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center - Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E H K M P Q 67 make next year profitable. 68 69 Requirement 3: 70 Redo Trident's 2016 income statement in contribution format, showing both a total column and a per unit column in the space provided below. 71 You MUST use formulas and cell refereces in the income statements in Requirements 3 and 5 to earn full credit. 72 12 Hint: You will need to calculate the variable and fixed components of Manufacturing Overhead (MOH) and billing. 73 74 Total Units Amount 75 Per Unit 76 77 Sales 78 Variable Costs 79 Direct materials Hint: Divide total cost column by total units to get VC per unit. 80 Direct Labor 81 Variable MOH Hint: Note that of total MOH, variable is $1 per unit ; the remaining MOH must be fixed 82 Sales commissions Shipping Variable billing 83 84 Variable Cost per unit is from From Requirement 2 a) above 85 Total Variable Costs 87 Fixed Costs 88 Fixed MOH 89 Advertising 90 Sales and admn. salaries 91 Fixed billing Fixed billing is from From Requirement 2 b) above Total Fixed Costs 92 93 Net Operating Income Hint: Operating Income must equal the original income from above. 94 95 96 Requirment 4: 97 Calculate Trident's current breakeven point in both units and dollars. Show work in this area: 98 99 Units: ANSWER 100 101 102 Units Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 区国 日ら,。 Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E F G K M P Q 94 95 96 Requirment 4: 97 Calculate Trident's current breakeven point in both units and dollars. 98 Show work in this area: 99 Units: ANSWER 100 101 102 Units 103 104 Dollars: 105 106 Dollars 107 108 109 Requirement 5: 110 111 Multiply the lowest digit (other than zero) from the last four digits of your student ID number by 10,000 and 112 enter for C. below to get the reduction in advertising. 113 114 a. The vice president suggests that selling price be lowered by 5% and advertising be reduced by 115 She is confident that this action will increase sales by 10,000 units. C. 116 117 The new selling price price per unit would be: 118 119 The new advertising amount would be: 120 121 122 123 124 125 126 127 128 129 Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 面, 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum E Wrap Text AY H Calibri -11 A A General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- A EE E Merge & Center - $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E F G H K M P Q 130 b. Prepare a new contribution margin income statement, using the vice president's recommendation. Remember, when volume changes, 131 total variable costs change proportionately. To get total variable costs, multiply the per unit amounts from Requirement 3 by the new 132 number of units. (Remember, VC per unit remains constant.) 133 134 Total Units Amount 135 Per Unit 136 137 Sales 138 Variable Costs New from above 139 Direct materials 140 Direct Labor 141 Variable MOH 142 Sales commissions 143 Shipping 144 Variable billing 145 Total Variable Costs 146 Contribution Margin 147 Fixed Costs 148 Fixed MOH 149 Advertising 150 Sales and admn. salaries 151 Fixed billing 152 Total Fixed Costs 153 Net Operating Income New from above 154 155 156 Requirement 6: 157 Using the budgeted income statement based on the vice president's proposal above, calculate the 158 Show your work in the areas provided. (Hint: You must calcualte a new breakeven point to complete this section.) 159 a. Margin of safety in units: 160 161 162 b. Margin of safety in dollars of sales: 163 164 165 c. Margin of safety percentage: Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 区国 日ら,。 A: E- Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles- Paste BIU- EE E Merge & Center Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 X A B D E H K M P Q 154 155 156 Requirement 6: 157 Using the budgeted income statement based on the vice president's proposal above, calculate the 158 Show your work in the areas provided. (Hint: You must calcualte a new breakeven point to complete this section.) 159 a. Margin of safety in units: 160 161 162 b. Margin of safety in dollars of sales: 163 164 165 c. Margin of safety percentage: 166 167 168 169 Requirement 7: 170 a. Calculate the degree of operating leverage using the vice-president's proposed income statement above. 171 Answer should use two decimal places. 172 173 Show your work in this area: 174 Answer 175 176 177 178 b. If sales volume increase 10%, operating income will increase by: 179 180 Percent Dollars 181 182 183 184 185 186 187 188 189 Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 面, Presented below is Trident Company's Income Statement prepared on the traditional (functional) basis: Requirement 1: Replace the two unknown amounts (?) in A. and B. as directed. To find the unknown for B, you will have to complete Requirement 2. Then, complete the totals on the income statement. Trident Company Income Statement For the Year Ended December 31, 2016 Sales $350,000 Cost of Goods Sold $60,000 Direct Materials (variable) Direct Labor (variable) Manufacturing Overhead (mixed) 52,500 64,000 176,500 173,500 Gross Margin Operating Expenses Commissions (variable) 21,000 A. Multiply the HIGHEST digit entered above Shipping (variable) above by 1,000 and enter here enter the result 90,000 Advertising (fixed) Billing (mixed) Sales and Administrative Salaries (fixed) ? B. Complete Requirement 2 below and insert result 60,000 Total Operating Expenses Net Operating Income (Loss) 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum E Wrap Text AY H Calibri -11 A A General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center - $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E G H K M P Q 40 41 Selling price per unit is $14 and variable manufacturing overhead is $1 per unit. All variable expenses in the company 42 vary in terms of units sold. There was no change in beginning or ending inventories. Trident's plant capacity is 40,000 43 units per year. 44 Sales in Units Billing Costs 45 Requirement 2: 46 Billing costs for the past 5 years, along with total units sold follows: Year 2014 23,850 3,375 47 2013 22,000 3,156 48 2012 21,000 3,033 49 2011 22,750 3,290 50 2010 23,000 3,309 51 Use the high-low method to calculate the following: Show your work in this area: 52 ANSWER: 53 a. Variable billing cost per unit 54 55 56 b. Total fixed billing costs 57 58 c. Total cost equation for billing costs 59 60 61 d. Determine the total number of units currently being sold. Then determine total billing costs for that level- sales. 62 63 Insert your answer for 2)d. in the income statement above in the blank provided for Billing (Unknown B) 64 65 66 The company has been operating at a loss for several years. Management is trying to determine what it can do to 67 make next year profitable. 68 69 Requirement 3: 70 Redo Trident's 2016 income statement in contribution format, showing both a total column and a per unit column in the space provided below. 71 You MUST use formulas and cell refereces in the income statements in Requirements 3 and 5 to earn full credit. 72 Hint: You will need to calculate the variable and fixed components of Manufacturing Overhead (MOH) and billing. 73 74 Total Units Amount 75 Per Unit Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 86 Contribution Margin 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center - Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E H K M P Q 67 make next year profitable. 68 69 Requirement 3: 70 Redo Trident's 2016 income statement in contribution format, showing both a total column and a per unit column in the space provided below. 71 You MUST use formulas and cell refereces in the income statements in Requirements 3 and 5 to earn full credit. 72 12 Hint: You will need to calculate the variable and fixed components of Manufacturing Overhead (MOH) and billing. 73 74 Total Units Amount 75 Per Unit 76 77 Sales 78 Variable Costs 79 Direct materials Hint: Divide total cost column by total units to get VC per unit. 80 Direct Labor 81 Variable MOH Hint: Note that of total MOH, variable is $1 per unit ; the remaining MOH must be fixed 82 Sales commissions Shipping Variable billing 83 84 Variable Cost per unit is from From Requirement 2 a) above 85 Total Variable Costs 87 Fixed Costs 88 Fixed MOH 89 Advertising 90 Sales and admn. salaries 91 Fixed billing Fixed billing is from From Requirement 2 b) above Total Fixed Costs 92 93 Net Operating Income Hint: Operating Income must equal the original income from above. 94 95 96 Requirment 4: 97 Calculate Trident's current breakeven point in both units and dollars. Show work in this area: 98 99 Units: ANSWER 100 101 102 Units Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 区国 日ら,。 Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- EE E Merge & Center $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E F G K M P Q 94 95 96 Requirment 4: 97 Calculate Trident's current breakeven point in both units and dollars. 98 Show work in this area: 99 Units: ANSWER 100 101 102 Units 103 104 Dollars: 105 106 Dollars 107 108 109 Requirement 5: 110 111 Multiply the lowest digit (other than zero) from the last four digits of your student ID number by 10,000 and 112 enter for C. below to get the reduction in advertising. 113 114 a. The vice president suggests that selling price be lowered by 5% and advertising be reduced by 115 She is confident that this action will increase sales by 10,000 units. C. 116 117 The new selling price price per unit would be: 118 119 The new advertising amount would be: 120 121 122 123 124 125 126 127 128 129 Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 面, 区国 日ら,。 A 5: A Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum E Wrap Text AY H Calibri -11 A A General Fill- +8 8 Conditional Format as Cell Formatting Table Styles Paste BIU- A EE E Merge & Center - $- % > Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 A B D E F G H K M P Q 130 b. Prepare a new contribution margin income statement, using the vice president's recommendation. Remember, when volume changes, 131 total variable costs change proportionately. To get total variable costs, multiply the per unit amounts from Requirement 3 by the new 132 number of units. (Remember, VC per unit remains constant.) 133 134 Total Units Amount 135 Per Unit 136 137 Sales 138 Variable Costs New from above 139 Direct materials 140 Direct Labor 141 Variable MOH 142 Sales commissions 143 Shipping 144 Variable billing 145 Total Variable Costs 146 Contribution Margin 147 Fixed Costs 148 Fixed MOH 149 Advertising 150 Sales and admn. salaries 151 Fixed billing 152 Total Fixed Costs 153 Net Operating Income New from above 154 155 156 Requirement 6: 157 Using the budgeted income statement based on the vice president's proposal above, calculate the 158 Show your work in the areas provided. (Hint: You must calcualte a new breakeven point to complete this section.) 159 a. Margin of safety in units: 160 161 162 b. Margin of safety in dollars of sales: 163 164 165 c. Margin of safety percentage: Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 区国 日ら,。 A: E- Project 2 Su17 (2) - Excel ? E - a FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in E AutoSum AY H Calibri -11 A A E Wrap Text General Fill- +8 8 Conditional Format as Cell Formatting Table Styles- Paste BIU- EE E Merge & Center Insert Delete Format Sort & Find &e 2 Clear Filter- Select Clipboard a Font Alignment Number Styles Cells Editing M9 X A B D E H K M P Q 154 155 156 Requirement 6: 157 Using the budgeted income statement based on the vice president's proposal above, calculate the 158 Show your work in the areas provided. (Hint: You must calcualte a new breakeven point to complete this section.) 159 a. Margin of safety in units: 160 161 162 b. Margin of safety in dollars of sales: 163 164 165 c. Margin of safety percentage: 166 167 168 169 Requirement 7: 170 a. Calculate the degree of operating leverage using the vice-president's proposed income statement above. 171 Answer should use two decimal places. 172 173 Show your work in this area: 174 Answer 175 176 177 178 b. If sales volume increase 10%, operating income will increase by: 179 180 Percent Dollars 181 182 183 184 185 186 187 188 189 Proj 2 READY 曲回 四 100% 10:33 AM O Type here to search x目 7/19/2017 面,
Expert Answer:
Related Book For
Fundamentals of Electric Circuits
ISBN: 978-0078028229
6th edition
Authors: Charles K Alexander, Matthew Sadiku
Posted Date:
Students also viewed these mechanical engineering questions
-
For each situation given, calculate cost of goods sold and identify if the information provided reflects a perpetual or periodic inventory system. a. b. A physical inventory count at year-end showed...
-
Fixed costs are 40 of the cost of goods sold and 18 of the selling and administrative expenses Dinner Ware assumes that fixed costs would not be significantly affected if the Cups line were...
-
The Cole Corporation had cost of goods sold of $ 685,000 during 2010. Based on the beginning and ending balances of the Inventory and Accounts Payable Merchandise accounts, how much cash did Cole...
-
For rigid-body motion, the strains will vanish. Under these conditions, integrate the straindisplacement relations (7.6.1) to show that the most general form of a rigid-body motion displacement field...
-
Indigo, Inc., a personal service corporation, has the following types of income and losses. Active income............. $325,000 Portfolio income ............ 49,000 Passive activity loss .............
-
The computation of comprehensive income for 2011 for Coca-Cola is shown below. For the Year Ended December 31, 2011...
-
Describe the purpose of an Affirmative Action Plan.
-
SummerFun, Inc., produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast: Develop an aggregate plan using each of the following guidelines...
-
Mortgage companies usually charge interest semi-annually. What would be the effective rate of interest on a mortgage at 4.25 percent compounded semi-annually?
-
On January 1, Year 4, Handy Company (Handy) purchased 70% of the outstanding common shares of Dandy Limited (Dandy) for $13,300. On that date, Dandy's shareholders' equity consisted of common shares...
-
It was reported in the network news that Dow-Jones Industrial Averages (DJIA) jumped by 500 points from 10,000 to 10,500 in the month of January. This means __________ : a) All share prices in New...
-
What is a good example of Strategy Implementation - including timeline for a psychiatric hospital that is planning to add an additional service?
-
What are some examples of things you can't do on company computers and why?
-
Contrast the differences between straight piecework, differential piece rate, and standard hour plans. Explain where each plan might best be used. What are the reasons behind the different payment...
-
Although achieving horizontal and vertical fits are important for high-performance work systems, what do you consider more critical and why?
-
State and overall position regarding the meaning and function of leadership in organizations today.
-
Your organization is building a collaboration platform for which they chose AWS EC2 for web and application servers and Aurora instance as the database. Due to the nature of the traffic to the...
-
A local politician is concerned that a program for the homeless in her city is discriminating against blacks and other minorities. The following data were taken from a random sample of black and...
-
Using Fig. 4.70 , design a problem to help other students better understand linearity. Find v o in the circuit of Fig. 4.70. If the source current is reduced to 1 μA. what is v o ? R4...
-
Determine v for t > 0 in the circuit in Fig. 16.60 . 250 mH ele 20u(t) A 4 20u(t) V 500 mF +1
-
(a) Calculate current i in Fig. 2.68 when the switch is in position 1. (b) Find the current when the switch is in position 2. 1 100 150 3 2.
-
As problems 5.18 and 5.19 reflect, the air temperature in the test section of conventional hypersonic wind tunnels is low. In reality, air liquefies at a temperature of about \(50 \mathrm{~K}\)...
-
The reservoir temperature calculated in problem 5.20 is beyond the capabilities of heaters in the reservoir of continuous-flow wind tunnels using air. This is why you do not see a Mach 20...
-
Write the \(y\) component of Eq. (6.7), and use it to derive Eq. (6.12). Equation 6.12: \(\frac{\partial(ho v)}{\partial t}+abla \cdot(ho v \mathbf{V})=-\frac{\partial p}{\partial y}+ho f_y\) V pfd7...
Study smarter with the SolutionInn App