Month	Labor Hours	Machine Hours	OH Costs	Units Mfg'd
January	1,262	1,752	$226,704	5,256
February	962	1,362	$195,158	4,086
March	1,318	2,238	$229,283	6,714
April	1,280	2,205	$235,735	6,615
May	942	2,013	$220,021	5,652
June	1,188	2,205	$225,248	6,615
July	1,114	1,845	$212,357	5,535
August	1,006	1,773	$209,447	5,319
September	1,344	1,641	$223,154	4,923
October	1,196	1,971	$226,687	5,913
November	760	1,752	$200,362	4,560
December	792	2,229	$203,959	4,752
Totals	13,164	22,986	$2,608,113	65,940

What is the estimated variable cost per labor hour?						Q1
What is the estimated monthly fixed overhead cost?						Q2
Forecast monthly overhead costs for a month when labor hours are equal to				1,100		Q3
What is the average number of labor hours per unit?						Q4
What is your estimate of the variable overhead cost per unit?						Q5

all information is given.

Excel File Edit View Insert Format Tools Data Window Help 67% Fri 2-22 PM a E 911 A1 Cost Estimation (11 Share Home Insert Page Layout Formulas Out Paling Pure Data Review View A-A Custom 29 Dancial For Formatting Table Styles Del For S. C H 1 Labor Hours 1.22 Units Migd 1,318 1.240 US 6,714 017 A . 2 Data Table 3 Month January 5 February March April May June 10 July 11 August 13 September 13 October 14 November ts December 16 Total Machine Hours 1712 1.362 $ 2,2385 2,2055 2,013 5 2,2055 1.8455 1773 $ OH Costs 226,704 195.158 229,283 235735 220,021 22528 212,357 2019,412 223,154 226,687 200,362 203.050 1,188 1,114 1,006 1,344 1.196 70 792 13,164 615 1.971 $ 1.752 4,923 5913 4.50 4,252 Use the light blue ces above to show the results of running a linear regression 20 M 21 Min 224 the there are to show your Willow calculations V Before you answer the required questions that you go to the data worksheet. There I have autol data that is related, but different to the data displayed in the Question workshet. You wil also weaXY scatter graph that includes a trendline It is always a good idea to start your data analysis by looking at the raw data to check for outlers and also to see if there are any evious trends You can change the value of the displayed scatter graph by selecting the graph and then on the Date Chart Source This will bring up a pop up window. Select the X-vale bon and then pick a new range of calls. The Scatter plot wil update automatically. Since I set the plot up to include a trendine and the quation of the trend ine you will also see the results of a simple linear regression of the form 26 Data Table 1 to answer the following Questions The following assumptions apply under an altomative specifically given in a question The Sales Price per unit Direct materials and direct labor costs per unit. 1 Variable General and Administrative costs per unit $ 74.00 19.00 14.00 + Select destination and press ENTER or choose Paste 16 A