Making Buying Decisions: Using the Computer as a Tool

✍ Scribed by Richard Clodfelter

• Publisher: Fairchild Books
• Year: 2008
• Tongue: English
• Leaves: 192
• Edition: 3
• Category: Library

✦ Synopsis

This text is designed for use in a buying course with a heavy math emphasis. The book first presents merchandising concepts in a simple, understandable way and shows students how they can use computerized spreadsheets to perform related merchandising math operations. Activities then ask the student to apply what they've learned by solving merchandising problems using spreadsheets that are included on the enclosed CD-Rom. Students will learn how the computer can help minimize the time it takes to perform repetitive calculations. By constructing and using spreadsheets for each mathematical operation, they will develop a better understanding of the merchandising concepts they're studying. This manual is designed to accompany the text Retail Buying, also by Richard Clodfelter.

✦ Table of Contents

Contents
Extended Contents
Preface
Acknowledgments
1. Using Computerized Spreadsheets
Basic Computer Operations
Loading Files from the Merchandising CD
Opening a File
Reading the Spreadsheet Screen
Changing the Width of a Column
Changing How Numbers Are Displayed
Entering Formulas
1–1 Input Data and Interpret Computer Output
Practice Activities
1. Review Decimals and Percentages
2. Enter Data and Calculate
3. Revise Data and Recalculate
4. Create a Formula to Add Numbers
5. Create a Formula to Calculate Percentage of Change between Two Numbers
6. Revise Data and Recalculate
Additional Computer Operations
Using Edit Commands
Saving Your Work
Printing
Quitting
2. Individual Markups
2–1 Calculate Retail Price
2–2 Calculate Desired Cost
2–3 Calculate Individual Markup Percentage
3. Initial Markup
3–1 Calculate Initial Markup Percentage
3–2 Estimate Sales
3–3 Estimate Profit
4. Cumulative Markup
4–1 Calculate Cumulative Markup Percentage
4–2 Calculate Markup Percentage Needed on New Purchases
5. Markdowns and Markdown Cancellations
5–1 Calculate Total Dollar Markdowns
5–2 Calculate Markdown Percentage
5–3 Calculate Off-Retail Percentage
5–4 Calculate Markdown Cancellations
6. Maintained Markup
6–1 Calculate Maintained Markup
7. Stock Planning
7–1 Calculate Stock Turnover Rate
7–2 Calculate Stock-to-Sales Ratio and Planned Sales
8. Planning Sales and Purchases
8–1 Calculate Planned Sales
8–2 Calculate Planned Purchases
8–3 Develop a Six-Month Merchandise Buying Plan
9. Assortment Planning
9–1 Calculate Assortments to Be Purchased
10. Purchase Orders
10–1 Calculate Cost and Retail Extensions with Markup Percentages
11. Open-to-Buy
11–1 Calculate Open-to-Buy
12. Operating Results
12–1 Calculate Profit or Loss
Glossary
Appendix: Basic Retail Math Formulas
Index