1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Y_Kistochka [10]
3 years ago
15

A TV manufacturing company uses speakers at the rate of 8000/mo. When it places an order for speakers it incurs a fixed cost of

$1200. The monthly interest rate for keeping a speaker in stock is assessed at 1%/mo. The cost of the speaker depends on the order size. If less than 1000 speakers are ordered the cost is $11 each. When the order size is between 1000 and 10,000 the cost is $10.50/unit. For order sizes between 10,000 and 30,000 the cost is $10 per unit. For order quantities between 30,000 and 80,000 the cost drops to $9.50. Beyond 80,000 the cost is $9.25. Determine the optimum order size and time between orders if shortages are not allowed.
Please use excel to solve this problem. Show all cell formulas and parameters used.
Business
1 answer:
sveticcg [70]3 years ago
7 0

Solution :

1. Ordering quantity         500      1000      10000     30000        80000

2. No. of orders                 16          8             0.8         0.27            0.1

3. Average inventory        250      500       5000      15000        40000

4. Value of average         2750    5250      50000  142500      370000

   inventory

5. Monthly total cost

a). Cost of material        88000   84000    80000   760000     740000

b). Ordering cost           19200      9600       960          320           120

c). Carrying cost                27.5       52.5       500        1425         3700

Total monthly cost        107227.5 93652.5  81460   77745       77820

Among the total monthly cost, $ 77,745 is the least cost.

Therefore, the optimum order size of quantity = 30,000

The number of orders per month = 8000/30000 = 0.267

Time between two consecutive orders = 30000/8000 = 3.75 months

     

You might be interested in
Which of the following is an advantage of a sole​ proprietorship?
Y_Kistochka [10]
Some of the advantages of sole proprietorship
1. efficient decision making, by owner only
2. easy to set up, minimal cost, minimal fuss
3. low fixed cost (overhead), could be a home-office

I might have missed others, you could figure them out from the options
4 0
3 years ago
If the owner of a concert hall wishes to use third-degree price discrimination to price its tickets at $20, $15, and $10, it sho
Anika [276]

Answer: more elastic in their demand for tickets

Explanation:

Third-degree price discrimination is used by company when different price is being charged to a particular group of consumers.

Based on the scenario in the question, the owner of the concert hall should price tickets lower for customers who are more elastic in their demand for tickets.

Elastic demand simply means that a little change in the price of the concert hall will lead to a higher change in the quantity demanded. In this case, when the price increases, such people will buy little tickets. Therefore, the prices should be set lower for these set of people as there will be a huge increase in demand when the price is lower.

3 0
2 years ago
Name the institution that makes it possible for investors to buy and sell shares in South Africa​
olga2289 [7]

Answer:

Johannesburg Stock Exchange

Explanation:

6 0
2 years ago
Nichols Enterprises has an investment in 250 bonds of Elliott Electronics that Nichols accounts for as a security available for
sweet [91]

Answer:

The value per bond must be $1000

Explanation:

The reason is that the short term investments must be valued at current fair market value which is $1000 per bond today so the perceived value of the unit bond which is $1200 per bond is irrelevant here.

The amount recorded = Number of bonds * Current market value

The amount recorded = 250 * $1000 = $250,000

3 0
2 years ago
Is a liability that represents the amount the company owes to others as a result of issuing a promissory note.
solong [7]

A note payable is a financial document considered a liability that represents that it records that the company that signs it has the obligation to pay on the specific date.

<h3>What is a note payable?</h3>

It is a document that commits its issuer (the company) to pay a certain amount, within a specific period.

Its characteristic is the exchange action, which refers to the document being returned to the subscriber in exchange for payment.

Therefore, we can conclude that a note payable is a financial document considered a liability that represents that it records that the company that signs it has the obligation to pay on the specific date.

Learn more about a note payable here: brainly.com/question/25738368

4 0
2 years ago
Other questions:
  • The decision-making process followed by consumers to maximize utility assumes thatA. consumers do not know how much marginal uti
    11·1 answer
  • You have decided to refinance your mortgage. You plan to borrow whatever is outstanding on your current mortgage. The current mo
    13·1 answer
  • A blackboard used during a presentation would NOT be considered a visual aid<br><br> true<br> false
    10·1 answer
  • When someone gets a small sum of money based on the service they gave is called a _____?
    13·2 answers
  • What are three ways you can learn more about a company, organization, potential employer, and/or the open position you are apply
    13·1 answer
  • "record revenue when goods or services are provided to customers" is the definition of which principle in accounting?
    11·1 answer
  • One of the disadvantages of the Six Sigma approach compared to the Kaizen approach is that: Select one: a. the lack of ownership
    5·1 answer
  • You are an executive with an internet merchandizing company. Azzamon Inc. You have been assigned the task of analyzing whether t
    7·1 answer
  • At Eady Corporation, maintenance is a variable overhead cost that is based on machine-hours. The performance report for July sho
    5·1 answer
  • What was seen as a sign of the most power and influence among European nations? industrialism imperialism nationalism militarism
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!