Answer:
Calculating the bill total for the week:
The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.
Explanation:
In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.
Answer:
285,000 common stock outstanding with a $8 par value
it declares 13% stock dividend
market price at $16
since the stock dividend is considered small (less than 20%), we use the market price to record it
December 1, 202x stock dividends are declared (37,050 stocks)
Dr Retained earnings 592,800
Cr Common stock dividends distributable 296,400
Cr Additional paid in capital 296,400
December 31, 202x, distribution of stock dividends
Dr Common stock dividends distributable 296,400
Cr Common stock 296,400
The purpose of the Federal Reserve cutting interest rates during a recession is to encourage borrowing (borrowing becomes cheaper) and in this way especially for companies they may spend more money then on improvements, new products etc so the economy theoretically will be stimulated to counteract the recession.
Answer:
<u>Contribution Margin Statement</u>
Sales revenue ($100 x 980) $98,000
Less Variable costs:
cost of goods sold ($58 x 980) $56,840
Commissions expense ($5 x 980) $4,900
Shipping expense ($3 x 980) <u>$2,940</u>
<u>$64,680</u>
Gross margin $33,320
Less Fixed costs:
Salaries expense $7,900
Advertising expense <u>$5,800</u>
<u>$13,700</u>
Net Profit <u>$19,620</u>
Answer:
Expected number of orders=31.6 orders per year
Explanation:
<em>The expected number of orders would be the Annual demand divided by the economic order quantity(EOQ).</em>
<em>The Economic Order Quantity (EOQ) is the order quantity that minimizes the balance of holding cost and ordering cost. At the EOQ, the holding cost is exactly the same as the ordering cost.</em>
It is calculated as follows:
EOQ = (2× Co D)/Ch)^(1/2)
Co- ordering cost Ch - holding cost, D- annual demand
EOQ = (2× 10 × 100000/2)^(1/2)= 3162.27 units
Number of orders = Annual Demand/EOQ
= 100,000/3,162.27= 31.62 orders
Expected number of orders=31.6 orders per year