1) Using high-low method calculate and express the cost behavior in equation form2) Predict the energy cost for a month with production of 26,000 pints of apple sauce MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberApple SauceProduced (Pints)35,00021,00022,00024,00030,00032,00040,00030,00030,00028,00041,00039,000Energy Cost23,40022,10022,00022,45022,90023,35028,00022,80023,00022,70024,10024,950

The costs incurred for production are classified as fixed and variable Costs. The high low method…

Answered: Using high-low method calculate and…

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

Help
= Adam's Repair Shop has a monthly target operating income of $12,500. Variable expenses are 75% of sales, and monthly fixed expenses are $9,500. Hint: The contribution margin ratio= 100% - Variable expenses percentage of sales. Read the requirements. Requirement 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. Begin by identifying the formula to compute the margin of safety. = Margin of safety in dollars (Round intermediate calculations up to the nearest whole dollar and your final answer to the nearest whole dollar.) The margin of safety is Requirement 2. Express Adam's margin of safety as a percentage of target sales. Begin by identifying the formula to compute the margin of safety as a percentage of target sales. (Round the percentage to the nearest whole percent.) The margin of safety percentage is % of target sales. Requirement 3. What is Adam's operating leverage factor at the target level of operating income? Begin by identifying the…
Denger
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 2,500 $ 18,400 February 2,900 21,000 March 1,900 13,500 April 3,100 23,000 May 3,800 28,250 June 3,300 22,000 July 4,100 24,750 August 3,500 22,750 September 2,000 15,500 October 3,700 26,000 November 4,700 31,000 December 4,200 27,750 Summary Output Regression Statistics Multiple R 0.965 R Square 0.932 Adjusted R2 0.925 Standard Error 1,425.18 Observations 12.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 3,726.88 1,682.82 2.21 0.05 (22.69) 7,476.45 Machine Hours 5.77 0.49 11.7 0.00 4.67 6.87 The percent of the total variance that can be explained by the regression is:…
Develop an equation for total monthly production costs. Total Monthly Production costs = Fixed Costs + Variable Costs = _____________ + ($ per unit X Number of units) Predict total costs for a monthly production volume of 9,000 units.
K Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the unit price is $12; if more than 1,000 and up to 5,000 units are purchased, the unit price is $8.00; and if more than 5,000 units are purchased, the unit price is $7.50. Develop an Excel template using the VLOOKUP function to find the unit price associated with any order quantity and compute the total cost of the order. Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C8 to find the unit price for the order quantity. (Type integers or decimals rounded to two decimal places as needed.) 1 2 3 5 6 7 8 6 A B C Purchase Quantity 1 to 1000 1001 to 5000 5001 or more Quantity Ordered Unit Price Total Cost 2400 D Unit Price $ $ $
a) Compute the breakeven sales dollars of cach product assuming the same sales mix remains constant. b) Prepare an analysis showing whether Product Z should be eliminated. The amount of change to net income should be computed. c) Assume the current demand of cach product is same as the sales volume the company has for the year. Below is the machine processing time required for cach product. Product Machine processing time in hours i. How many units should the company produce for each product if there is a constraint of only 24.000 hours of machine processing time in the year. ii. Compute the highest possible net income camed by the company. 3 2 An accountant has prepared the folowing product-line income statement for the year: Product Tatal No of mts sokd 5,000 4,000 4,000 Saks Varible enpermes 200,000 S 120,000 100,000 S 60.000 40,000 S 20,000 60,000 40,000 20,000 Cotribution mangin 80,000 40,000 20,000 Fihed expenses Rert Depreciin 10,000 12,000 8,000 5.000 6,000 2,000 2,400 3,000…
Calculate per-unit costs and compare to last year. Are the reduced unit costs for Product A due to scale or scope? Product A last year Product B last year Units Production Cost Marketing Cost 100 50 200 80 2.5 4 Units Production Cost Marketing Cost Product A coming year 150 150 40 Product B coming year 200 80 2 3.2 a. The reduced per unit costs for product A are due to scale b. The reduced per unit costs for product A are due to scope c. We cannot be certain whether the reduced per unit costs for product A are due to scale or scope. d. The reduced per unit costs for product A are due to both scale and scope

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS

Using high-low method calculate and express the cost behavior in equation form 2) Predict the energy cost for a month with production of 26,000 pints of apple sauce