Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method 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. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales) Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the following 1. Using the high-low method, determine a cost formula for shipping costs. 2. Prepare a contribution margin income statement for Quarter 1 of 2024. Navigation:

Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method 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. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales) Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the following 1. Using the high-low method, determine a cost formula for shipping costs. 2. Prepare a contribution margin income statement for Quarter 1 of 2024. Navigation:

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter2: Building Blocks Of Managerial Accounting

Section: Chapter Questions

Problem 9EB: The cost data for BC Billing Solutions for the year 2020 is as follows: Using the high-low method,...

See similar textbooks

Similar questions

A company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950
Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 85.00 Labor cost 37.00 Overhead cost 7.10 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.80 $522,000 142,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…
Variable Costs, Contribution Margin, Contribution Margin Ratio Super-Tees Company plans to sell 20,000 T-shirts at $19 each in the coming year. Product costs include: Direct materials per T-shirt $6.65 $1.33 Direct labor per T-shirt Variable overhead per T-shirt $0.57 Total fixed factory overhead $43,000 Variable selling expense is the redemption of a coupon, which averages $0.95 per T-shirt; fixed selling and administrative expenses total $13,000.
Refer to the information for Jasper Company on the previous page.Required:1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for eachline item on the income statement. (Note: Round percentages to the nearest tenth of a percent.)2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the incomestatement created for Requirement 1 to better control costs.
Prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget. Please show work Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take next year to reach profitability. They begin by reviewing the most recent income statement (below). Carolina Manufacturing Company Income Statement For the Year Ended December 31 Sales (45,000 units at $15) Less cost of goods sold: Net loss Direct materials Direct labor Manufacturing overhea Gross margin Less operating expenses Selling expenses Variable Sales commissions Shipping 135,000 117,450 147,750 Fixed (advertising, salaries) Administrative expenses Variable (billing and other) Fixed (salaries and other) 40,500 8,100 180,000 $675,000 400,200 274,800 228,600 2,700 72,000 74,700 ($28,500)
The contribution margin income statement of Unique Donuts for August 2024 follows: (Click the icon to view the contribution margin income statement.) Data table Unique Donuts Contribution Margin Income Statement Month Ended August 31, 2024 Net Sales Revenue Variable Costs: Cost of Goods Sold Selling Costs Administrative Costs Contribution Margin Fixed Costs: Selling Costs Administrative Costs Operating Income $ 32,300 17,200 1,300 42,210 14,070 $ $ - 127,000 50,800 76,200 56,280 19,920 Requirements Unique sells two dozen plain donuts for every dozen custard-filled donuts. A dozen plain donuts sells for $3.10, with total variable cost of $1.24 per dozen. A dozen custard-filled donuts sells for $7.20, with total variable cost of $2.88 per dozen. d-filled donuts 1. Calculate the weighted-average contribution margin. 2. Determine Unique's monthly breakeven point in dozens of plain donuts and custard-filled donuts. Prove your answer by preparing a summary contribution margin income…
Please help me with the functions for this ! Thank you! Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of 2024: Sales in units 17,000 Sales price per unit $48.00 After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) $45,000 Rent Expense (per quarter) $27,000 Depreciation Expense (per quarter) $36,000 Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Total Cost Units Quarter 1 $67,000 12,500 Quarter2 $94,000 21,000 Quarter 3 $89,800 13,800 Quarter 4 $92,600 20,000 2023 Quarter 1 $72,500 13,700 Quarter2 $80,000 14,000 Quarter 3 $84,000 14,300 Quarter…
The controller of the Stump Company is preparing the budget for 2021 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are: LOADING... (Click the icon to view the information.) Requirements 1. Estimate the cost function for delivery. 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. Requirement 1. Estimate the cost function for delivery. Delivery costs = + ( × ) Delivery costs = + ( × ) Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain. The cost function in requirement 1 is an estimate of how costs behave ▼ outside of within the relevant range, not at cost levels ▼ outside within the relevant range. If there are no months with zero miles driven represented in the delivery cost…
Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Maintenance Machine Month Cost Hours $ 4,200 Jan. 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $43, 200 4,800 $ 3,600 $ $ $ 684.65 Average 400 Average cost per hour a (intercept) b (coefficient) 9.00 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105 At 400 hours of activity, Armer management can be approximately two-thirds confident that the maintenance costs will be in the range of
The information provided below was taken from the records of Chotoo Projects for the financialyear ended 31 May 2020.Extract of statement of comprehensive income for the year ended 31 May 2020RRevenue 480 000Direct costs 240 000Rent income 150 000Advertising 4 800Salaries and wages 90 000Rates and taxes 1 200Other operating expenses 80 000Additional information1. Revenue is calculated as direct cost plus 25%.2. Revenue is divided equally each month. Revenue is expected to increase by 18% for thefinancial year ending 31 May 2021.POSTGRADUATE DIPLOMA IN PROJECT MANAGEMENT – ACADEMIC AND ASSESSMENT CALENDARREGENT BUSINESS SCHOOL (RBS) January 2021 173. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtorsnormally pay their accounts as follows:• 40% in the month of the invoice, and these debtors are entitled toa 5% discount;• 55% one month after the invoice;The balance is usually written off as bad debts.4. Purchases for June and July are expected to be 30…
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted Information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) Required: $ 100.00 60.00 1,113,040 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $316,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $60 variable cost per unit the labor-cost component is $27. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is…
Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…