Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Statler Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2021. The following cost

image

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 -

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Cost Accounting A Managerial Emphasis

Authors: Srikant M. Datar, Madhav V. Rajan

16th edition

134475585, 978-0134475998, 134475992, 978-0134475585

More Books

Students also viewed these Accounting questions

Question

Where is the position?

Answered: 1 week ago

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago