Question

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%

March

10.5%

April

12 %

May

12.8 %

June

11 %

July

11.5 %

5. Based upon the Planned Monthly Sales you just calculated, fill in the chart below and calculate the Planned Monthly BOM Inventory. ROUND TO THE NEAREST WHOLE NUMBER.

Stock-to-Sales Ratio

Planned Monthly Sales(From question #4)

Planned Monthly BOM Inventory

February

2.8

March

3.2

April

4.5

May

4.0

June

3.5

July

11.5

Homework Answers

Answer #1

Total Planned sales=

107000*(1.15) = 123,050

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
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...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050   February 1,350 June 2,200   March 1,300 July 1,900   April 1,800 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,950 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after production. Labour cost is $3 per unit and...
Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier,...
Schedule of Cash Collections of Accounts Receivable Bark & Purr Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $184,000 June 192,000 July 201,000 All sales are on account. Sixty percent of sales are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
A company Motorsports sells a new sports car. Here are the records of shipments and sales...
A company Motorsports sells a new sports car. Here are the records of shipments and sales for the six months of this year. The BOM inventory is the number of cars on hand just before the first business day of the month. Sales is the number of cars sold during the month, including new backorders. Received is the number of cars received on the first business day of the month. Company inventory and sales records Month BOM inventory Sales Received...
The following are the monthly figures of advertising expenditure and sales of a company. It is...
The following are the monthly figures of advertising expenditure and sales of a company. It is found that advertising expenditure has impact on sales generally after 2 months. Allowing for this time lag, calculate the coefficient of correlation : Month Advertising expenditure (in thousand ) Sales (in units) January 50 1200 February 60 1500 March 70 1600 April 90 2000 May 120 2200 June 150 2500 July 140 2400 August 160 2600 September 170 2800 October 100 2000 November 200...
The Prince Albert Corporation has forecast the following sales for the first seven months of the...
The Prince Albert Corporation has forecast the following sales for the first seven months of the year.   January $28,000    May 28,000   February 30,000   June 34,000   March 32,000   July 36,000     April 38,000 Monthly material purchases are set equal to 30 percent of forecasted sales for the next month. Of the total material costs, 40 percent are paid in the month of purchase and 60 percent are paid in the following month. Labour costs will run $5,800 per month, and fixed overhead...
Croy Inc. has the following projected sales for the next five months:    Month Sales in...
Croy Inc. has the following projected sales for the next five months:    Month Sales in Units April 3,570 May 3,890 June 4,510 July 4,110 August 4,000 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.90 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units...
Croy Inc. has the following projected sales for the next five months: Month Sales in Units April 3,590 May 3,800 June 4,560 July 4,145 August 3,950 Croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. Direct material costs $2.60 per pound, and each unit requires 2 pounds. Raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
2. The sales forecast for Moss follows: January = 5,000 February = 5,200 March = 5,600...
2. The sales forecast for Moss follows: January = 5,000 February = 5,200 March = 5,600 April = 6,000 May = 6,500 June = 7,000 July = 7,500 August = 7,000 (i). Company policy is to keep a target ending inventory of 20% of the next month’s sales. Prepare a production budget for April, may and June. (ii). Using the information from part (i), prepare a labor usage and purchases budget. It requires 3 hours at $18 per hour.
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT