Question

In: Accounting

On the sheet of Goal Seek, find the way to achieve your 2017 profit goals. Go...

  1. On the sheet of Goal Seek, find the way to achieve your 2017 profit goals.
    1. Go back to Income Statement sheet. It must be completed by now. Copy the gray area (A3:G23). Go to the sheet of Goal Seek, and paste it at the cell A3.
    2. At the blank Rows 1 & 2, merge some cells and add a title 2017 Sales Estimates.
    3. The cell J3 should show a label Price Increasing Rate:, and J4 should show 5%. If they are not there because of your copying and pasting, please add them to your sheet at proper locations.
    4. Edit your data sheet and include 5% increase on Unit Price of all products. Make sure you use formula with reference to J4, where it shows the increasing rate of prices.
    5. Use the Goal Seek tool and see if we want to achieve a $125,000 net profit, what is the increasing rate of price we should apply in 2017?
  2. The goal Seek is:
    Price Increasing Rate:
    10%

Solutions

Expert Solution

solution :

given that Rundle Freight Company owns a truck that cost $33,000.

also given that Currently, the truck’s book value is $27,000, and its expected remaining useful life is five years

mentioned in gi ven indormation that

Rundle has the opportunity to purchase for $28,000 a replacement truck that is extremely fuel efficient. Fuel cost for the old truck is expected to be $7,000 per year more than fuel cost for the new truck.

some other given information The old truck is paid for but, in spite of being in good condition, can be sold for only $16,000.

Calculating the total relevant costs:

retaining truck replacing truck
cost of the new truck $- $28000
additional fuel cost (5*7000) $35000 $-
oppurtunity cost $16000 $-
total cost $51000 $28000

final decision of retaining old truck :

the purchase cost of ol;d truck and book value are irrelevant

they are sunk cost

therefore they should not be considered

the comparision cost of replacing and retaining truck are given above

from the above table

the company should replace the old truck as it would cost $28000 in replacement as against the cost of reraining truck of $51000


Related Solutions

Seek and Find Choose and research four (4) infectious diseases. Try to achieve a variety in...
Seek and Find Choose and research four (4) infectious diseases. Try to achieve a variety in your own selections as well as diseases unique from what your classmates have already posted. For your research please use only well-known, reputable sources. In one discussion post that has four sections, create a brief description or summary of each of your four diseases. The word count for each disease should be approximately 100 words. The content of your summaries should include the etiology,...
As a Manager, your goal is to maximize profit of your business.Assume you are in...
As a Manager, your goal is to maximize profit of your business. Assume you are in charge of managing your company's costs - you are the Controller of Accounts and all purchases must be approved by you. With appropriate examples, illustrate how you and your Division will contribute to maximizing profit of your business.
Write an essay about your opinions on the goals of public speaking and how to achieve...
Write an essay about your opinions on the goals of public speaking and how to achieve the goals. (about 500 words) The essay should include the following: The varieties of public speaking; The ways to achieve the goals.
In order to achieve your vision and your goals, you will need objectives (outcomes for your marketing team).
In order to achieve your vision and your goals, you will need objectives (outcomes for your marketing team). List three marketing objectives that you want your marketing team to accomplish for your company. Be concise, we do not need an academic paper and discussion, only that the objectives be clearly understand. You do not have to know how you are going to achieve those goals at this point, only that you want them done somehow.You should work as much as...
Suppose you are a discus hurler and your goal is to maximize the distance you achieve.
Suppose you are a discus hurler and your goal is to maximize the distance you achieve. You "produce" discus hurls by practicing. The total benefit of practice is distance achieved, and the input that achieves this distance is hours of practice. Describe the total benefit curve of practice. What point on the curve would you select?
Given the information below, use WACM to find the dollar sales needed to achieve the profit...
Given the information below, use WACM to find the dollar sales needed to achieve the profit goal. Show your work and answer. Annual profit requirement: 10% return on investment for $500,000 Fixed cost $150,000 Menu Items Revenue % Variable Cost % A 50% 0.4 B 20% 0.4 C 30% 0.5
Calculate the time necessary to achieve an investment goal. Give your answer to the nearest day....
Calculate the time necessary to achieve an investment goal. Give your answer to the nearest day. Use a 365-day year. (First enter the total number of full years, then give the remaining days.) $9,000 at 5% daily interest; deposit $4,000
Discuss about three goals you would like to achieve with your diet and use the SMART...
Discuss about three goals you would like to achieve with your diet and use the SMART goal guidelines to write them down. This question is belongs to Physical Activity.
Give some examples of self directed learning goals in your internship and how would you achieve...
Give some examples of self directed learning goals in your internship and how would you achieve those goals.
what is the best way to calculate the problems below: 1. Your goal is to have...
what is the best way to calculate the problems below: 1. Your goal is to have $78,179. If you can earn 11.61% per year and you invest $16,060 today, how many years until you reach your goal? 2. An investment will pay you $4,903 in 4 years if you pay $1,729 today. What is the implied rate of return? (Convert to a decimale. Round to 2 decimal places.) 3. You are buying an investment property for $376,073 today. Through research,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT