BA320 Spread Sheet - 75431

Request Posted by


Rating : No Rating
Earned: $0
Request Detail
Price: $10
  • From: Mathematics, Algebra
  • Due on: Tue 07 Oct, 2014 (07:03pm)
  • Asked on: Sat 04 Oct, 2014
  • Due date has passed, but you can still Post Solution.

Merchandise Budgeting


Using the following data, develop a monthly merchandise budget using the basic stock method (BSM) and the percentage variation method (PVM).

The Corner Hardware Store is attempting to develop a merchandise budget for the next 12 months. To assist in this process, the following data have been developed. The target inventory turnover is 4.8 and forecast sales are (Month/Forecast Sales):

Jan./$27,000; Feb./$26,000; Mar./$20,000; Apr./$ 34,000; May/$41,000; Jun./$40,000

Jul./$28,000; Aug./$27,000; Sep./$38,000; Oct./$39,000; Nov./$26,000; Dec./$28,000

2 Solution for BA320 Spread Sheet
Please Login or Register to Submit the Solution for the Request