g "With respect to the types of information systems used in organizations, financial, operations, and human resource management
1 answer:
You might be interested in
Answer:
the formula in cell F5 =IF(AND(B5="FT",C5>0),0.07*(D5-E5),0.05*(D5-E5))
Explanation
Check attachment for the given data and solution data
Answer:
Explanation:
In the income statement, the total revenues and the total expenses are recorded.
If the total revenues are more than the total expenditure then the company earns net income
And, If the total revenues are less than the total expenditure then the company have a net loss
This net income or net loss would reflect in the statement of the retained earning account.
The preparation of the income statement is presented in the spreadsheet. Kindly find the attachment below:
Answer:
93 units
Explanation:
Annual demand for an item = 11,000 units
cost per unit = $250
holding rate = 10%
Order cost = $14.00 per order
No. of days in a year = 260
Lead-time = 2 days
= 42.3 units
For a service level of 97%, the value of z is 1.881
Therefore,
Reorder point:
= Average daily demand × Lead time + Standard deviation of the daily demand × no. of standard deviation corresponding to service level probability ×
= (42.3 × 2) + (3 × 1.88 × )
= 92.57
= 93 units