Sql has built-in functions, which are also called ____________________ functions.
1 answer:
You might be interested in
Answer:
a. The value of ending Inventory using FIFO is $2749.
b. The value of ending Inventory using LIFO is $2667.
c. The value of ending Inventory using Average Cost method is $2713.
We have:
Date Explanation Units unit cost Total Cost
Sep-01 inv 11 97 1067
Sep-12 purchases 44 100 4400
Sep-19 purchases 47 101 4747
Sep-26 purchases 22 102 2244
Total 124 12458
Novak sold 97 snowboards, so the number of snowboards with it at the end of September is .
If Novak adopts First In First Out (FIFO) method, and 27 units are remaining, all 22 units purchased on Sept-26th and from the purchases made on Sept-19th will remain in inventory.
So the value of inventory using FIFO will be
If Novak adopts Last In First Out (LIFO) method, all 11 units in inventory on Sept-01st and from the purchases made on Sept-12th will remain in inventory.
Hence inventory value using LIFO will be
We calculate the Average cost by dividing the Total Cost by total number of units purchased.
The value of inventory using the average cost method is .
Answer:
$633,000.
Explanation:
We use the High-low method to get the cost formula:
This means 5,000 machine hours generate 140,000 labor cost
We divide and get the variable cost generate per machine hour:
Cost 140000
machine hours 5000
140,000/5,000 = 28
variable cost 28
Next, we use this to calculate the fixed cost:
total cost = variable cost + fixed cost
fixed cost = total cost - 28 X DL
<u>High:</u>
Total Cost 710,000
Variable 399,000 (14,250 x 28)
Fixed Cost 311,000
<u>Low:</u>
Total Cost 570,000
Variable 259,000 (9,250 x 28)
Fixed Cost 311,000
Now with the cost formula we solve for 11,500 machine hours
cost = 311,000 + 28 X Machine Hours
cost = 311,000 + 28 x 11,500
cost = 633,000