Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started