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
WINSTONCH [101]
3 years ago
6

The demand for toys produced by the Miki Manufacturing Company has been collected in the Microsoft Excel Online file below. Use

the Microsoft Excel Online file below to develop simple linear regression forecast and answer the following questions.
Simple Linear Regression Forecast
Period Actual Demand Forecast Formulas
1 1,600 #N/A
2 2,000 #N/A
3 1,800 #N/A
4 1,200 #N/A
5 2,300 #N/A
6 3,600 #N/A
7 3,300 #N/A
8 3,200 #N/A
9 4,000 #N/A
10 4,900 #N/A
11 4,500 #N/A
12 4,400 #N/A
13 #N/A
Intercept #N/A
Slope #N/A
1. What is the trend line? Round your answers to two decimal places. Do not round intermediate calculations.
2. Calculate the linear trend forecast for the periods from 1 to 13. Round your answers to the nearest whole number. Use unrounded intercept and slope values.
Period Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
Business
1 answer:
harina [27]3 years ago
6 0

Answer:

attached below is the required solution

Explanation:

1) Determine the trend line

The trendline ( Y ) = 319.58x + 989.39 ( attached below is a graph showing the trendline )

2) attached below is the table showing the calculation of Linear trend forecast

You might be interested in
Suri Company has offered to sell 6 comma 300 units of the same part to Cruise Company for $ 14.40 per unit. Assuming the company
Sergeu [11.5K]

Complete Question:

Cruise Company produces a part that is used in the manufacture of one of its products. The unit manufacturing costs of this part, assuming a production level of 6,000 units, are as follows:

Direct materials$4.00

Direct labor$4.00

Variable manufacturing overhead$3.00

Fixed manufacturing overhead$1.00

Total cost$12.00

The fixed overhead costs are unavoidable.

Assuming Cruise Company can purchase 6,000 units of the part from Suri Company for $14 each, and the facilities currently used to make the part could be rented out to another manufacturer for $24,000 a year, what should Cruise Company do?

A) Make the part and save $6.00 per unit.

B) Make the part and save $2.00 per unit.

C) Buy the part and save $2.00 per unit.

D) Buy the part and save $1.00 per unit.

Answer:

Option (B) Buy the part and save $1.00 per unit

Explanation:

The cost benefit analysis is as under:

Option 1

Costs and savings associated with not renting out the factory and making sales of 6000 units of the part:

Total Variable Cost (4+4+3) $11 * 6000 = ($66000)

The Revenue earned = 6000 * 14 =          <u> $84000</u>

Net Savings                                                 $18000

Option 2

Costs and revenues arising due to renting out of factory and not selling the 6000 units of the product part is

Revenue from renting Out          $24000

lost of Contribution $3 *6000    <u>($18000)</u>

Net Savings                                   $6000

Decision:

As the savings from option 1 are higher so the company must not rent out the factory and can save $2 ($18000 savings / 6000 units) by making the product in home.

5 0
3 years ago
Recall that trading by arbitrageurs (smart investors) tend to make prices better reflect fundamental value. We know that institu
uranmaximum [27]

Answer:

Yes, the prices of large capitalization stocks tend to be more efficient.

Explanation:

Large capitalization stocks are much more liquid than small capitalization stocks since they belong to well established companies that are generally industry leaders. A lot of investors trade their stocks every single day, which results in thousands of them being sold every trading day. That also lowers the opportunity for arbitrage, since a large of investors must be wrong and a single (or a few) arbitrator must be right.

Large capitalization stocks generally have more stable prices and tend to pay consistent dividends. Their sustainable growth rate is lower than most small capitalization stocks but it is much more steady. This also results in lower potential returns when investing in large capitalization stocks since they pose a very low risk. On the other hand, small capitalization stocks pose a larger risk and one of them is that they are not valued correctly (which allows arbitrators to step in).

8 0
3 years ago
Sandhill Co. entered into these transactions during May 2022, its first month of operations.
mixer [17]

Answer and Explanation:

The transactions 3 6 and 8 represents that the expenses are incurred which results in increased and expenses and the transaction 4 and 5 shows that there is an increased in revenue

The journal entry is shown below:

For transaction 3

Rent expense

        To Cash

(Being the rent expense is paid for cash is recorded)

As the expense has debit balance so it would be increased

For transaction 6

Electricity expenses Dr

      To Cash

(Being the energy usage is paid for cash is recorded)

As the expense has debit balance so it would be increased        

For transaction 8

Advertising expense Dr

             To Account payable

(Being the advertising expense is recorded)

As the expense has debit balance so it would be increased

For transaction 4

Account receivable Dr

        To Service revenue

(Being the service is provided)

As the revenue has credit balance so it would be increased

For transaction 5

Cash Dr

        To Service revenue

(Being the service provided is recorded)

As the revenue has credit balance so it would be increased

The attachment is provided for better understanding  

The other transactions represent the assets, liabilities and stockholder equity

8 0
3 years ago
The sea wharf restaurant would like to determine the best way to allocate a monthly advertising budget of $1000 between newspape
Andreas93 [3]
From what I understood in the problem, the total budget that covers all types of media is only $1,000 per month. For the allocation, each type of media would get at least 25% of the budget. If we infer on this information, there should only be 4 types of media, at least. This is because four 25% portions would equal to 100%. If it exceeds 25% for each of the four types, it would be over the $1000 budget. With that being said, it is also possible that there will be 3 or 2 types of media. Nevertheless, let's just stick to the least assumption of 25% for each of the 4 types.

If local newspaper advertising is one of the four types, then:

$1000(25%) = $250

It would get $250 from the overall budget.
5 0
3 years ago
Cutter Enterprises purchased equipment for 60,000 on January 1, 2021. The equipment is expected to have a five-year life and a r
levacccp [35]

Answer:

$21,600

Explanation:

The expected life of the equipment is 5 years

Double-declining-balance rate = (1/5) *2 = 40%

Depreciation for 2021 = $60,000*40% = $24,000

Book Value at Dec 31, 2021 = $60,000 - $24,000

Book Value at Dec 31, 2021 = $36,000

Depreciation for 2022 = $36,000*40% = $14,400

Book Value at Dec 31, 2021 = $36,000 - $14,400

Book Value at Dec 31, 2021 = $21,600

Using the double-declining-balance method, the book value at December 31, 2022, would be $21,600.

4 0
3 years ago
Other questions:
  • In one or two sentences, describe which is greater: gross pay or net pay.
    13·2 answers
  • Show your understanding of the ownership of goods in transit by completing the following statement.If goods are shipped FOB ship
    5·1 answer
  • If retention is so much more profitable than acquisition, why have companies persisted for so long in spending more on getting n
    6·1 answer
  • The law of comparative advantage explains why a. specialization and exchange will make it possible for trading partners to expan
    9·1 answer
  • A client interested in the returns offered by CMOs asks you which type has the lowest prepayment risk. What should you say
    15·1 answer
  • As a local kayak outfitter was looking over her financial records, she noticed that when the shop down the street increased the
    8·1 answer
  • Which of the following does the reading test of the SAT ask you to do?
    11·2 answers
  • Identify each statement as true or false. If false, indicate how to correct the statement.
    11·1 answer
  • Windsor, Inc. just began business and made the following four inventory purchases in June: June 1 138 units $828 June 10 184 uni
    7·1 answer
  • You are assigned as the manager of risk management project for Health Network, inc. The attached case study provides brief intro
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!