Question

In: Accounting

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.


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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT