Statler Corporation wants to find an equation to estimate some of their monthly operating costs for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Statler Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2021. The following cost and other data were gathered for 2020: (Click the icon to view the cost and other data) Read the requirements. ... Data table Requirement 1. Which of the preceding costs is variable? Fixed? Mixed? Explain. Cost Cost function Maintenance Explanation Month Costs Machine Health Hours Insurance Number of Shipping Employees Costs Shipped Units Maintenance Mixed The cost neither remains constant in total nor remains constant per unit. January Health insurance Shipping costs Fixed Variable Although the cost driver varies from month to month, the total cost remains constant. The cost per unit remains constant each month. February 4,570 160 $ 8,560 4,430 115 61 $ 20,677 7,130 8,560 83 March 4,680 227 $ 8,560 98 Health insurance y = a + bx y = a y = bx Requirement 2. Using the high-low method, determine the cost function for each cost. Begin by selecting the general formula that represents the linear cost function for each cost. Maintenance April 4,830 306 $ 8,560 107 May 5,195 464 $ 8,560 88 $ 24,012 8,280 $ 22,968 7,920 $ 18,792 6,480 17,081 5,890 June 4,751 276 $ 8,560 91 $ 26,854 9,260 July 4,912 348 $ EA 8,560 89 $ 25,346 8,740 Shipping costs Now determine the cost function for each cost. (Enter all values in the same format as the general linear formula. If an input field is not used in the Cost function August September October November Maintenance y = 5230 + 2x per machine hour Health insurance y = + per employee Shipping costs y = + per unit shipped December EA 4,932 368 5,033 423 5,211 470 5,230 515 $ 4,751 274 $ EA 8,560 84 $ 24,534 8,460 8,560 97 $ 19,662 6,780 8,560 113 EA 8,560 90 $ 16,327 $ 20,793 7,170 5,630 EA 8,560 93 86 $ EA 28,014 9,660 Print Done - Statler Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2021. The following cost and other data were gathered for 2020: (Click the icon to view the cost and other data) Read the requirements. ... Data table Requirement 1. Which of the preceding costs is variable? Fixed? Mixed? Explain. Cost Cost function Maintenance Explanation Month Costs Machine Health Hours Insurance Number of Shipping Employees Costs Shipped Units Maintenance Mixed The cost neither remains constant in total nor remains constant per unit. January Health insurance Shipping costs Fixed Variable Although the cost driver varies from month to month, the total cost remains constant. The cost per unit remains constant each month. February 4,570 160 $ 8,560 4,430 115 61 $ 20,677 7,130 8,560 83 March 4,680 227 $ 8,560 98 Health insurance y = a + bx y = a y = bx Requirement 2. Using the high-low method, determine the cost function for each cost. Begin by selecting the general formula that represents the linear cost function for each cost. Maintenance April 4,830 306 $ 8,560 107 May 5,195 464 $ 8,560 88 $ 24,012 8,280 $ 22,968 7,920 $ 18,792 6,480 17,081 5,890 June 4,751 276 $ 8,560 91 $ 26,854 9,260 July 4,912 348 $ EA 8,560 89 $ 25,346 8,740 Shipping costs Now determine the cost function for each cost. (Enter all values in the same format as the general linear formula. If an input field is not used in the Cost function August September October November Maintenance y = 5230 + 2x per machine hour Health insurance y = + per employee Shipping costs y = + per unit shipped December EA 4,932 368 5,033 423 5,211 470 5,230 515 $ 4,751 274 $ EA 8,560 84 $ 24,534 8,460 8,560 97 $ 19,662 6,780 8,560 113 EA 8,560 90 $ 16,327 $ 20,793 7,170 5,630 EA 8,560 93 86 $ EA 28,014 9,660 Print Done -
Expert Answer:
Related Book For
Horngrens Cost Accounting A Managerial Emphasis
ISBN: 978-0134475585
16th edition
Authors: Srikant M. Datar, Madhav V. Rajan
Posted Date:
Students also viewed these accounting questions
-
Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017: Required 1....
-
Three brothers, Daniel, David and Derrick have been discussing their respective taxation affairs and how much they dislike paying tax. None of them are Scottish taxpayers. Daniel's income for tax...
-
Petroleum waste contamination. Accidental spillage and misguided disposal of petroleum wastes have resulted in extensive contamination of soils across the country. A common hazardous compound found...
-
Refer to Problem 15.6. For marginal homogeneity, explain why the minimum modified chi-squared estimates are identical to WLS estimates. Data from Problem 15.6: Consider marginal homogeneity for an I ...
-
Show that the stochastic process \[e^{\int_{0}^{t} c(s) d B_{s}-\frac{1}{2} \int_{0}^{t} c^{2}(s) d s}\] is a martingale for any deterministic function \(c(t)\). Does the result change if \(c(t,...
-
Rebecca S. Dukat arrived at Mockingbird Lanes, a bowling alley in Omaha, Nebraska, at approximately 6:00 P.M. to bowl in her league game. The bowling alleys parking lot and adjacent sidewalk were...
-
make 1 paragraph in the abstract below, with the journal name Optimizing the thermal management system of PCM fin-structured Li-ion batteries under mechanical vibration conditions: A comparative...
-
Pharoah Electronics issues a $393,500, 5%, 15-year mortgage note on December 31, 2019. The proceeds from the note are to be used in financing a new research laboratory. The terms of the note provide...
-
The late Mr. Loyola's Gross Estate has been valued at P56,000,450 and the 5,000,000 standard deduction is being availed alongside P500,000 worth of funeral expenses without receipts. How much is the...
-
Blossom corporation north divison generates operaing income of 123000 on 923000 in sales. The cpmaony had 423000 in assets at the beginning of the year and 47300 at the end of the year. What is the...
-
25% Rate x Income before Income Taxes is $118,875, Income Before Income Taxes is $475,500 and Total Income is $689,500. What is net income and net income%?
-
1. A person deposits $5000 into an account which pays interest at a rate of 8% per year. The amount in the account after 10 years will be? 2. A chemical engineer believes that by modifying the...
-
You buy a new Ford F150. The tires that come with the truck are final goods. intermediate goods. transfer goods. financial goods
-
Bullying needs to be able to be defined in behavioral terms so that a workplace bullying policy can move from a concept to an opera-tional reality. If bullying could be behaviorally defined, the...
-
Use this circle graph to answer following Exercises. 1. What fraction of areas maintained by the National Park Service are designated as National Recreation Areas? 2. What fraction of areas...
-
The circuit in Figure P32.96 represents your planned design for a wall power supply that will run a radio that usually runs on a 9-V battery. The power supply uses a transformer (not shown) to...
-
Your boss has purchased a new AC power source to run a high-voltage, low-current display, but it is not working. While he is fuming, you look at the owner's manual and discover that this power source...
-
Construct a phasor diagram representing the current and potential difference in Figure 32. 10 at \(t=T / 4, T / 2\), and \(3 T / 4\). Data from Figure 32.10 Ve maximum, current zero Ve minimum,...
Study smarter with the SolutionInn App