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
Talja [164]
3 years ago
9

Suppose a small business has sales of $14,000 this month, with future sales expected to grow by $1,300 each month. Costs consist

of a fixed component, which is $8,400 per month, and a variable component, which is 25 percent of sales. Design a spreadsheet to compute the gross profit (revenue less fixed and variable costs) per month over a nine month period. What is the gross profit in a single month 8 months from now?
Business
1 answer:
jeyben [28]3 years ago
8 0

Answer:

Please check the attachment to this document to get the excel sheet

Gross Profit (8 months from now)=$10,875

Explanation:

Please check the attachments of this post and download the excel sheet.

Best of luck

Download xlsx
You might be interested in
8. Hayward Industries manufactures dining chairs and tables. The following information is available: Dining ChairsTablesTotal Co
Contact [7]

Answer:

Instructions are listed below.

Explanation:

Giving the following information:

Dining Chairs - Tables - Total cost

Machine setups: 200 - 600 - $48,000

Inspections: 250 - 470 - $72,000

Labor hours: 2,600 - 2,400

A) A single overhead rate:

To calculate the estimated manufacturing overhead rate we need to use the following formula:

Estimated manufacturing overhead rate= total estimated overhead costs for the period/ total amount of allocation base

Estimated manufacturing overhead rate= (48,000 + 72,000) / (2,600 + 2,400)= $24 per direct labor hour

Now, we can allocate overhead based on direct labor hours:

Allocated MOH= Estimated manufacturing overhead rate* Actual amount of allocation base

Dining Chairs:

Allocated MOH= 24*2,600= $62,400

Tables:

Allocated MOH= 24*2,400= $57,600

B) We have to calculate an overhead rate for each activity cost pool.

<u>Overhead rate:</u>

Machine setups:

Estimated manufacturing overhead rate= 48,000/800= $60 per machine hour set up

Inspections:

Estimated manufacturing overhead rate= 72,000/ 720= $100 per inspection

Based on the overhead rate, we can allocate overhead to each product.

Dining chairs:

Allocated MOH= 60* 200 + 100*250= $37,000

Tables:

Allocated MOH= 60*600 + 100*470= $83,000

C) We can conclude that activity cost allocation is more accurate than using a single rate plant-wide. We can allocate costs more efficiently.

7 0
3 years ago
We are evaluating a project that costs $644,000, has an eight-year life, and has no salvage value. Assume that depreciation is s
AleksandrR [38]

Solution :

a).

Particulars                                                Details

Selling price per unit                                 37

Less : variable cost per unit                     -21

Margin per unit                                           16

No. of units sold per unit                       70,000

Gross margin                                        11,20,000

Less : fixed cost                                     - 7,25,000

Profit before depreciation and tax       3,95,000

Less : depreciation                                -80,500

Profit before tax                                     3,14,500

Less : Tax                                               -1,10,075

Net profit per year                                 2,04,425

Project Cost                                           6,44,000

Accounting breakeven point in years     3.15

b).

Calculating the base Cash - Cash flow and NPV

Particulars                                                       Amount

Net profit per year                                        2,04,425

Add : depreciation                                         80,500

Base Cash cashflow                                     2,84,925

Required rate of return                                    15%

Present value of base cash cash flow        12,78,550

received in 8 years.

Project cost                                                  -6,44,000

NPV                                                               6,34,550

The present value of base cash cash flow received in 8 years is calculated as Present value of annuity received at the end of each year $ 2,84,925 at the rate of interest 15% for a period of 8 years.

The sensitivity of the NPV to 500 units decrease in projected sales :

Particulars                                                          Details

Selling price per unit                                            37

Less : variable cost per unit                                -21

Margin per unit                                                     16

Number of units sold per year                          69,500

Gross margin                                                      11,12,000

Less : fixed cost                                                -7,25,000

Profit before depreciation and tax                   3,87,000

Less : depreciation                                            -80,500

Profit before tax                                                 3,06,500

Less : tax                                                            -1,07,275

Net profit per year                                             1,99,225

Add : depreciation                                              80,500

Base Cash cashflow                                          2,79,725

Required rate of return                                         15%

Present value of base cash cash flow              12,55,216

received in 8 years.

Project cost                                                    -6,44,000

NPV                                                                6,11,216

Original NPV                                                  6,34,550

Sensitive NPV                                                  -23,334

c).

Particulars                                                              Details

Selling price per unit                                               37

Less : variable cost per unit                                   -20

Margin per unit                                                        17

No. of units sold per year                                     70,000

Gross Margin                                                         11,90,000

Less : fixed cost                                                     -7,25,000

Profit before depreciation and tax                       4,65,000

Less : Depreciation                                                -80,500

Profit before tax                                                     3,84,500

Less : tax                                                                -1,34,575

Net profit per year                                                  2,49925

Add : depreciation                                                   80,500

Operating cash flow                                               3,30,425

Original operating cashflow                                   2,84,925

Sensitivity of OCF                                                      45,500

7 0
2 years ago
Exercise 16-05 a-b (Video) In Waterway Company, materials are entered at the beginning of each process. Work in process inventor
____ [38]

Answer:

(a) Total units for January = 14,200

Total units for May = 23,260

(b). Conversion cost for :

January = 13,053  

March = 13,660

May = 21,688

July = 11,212

Explanation:

As per the data given in the question,

1)

                                                 Jan.                        May

Units to be accounted for

Beginning WIP                            0                            0

Started into production            14,200                   23,260

Total number units                   14,200                   23,260

Units accounted for

Transferred out                         11,100                   15,400

Ending WIP                                 3,100                      7,860

Total units                                 14200                   15400

2)

We can calculate the conversion cost by using following formula:

Conversion cost = Transferred out unit + (Work in process  unit × conversion cost)

                            Material           Conversion cost

Jan.                       14,200                    13,053              (11,100 + 3,100 × 63%)

Mar.                      15,700                     13,660              (12,300 + 3,400 × 40%)

May                       23,260                   21,688             (15,400 + 7,860 × 80%)

July                        12,400                   11,212              (10,200 + 2,200 × 46%)

7 0
2 years ago
Two investors have the following pattern of expected returns (Before-Tax Cash Flows): Investment A: Y1: $5,000; Y2: $10,000; Y3:
Arada [10]

Answer:

Investment A = 11.089%

Investment B = 12.772%

Explanation:

The internal rate of return is the discount rate that equates the after tax cash flows from an investment to the amount invested.

The internal rate of return can be calculated using a financial calculator

For investment A,

Cash flow in year zero = -$110,000

Cash flow in year 1 = $5,000

cash flow in Y2 = $10,000

cash flow in Y3 = $12,000

Cash flow in Y4 = $15,000 + $120,000 = $135,000

Irr = 11.089%

For investment B,

Cash flow in year zero = -$120,000

Cash flow in year one = $2,000

cash flow inY2: $4,000

cash flow in Y3: $1,000

cash flow in Y4: $5,000 + $180,000 = $185,000

IRR = 12.772%

To find the IRR using a financial calacutor:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.

I hope my answer helps you

4 0
2 years ago
A family spends $40,000 on living expenses. With an annual inflation rate of 6 percent, they can expect to spend approximately _
il63 [147K]

Answer: $42,400

Explanation:

The family currently spends $40,000 on living expenses.

Inflation is expected to be 6% and as Inflation is used to refer to the general rise in prices, this means that the family will be spending 6% more in one year.

They will therefore be spending;

= 40,000 * (1 + 6%)

= $42,400

7 0
3 years ago
Other questions:
  • Two currently owned machines are being considered for the production of a part. The capital investment associated with the machi
    13·1 answer
  • Piper owns a vacation cabin in the Tennessee mountains. Without consider-ing the cabin, she has gross income of $65,000. During
    11·1 answer
  • Miscavage Corporation has two divisions: the Beta Division and the Alpha Division. The Beta Division has sales of $310,000, vari
    7·1 answer
  • Pinkie Print​ Supplies, Inc., sells laser printers and supplies. Assume Pinkie started the year with 100 containers of ink​ (ave
    7·1 answer
  • The distinction between fundamental and particular risks is important because a. normally only particular risks are insurable. b
    5·1 answer
  • In 1895, the first putting green championship was held. the winner’s prize money was $190. in 2014, the winner’s check was $1,49
    12·1 answer
  • Planet Earth Developers is a large nationwide construction company with home offices in Lansing, MI. The local media often remar
    12·1 answer
  • A net worth statement, insurance plan, and a budget are all part of a ____
    8·1 answer
  • Vietnamese citizens went working in Korea. They sent their income back to the families in Vietnam, worth of $678,000. Which acco
    6·1 answer
  • What is Ministry of Freedom ?
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!