The following gure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values

Question:

The following ﬁgure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values for up to ﬁve demand points. Re-create this spreadsheet in Excel. While your formatting does not have to be exactly the same, your answers should be. Your spreadsheet should recalculate results whenever any changes are made to the shaded cells. To test your logic, change the weight on demand point D to 250. Your new weighted X and Y coordinates should be 3.04 and 2.96, respectively.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 50% (12 reviews)

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac...View the full answer

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question

Introduction to Operations and Supply Chain Management

ISBN: 978-0132747325

3rd edition

Authors: Cecil B. Bozarth, Robert B. Handfield

See More Books

Question Posted: Apr 10, 2015 10:09 AM

See More Questions

The following gure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values

Question:

A B 1 Weighted Center of Gravity Model for Up to Five Demand Points 2 3 Demand Point X Coordinate Y Coordinate weighting factor 5.00 4 1.00 300 200 A 2.00 4.00 3.00 6 C 3.00 100 17 4.00 2.00 300 E 5.00 1.00 300 Weighted X coordinate: Weighted Y coordinate: 10 3.08 11 2.92 B.

Step by Step Answer:

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespac...View the full answer

Introduction to Operations and Supply Chain Management

Students also viewed these Management Leadership questions