Developing a Six-Month Plan Spreadsheet Use a spreadsheet program to create a six-month merchandise plan using the data shown in Figure 23.1 of your text. Learn how to write formulas so that your worksheet will automatically calculate the fi gures for the current year’s planned sales, BOM, planned reductions, and planned purchases.

Activity Note these formulas on the bottom of your worksheet. Change the expected sales increase to fi ve percent and the planned reductions to 10 percent. Enter the data and complete the plan.