do not answer image format Required information[The following information applies to the questions displayed below.]This Applying Excel worksheet includes an explanation of the Goal Seek function and the PMT formula.Keeping all other data the same as in the original example, change the targeted operating income goal for the quarter, units sold forJanuary and February, and price per unit and variable expense per unit for all three months to match the information belowTargeted operating income for the quarter = $11,400Income StatementUnits SoldPrice per unitVariable expense per unitTotal number of units to sell in MarchJanuary1,140a SearchFebruary March890$ 6.00$6.00$6.00$ 2.00 $ 2.00 $2.00Required:2a. Using Goal Seek in Excel, determine the total number of units Jim needs to sell in March in order to meet his targeted operatingincome for the quarter. (Round your answer up to the nearest unit.)< Prev3Check mof 3Next

Contribution = Sales - variable cost Net operating income = Contribution - Fixed costs

Required information [The following information applies to the questions displayed below] This Applying Excel worksheet includes an explanation of the Goal Seek function and the PMT formula. Keeping all other data the same as in the original example, change the targeted operating income goal for the qua January and February, and price per unit and variable expense per unit for all three months to match the informati Targeted operating income for the quarter = $11,400 Income Statement Units Sold Price per unit Variable expense per unit January February March 1,140 890 Total number of units to sell in March $ 6.00 $6.00 $6.00 $ 2.00 $ 2.00 $2.00 Required: 2a. Using Goal Seek in Excel, determine the total number of units Jim needs to sell in March in order to meet his t income for the quarter. (Round your answer up to the nearest unit.) < Prev 9 3 of 3 Next

Required information [The following information applies to the questions displayed below] This Applying Excel worksheet includes an explanation of the Goal Seek function and the PMT formula. Keeping all other data the same as in the original example, change the targeted operating income goal for the qua January and February, and price per unit and variable expense per unit for all three months to match the informati Targeted operating income for the quarter = $11,400 Income Statement Units Sold Price per unit Variable expense per unit January February March 1,140 890 Total number of units to sell in March $ 6.00 $6.00 $6.00 $ 2.00 $ 2.00 $2.00 Required: 2a. Using Goal Seek in Excel, determine the total number of units Jim needs to sell in March in order to meet his t income for the quarter. (Round your answer up to the nearest unit.) < Prev 9 3 of 3 Next

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter3: Cost Behavior And Cost Forecasting

Section: Chapter Questions

Problem 54E: Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects...

See similar textbooks

Similar questions

Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
Contribution margin, break-even sales, cost-volume-profit chart, margin of safety, and operating leverage Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows: It is expected that 12,000 units will be sold at a price of 240 a unit. Maximum sales within the relevant range are 18,000 units. Instructions 1. Prepare an estimated income statement for 20Y7. 2. What is the expected contribution margin ratio? 3. Determine the break-even sales in units and dollars. 4. Construct a cost-volume-profit chart indicating the break-even sales. 5. What is the expected margin of safety in dollars and as a percentage of sales? (Round to one decimal place.) 6. Determine the operating leverage.
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
Bradshaw Company reported sales of 5,000,000 in 20X1. At the end of the fiscal year (June 30, 20X1), the following quality costs were reported: Required: 1. Prepare a quality cost report. 2. Prepare a graph (pie chart or bar graph) that shows the relative distribution of quality costs, and comment on the distribution. 3. Assuming sales of 5,000,000, by how much would profits increase if quality improves so that quality costs are only 3% of sales?
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects to sell 28,700 units at 32 each. Kallings controller provided the following information for the coming year: Required: 1. Calculate the cost of one unit of product under absorption costing. 2. Calculate the cost of one unit of product under variable costing. 3. Calculate operating income under absorption costing for next year. 4. Calculate operating income under variable costing for next year.
Sales Revenue Approach, Variable Cost Ratio, Contribution Margin Ratio Arberg Companys controller prepared the following budgeted income statement for the coming year: Required: 1. What is Arbergs variable cost ratio? What is its contribution margin ratio? 2. Suppose Arbergs actual revenues are 30,000 more than budgeted. By how much will operating income increase? Give the answer without preparing a new income statement 3. How much sales revenue must Arberg earn to break even? Prepare a contribution margin income statement to verify the accuracy of your answer. 4. What is Arbergs expected margin of safety? 5. What is Arbergs margin of safety if sales revenue is 380,000?
Total Pops data show the following information: New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next months requirements. Direct material requires 2 pounds per unit at a cost of $3 per pound. The ending inventory required for direct materials is 15% of the next months needs. In January, the beginning inventory is 3,000 units of finished goods and 4,470 pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.
The fixed overhead budgeted for Ranier Industries at an expected capacity of 500,000 units is 1,500,000. Variable costing is used internally, and the net income is adjusted to an absorption costing net income at year-end. Data collected over the last three years show the following: Determine the adjustment each year to convert the variable costing income to absorption costing net income. Compute the absorption costing net income for each year.
More-Power Company has projected sales of 75,000 regular sanders and 30,000 mini-sanders for next year. The projected income statement is as follows: Required: 1. Set up the given income statement on a spreadsheet (e.g., ExcelTM). Then, substitute the following sales mixes, and calculate operating income. Be sure to print the results for each sales mix (a through d). 2. Calculate the break-even units for each product for each of the preceding sales mixes.
Norris Company implemented a quality improvement program and tracked the following for the 5 years: By cost category of sales for the same period of time: Required: 1. Prepare a bar graph (hat reveals the trend in quality cost as a percentage of sales (time on horizontal axis and percentages on the vertical). Comment on the message of the graph. 2. Prepare a bar graph for each cost category as a percentage of sales. What does this graph tell you?
Aldovar Company produces a variety of chemicals. One division makes reagents for laboratories. The divisions projected income statement for the coming year is: Required: 1. Compute the contribution margin per unit, and calculate the break-even point in units. (Note: Round answer to the nearest unit.) Calculate the contribution margin ratio and use it to calculate the break-even sales revenue. (Note: Round contribution margin ratio to four decimal places, and round the break-even sales revenue to the nearest dollar.) 2. The divisional manager has decided to increase the advertising budget by 250,000. This will increase sales revenues by 1 million. By how much will operating income increase or decrease as a result of this action? 3. Suppose sales revenues exceed the estimated amount on the income statement by 1,500,000. Without preparing a new income statement, by how much are profits underestimated? 4. Compute the margin of safety based on the original income statement. 5. Compute the degree of operating leverage based on the original income statement. If sales revenues are 8% greater than expected, what is the percentage increase in operating income? (Note: Round operating leverage to two decimal places.)