Question: using excel formulas cna someone help me please example : =B3-B4 Jay Corporation has provided data from a two-year period to aid in planning. The





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. After analyzing expenses, the company has determined the following cost patterns. Shipping has been determined to be a mixed cost with the following total costs and units: Required: Use the data to answer the following 1. Using the high-low method, determine a cost formula for shipping costs. For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =83+C3 Jay Corpontion has decided to prepare contribution income statements for internal planning. After analyzing expenses, the company has determined the following cost patterns. 15 Shipping bas been determined to be a mixed cost with the following total costs and units: Use the data to answer the following (Use cells A4 to C26 from the given inlormation to complete this question. All answers should be input and displayed as positive values.) 1. Using the highmow method, determine a cost formula for shipping costs. 2. Prepare a contribution margin income statement for Quarter 1 of 2024. Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work Nothing in this area will be graded, but it will be submitted with your assignment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
