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
Artemon [7]
3 years ago
7

Complete the bill of materials by calculating the extended cost of each component and the total materials cost for each brake sy

stem. develop a sensitivity analysis to show the impact on total brake system materials costs if the front brake calipers unit cost ranges from $103 to $107 and if the brake pipe unit cost ranges from $27 to $31.

Business
1 answer:
Nostrana [21]3 years ago
7 0

Complete Question:

A hypothetical bill of materials is used in manufacturing and production to show all of the parts and materials required to manufacture a specific item or for the subassembly of a finished product, such as a motorcycle. The information in the bill of materials is useful for determining product costs, coordinating orders, and managing inventory. It can also show how product costs will be affected by price changes in components or raw materials. This project provides you with an opportunity to use spreadsheet software to perform a sensitivity analysis showing the impact of various prices for component parts on the total costs of a dirt bike. The bill of materials for this project has been simplified for instructional purposes.  

Dirt Bikes’s management has asked you to explore the impact of changes in some of its parts components on production costs. Review the spreadsheet file containing bill of materials information for the brake system for Dirt Bikes’s Moto 300 model, which can be found on the Laudon Web site for this chapter. The completed bill of materials contains the description of the component, the identification number of each component, the supplier (source) of the component, the unit cost of each component, the quantity of each component needed to make each finished brake system, the extended cost of each component, and the total materials cost. The extended cost is calculated by multiplying the quantity of each component needed to produce the finished brake system by the unit cost. The prices of components are constantly changing, and you will need to develop a spreadsheet application that can show management the impact of such price changes on the cost to produce each brake system and on total production costs for the Moto 300 model.  

<em>-Complete the bill of materials by calculating the extended cost of each component and the total materials cost for each brake system.  </em>

<em>-Develop a sensitivity analysis to show the impact on total brake system materials costs if the front brake calipers unit cost ranges from $103 to $107 and if the brake pipe unit cost ranges from $27 to $30.  </em>

-The brake system represents 30 percent of the total materials cost for one Moto 300 motorcycle. Use sensitivity analysis again to show the impact of the changes in front brake caliper unit costs and brake pipe unit costs described previously on total materials costs for this motorcycle model.

Answer and explanation:

Check the attached files for well formatted answers

(a)

Component Component No. Source Unit Cost Quantity Extended Cost

Brake cable M0593 Nissin 27.81 1 27.81

Brake pedal M0546 Harrison Billet 6.03 2 12.06

Brake pad M3203 Ressell 27.05 2 54.1

Front brake pump M0959 Brembo 66.05 1 66.05

Rear brake pump M4739 Brembo 54.00 1 54

Front brake caliper M5930 Nissin 105.20 1 105.2

Rear brake caliper M7942 Nissin 106.78 1 106.78

Front brake disc M3920 Ressell 143.80 1 143.8

Rear brake disc M0588 Ressell 56.42 1 56.42

Brake pipe M0943 Harrison Billet 28.52 1 28.52

Brake lever cover M1059 Brembo 2.62 1 2.62

Total Cost 657.36

(b)

We use a two-way data table to show the sensitivity of the total cost with respect to changes in price for the front brake calipers unit and the brake pipe unit.

Brake pipe price

653.64 $27 27.5 $28 28.5 $29 29.5 $30

Front brake caliper price $103.0 $653.6 $654.1 $654.6 $655.1 $655.6 $656.1 $656.6

$103.5 $654.1 $654.6 $655.1 $655.6 $656.1 $656.6 $657.1

$104.0 $654.6 $655.1 $655.6 $656.1 $656.6 $657.1 $657.6

$104.5 $655.1 $655.6 $656.1 $656.6 $657.1 $657.6 $658.1

$105.0 $655.6 $656.1 $656.6 $657.1 $657.6 $658.1 $658.6

$105.5 $656.1 $656.6 $657.1 $657.6 $658.1 $658.6 $659.1

$106.0 $656.6 $657.1 $657.6 $658.1 $658.6 $659.1 $659.6

$106.5 $657.1 $657.6 $658.1 $658.6 $659.1 $659.6 $660.1

$107.0 $657.6 $658.1 $658.6 $659.1 $659.6 $660.1 $660.6

(c)

Just by dividing all elements of the above data table by 030, we will get the sensitivity of the total cost.

Brake pipe price

$27.0 $27.5 $28.0 $28.5 $29.0 $29.5 $30.0

Front brake caliper price $103.0 $2,178.80 $2,180.47 $2,182.13 $2,183.80 $2,185.47 $2,187.13 $2,188.80

$103.5 $2,180.47 $2,182.13 $2,183.80 $2,185.47 $2,187.13 $2,188.80 $2,190.47

$104.0 $2,182.13 $2,183.80 $2,185.47 $2,187.13 $2,188.80 $2,190.47 $2,192.13

$104.5 $2,183.80 $2,185.47 $2,187.13 $2,188.80 $2,190.47 $2,192.13 $2,193.80

$105.0 $2,185.47 $2,187.13 $2,188.80 $2,190.47 $2,192.13 $2,193.80 $2,195.47

$105.5 $2,187.13 $2,188.80 $2,190.47 $2,192.13 $2,193.80 $2,195.47 $2,197.13

$106.0 $2,188.80 $2,190.47 $2,192.13 $2,193.80 $2,195.47 $2,197.13 $2,198.80

$106.5 $2,190.47 $2,192.13 $2,193.80 $2,195.47 $2,197.13 $2,198.80 $2,200.47

$107.0 $2,192.13 $2,193.80 $2,195.47 $2,197.13 $2,198.80 $2,200.47 $2,202.13

You might be interested in
All of the following would be considered closing costs except for: a) A title search b) Cost of repainting the kitchen before mo
otez555 [7]
B/ <span>Cost of repainting the kitchen before moving in</span>
5 0
3 years ago
Support functions manage and improve the efficiency of an organization's conversion processes so that more value is created.
HACTEHA [7]

Answer:

a) true

Explanation:

Support Function include Information Technology, Human Resources, Finance and Marketing. These are there to ensure that conversion process is efficient by providing support services such as sourcing of talent, fund management, communication.

3 0
3 years ago
Today, upon graduation from medical school, physicians often recite the Hippocratic oath. Where did this originate, and what was
finlep [7]
The answer would be c
6 0
3 years ago
Read 2 more answers
Dabney Electronics currently has no debt. Its operating income is $20 million and its tax rate is 40%. It pays out all of its ne
ValentinkaMS [17]

Answer:

$29 per stock

Explanation:

WACC=PBIT*(1-tax)/Market value of firm

10%=$20,000,000*(1-40%)/Market Value of the firm

Market Value of the firm=$20,000,000*60%/10%=$120,000,000

Stock price for all shares=$120,000,000*60%=$72,000,000

Stock price per share=$72,000,000/2,500,000=$29 per share

6 0
3 years ago
The selling price per unit less the variable cost per unit is the ________.
OlgaM077 [116]

The selling price per unit less the variable cost per unit is the contribution margin per unit.

<h3>What is the contribution margin per unit.?</h3>

This is the term that is used to refer to the selling price that was used for the sale of a particular good minus the variable cost that was employed in the production of that particular good. It is the contribution that is made towards the payment of the fixed costs.

Hence we can say that The selling price per unit less the variable cost per unit is the contribution margin per unit.

Read more on contribution margin per unit here: brainly.com/question/13528647

#SPJ1

6 0
1 year ago
Other questions:
  • A maker of frozen meals claims that the average caloric content of its meals is 400, and the standard deviation is 15. a researc
    7·1 answer
  • In economics, why must consumers, businesses, and governments make choices?
    14·1 answer
  • A company must account for a contract modification as a new contract if the:
    6·1 answer
  • The risk-free rate is 5.4 percent and the market risk premium is 5 percent. Assume that required returns are based on the CAPM.
    14·1 answer
  • A certain firm produces and sells staplers. Last year, it produced 7,000 staplers and sold each stapler for $6. In producing the
    13·1 answer
  • Emily Turnbull, president of Aerobic Equipment Corporation, is concerned about her employees’ well-being. The company offers its
    7·1 answer
  • Analysts predicted earnings per share (EPS) for your company to be $0.XX at the close of 20XX. How does this compare to actual E
    13·1 answer
  • Who were some of the people aboard the titanic during its maiden voyage?
    6·1 answer
  • A car rental agency rents 220 cars per day at a rate of 28 dollars per day. For each 1 dollar increase in the daily rate, 6 fewe
    11·1 answer
  • The value proposition for the AARP brand is seen in what kinds of benefits for the members? (Select 3)
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!