Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

image text in transcribedimage text in transcribed

Shannon 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: (Click the icon to view the cost and other data) Read the requirements. Cost function Maintenance Mixed Explanation The cost neither remains constant in total nor remains constant per unit. Although the cost driver varies from month to month, the total cost remains constant. The cost per unit remains constant each month. Health insurance Fixed Shipping costs Variable 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 y = a + bx Health insurance y = a Shipping costs y = bx Now determine the cost function for each cost. (Enter all values in the same format as the general linear formula. If a box is not used in the equation, leave the box empty; do not enter a zero or select a label.) Cost function Maintenance y = + Health insurance y = + Shipping costs + y = Maintenance Costs Machine Hours Health Insurance Number of Employees Shipping Costs Month Units Shipped 4,510 158 $ 8,550 65 $ 24,208 7,120 January February 4,473 110 $ 8,550 82 $ 28,220 8,300 March 4,615 237 $ 8,550 91 $ 26,996 7,940 April 4,840 313 $ 8,550 104 $ 22,066 6,490 May 5,160 468 8,550 84 $ 20,162 5,930 June 4,715 290 8,550 91 $ 31,552 9,280 4,905 347 $ 8,550 86 $ 29,580 8,700 July August 4,967 366 $ 8,550 90 $ 28,764 8,460 5,011 421 $ 8,550 97 $ 22,814 6,710 September October November 5,245 470 $ 8,550 110 $ 24,310 7,150 5,370 500 8,550 98 $ 18,734 5,510 December 4,710 279 8,550 95 $ 32,742 9,630 Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

15th edition

978-0077522940

Students also viewed these Accounting questions