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
A process with completed and transferred out 28,000 units during a period and had 14,000 units in the ending work in process tha
mestny [16]

Answer:

35,000 equivalent units

Explanation:

Equivalent Units E.U) are notional whole units which represent incomplete work and are used to apportion costs between between work in progress and completed work.

To compute as

Equivalent Units = Degree of completion (%) × units

Items          Units            Workings                 E.U

Completed   28,000     28,000× 100%        28,000

Closing WIP     14,000     14,000 × 50%         7,000

Total equivalent units                                   35000

The total equivalents for conversion cost

= 28,000 + 7,000

= 35,000

8 0
3 years ago
Which of the following best describes the advantage of living in a suburban area? A. Suburbs give people access to city jobs alo
Fittoniya [83]

Answer:

Suburbs give people access to city jobs along with more living space. ( A )

8 0
3 years ago
If a country has a comparative advantage in the production of some good then A. that country can produce the good at a lower opp
djverab [1.8K]

Answer:

Explanation:

C.

6 0
3 years ago
1640s, the principal crop grown in barbados went from being tobacco to
Gnom [1K]
The answer is sugar cane. Tobacco, the crop on which the economy of the Lesser Antilles was originated, began to decline as a result of competition from Virginia tobacco. In 1613 John Rolfe had presented tobacco to Virginia, the earliest of the North American colonies. A variation imported from Trinidad proved very satisfactory. A new market force at work was the increasing demand for sugar in Europe. After the colonization of India and the Far East, coffee and tea were becoming gradually popular in Europe and hence the request for sugar as a sweetener for these drinks. A transatlantic voyage made the West Indies available to the European market. This journey was much easier than that which brought coffee, tea and spices to the European market. Chance also played a share. The Dutch and the Portuguese were struggling for Brazil between 1624 and 1654, and once the Dutch were winning, at least in Northern Brazil, they sent Portuguese prisoners of war north to the islands to be sold as slaves. In 1643 a Dutch ship transported fifty Portuguese slaves to Barbados. They were freed because the enslaving of Christians was not accepted, but Barbados had fifty laborers experienced in the growing of sugar available. Then, when the Portuguese started appealing back Northern Brazil from the Dutch, the Dutch move towards to the islands of the eastern Caribbean as expats, bringing with them their skill in sugar production.
3 0
3 years ago
Which of the following best describes the relationship between the computed mean and the actual​ mean? A. The computed mean is n
Alex777 [14]

Answer:

The computed mean is not close to the actual mean because the difference between the means is more than 5%.

Explanation:

Mean in statistics is the average used to get the central tendency of the data in the problem. This is the actual mean that we get by adding all the data points of a population and the dividing it is using the total. The computed mean is a guess or assumption of the actual mean, and it can be close to the actual mean or not.  

7 0
3 years ago
Other questions:
  • Hale Company sells merchandise on account for $1,000 to Long Company with credit terms of 2/10, n/30. Long Company returns $200
    7·1 answer
  • The economic significance of successful ticket scalping (scalpers sell tickets at higher than official prices) at baseball games
    12·1 answer
  • Prepare journal entries to record each of the following sales transactions of a merchandising company. The company uses a perpet
    6·1 answer
  • A weekly time ticket for Joyce Caldwell follows: Direct Labor Time Ticket Dates: Monday 8/13 − Friday 8/17, 2018 Ticket Number:
    6·1 answer
  • the ongoing responsibilities of the security manager. What other components of security management, as outlined by this model, c
    15·1 answer
  • Questions and Problems
    7·1 answer
  • What is interest based upon?
    8·1 answer
  • Account balance of 1723.57 the interest rate of the account is 3.4% compounded daily. If the account was opened 9 years ago, wha
    13·1 answer
  • Fluno Corporation has 1 million shares outstanding at the end of fiscal 2005. Its stock is trading at $15 per share. It issued $
    9·1 answer
  • Aneko is a media buyer with simantel, an advertising agency. Aneko typically purchases radio and television commercial time slot
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!