9781563672231

This text, written for students who wish to plan a career in merchandising, includes a CD-ROM with Windows-based Microsoft Excel data. Designed for use in a buying course with a heavy math emphasis, activities involve the student solving merchandising problems by using computerized spreadsheets. This manual is designed to accompany the text Retail Buying, 2nd edition, also by Richard Clodfelter.

Using Computerized Spreadsheets

1

(16)

Basic Computer Operations

3

(4)

Loading Files from the Merchandising CD

3

(1)

Opening a File

3

(1)

Reading the Spreadsheet Screen

3

(2)

Changing the Width of a Column

5

(1)

Changing How Numbers Are Displayed

6

(1)

Entering Formulas

6

(1)

Input Data and Interpret Computer Output

7

(5)

Practice Activities

7

(1)

Review Decimals and Percentages

7

(2)

Enter Data and Calculate

9

(1)

Revise Data and Recalculate

9

(1)

Create a Formula to Add Numbers

9

(1)

Create a Formula to Calculate Percentage of Change between Two Numbers

10

(1)

Revise Data and Recalculate

11

(1)

Additional Computer Operations

12

(5)

Using Edit Commands

12

(1)

Saving Your Work

13

(1)

Printing

13

(1)

Quitting

13

(4)

Individual Markups

17

(12)

Calculate Retail Price

18

(3)

Calculate Desired Cost

21

(3)

Calculate Individual Markup Percentage

24

(5)

Initial Markup

29

(18)

Calculate Initial Markup Percentage

30

(8)

Estimate Sales

38

(4)

Estimate Profit

42

(5)

Cumulative Markup

47

(14)

Calculate Cumulative Markup Percentages

48

(6)

Calculate Markup Percentage Needed on New Purchases

54

(7)

Markdowns and Markdown Cancellations

61

(20)

Calculate Total Dollar Markdowns

62

(4)

Calculate Markdown Percentage

66

(5)

Calculate Off-Retail Percentage

71

(3)

Calculate Markdown Cancellations

74

(7)

Maintained Markup

81

(8)

Calculate Maintained Markup

82

(7)

Stock Planning

89

(14)

Calculate Stock Turnover Rate

90

(8)

Calculate Stock-to-Sales Ratio and Planned Sales

98

(5)

Planning Sales and Purchases

103

(24)

Calculate Planned Sales

104

(7)

Calculate Planned Purchases

111

(5)

Develop a Six-Month Merchandise Buying Plan

116

(11)

Assortment Planning

127

(10)

Calculate Assortments to Be Purchased

128

(9)

Purchase Orders

137

(10)

Calculate Cost and Retail Extensions with Markup Percentages

138

(9)

Open-to-Buy

147

(6)

Calculate Open-to-Buy

148

(5)

Operating Results

153

(10)

Calculate Profit or Loss

154

(9)

Glossary

163

(4)

Appendix: Basic Retail Math Formulas

167

(2)

Index

169

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Making Buying Decisions 2nd Edition : Using the Computer as a Tool

Making Buying Decisions 2nd Edition : Using the Computer as a Tool

1563672235

Summary

Table of Contents

Supplemental Materials