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
The government of Ruritania has implemented many programs that promote equality, but has become concerned about the very slow ra
IceJOKER [234]

Answer: b. reduce taxes and cut back on some social programs

Explanation:

When the Economy is not doing well, Social programs are usually targeted as they usually take a lot of money from the Government's coffers.

It is also a generally held view that reducing taxes as a Fiscal policy can help stimulate the Economy by leaving the public with more funds to invest in and spend on the Economy.

The Government of Ruritania is therefore most likely to combine reducing Social programs as well as reducing taxes. This will have the effect of leaving the Government with some money as it loses revenue from taxes whilst also enabling the public to have more money to invest and to spend which will then lead to Economic growth.

8 0
3 years ago
When goods are produced at the lowest possible cost, an economy is said to have achieved:?
kondor19780726 [428]
When goods are produced at the lowest possible cost an economy is said to have achieved?
Answer: production efficiency
4 0
3 years ago
The Whalers are interested in trading their star left tackle. He is a veteran and makes $1.6 million per year. They are consider
Romashka-Z-Leto [24]

Answer:

$1,800,000

Explanation:

The veteran player makes $1.6 million per year.

The new prayer will be paid $1 million per year.

the Savings per year will be

= $1, 600,000 - 1,000,000

= $ 600,000

The savings in three years will be

=$600,000 x 3

=$1,800,000

3 0
3 years ago
_____ is abroad declaration of an organization's purpose that identifies the organization's products and customers and distingui
fgiga [73]
A mission is abroad declaration of an organization's purpose that identifies the organization's products and customers and distinguishes the organization from its competitors.

Sometimes this is confused with vision. The vision is where the organization wants to be 5 - 10 years from now.
5 0
3 years ago
1. "The biggest thing when we talk about personal branding is that it’s a _________" a. Hard thing b. Waiting game c. Process d.
notsponge [240]

Answer:

1- c. Process.

2- d. Consistency.

Explanation:

A personal brand can be defined as a continuous process of using marketing efforts and developing different factors to increase the perception and reputation of a company, individual, group, institution, etc.

Personal brand management corresponds to a continuous process of action and positioning, so that the target audience that you want to reach through your brand, can get to know you, including the values ​​and the solution of the problems and benefits you have to offer.

This is a process that demands consistency of actions and posture, since the process of consolidating a personal brand is a continuous process that requires a lot of research, knowledge and analysis of trends and market, advertising, presence in the media most used by the public, demonstration of seriousness, quality, benefits, quick response to problems, and several other factors that gradually contribute so that through a consistent process the brand has value and is consolidated in the market.

8 0
3 years ago
Other questions:
  • Why would deca, an international association of marketing students, be classified as a nonprofit organization?
    14·1 answer
  • Market Indicators are employed in-
    10·1 answer
  • Paddy has lots of cousins. With a family reunion in the near future, Paddy decides to collect income information for himself and
    13·1 answer
  • Cesario Corporation purchases a machine for $125,000. It has an estimated salvage value of $10,000 and is expected to produce 50
    15·1 answer
  • the personal computer is designed to be used by how many people at a time? select one: a. 1 b. 2 c. 3 d. 4
    10·1 answer
  • ecan Theatre Inc. owns and operates movie theaters throughout Florida and Georgia. Pecan Theatre has declared the following annu
    13·1 answer
  • The Finishing Department had 11,500 incomplete units in its beginning Work-in-Process Inventory which were 100% complete as to m
    12·1 answer
  • On December 31, Year 4, Deal, Inc., failed to accrue the December Year 4 sales salaries that were payable on January 6, Year 5.
    13·1 answer
  • During the taking of its physical inventory on December 31, 2014, Barry's Bike Shop incorrectly counted its inventory as $225,51
    12·1 answer
  • When Zappos focused on aligning and maximizing customer service, distribution, product selection, and other key areas, they were
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!