Using Computerized Spreadsheets Mathematics for Retail Buying

by Cushman, Linda M.

• ISBN13: 9781563673368
• ISBN10: 1563673363
• Edition: CD
• Format: Paperback
• Copyright: 2004-08-20
• Publisher: Fairchild Books

Summary

Using Computerized Spreadsheets: Mathematics for Retail Buying is a computer spreadsheet component for retail buying and merchandising mathematics students. Cushman demonstrates how to create, calculate, and analyze using Microsoft Excel® spreadsheets. A cross-platform CD-ROM is included for students to apply the lessons as they learn them in the book. This book is designed as a supplement to Mathematics for Retail Buying, Revised 5th Edition, by Bette Tepper, but the concepts are easily adaptable to any text meant to cover the mathematical concepts associated with retail buying.

Author Biography

Linda M. Cushman serves as the Director and Department Chair of Retail Management and Consumer Studies at Syracuse University's College for Human Development. She is a member of both the American Collegiate Retailing Association and the International Textile and Apparel Association.

Table of Contents

Preface	xi
Format of the Workbook	xi
Acknowledgments	xii
CHAPTER 1 Introduction to Using Computerized Spreadsheets	1	(14)
Lesson 1: Basic Spreadsheet Operations	1	(11)
Opening a File	1	(1)
Entering Data	2	(1)
Formatting the Numbers	3	(1)
Formula Writing	3	(2)
Copying a Formula	5	(1)
Creating a Formula	5	(1)
Completing the Formatting	6	(1)
Formatting a Cell	7	(1)
Centering Data in a Cell	7	(1)
Creating Bold Headings	8	(1)
Placing a Border Under Column Headings	9	(1)
Setting a Print Area and Formatting the Page	9	(2)
Saving Your Work and Printing	11	(1)
Printing Formulas	12	(1)
Additional Spreadsheet Operations	12	(1)
Wrapping Text	12	(1)
Widening Column Width	12	(1)
Practice Problem	13	(2)
CHAPTER 2 Profit and Loss Statements	15	(14)
Definitions	16	(1)
Lesson 2: Basic Profit and Loss Calculations	16	(8)
Opening the File	16	(1)
Completing the Spreadsheet	17	(1)
Calculating Percentages	18	(2)
Formatting the Spreadsheet	20	(3)
Setting a Print Area and Formatting the Page	23	(1)
Saving Your Work and Printing	23	(1)
Printing Formulas	23	(1)
Practice Problems	24	(5)
CHAPTER 3 The Relationship of Markup to Profit	29	(14)
Formulas	29	(1)
Lesson 3: Calculating Cost, Markup, and Retail	30	(7)
Opening the File	30	(1)
Completing the Spreadsheet	30	(5)
Completing the Table	35	(2)
Setting a Print Area and Formatting the Page	37	(1)
Saving Your Work and Printing	37	(1)
Printing Formulas	37	(1)
Practice Problems	37	(6)
CHAPTER 4 Repricing of Merchandise	43	(18)
Definitions	43	(1)
Formulas	44	(1)
Lesson 4: Price Changes	45	(9)
Opening the File	45	(1)
Completing the Spreadsheet	45	(8)
Setting a Print Area and Formatting the Page	53	(1)
Saving Your Work and Printing	54	(1)
Printing Formulas	54	(1)
Practice Problems	54	(7)
CHAPTER 5 The Retail Method of Inventory	61	(12)
Formulas	62	(1)
Lesson 5: Implementing the Retail Method of Inventory	62	(5)
Completing the Spreadsheet	63	(3)
Setting a Print Area and Formatting the Page	66	(1)
Saving Your Work and Printing	67	(1)
Printing Formulas	67	(1)
Practice Problems	67	(6)
CHAPTER 6 Dollar Planning and Control	73	(18)
Formulas	73	(1)
Lesson 6: Six-Month Seasonal Dollar Plan	74	(9)
Opening the File	74	(1)
Completing the Spreadsheet	75	(1)
Formatting Planned Sales Figures	76	(2)
Formatting the Stock-Sales Ratio Figures	78	(1)
Formatting the BOM Stock Figures	78	(1)
Determining the Percent of Markdowns Monthly	79	(2)
Setting a Print Area and Formatting the Page	81	(1)
Saving Your Work and Printing	82	(1)
Printing Formulas	82	(1)
Practice Problems	83	(8)
CHAPTER 7 Invoice Mathematics	91	(14)
Definitions	91	(2)
Lesson 7: Terms of Sale and the Purchase Order	93	(7)
Opening the File	93	(1)
Completing the Spreadsheet	94	(5)
Setting a Print Area and Formatting the Page	99	(1)
Saving Your Work and Printing	99	(1)
Printing Formulas	100	(1)
Practice Problems	100	(5)
Index	105