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 how sensitive the company is to changes in sales. This lab consists of two parts. Part I 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 I: Exhibit 4-A is a reproduction of Exhibit 1-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 4A. 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,228August 420 $ 3,251 September 450 $ 3,392 October 283 $ 2,607 November 260 $ 2,498 December January 284 $ 2,611 February March April May 291 $ 2,644 310 $ 2,734 340 $ 2,875 350 $ 2,922 June 395 $ 3,133 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 how sensitive the company is to changes in sales. This lab consists of two parts. Part I 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 I: Exhibit 4-A is a reproduction of Exhibit 1-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 4A. 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,228August 420 $ 3,251 September 450 $ 3,392 October 283 $ 2,607 November 260 $ 2,498 December January 284 $ 2,611 February March April May 291 $ 2,644 310 $ 2,734 340 $ 2,875 350 $ 2,922 June 395 $ 3,133 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)
Exhibit 4A Account name Amount Variable Cost Fixed Cost Sales Revenue 264000000 Expenses Admistrative office supplies 360000 360000 Admistrative staff egaccountant etc 12500000 12500000 Admistrative p... View the full answer
Related Book For
Essentials of Marketing
ISBN: 978-0078028885
13th edition
Authors: William D. Perreault, Joseph P. Cannon
Posted Date:
Students also viewed these accounting questions
-
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....
-
Describe cost volume profit analysis and how management can use it in more than just financial analysis. Explain the main differences between operating income and net income overall for a business....
-
The contribution format income statement for Westex, Inc., for its most recent period is given below: The company had average operating assets of $500,000 during the period. Required: 1. Compute the...
-
TDS is a national delivery company based at Thornton Science Park. They employ 5 0 staff including administration, vehicle drivers, and warehouse workers. Their system is reliant on IT systems. Their...
-
What positive publicity and image-enhancement programs are used in international public relations efforts?
-
Enhance the ButtonViewer program in Section 10.7.1 so that it prints a message Iwasclicked n times! whenever the button is clicked. The value n should be incremented with each click.
-
A spherical tank of diameter \(D\) has a drain hole of diameter \(d\) at its bottom. A vent at the top of the tank maintains atmospheric pressure at the liquid surface within the tank. The flow is...
-
The partnership of W, X, Y, and Z has the following balance sheet: Z is personally insolvent, and one of his creditors is considering suing the partnership for the $5,000 that is currently due. The...
-
Campbell Corporation expects to incur indirect overhead costs of $167,475 per month and direct manufacturing costs of $15 per unit. The expected production activity for the first four months of the...
-
The following summarized data (amounts in millions) are taken from the September 26, 2020, and September 28, 2019, comparative financial statements of Apple Incorporated, a company that designs,...
-
Bob and Allie Katz are a married couple with three children. Their salaries for 2018 totaled $125,400 with an additional $200 in interest income. They calculated their itemized deductions at $33,700...
-
Compare and contrast, by making use of two graphs the policy options of liability and property rights approaches and command-and-control strategies on emission standards. "Emission charges are...
-
Figure 5.6: Example of a heap storing 13 integer keys. The last node is the one storing key 8, and external nodes are empty. 1. Show the steps for removing key 16 from the heap of Figure 5.6. 2. Show...
-
Snopp Dogg has a net worth of $160 Million. In collaboration with Corona (owned by Constellation Brands, a Rochester NY company) Snoop developed an insulated sleeve for Corona cans. He agreed to be...
-
Surgical Equipment Web site Forecast March April May June Web site organic 200 300 400 500 Web site social media 250 400 550 700 Web site PPC 4,000 4,000 4,000 4,000 Total web site visits 4450 4700...
-
"In years when people buy many shares of stock, investment will be high and, therefore, so will GDP." Explain in maximum of 3 lines why the statement is right or wrong. [3 marks]
-
You are investing in a stock expected to pay a dividend of $3.5 (per share) in year 1, $3.7 in year 2, $3.9 in year 3, and $4.0 in year 4. The required rate of return on the stock is 9.5%. Analysts...
-
You have accepted the engagement of auditing the financial statements of the C. Reis Company, a small manufacturing firm that has been your auditee for several years. Because you were busy writing...
-
Distinguish between a generic market and a product market. Illustrate your answer.
-
Why does adoption of the marketing concept encourage a firm to operate more efficiently? Be specific about the impact of the marketing concept on the various departments of a firm.
-
Describe a recent purchase you made. Indicate why that particular product was available at a store and, in particular, at the store where you bought it.
-
One of the main fears that retail startups have is if they will be able to compete against Walmart, Home Depot, and the other big-box stores. This is a legitimate fear. Big-box stores continue to...
-
Influencer marketing is a type of marketing where companies partner with influencers, who have a significant following on social media platforms, to promote their products or services. Influencers...
-
In the summer of 2015, Stephen Kuhl and Kabeer Chopra made their way to Philadelphia to prepare for business school. It was their first semester in the Wharton MBA program. They were both in an...
Study smarter with the SolutionInn App