Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
Answer:
Income under absorption costing = $1,100,000
Explanation:
Marginal and absorption costing are two different methods to deal with fixed production overheads and and decide whether or not they are included in valuation of inventory.
<u>Valuation of inventory</u>
Opening and closing inventory are valued at variable cost under variable costing. Whereas in absorption costing, opening and closing inventory are valued at full production cost (including fixed production overheads).
<u>Reconciling profits reported under two different methods</u>
When inventory levels increase or decrease during a period then profits will differ under absorption and marginal costing because of fixed production cost.
Net Income under absorption costing = Income under variable costing + fixed production cost in ending inventory – fixed production cost in beginning inventory
= $1,050,000 + $300,000 - $250,000
= $1,100,000
Answer:
variable costs
manufacturing supplies =$14000
production supervisor wages=$135,000
power and light=$48000
production control wages=$32000
materials management wages=$39000
total=$268000
fixed costs
factory insurance =$30000
factory depreciation =$22000
<u>Total= $52000</u>