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.
Assume that the market for corn is perfectly competitive. Currently, firms growing corn are generating losses. In the long run, we can expect "some firms to exit causing the market price of corn to rise.".
<h3>What is perfectly competitive market?</h3>
According to economic theory, perfect competition exists when all businesses sell the same goods, market share has no bearing on prices, businesses can enter or quit the market without any obstacles, consumers have perfect or complete information, and businesses are unable to set prices.
There are five characteristics that have to exist in order for a market to be considered perfectly competitive. The characteristics are -
- homogenous items,
- no entry or exit obstacles,
- price taker sellers,
- transparent products, and
- no seller has any control over market prices.
The three key components of perfect competition are as follows:
- There are a lot of buyers and sellers in the market.
- These buyers and sellers are in competition with one another.
- The good being offered or purchased is uniform.
- Companies are free to enter or leave the market.
To know more about; Why is perfect competition the best form of market structure?, here
brainly.com/question/4190313
#SPJ4
Answer:
a. FIFO - Inventory Used: $39900 Remaining Inventory: $14700
b. LIFO - Inventory Used: $41700 Remaining Inventory: $12900
c. Weighted Average Cost - Inventory Used: $40950 Remaining Inventory: $13650
Explanation:
Jan 01. Beginning inventory = 40 x $165 = $6600
Aug 13. Purchases 200 x $180 = $36000
Nov 30. Purchases 60 x $200 = $12000
Ending inventory = 75 units
Inventory Used = 300 – 75 = 225
(a) First-In-First-Out (FIFO)
This is the method where the inventory first received is the one that is used first. Common method when the inventory is perishable and would be wasted if left too long.
Inventory Used:
40 x $165 = $6600
185 x $180 = $33300
Total = $39900
Remaining Inventory:
15 x $180 = $2700
60 x $200 = $12000
Total = $14700
(b) Last-In-First-Out
Method whereby the inventory received latest is used first. Common in goods that are bulky. the inventory on top (latest purchased) is used first.
Inventory Used:
60 x $200 = $12000
165 x $180 = $29700
Total = $41700
Remaining Inventory:
40 x $165 = $6600
35 x $180 = $6300
Total = $12900
(c) Weighted Average Cost
This is whereby you divide the cost of goods sold by the number of units available for sale.
54,600 / 300 = $182
Inventory Used: 225 x $182 = $40950
Remaining inventory = 75 x $182 = $13650
Answer:
Life cycle assessment
Explanation:
Life cycle assessment is a technique that is used to analyse the environmental impacts of products from the design stage through end life. This assessment technique helps to examine the environmental impacts of products throughout their lives. It consists of 5 stages of material extraction, manufacturing, packaging and transportation, use and end of life. This analysis is carefully designed to effectively estimate the environmental impacts.
