Month Labor Cost Employee Hours January $7,200 420 February 8,340 610 March 10,099 700 April 9,987 670 May 8,690 540 June 7,650 410 July 9,690 630 August 7,731 370 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $5,076 + ($7.18 × Employee Hours) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below X Open spreadsheet Required: Assume that 3,900 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. Round your answer to the nearest whole dollar. 2. Calculate total fixed labor cost for the year. Round your answer to the nearest whole dollar.

Month Labor Cost Employee Hours January $7,200 420 February 8,340 610 March 10,099 700 April 9,987 670 May 8,690 540 June 7,650 410 July 9,690 630 August 7,731 370 Assume that this information was used to construct the following formula for monthly labor cost. Total Labor Cost = $5,076 + ($7.18 × Employee Hours) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below X Open spreadsheet Required: Assume that 3,900 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. Round your answer to the nearest whole dollar. 2. Calculate total fixed labor cost for the year. Round your answer to the nearest whole dollar.

Intermediate Algebra

19th Edition

ISBN:9780998625720

Author:Lynn Marecek

Publisher:Lynn Marecek

Chapter12: Sequences, Series And Binomial Theorem

Section12.3: Geometric Sequences And Series

Problem 12.57TI: What is the total effect on the economy of a government tax rebate of $1,000 to each household in...

See similar textbooks