Tonia and Tara have realized that they will be able to better analyze their profitability and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tonia and Tara have realized that they will be able to better analyze their profitability and cost structure by converting their pro forma income statement to a Contribution Format Income Statement. After reformatting the income statement and analyzing fixed and variable costs, the two women analyze their breakeven point. They use this information to determine sales information for different target profits, along with completing an analysis on bow sensitive the company is to changes in sales. This lab consists of two parts. Part l consists of identifying variable and fixed costs, breaking a mixed cost into its variable and fixed components, and reformatting the income statement. Part 2 consists of using the contribution margin calculated in Part 1 to perform a breakeven analysis and a sensitivity analysis. PART 1: Exhibit 4-A is a reproduction of Exhibit I-A. In this exhibit, identify whether a cost is variable or fixed and enter the amount in the correct column. Note that Factory Utilities is a mixed cost. You will need to complete Worksheet 4-1 to determine the variable and fixed components for Factory Utilities using the High-Low method Exhibit 4-A. T.O.T.E.S. accountant collected the following data from last year's utility bills to assist you in calculating the fixed and variable components of the factory utility costs. Utility Expenses for Prior Year Machine Cost of Machine Cost of Month Month Hours Utilities Hours Utilities 400 $ 3,157 July 415 $ 3,228 August 420 $ 3,251September 450 $ 3,392October 283 $ 2,607 November 260 $ 2,498December 284 $ 2,611 January February March 291 $ 2,644 310 $ 2,734 April May June 340 $ 2,875 350 $ 2,922 395 $ 3,133 23 EXHIBIT 4-A: Determine Variable and Fixed Costs IDENTIFY IF COST IS VARIABLE OR FIXED T.O.T.E.S. Estimated Revenues And Expenses For Upcoming Year 550,000 (put an X in the correct column) FIXED COST Forecasted Sales in units VARIABLE ACCOUNT NAME AMOUNT COST Sales Revenue 2,640,000 Expenses Administrative Office Supplies Administrative Staff, eg, accountant, etc. 3,600 125,000 Adminstrative Payroll and Fringe Advertising. Trade Shows, Travel & Entertainment 103,400 46,000 Company Labels Depreciation - Admin. Furniture & Equipment Depreciation - Sewing Machines & Cutting Machines Equipment Lease - Administrative Offices 4,200 2,450 7,600 5,000 Executive Salaries 229,000 Fabric 600,000 Factory Utilities (mixed cost) Freight & Postage - Administrative Insurance - Company Liability 38,000 2,500 9,000 14,000 Insurance - Plant Legal & Professional Logo Ink Plant Maintenance Supervisor 5,000 26,000 32,000 68,000 Plant Manager Rent - Administrative Building 43,400 42,000 Rent - Plant Building Repairs and Maintenance - Plant 27,000 113,400 Sales Commissions Sales Salaries 44,000 Shipping and Handling of Finished Product (Selling) 40,350 Thread 50,000 87,100 Wages - Cutting Department Wages - Printing Department Wages - Sewing Department 20,000 160,000 Webbing 540,000 Hint: There are 10 variable costs, including the variable portion of the mixed cost item. 25 PART 2: Complete the Contribution Format Income Statement with ALL accounts listed using the Excel worksheet found on Blackboard. Complete Exhibit 4-B using the totals from the Excel Pro forma Contribution Format Income Statement. Verify all totals are correct PRIOR to starting Part 3. EXHIBIT 4-B: Pro forma Contribution Format Income Statement T.O.T.E.S. Pro forma Summarized Contribution Format Income Statement For Year ending December 31, 20XX SALES REVENUES TOTAL VARIABLE COSTS CONTRIBUTION MARGIN TOTAL FIXED COSTS OPERATING INCOME (LOSS) PART 3: Using the information from Exhibit 4-B, calculate contribution margin, contribution margin ratio, perform a breakeven analysis, and perform a sensitivity analysis using operating leverage. Unless otherwise specified, the information will be taken from the amounts appearing in Exhibits 4-A and Exhibit 4-B. 1. Compute the TOTAL VARIABLE COSTS PER UNIT as follows: a. Total projected annual variable costs from Exhibit 4-B b. Total projected units from Exhibit 4-A c. Total Variable Cost per unit (la + Ib) per unit (Round to 4 decimal places) 2. Compute CONTRIBUTION MARGIN PER UNIT using sales price per unit and variable cost per unit (Round to 4 decimal places): 3. Compute the CONTRIBUTION MARGIN RATIO (Round to 4 decimal places): 26 4. Compute the BREAKEVEN IN UNITS (Round up to the nearest whole number): 5. Compute the BREAKEVEN IN SALES DOLLARS (Round up to the nearest dollar): 6. Compute the NUMBER OF UNITS THAT MUST BE SOLD to reach a targeted profit of $152,000 taking into consideration the total projected fixed costs (Round to the nearest whole number. Hint: Use the breakeven unit formula): 7. How MANY SALES DOLLARS MUST BE GENERATED to carn an annual operating income of $300,000? (Round to the nearest dollar. Hint: Use Breakeven in Sales $ formula) 8. Calculate the company's DEGREE OF OPERATING LEVERAGE based on the proposed budget (Round to 4 decimal places): 9. If sales in units increase by 10% what would be the NEW PROJECTED OPERATING INCOME? (Use degree of operating leverage calculated in #8. Round final answer to nearest dollar) 10. If sales in units decreased by 15% what would be the NEW PROJECTED OPERATING INCOME? (Round final answer to nearest dollar.) Tonia and Tara have realized that they will be able to better analyze their profitability and cost structure by converting their pro forma income statement to a Contribution Format Income Statement. After reformatting the income statement and analyzing fixed and variable costs, the two women analyze their breakeven point. They use this information to determine sales information for different target profits, along with completing an analysis on bow sensitive the company is to changes in sales. This lab consists of two parts. Part l consists of identifying variable and fixed costs, breaking a mixed cost into its variable and fixed components, and reformatting the income statement. Part 2 consists of using the contribution margin calculated in Part 1 to perform a breakeven analysis and a sensitivity analysis. PART 1: Exhibit 4-A is a reproduction of Exhibit I-A. In this exhibit, identify whether a cost is variable or fixed and enter the amount in the correct column. Note that Factory Utilities is a mixed cost. You will need to complete Worksheet 4-1 to determine the variable and fixed components for Factory Utilities using the High-Low method Exhibit 4-A. T.O.T.E.S. accountant collected the following data from last year's utility bills to assist you in calculating the fixed and variable components of the factory utility costs. Utility Expenses for Prior Year Machine Cost of Machine Cost of Month Month Hours Utilities Hours Utilities 400 $ 3,157 July 415 $ 3,228 August 420 $ 3,251September 450 $ 3,392October 283 $ 2,607 November 260 $ 2,498December 284 $ 2,611 January February March 291 $ 2,644 310 $ 2,734 April May June 340 $ 2,875 350 $ 2,922 395 $ 3,133 23 EXHIBIT 4-A: Determine Variable and Fixed Costs IDENTIFY IF COST IS VARIABLE OR FIXED T.O.T.E.S. Estimated Revenues And Expenses For Upcoming Year 550,000 (put an X in the correct column) FIXED COST Forecasted Sales in units VARIABLE ACCOUNT NAME AMOUNT COST Sales Revenue 2,640,000 Expenses Administrative Office Supplies Administrative Staff, eg, accountant, etc. 3,600 125,000 Adminstrative Payroll and Fringe Advertising. Trade Shows, Travel & Entertainment 103,400 46,000 Company Labels Depreciation - Admin. Furniture & Equipment Depreciation - Sewing Machines & Cutting Machines Equipment Lease - Administrative Offices 4,200 2,450 7,600 5,000 Executive Salaries 229,000 Fabric 600,000 Factory Utilities (mixed cost) Freight & Postage - Administrative Insurance - Company Liability 38,000 2,500 9,000 14,000 Insurance - Plant Legal & Professional Logo Ink Plant Maintenance Supervisor 5,000 26,000 32,000 68,000 Plant Manager Rent - Administrative Building 43,400 42,000 Rent - Plant Building Repairs and Maintenance - Plant 27,000 113,400 Sales Commissions Sales Salaries 44,000 Shipping and Handling of Finished Product (Selling) 40,350 Thread 50,000 87,100 Wages - Cutting Department Wages - Printing Department Wages - Sewing Department 20,000 160,000 Webbing 540,000 Hint: There are 10 variable costs, including the variable portion of the mixed cost item. 25 PART 2: Complete the Contribution Format Income Statement with ALL accounts listed using the Excel worksheet found on Blackboard. Complete Exhibit 4-B using the totals from the Excel Pro forma Contribution Format Income Statement. Verify all totals are correct PRIOR to starting Part 3. EXHIBIT 4-B: Pro forma Contribution Format Income Statement T.O.T.E.S. Pro forma Summarized Contribution Format Income Statement For Year ending December 31, 20XX SALES REVENUES TOTAL VARIABLE COSTS CONTRIBUTION MARGIN TOTAL FIXED COSTS OPERATING INCOME (LOSS) PART 3: Using the information from Exhibit 4-B, calculate contribution margin, contribution margin ratio, perform a breakeven analysis, and perform a sensitivity analysis using operating leverage. Unless otherwise specified, the information will be taken from the amounts appearing in Exhibits 4-A and Exhibit 4-B. 1. Compute the TOTAL VARIABLE COSTS PER UNIT as follows: a. Total projected annual variable costs from Exhibit 4-B b. Total projected units from Exhibit 4-A c. Total Variable Cost per unit (la + Ib) per unit (Round to 4 decimal places) 2. Compute CONTRIBUTION MARGIN PER UNIT using sales price per unit and variable cost per unit (Round to 4 decimal places): 3. Compute the CONTRIBUTION MARGIN RATIO (Round to 4 decimal places): 26 4. Compute the BREAKEVEN IN UNITS (Round up to the nearest whole number): 5. Compute the BREAKEVEN IN SALES DOLLARS (Round up to the nearest dollar): 6. Compute the NUMBER OF UNITS THAT MUST BE SOLD to reach a targeted profit of $152,000 taking into consideration the total projected fixed costs (Round to the nearest whole number. Hint: Use the breakeven unit formula): 7. How MANY SALES DOLLARS MUST BE GENERATED to carn an annual operating income of $300,000? (Round to the nearest dollar. Hint: Use Breakeven in Sales $ formula) 8. Calculate the company's DEGREE OF OPERATING LEVERAGE based on the proposed budget (Round to 4 decimal places): 9. If sales in units increase by 10% what would be the NEW PROJECTED OPERATING INCOME? (Use degree of operating leverage calculated in #8. Round final answer to nearest dollar) 10. If sales in units decreased by 15% what would be the NEW PROJECTED OPERATING INCOME? (Round final answer to nearest dollar.)
Expert Answer:
Answer rating: 100% (QA)
Answer Solution Exhibit 4A Account name Amount Variable Cost Fixed Cost Sales Revenue 264000000 Expenses Administrative office supplies 360000 360000 Administrative staff egaccountant etc 12500000 125... View the full answer
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Posted Date:
Students also viewed these general management questions
-
Pro forma income statement At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales ................... $3,000 Operating cost excluding...
-
For the Pro Forma Income Statement model in the Excel file Net Income Models (Figure 11.7), add a scroll bar form control to allow the user to easily change the level of sales from 3,000,000 to...
-
Your assistant has prepared the following pro forma income statement for 2010. He used your forecast sales figure as the starting point. The administrative expenses are fixed except for salaries,...
-
What will be the sum of third proportional to 18 and 54 and fourth proportional to 12, 18 and LCM of 12 and 18? 1. 162 2. 216 3. 612 4. 256 526 5.
-
The claim is made that MDS is of little help in new-product planning, because most of the dimensions are "psychological" dimensions and not really actionable. Predicting psychological reactions to...
-
Is the level of measurement of the 641 individual responses nominal, ordinal, interval, or ratio? Why? Refer to the table in the margin, which summarizes results from 641 people who responded to a...
-
FRAUD PREVENTION AND DETERRENCE IN ACTION Assume the following facts: thirty-day collection period. The invoice is used to post-sales to the accounting system. Checks are received in the mailroom and...
-
Plantwide versus Departmental Overhead Rates; Underapplied or Overapplied Overhead Blast it! said David Wilson, president of Teledex Company. Weve just lost the bid on the Koopers job by $2,000. It...
-
What ways can I make my Relational Data Model conversion meet the following requirements listed below? Am I on the right track? What corrections do I need to address? ERD: My Conversion of ERD onto a...
-
Adam and Eve are partners in a wedding catering business. Adam is responsible for the cake design and baking, while Eve handles the cake orders, supplies and accounting. The following are true...
-
The graph of a function fis given in the figure. y -2 2 (a) Find the value of f(1). 3 (b) Estimate the value of f(-1). 2 4 X (c) For what values of x is f(x) = 1? (Enter your answers as a...
-
Kate's soccer team is selling coupon books and recipe books to raise money for transportation to their games. Coupon books cost $12 each and recipe books cost $7.50 each. If Kate sold a total of 42...
-
Julie bought 3 fruits: an apple, a banana, and a guava at a cost of $0.25,$0.23 and $0.17 respectively. How much did she pay?
-
Calculate the overall on-prem cost for the e-commerce architecture. State all the assumptions. You can omit the costs related to the IT staff
-
You are paid 1.2 times your normal hourly rate for each hour you work over 30 hours in a week. You work 34 hours this week and earn $523.74. What is your normal hourly rate?
-
Describe the importance of presenting a comprehensive and accurate Consolidated EPS. How do factors like stock splits, dividends, and changes in ownership interest affect its calculation?
-
I need to write a collection of classes to describe the following shapes: Rectangle Square Circle Cylinder Cube Each class should meet the properties defined above. In addition, each class should...
-
Access the Federation of Tax Administrators Internet site at www. taxadmin.org/state-tax-forms and indicate the titles of the following state tax forms and publications: a. Minnesota Form M-100 b....
-
Beverly Ann Cosmetics has created two new perfumes: Summer Passion and Ocean Breeze. It costs $ 5.25 to purchase the fragrance needed for each bottle of Summer Passion and $ 4.70 for each bottle of...
-
For the car rental decision in these Problems suppose that the cost of a minor fender bender is normally distributed with a mean of $ 2000 and standard deviation of $ 100, and the cost of a major...
-
Total marketing effort is a term used to describe the critical decision factors that affect demand: price, advertising, distribution, and product quality. Let the variable x represent total marketing...
-
A cylinder of mass \(M\), moment of inertia \(I\) about the cylindrical axis and radius \(R\) rolls on a horizontal surface without slipping. (a) Express the no-slip constraint in differential form....
-
A block of mass \(m\) slides without friction on a larger block of mass \(M\) and is attached to a pin in this block by a massless spring with spring constant \(k\). All motion is in one dimension....
-
A bead of mass \(m\) is threaded without friction on a massless wire hoop of radius \(R\) that is forced to oscillate vertically in a fixed vertical plane at angular frequency \(\omega\) and with...
Study smarter with the SolutionInn App