USES ( APPLICATIONS) of spreadsheet are;
1) to create budgets : Excel can be used in creation of budget s which is the estimation of revenue as well as expenses which covers specified future period of time.
2)produce graphs and charts: it's application is helpful in creating graphs in mathematics as well as statistics
3 for storing and sorting data: Data sorting can be done using spreadsheet. It involves arrangements of data into an order in order to make analysis of the data easier.
SPREADSHEET APPLICATION
1)Microsoft Excel : This is used in data
crunching , it can handle large data sets.
2)LibreOffice : it's applicable in Calc for a free as well as native spreadsheet app.
4) Smartsheet: is useful when handling
task involving non-spreadsheet and can be used for project management.
5)Quip : it's useful for integration of
spreadsheets into shared documents.
Answer:
Estimated manufacturing overhead rate= $30.5 per direct labor hour
Explanation:
Giving the following information:
Direct labor-hours= 79,000 labor-hours.
The estimated variable manufacturing overhead was $11.90 per labor-hour and the estimated total fixed manufacturing overhead was $1,469,400.
To calculate the predetermined manufacturing overhead rate we need to use the following formula:
Estimated manufacturing overhead rate= total estimated overhead costs for the period/ total amount of allocation base
Estimated manufacturing overhead rate= (1,469,400/79,000) + 11.9= $30.5 per direct labor hour
Answer:
Debit : Allowance for doubtful debts = $2900
Credit : Accounts receivables = $2900
Explanation:
An account for allowance for doubtful debts is a contra account created, predicting that certain debtors will not be able to pay for the goods and services they purchased. This may be based on historical experiences. Doubtful debts aren’t officially uncollectible, it is simply an estimation made, but bad debts are, where you have officially written off a certain accounts receivable as uncollectible.
An allowance for doubtful debts is recorded in the balance sheet, directly under accounts receivables. Bad debts are recorded as an expense in the income statement. When there is an allowance for doubtful debts, the bad debts account is debited and the allowance for doubtful debts account is credited.
According to the question, the balance was $2,200 (Cr) in the allowance for doubtful debts account. The initial expected amount for allowance for doubtful debts was $5100 (Cr). This means that the difference was the amount that was declared as uncollectible and officially written off i.e. bad debts. Thus $2900 ($5100 -$2200) would have been confirmed as bad debts.
The entry to record the above transaction is:
Debit : Allowance for doubtful debts = $2900
Credit : Accounts receivables = $2900
Answer:
B) firms reduce hours before laying off when the economy is in recession, and increase hours before hiring when the economy expands.
Explanation:
In the case when the output falls so the workers would not be laid off in a direct manner. In the first time the labor would be decreased so that the demand could be analyzed. The same would be happen in that case also where the growth picked up
Therefore in the given case, the option B is correct
And the other options are wrong
Answer:
$80,160.
Explanation:
An account receivable is lawfully enforceable cases for installment, held by a business for the products provided and benefits that clients/customers have requested yet not paid for.
According to Rahal's autos noncollectable accounts and the amount they received in the following year. Rahal's collectible accounts on December 31, 2021, is
86,500 + 404,000 - 408,000 - 2,340
