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
Veronika [31]
3 years ago
5

You currently have 80 units of a product on the shelf. The demand for the product has been simulated as follows: Demand_Data.xls

x Sales are made to the extent that you have units in stock (for example, if the demand is for 65 units, then 65 units are sold; however, if the demand is for 135 units, then only 80 units are sold).
Demand_Data.xlsx (Following values correspond with each of the 200 rows)
65.2109419609769
36.3814378436655
12.0877429656684
42.5590896559879
82.2785877465503
63.8527707854519
63.4004335955251
15.8457750733942
71.0140411177417
70.8838469511829
17.5017830263823
55.8463070268044
72.5535427994328
83.9481016958598
77.4359377322253
51.6086528880987
61.2436578597408
41.7028003942687
61.3092779024737
57.1605268708663
63.4424295133795
105.393077268964
42.3098881077021
72.9272996471264
73.4634922485566
92.1699337998871
73.9350879887934
62.634502632427
75.1440792958601
78.2438873505453
132.73330654949
56.5183781366795
83.8099039759254
85.089108273969
79.8164036899107
87.0501152751967
41.0291376686655
63.5085725155659
84.9410880112555
59.0508206590312
56.5433210288757
59.7236421020352
65.8728722049273
73.6344772524899
49.9832039570902
47.852667143452
92.3204551730305
74.595608515956
66.5629058351624
32.4733391101472
97.4920239462517
74.2992041926482
9.96752891689539
85.1971107698046
110.769009501673
69.4912286638282
118.182118916884
80.9065695141908
66.242581801198
74.6631839722977
94.2071109823883
89.928620531573
59.5205746724969
104.95497367112
63.1786987872329
113.474574340507
47.0437170809601
79.1452875494724
82.0594904728932
45.6039869680535
97.7821527561173
65.7133240968687
58.5785200604005
84.1517375595868
41.9052539148834
63.9809640636668
78.9487002696842
85.280966181308
61.2992052486516
49.7980308358092
67.0680619298946
49.0870788274333
60.8445261098677
68.4155920174089
91.2059148907429
54.3580098968232
44.4463366369018
66.7196345096454
59.9047907092609
41.6861111664912
40.0889020459726
58.9671926212031
56.350849212613
65.2880671116873
75.5627424444538
48.9305093145231
35.4057319276035
71.0829808161361
32.9006197210401
86.8856786331162
77.7846607382526
104.655840863707
106.356141208671
48.7940851092571
72.7866462914972
61.3815372565296
95.9817170444876
51.57595655357
87.819729691837
85.2932898345171
27.4374669464305
52.1301571500953
79.2558366304729
82.1587163448567
97.4762896879111
42.4961980973603
78.3406121120788
62.3225004749838
69.8783550836379
69.651913640264
68.1852624841849
63.8094333629124
72.8979229682591
71.9960907593486
78.7327634901158
77.8358425525948
59.3799213168677
102.537536753807
75.808078640257
47.8837263875175
65.2613052300876
66.4013113640249
61.8226876616245
79.575478543411
91.3108705793275
96.5802555077244
32.6323187840171
63.5827418084955
42.1373114880407
76.5624135459075
89.248909666203
76.6884695115732
79.5514678832842
77.5245679909131
69.5065309121856
109.253427530639
61.218396644399
84.3726992973825
79.2933305495535
77.684093361604
9.07986208796501
65.9900151225156
67.2133537085028
97.0921646006173
55.312570061069
74.2412921175128
78.6738964455435
58.1307985560852
70.8149299901561
50.1941612531664
102.560546969762
69.0012838679832
71.4907982404111
107.142126529943
88.3843440026976
68.1837390805595
60.2680883678841
86.1327989189886
80.9313987195492
48.4910414746264
43.4493030700833
72.7449459594209
70.5454921847559
55.8600403968012
92.95628291904
50.2714683028171
56.9870862312382
127.145371101797
69.4912286638282
118.879155656323
80.3445017884951
119.5754648
54.8273546376731
76.6189386416227
57.2600028538727
94.6262061409652
80.7842652141699
88.6095803655917
59.0686012804508
64.1408532322384
53.0245542398188
55.6273007026175
101.024046620587
46.6278051538393
105.879475035472
113.218460632488
77.5130628829356
93.539587346022
89.7584540728712
71.5537125364062
Business
1 answer:
TEA [102]3 years ago
6 0

Answer:

how do you want the answer to be

Explanation:

???

You might be interested in
Which of the following is not a step in creating a debt payment plan? a. Rank all debts in the order in which you would like to
7nadin3 [17]

Answer:

b. Consolidate all credit cards onto a single card with a single interest rate.

Explanation:

When a debt payment plan is initiated then, it is decided according to the outstanding amounts, that which shall be paid first and the order of payment for remaining debts.

For this monthly income and expenses are to be evaluated, in order to decide how much payment shall be made accordingly, in each month.

But this entire process do not involve the step of aggregating all the cards so that there is only one card with the same payment. There is no relation to any such payment.

7 0
3 years ago
The project is expected to generate the following net cash flows:
iVinArrow [24]

Answer:

Correct option is A 5.01%

Explanation:

Let irr be x%

At irr,present value of inflows=present value of outflows.

1,500,000=350,000/1.0x+475,000/1.0x^2+400,000/1.0x^3+475000/1.0x^4

Hence x=irr=5.01%(Approx).

8 0
3 years ago
A person who ensures that people adhere to the definitions for the master data in their organizational units is called a(n) ____
pashok25 [27]

Answer:Data steward

Explanation:

8 0
2 years ago
You buy an annuity which will pay you $12,000 a year for ten years. The payments are paid on the first day of each year. What is
Kruka [31]

Answer:

PV of annuity due = $90,182.8 (Approx.)

Explanation:

Given:

Payment per year = $12,000

Number of year = 10

Interest rate = 7% = 0.07

Find:

PV of annuity due

Computation:

PV of annuity due = P + P[{1-(1+r)⁻⁽ⁿ⁻¹)/r]

PV of annuity due = 12,000 + 12,000[{1-(1+0.07)⁻⁽¹⁰⁻¹)/0.07]

PV of annuity due = $90,182.8 (Approx.)

7 0
3 years ago
Down Under Boomerang, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.
Sedbober [7]

Answer:

Explanation: please refer to the explanation section

Initial fixed asset Investment = 2.33million = 2 330 000

Modified Accelerated Cost recovery System

The Fixed Asset Falls under the 3 year MACRS class the project the asset which states that Asset Depreciation range Midpoint is 4 years or less  The period for this project is 3 years

Estimated annual sales = $1735000

costs = $640,000

Initial Net working Capital  investment = $300,000

Residual Value (Value of the fixed asset at the end) = $255,000

a. Projected Cash flows

Year 0

Cash outflows = 2 330 000 - 300 000 - 255 000 = 2375000

                                year 1       year 2         year 3

Estimated sales 1735000 1735000     1735000

costs                  -640000    -640000      -640000

Depreciation     -791666.67  -791666.67    -791666.67

Residual Value<u>                     255000 </u>

Net sales          303333.33     303333.33  558333.33

Tax  25%  -<u>75833.33 -75833.33 -139583.33</u>

Net Cash flows  <u>227500           227500              418750</u>

Depreciation = (2330 00 + 300 000 -255000)/3= 791666.67

Tax =  Net sales x 25%

b Net Present Value (Required rate Return = 9%)

PV  =  227500/(1+0.09)^1 + 227500/(1 + 0.09)^2 + 418750/(1+0.09)^3

Present Value of cash flows = 723549.63

Net Present Value = 723549.63 - 2630 000 = -1906450.37

The net present Value is Negative indicating the project will not bring positive returns

5 0
3 years ago
Other questions:
  • Assume a company pays out $100 in dividends in Year 1. What would the annual growth rate (rounded to the nearest 1%) for dividen
    13·1 answer
  • An IRA uses immediate annuities to pay out benefits; the IRA owner is nearly 75 years old when he decides to collect distributio
    6·1 answer
  • The glo-brite company is considering development of a new children's toothpaste in fun-shaped dispensers. before performing any
    15·2 answers
  • Legal obligations that carry punishments, if not followed, are ____?
    12·1 answer
  • The company wants to end each month with ending finished goods inventory equal to 10% of the next month’s sales. Finished goods
    8·1 answer
  • What are the disadvantages for an employer of paying employees piece rate or commission
    13·2 answers
  • uses a periodic inventory system. The company has a beginning inventory of 350 units at $6 each on January 1. Hentertainment pur
    7·1 answer
  • ¿Qué no se considera dividendo?
    6·1 answer
  • 32 POINTS! Please answer QUICKLY! Giving away a product for free can be a good business practice. Why is this TRUE?
    8·2 answers
  • If a firm hires an additional worker and discovers that its total output has fallen, then it must be true that:________
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!