Answer:
The three-dimensional formula that would give you the required result, that is suming the diesel fuel expenditures, which are always recorded in cell D18 for the months of August through December is:
=SUM(August:December!D18).
Explanation:
First, enter the excel starting formula "=SUM(". Type "August" or left-click on the August sheet with the mouse. Type in colon and December or hold the Shift key and left-click on the December sheet. Then, select the cell C3 in the December sheet. Before pressing "Enter," add a closing bracket. The sum formula looks exactly like this: "=SUM(August:December!D18)." This formula can completely be typed manually. The formula sums up cell D18 across each of the sheets from August to December, returning a value.
45 quarters +120 dimes = 165 coins
45(.25) + 120(.05) =
11.25 + + 12.00 = 23.25
There are 45 quarters and 120 dimes.
Answer:
a. $738,000
Explanation:
Calculation for the cost of goods sold
Beginning Finished goods inventory $57,000
Add: Cost of goods manufactured $714,000
Goods available for sale $771,000
($714,000+$57,000)
Less Ending Finished goods inventory $33,000
Cost of goods sold $738,000
($771,000-$33,000)
Therefore the cost of goods sold will be $738,000
Answer:
$45,000
Explanation:
The Daily Grind sells coffee makers. Its inventory of coffee makers without timers cost $20,000 and has a net realizable value of $10,000. Its inventory of coffee makers with timers cost $35,000 and has a net realizable value of $35,000.
The amount that should be reported for Daily Grind's inventory is the net realizable values which is $10,000 + $35,000 = $45,000
<u>According to International Financial Reporting Standards, inventory should be valued at lower of cost and net realizable value. </u>
<u>Since the cost value of ''inventory of coffee makers without timers'' is higher than its net realizable value, it cannot be used.</u>