It's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19,670 460 August $20,940 560 September $19, 430 400 October $20,020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.

It's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19,670 460 August $20,940 560 September $19, 430 400 October $20,020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 5CE: Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and...

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?
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.
Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Using Multiple Regression Results to Construct and Apply a Cost Formula The controller for Dohini Manufacturing Company felt that the number of purchase orders alone did not explain the monthly purchasing cost. He knew that nonstandard orders (for example, one requiring an overseas supplier) took more time and effort. He collected data on the number of nonstandard orders for the past 12 months and added that information to the data on purchasing cost and total number of purchase orders. Month Purchasing Cost Number of Purchase Orders Number of Nonstandard Orders January $18,860 370 53 February 18,065 330 35 March 19,250 370 61 April 18,050 410 14 May 19,345 400 73 June 19,500 450 55 July 19,670 460 30 August 20,940…
Check my work 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 63.00 1,227,327 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 $332,001 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $63 variable cost per unit the labor-cost component is $29. 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…
It's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19,670 460 August $20,940 560 September $19,430 400 October $20,020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.
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…
Click Draperies makes and sells curtains. Information related to its performance in 2020 is given below: (Click the icon to view the data.) Calculate Click Draperies' flexible budget for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income. Calculate Click's flexible budget for (a) revenues. Begin by determining the formula and then solve for the amount. Flexible budget for revenues X X Data table Units made and sold Selling price Variable costs Fixed costs $ Actual = = 1,560 $220 per curtain 168,000 77,000 $ Budgeted I X 1,460 $232 per curtain $108 per curtain 73,000
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…
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.
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) $ 100.00 70.00 1,200,000 Required: 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 $300,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $70 variable cost per unit the labor-cost component is $25. 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…
Explaining why companies use performance evaluation systems Financial performance is measured in many ways. Requirements Explain the difference between lag and lead indicators. The following is a list of financial measures. Indicate whether each is a lag or a lead indicator: An income statement shows net income of $100,000 Listing of next week’s orders of $50,000 The trend showing that average hits on the redesigned Web site are increasing at 5% per week Price sheet from vendor reflecting that cost per pound of sugar for the next month is $2 Contract signed last month with a large retail store that guarantees a minimum shelf space for Grandpa’s Overloaded Chocolate Cookies for the next year