Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 国日High-Low Method; Contribution Format Income Statement - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InCalibri-11A APasteBIU -Alignment NumberConditional Format as CellCellsEditingFormatting -Table- StylesClipboardFontStylesЕ11 To ald in planning, Jay Corporation is preparing a contribution format income statement.Budgeted information for Quarter l of Year 3:Sales in units17,000Sales price per unit48.007 After analyzing expenses, the company has determined the following cost patterns.8 Cost of goods sold9 Sales commissions29.00 per unit9.50% per dollar of sales1011 Administrattve salaries12 Rent expense13 Depreciation expense45,000.00 per quarter27,000.00 per quarter36,000.00 per quarter1415 Management has concluded that shipping oxpense is a mixed cost. Units shipped and the related shippling cost overthe last cight quarters are:16JOtal Shipping Cost67,000.0017 Year 118 Quarter 119 Quarter220 Quarter 321 Quarter 422 Year 223 Quarter 124 Quarter225 Quarter 326 Quarter 4Lnits12,50094,000.0021,00089,800.0013,80092,600.0020,00072,500.0013,70080,000.0084,000.0014,00014,300100,000.0022,5002728 Use the data to anawer the following2930 1. Using the high low method, determine a cost formula for shipping expenses31Sheet1......READY+10%Attempt(s)Hint囲 High-Low Method; Contribution Format Income Statement - ExcelSign InFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWCalibri-11APasteBIU -Alignment Number Conditional Format asCellCellsEditingFormatting - Table - Styles-ClipboardFontStylesЕ132Total Shipping CostUnits33 High level af activity34 Low level of activity35 Change in activity3637 Variable costper unit3839 Compute the fxed cost portion using the high level of activity.40 Total cost at high level of activity41 Less: Variable cost element42 Total fixed cost4344 2. Prepare a contribution format income statement for Quarter 1 of Year 3.4546Jay CorporationBudgetnd Contribution Format Income StatementFor Year 3, Quarter 1474849so Sales51 Variable cxpenses:52 Cost of goods sold53 Sales commissions54 Shipping expense55 Total variable expenses56 Contributon margin57 Fed expenses:58 Administrattve salaries50 Rent expense60 Shipping expense61 Depreciation expense62 Total fed expenses63 Net operatting incomeSheet1...READY10%Attempt(s)Hint囲

Contribution margin=Sales-Total variable expensesNet operating income=Contribution margin-Total…

E1 1 To ald in planning, Jay Corporation is preparing a contributon format income statement. 3 Budgeted Information for Quarter 1 of Year 3: Sales in units 17,000 5 Sales price per unit 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of goods sold 29.00 per unit Sales commissions 9.5O% per dollar of sales 10 Administrative salaries Rent oxpense 11 45,000.00 per quarter 12 27,000.00 per quarter 13 Depreciation expense 36,000.00 per quarter 15 Management has concluded that shipping oxpense is a mixed cost. Units shipped and the related shipping cost over the last eight quarters are: 16 17 Year 1 Jotal Shipping Cont 67,000.00 Units 18 Quarter 1 19 Quarter2 20 Quarter 3 12,500 94,000.00 21,000 89,800.00 13,800 21 Quarter 4 92,600.00 20,000 22 Year 2 23 Quarter 1 24 Quarter2 72,500.00 13,700 80,000.00 14,000 25 Quarter 3 34,000.00 14,300 26 Quarter 4 27 100,000.00 22,500 28 Use the data to anower the folowing 29 30 1. Using the high low method, determine a cost formula for shipping expenses 31 SSS

E1 1 To ald in planning, Jay Corporation is preparing a contributon format income statement. 3 Budgeted Information for Quarter 1 of Year 3: Sales in units 17,000 5 Sales price per unit 48.00 7 After analyzing expenses, the company has determined the following cost patterns. 8 Cost of goods sold 29.00 per unit Sales commissions 9.5O% per dollar of sales 10 Administrative salaries Rent oxpense 11 45,000.00 per quarter 12 27,000.00 per quarter 13 Depreciation expense 36,000.00 per quarter 15 Management has concluded that shipping oxpense is a mixed cost. Units shipped and the related shipping cost over the last eight quarters are: 16 17 Year 1 Jotal Shipping Cont 67,000.00 Units 18 Quarter 1 19 Quarter2 20 Quarter 3 12,500 94,000.00 21,000 89,800.00 13,800 21 Quarter 4 92,600.00 20,000 22 Year 2 23 Quarter 1 24 Quarter2 72,500.00 13,700 80,000.00 14,000 25 Quarter 3 34,000.00 14,300 26 Quarter 4 27 100,000.00 22,500 28 Use the data to anower the folowing 29 30 1. Using the high low method, determine a cost formula for shipping expenses 31 SSS

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Can you help me to solve this?
Evaluate these three technologies used to obtain energy and atmosphere credits towards LEED certification by calculating total NPV and gross NPV at R=7% and complete the table for gross and net NPV values. If you could only recommend one to your client, which would you recommend and why? Suggestion: Set this up in an Excel spreadsheet to make your calculations a little easier to keep track of. If you do that, please include that spreadsheet with your assignment. Building Technology Install high efficiency packaged rooftop units (RTUS) Comprehensive lighting and plug load efficiency Incremental Cost $50,000 $50,000 strategy Enhanced insulation $50,000 and glazing package for building envelope Annual Total SPP Savings (Yrs) Life (Yrs) $10,000 5 12 $5,000 10 $10,000 5 Investment 10 15 Gross NPV Net NPV
Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year $ 31,800 89,500 112,500. 10,700 278,500 $ 523,000 Interest expense Income tax expense Total costs and expenses Net income. Earnings per share $ 129,900 98,500 163,500 131,100 $ 523,000 Current Year $ 411,225 209,550 1 Year Ago $ 35,625 62,500 82,500 9,375 255,000 $ 445,000 The company's income statements for the current year and one year ago follow. Assume that all sales are on credit: 4 12,100 9,525 $ 75,250 101,500 163,500 104,750 $ 445,000 $ 673,500 2 Years Ago 642,400 $ 31,100 $ 1.90 $ 37,800 50,200 54,000 5,000 230,500 $ 377,500 $51,250 83,500 163,500 79,250 $ 377,500 1 Year Ago $ 345,500…
Classify the performance measures below into the most likely balanced scorecard perspective itrelates to. Label your answers using C (customer), P (internal process), I (innovation and growth), or F(financial). Gallons of water reused
Discuss any four factors that an accountant would consider when selecting a data input device that they can use to perform their daily task
The financial accounting system is the primary source of information for: Multiple Choice planning the budget for next year. decision making on the factory floor. preparing the Income statement for shareholders. Improving the performance level of customer service.
Define the term key performance indicator. The text provides you with examples of KPIs applicable to revenue cycle activities. Extend that line of thinking and identify at least five possible KPIs relating to inventory accounts.
i. Briefly inform these stakeholders of the benefits of automation on the current business processes within the organization, specifically referencing the benefits of using a spreadsheet solution and how easy it was to process data to derive the information presented in the report. ii. Give a brief analysis of the data found in the chart
Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.
Imagine you are the project manager at an investment firm and given the task of preparing a report (essay) addressing several companies' projects' evaluations. Use the supplied information for each project to answer the associated questions. Your deliverable is a professionally prepared MS Excel file, MS Word report (essay) applying APA 7 formatting and a quick information sheet. In your recommendation/conclusion of your report identify the best project to invest in and give reasons why. The quick information sheet is this document with the blanks filled out for each question area. Harris Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine. The following information is given. The firm pays 40 percent taxes on ordinary income and capital gains. Project 2 Questions: 1) Calculate the book value of the existing asset being replaced. 2) Calculate the tax effect from the sale…
Provide table
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)