month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200...

month	units	total cost
april	8000	27400
may	6400	25800
june	3800	18300
july	5600	23200
august	7000	26000
september	8400	29800
october	7800	26500
november	6800	25700

using the gleason products data from above perform a LEAST REGRESSION ANALYSIS on the data ( use excel to perform analysis)

a) what is Gleasons total fixed cost?

b) what is Gleasons varaiable cost per unit?

c) what would total cost be for a month with 7500 units produced?

d) what proportion of varaiation in Gleasons cost is explained by a varaince in production?

Solutions

Expert Solution

Feel free to ask any clarification if required. Please provide feedback by thumbs up if satisfied. It will be highly appreciated. Thank you.

ekkarill92 answered 11 months ago

Next > < Previous

Related Solutions

Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June...

Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June 40,000 units July 30,000 units August 20,000 units Cash Collections 60% collected in month of sale 40% collected in the month after sale Accounts receivable at the end of March is $25,000 and it will be collected in April Production Budget Ending inventory is 25% of next month’s budgeted sales On March 31st there were 5,000 units on hand Direct Materials Budget 5 pounds...

Cost Behavior Assume a local pizzeria reported the following results for June and July April May...

Cost Behavior Assume a local pizzeria reported the following results for June and July April May Unit Sales 2,000 3,000 Cost of Food Sold $ 8,000 $ 12,000 Wages and Salaries 3,700 4,000 Rent 2,000 2,000 Depreciation 500 500 Utilities 1,400 1,500 Supplies 200 300 Total $ 15,800 $ 20,300 a. Identify each cost as being fixed, variable or mixed. b. Determine the equation for total operating costs...

Tipp Topp Company reports the following for the month of June. Units Unit Cost Total Cost...

Tipp Topp Company reports the following for the month of June. Units Unit Cost Total Cost June 1 Inventory 300 $5 $1,500 12 Purchase 450 6 2,700 23 Purchase 750 7.60 5,700 30 Inventory 160 Compute the cost of the ending inventory and the cost of goods sold under (1) FIFO and (2) LIFO. FIFO LIFO Ending inventory $ $ Cost of goods sold $ $ LINK TO TEXT Compute the cost of the ending inventory and the cost of...

Humphries Company reports the following for the month of June. Date Explanation Units Unit Cost Total...

Humphries Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 200 $5 $1 000 12 Purchase 300 6 1 800 23 Purchase 500 7 3 500 30 Inventory 160 Instructions Assume a sale of 400 units occurred on 15 June for a selling price of $8 and a sale of 440 units on 27 June for $9. Assume that a perpetual inventory system is used. Using FIFO, calculate: (a) the...

Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total...

Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 225 $5 $1,125 12 Purchase 375 6 2,250 23 Purchase 500 7 3,500 30 Inventory 180 A) Compute the cost of the ending inventory and the cost of good sold under (1) FIFO, (2) LIFO, (3) average cost B) Which costing method gives the highest ending inventory? the highset cost of goods sold? why? C) How do the average cost...

Pronghorn Corp reports the following for the month of June. Date Explanation Units Unit Cost Total...

Pronghorn Corp reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 120 $5 $600 12 Purchases 346 6 2,076 23 Purchases 189 7 1,323 30 Inventory 229 A sale of 375 units occurred on June 15 for a selling price of $8 and a sale of 51 units on June 27 for $9. Calculate the average cost per unit, using a perpetual inventory system. (Round answers to 3 decimal places, e.g....

Headlands Industries reports the following for the month of June. Date Explanation Units Unit Cost Total...

Headlands Industries reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 132 $5 $ 660 12 Purchases 392 6 2,352 23 Purchases 190 7 1,330 30 Inventory 235 Calculate weighted-average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average unit cost $enter a weighted-average unit cost in dollars eTextbook and Media Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO,...

Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total...

Plato Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 225 $5 $1,125 12 Purchase 525 6 3,150 23 Purchase 750 7 5,250 30 Inventory 330 Instructions (a) Calculate the cost of the ending inventory and the cost of goods sold for each cost flow assumption [LIFO,FIFO], using a perpetual inventory system. Assume a sale of 570 units occurred on June 15 for a selling price of...

Johnson Company reports the following for the month of June. Date Explanation Units Unit Cost Total...

Johnson Company reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 225 $5 $1,125 12 Purchase 525 6 3,150 23 Purchase 750 7 5,250 30 Inventory 280 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average cost. (Round average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 2,520.) FIFO LIFO AVERAGE COST Ending...

Kingbird, Inc. reports the following for the month of June. Date Explanation Units Unit Cost Total...

Kingbird, Inc. reports the following for the month of June. Date Explanation Units Unit Cost Total Cost June 1 Inventory 400 $6 $2,400 12 Purchase 800 7 5,600 23 Purchase 600 8 4,800 30 Inventory 200 Assume a sale of 880 units occurred on June 15 for a selling price of $9 and a sale of 720 units on June 27 for $10. Calculate the cost of the ending inventory and the cost of goods sold for each cost flow...

Subjects