The basic stock method is used to plan the bath towel department BOP $ inventory. You are

required to calculate the BOP$ inventory by period for the upcoming Spring season. The

Director of Planning has instructed for you to use LYA Average BOP $ Inventory to help

determine your basic stock requirement, and your This Year Sales $ Plan to determine the

average month$$s sales. Given the following information in the table below, in the Excel

Worksheet, calculate the BOP$ Inventory Plan for each period this year. Note: you may wish to

use the space beneath the table to make some additional calculations to help you arrive at the

final formula and answers.

February March April May June July Total

Season

BOP $ LYA $$684,993$ $$628,344$ $$609,223$ $$673,922$ $$702,933$ $$699,332$

Sales $ TY

Plan

$$482,933$ $$592,948$ $$692,883$ $$768,744$ $$688,594$ $$524,122$ $$3,750,224$

BOP $ TY

Plan