ZuoTi.Pro
Question

This question is to be answered using EXCEL Spreadsheets

This question is to be answered using EXCEL Spreadsheets

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer to Part A D(45) E(15 F(25) G (20 A (50) B (50) C (50) 15 (10 Transportation cost for D Transportation cost for E Transportation cost for F Transportation cost for G 5 *45 10 515 10 6 25+55 3 20 225 200 175 60 Total Cost 660 D(45) 8(45 E(15 F(25) 10 15 Answer to Part B G (20 A (50) B (50) C (50) 8 6(20) 5 1215) 5(25) Transportation cost for D Transportation cost for E Transportation cost for F Transportation cost for G 8*45 12 15 5 25 620 360 180 125 120 Total Cost 785 Answer to Part C (785-660)/660 100 19%

0 0
Add a comment
Know the answer?
Add Answer to:
This question is to be answered using EXCEL Spreadsheets
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • This question needs to be answered using spreadsheets. Please include the following: - objectives and objective...

    This question needs to be answered using spreadsheets. Please include the following: - objectives and objective function(s) - constraints - screenshot of solver 6.6 Stocking Warehouses: Nicklaus Razor Blade (NRB) Company plans to test market a new blade next month. The blades will be stocked in their three ware- houses in the following quantities Warehouse A B C Stock (cartons 50 50 50 The carton quantities required by the distributors in the four test markets are as follows. Distributor D...

  • please show all excel spreadsheets please Fit the data below to their respective models by using...

    please show all excel spreadsheets please Fit the data below to their respective models by using an appropriate transformation and linear regression. Determine the constants A and B, provide the R2 for your linear regression analysis, and comment on the goodness of the fit using residual analysis Data Set 3 0.5 1 0.8889 0.5 2 0.32 2.5 0.2222 3 0.1633 3.5 0.125 4 0.0988 4.5 0.08 5 0.0661 1.5 2 x-

  • I need this answered in Excel step by step please and using the corresponding Excel Functions....

    I need this answered in Excel step by step please and using the corresponding Excel Functions. Clipboard Font Alignment A11 B 1 2 DELFI G H I On June 1, 2008 you invested $2,750 into a stock mutual fund. You then invested $1,750 into that same mutual fund on the first day of June for each of the years 2009 through 2019. You averaged a 7.5% annual rate of return on your investment in this mutual fund. What is the...

  • Explain, in your own words, why formatting Excel spreadsheets is important. Also, describe 2 examples of...

    Explain, in your own words, why formatting Excel spreadsheets is important. Also, describe 2 examples of spreadsheets in which formatting is critical for those reading and interpreting the spreadsheet. Think about what the spreadsheet may represent and how formatting can enhance its readability. Your answer must be a minimum of 2 paragraphs

  • How would this question be answered using formulas in Excel? Please show the formulas you use....

    How would this question be answered using formulas in Excel? Please show the formulas you use. A B C D E F G H I J K L M nm to 000 Question 2: In a random sample of 400 residents of Nassau County, 320 residents indicated that they voted for the Democratic candidate in the last presidential election. a) Develop a 95% confidence interval for the proportion of all Nassau County residents who voted for the Democratic candidate. b)...

  • This question must be answered in Excel and you need to use Excel formulas to do...

    This question must be answered in Excel and you need to use Excel formulas to do your calculations in order to earn full credit. When you have finished, upload your Excel file.   A company buys a fixed asset at a cost of $100,000. The asset has an estimated useful life of 5 years. a . For the second year of the asset's life, what amount of depreciation expense will appear on the income statement? Use a formula in Excel to...

  • QUESTION 2 2. Most merchandise companies use computerized a. google spreadsheets O b. machinery software sales...

    QUESTION 2 2. Most merchandise companies use computerized a. google spreadsheets O b. machinery software sales O c. perpetual inventory systems d. net income QUESTION 3 S. Internet applications to plan and coordinate marketing and sales are known as: a. software programming b.itunes apps for businesses c. customer relationship management d. excel based spreadsheets

  • Objective: Learn how to apply and use Excel spreadsheets in data post-processing Emphasize on axial stress...

    Objective: Learn how to apply and use Excel spreadsheets in data post-processing Emphasize on axial stress in tensile test and ductile-to-brittle transition for material selection and design. Solve the below problems with Microsoft Excel. - Create a summarized file report containing your Name, ID, answers and figures. -Label correctly your graphs-axis-titles and employ the correct units. Convert your file to PDF and submit individually on BBlearn Problem 1 A specimen of magnesium having a rectangular cross-section of dimensions 3.2 mm...

  • 2. Create the following Excel spreadsheets on vineyard data: Level I Create a spreadsheet with the...

    2. Create the following Excel spreadsheets on vineyard data: Level I Create a spreadsheet with the following information: Block, Tons per Block, Price per Ton, Gallons Blocks: Barbera, Cab Franc, Chardonnay, Counoise, Cinsault Tons: • Barbera - 12.6 • Cab Franc - 11.18 • Counoise - 15.48 • Chardonnay - 15.48 • Cinsault - 6.07 Price/ton: • Barbera - 1050.00 • Cab Franc - 1050.00 • Counoise - 902.50 • Chardonnay - 902.5 • Cinsault - 1050.00 Gallons: • Barbera...

  • I need all parts answered using step by step. Not excel. E 1&2 and also F....

    I need all parts answered using step by step. Not excel. E 1&2 and also F. percent: What is the yield to maturity on a 10-year, 9 percent annual coupon, $1,000 par value bond that sells for $887.002 That sells for $1,134.202 What does the fact that a bond sells at a discount or at a premium te e. (1) ll about the relationship between ra and the bond's coupon rate? you (2) What is the current yield, the capital...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT