Question: 2. With the data below, find the fixed and variable parts of the monthly Wage cost, using the a) regression and b) max-min method.

2. With the data below, find the fixed and variable parts of the monthly Wage cost, usingthe a) regression and b) max-min me

2. With the data below, find the fixed and variable parts of the monthly Wage cost, using the a) regression and b) max-min method. Revenue (X) Wage (Y) 11,200 13,000 14,900 19,100 22,000 24,200 26,300 27,400 23,500 20,100 18,200 16,000 January February March April May June July August Septembe r October November December 5,300 6,100 6,200 7,000 9,000 9,600 9,700 10,100 8,300 7,600 8,000 7,100

Step by Step Solution

★★★★★

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Regression method The equation of a line is ymxb X Hours ytotal cost m N xy Ex yN x2 Ex2 Month Reven... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple...

Areas Michigan Ohio Indiana Wisconsin 2015 601 848 555 599 2016 480 833 700 675 2017 441 760 894 720 2018 500 711 893 855

Continuing Problem 2 with the data in the file P10_04.xlsx, employ stepwise regression to evaluate your conclusions regarding the specification of a regression model to predict the sales of deep-dish...

The controller of Terrance Corporation has asked for help in the selection of the appropriate activity measure to be used in estimating variable supplies cost for the company's budget. The following...

The Ramon Company is a manufacturer that is interested in developing a cost formula to estimate the fixed and variable components of its monthly manufacturing overhead costs. The company wishes to...

Liberty Bell Fitness, Inc. operates a chain of fitness centers in Philadelphia. The firms controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost...

Quinton Woodcraft Company (QWC) manufactures antique wooden cabinets to house modern televisions. QWC began operations in January of last year. Joe Quinton, the owner, asks for your assistance. He...

Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed in the section on moving averages in Table5.3. MONTH...

In Problem 12-45 in Chapter 12, Delaplane Computers supplier receives shipments of laptop screens from its manufacturing facility in the Philippines, which has maximum production rate of 200 units...

The U.S. Department of Agriculture publishes statistics on the production of various types of food commodities by month. Shown here are the production figures on broccoli for January of a recent year...

Analysis Component: If the Unearned Lawn Services of $93,200 had been recorded as a revenue when received instead of as a liability, what would the effect have been on the November 30, 2020,...

Rs. Direct materials 25,000 Indirect materials 5,000 Direct labour 30,000 Indirect labour 4,500 Factory overhead (excluding indirect materials and indirect labour) 15,000 Plant cost Required: Compute...

Yousif and his partner Hussain have decided to become a non-store retailer and would like to open a web-based retail store called Dee ReeTee which is specialized in selling unisex caps, hoodies, and...

Some health care facilities have initiated senior nurse/new graduate nurse mentoring programs in which junior staff receive informal advice and assistance from experienced staffers. Name the...

Elliott is quite the golfer and one day while playing a round of golf with some friends, he whacks his tee-shot into someone's back yard and hits the homeowner on the head with his golf ball. The...

Book: An Intro to Combustion 4th ed. by Turns and Haworth Rank these fuels in decreasing order of reactivity: H2, CH4, CO. For a given equivalence ratio, plot (qualitatively) the product gas...

i,ii,iii 2. The algorithm is to find the smallest of three numbers X, Y, Z. i) Based on the given algorithm below (Figure 1), draw the flowchart (1 mark) Step 1: Read the numbers X, Y, Z. Step 2: If...

Vince, Inc. has developed and patented a new laser disc reading device that will be marketed internationally. Which of the following factors should Vince consider in pricing the device? I. Quality of...

Divide a polynomial (x) = x5 5x4 + x3 - 6x2 7x + 10 by the monomial factor x 2.

The mast of a sailboat has a cross-sectional area of 10.65 cm2 and is constructed of an experimental aluminum alloy. Tests were performed to define the relationship between stress and strain. The...

The total drag on an airfoil can be estimated by D = 0.01?V 2 + 0.95/? (W/V) 2 Friction ? ? ? ? ? ? ? ? ? ? ? ?lift Where D = drag, ? = ratio of air density between the flight altitude and sea level,...

The Bureau of Labor Statistics, U.S. Office of Personnel Management, indicated that the average hourly compensation (salary plus benefits) for federal workers (not including military or postal...

Airgistics provides air consolidation and freightforwarding services for companies that ship their products internationally. As a part of its commitment to continuous process improvement, Airgistics...

Discuss the similarities and differences between a standard deviation and a standard error.