Question

Anne Cummins is in the process of developing the merchandise budget for the beachwear shop she...

Anne Cummins is in the process of developing the merchandise budget for the beachwear shop she is opening in Maui, Hawaii , next year. She has decided to use the basic stock method of merchandise budgeting. Planned sales for the first half of next year are $240,000, and this is divided as follows: February = 9 percent, March = 10 percent,, April = 15 percent, May = 21 percent, June = 22 percent, and July = 23 percent. Planned total reductions are 9 percent for February and March, 4 percent for April and May, and 12 percent for June and July. The planned initial markup percentage is 48 percent. Alexia desires the rate of inventory turnover for the season to be two times. Also, she wants to begin the second half of the year with $100,000 in inventory at retail prices. Develop a six-month merchandise budget for Anne

Homework Answers

Answer #1

Total reduction in dollar is calculated as

= sales figure × % of total reduction.

Markup is calculated as

total reduction in $ + 48%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Tory Burch is in the process of estimating sales figures for their Nolita store location for...
Tory Burch is in the process of estimating sales figures for their Nolita store location for their upcoming season. They have estimated based on pass sales that they will have an overall total sales increase of 15%. Based upon this information, fill in the chart below and calculate Planned Monthly Sales (which accounts for the 15% increase). ROUND TO THE NEAREST WHOLE NUMBER. Last year's sales = $107,000 Planned % of Total Planned Total Sales Planned Monthly Sales February 9%...
Purchases Budget Tiger Drug Store carries a variety of health and beauty aids, including 500-count bottles...
Purchases Budget Tiger Drug Store carries a variety of health and beauty aids, including 500-count bottles of vitamins. The sales budget for vitamins for the first six months of the year is presented below. Unit Sales Dollar Sales January 160         $1,440         February 150         1,350         March 170         1,530         April 180         1,620         May 200         1,800         June 190         1,710         The owner of Tiger Drug believes that ending inventories should be sufficient to cover 10 percent of the next month’s projected sales. On January...
4. James Co. has projected sales of $200,000 in April, $250,000 in May, $300,000 in June...
4. James Co. has projected sales of $200,000 in April, $250,000 in May, $300,000 in June and $200,000 in July. James desires an ending finished goods inventory each month equal to 30% of next month’s projected sales. If finished goods ending in inventory in March was $70,000, prepare a production budget for each of the months of April, May, and June. The sales price for each unit was $10 and the markup on Cost was 25 per cent. 5. Based...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 140,000 April 200,000 February 140,000 May 160,000 March 200,000 June 220,000 Beginning inventory for 2010 is 60,000 units. The budgeted inventory at the end of a month is 30 percent of units to be sold the following month. Purchase price per unit is $4. Prepare a purchases budget in units and...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 140,000 April 200,000 February 140,000 May 160,000 March 200,000 June 220,000 Beginning inventory for 2010 is 60,000 units. The budgeted inventory at the end of a month is 30 percent of units to be sold the following month. Purchase price per unit is $4. Prepare a purchases budget in units and...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six...
Purchases Budget in Units and Dollars Budgeted sales of The Music Shop for the first six months of 2010 are as follows: Month Unit Sales Month Unit Sales January 130,000 April 190,000 February 160,000 May 190,000 March 190,000 June 230,000 Beginning inventory for 2010 is 40,000 units. The budgeted inventory at the end of a month is 20 percent of units to be sold the following month. Purchase price per unit is $3. Prepare a purchases budget in units and...
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Adams, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $69,000 $79,000 $89,000 $95,000 Adams had a beginning inventory balance of $4,500 on April 1 and a beginning balance in accounts payable of $14,300. The company desires to maintain an ending inventory balance equal to 10 percent of the next period’s cost of goods sold. Adams makes all purchases...
Jordan, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget...
Jordan, Inc. sells fireworks. The company’s marketing director developed the following cost of goods sold budget for April, May, June, and July. April May June July Budgeted cost of goods sold $64,000 $74,000 $84,000 $90,000 Jordan had a beginning inventory balance of $2,900 on April 1 and a beginning balance in accounts payable of $14,100. The company desires to maintain an ending inventory balance equal to 20 percent of the next period’s cost of goods sold. Jordan makes all purchases...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for...
Production Budget Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 216,000 May 264,000 June 240,000 July 288,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000. Required: Prepare a production budget for the second...
Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and...
Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $11,000, accounts receivable of $861,000, inventories of $130,800, and accounts payable of $36,982. The budget is to be based on the following assumptions. Each month’s sales are billed on the last day of the month. Customers are allowed a 2 percent discount if payment is made within 10 days after the billing date. Receivables are...