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
~~~30 POINTS~~~
koban [17]
1. is credit card
2. is debit card
3. is card

hope this helped!!!
4 0
3 years ago
Read 2 more answers
Explain what a cash budget is and why it is important for all businesses.
deff fn [24]

Answer:

A cash budget is very important, especially for smaller companies. It allows a company to establish the amount of credit that it can extend to customers without having problems with liquidity. A cash budget helps avoid a shortage of cash during periods in which a company encounters a high number of expenses.

Explanation:

4 0
2 years ago
Cheyenne Corp. had the following transactions that took place during the year:I.Recorded credit sales of $2250II.Collected $1350
Degger [83]

Answer:

The correct option is d) <u>Decrease</u>.

Explanation:

Free cash flow (FCF) can be described as the cash that is generated by a company after cash outflows required to support operations and maintain the capital assets of the company have been accounted for.

Therefore, FCF can be calculated by adjusting for non-cash expenses, changes in working capital, and capital expenditures to reconcile net income.

The total effect of these transactions on free cash flow can be determined by first calculating the account receivable for the year as follows:

Calculation of account receivable for the year:

<u>Particular                                                     Amount ($)</u>

Credit sales                                                    2,250

Cash collected from the customer              (1,350)

Sales returns                                                <u>   (450)  </u>

Account receivable                                     <u>    450  </u>

A partial free cash flow statement can therefore be prepared as follows:

Cheyenne Corp.

Free cash flow statement (Partial)

<u>Particular                                                                   Amount ($)  </u>

Net income                                                                         xx

(Increase) decrease in non-cash current assets:

Increase in account receivable                                    <u>   (450)  </u>

Free cash flow                                                              <u>   (450)   </u>

<u />

Since the free cash flow is negative or minus $450, it therefore implies that the total effect of these transactions on free cash flow is a <u>decrease</u>.

Therefore, the correct option is d) <u>Decrease</u>.

7 0
3 years ago
When interacting with a customer who has a rational style and keeps communication brief, your best strategy is to
kakasveta [241]

The best strategy which a person should use when interacting with a customer who has a rational style and keeps communication brief is:

  • Ask open-ended questions to obtain information.

<h3>What is Communication?</h3>

This refers to the exchange of information between two or more people where feedback is given through a medium.

With this in mind, we can note that because the customer has a rational style and communicates in a straightforward manner, then the best strategy would be to ask open-ended questions to obtain information.

Read more about communication here:

brainly.com/question/26152499

3 0
2 years ago
Builtrite Furniture just paid an annual dividend of $2.50 last week and investors' believe that dividends will continue to grow
Ivenika [448]

Answer:

r = 11.55%

Explanation:

Given that,

Annual dividend paid last week, D1 = $2.50

Dividend growth rate, g = 8%

current price of common stock = $76

Stock price = D1 ÷ (r - g)

$76 = [$2.50 × (1 + 8%)] ÷ (r - 8%)

$76 = 2.7 ÷ (r - 8%)

(r - 8%)  = 0.0355

r = 0.0355 + 0.08

  = 0.1155 × 100

  = 11.55%

Therefore,

Return, r = 11.55%

6 0
3 years ago
Other questions:
  • A leftward shift of the supply curve for oil in the united states is most likely to result from:
    14·1 answer
  • hich of the following statements is true? The denominator used in computing earnings per share represents the shares of common s
    9·1 answer
  • Cedar Designs​ Company, a custom cabinet manufacturing​ company, is setting standard costs for one of its products. The main mat
    15·1 answer
  • Under absorption costing, which of the following statements is not true? Multiple Choice Fixed inventory costs are treated in th
    12·1 answer
  • Suppose Rocky Brands has earnings per share of ​$2.33 and EBITDA of ​$29.3 million. The firm also has 5.3 million shares outstan
    8·1 answer
  • In 2016, Teller Company sold 3,000 units at $600 each. Variable expenses were $420 per unit, and fixed expenses were $270,000. T
    7·1 answer
  • which of the following paycheck withholdings puts money into a retirement investment fund that you will manage?
    13·1 answer
  • What is it called whenever there<br> is no shortage or surplus in the<br> market?
    8·2 answers
  • How do I pay taxes once I turn 18?
    13·1 answer
  • he income statement columns in the end-of-period spreadsheet show that debits are equal to $26,754 and credits are $68,142. what
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!