Question
In: Accounting
month units total cost april 8000 27400 may 6400 25800 june 3800 18300 july 5600 23200...
|
||||||||||||||||||||||||||||
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 1 year agoRelated 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
Latest Questions
- Based on the loanable funds theory, explain how each of the following changes should impact interest...
- research paper: each student will be responsible for writing an argumentative research paper discussion a topic...
- In java based on the classes provided finish the program per the requirements: ----------------------------------------------Class1 package cardgame;...
- Identify two cultures and analyze the nurturing process within each culture and discuss the impact the...
- Digital security is an increasing concern is the Internet age. In order to protect sensitive information...
- the challenges experienced by companies considering full application of customer retention strategy in the face of...
- Respond to the following in a minimum of 175 words: The flow of a program is...
ADVERTISEMENT