Question

In: Accounting

A. Harrison Company produces hats for golfers. The company's projected sales for April are 15,000 hats....

A. Harrison Company produces hats for golfers. The company's projected sales for April are 15,000 hats. March sales were less than expected, so the company had 1,800 hats remaining in inventory at the end of March. Harrison prefers to maintain a 5 percent inventory of the next month's sales. Expected sales for May are 14,000 hats. How many hats should the company plan to produce in April?

a. 15,700

b. 15,000

c. 13,900

d. 17,500

B. Tea lovers produce herbal teas. The company expects to sell 125,000 boxes of tea during 2009. The company had 10,000 tea boxes on hand at the beginning of 2009. The sales budget calls for the company to sell 120,000 boxes of tea in 2010. If the company has a policy of maintaining an inventory of 10 percent of the boxes needed for the next year's expected sales, how many boxes must be purchased during 2009?

a. 125,000

b. 127,000

c. 137,000

d. It cannot be provided for the information provided

C. Refer to Question B. above. If each tea box costs $0.27, what is the total projected cost of the tea boxes for 2009?

a. $33,750

b. $34,290

c. $36,990

d. It cannot be determined from the information provided.

Solutions

Expert Solution

Ans. A Option c    13,900
Particulars April
Expected units to be sold 15000
Add: Desired ending inventory units 700
Total required units 15700
Less: Beginning inventory units -1800
Units to be produced 13900
*Beginning inventory of current month April = Ending inventory of previous month March = 1,800
*Ending inventory = Sales units of May * 5%
14,000 * 5%
700 hats
Ans. B Option b    127,000
Particulars 2009
Expected units to be sold 125000
Add: Desired ending inventory units 12000
Total required units 137000
Less: Beginning inventory units -10000
Units to be purchased 127000
*Ending inventory = Sales units of 2010 * 10%
120,000 * 10%
12000 boxes
Ans. C Option b    $34,290
Total cost of tea boxes = Units to be purchased * Cost per box
127,000 * $0.27
$34,290

Related Solutions

ABC Company limited produces coat racks. The projected sales for the first quarter of the coming...
ABC Company limited produces coat racks. The projected sales for the first quarter of the coming year and the beginning and ending inventory data are as follows: Sales 100,000 units Unit price SAR 15 Beginning inventory 8,000 units Targeted ending inventory 12,000 units The coat racks are molded and then painted. Each rack requires four pounds of metal, which cost SAR 2.50 per pound. The beginning inventory of materials is 4,000 pounds. ABC Company Limited wants to have 6,000 pounds...
A proposed new investment has projected sales of 15,000 units in year 1 and 20,000 units...
A proposed new investment has projected sales of 15,000 units in year 1 and 20,000 units in year 2. The sales price for both years will be $10 per unit. The project will terminate after the second year. Variable costs are expected to be 50% of sales. Fixed costs will be $25,000 per year. The investment will cost $20,000 and will be depreciated straight line to $0 over the 2 year period. The tax rate is 34% for both years...
% - XYZ Company provides you with the following data projected for 2018: Projected sales are...
% - XYZ Company provides you with the following data projected for 2018: Projected sales are 30,000 units. Inventory at Dec 31,2017 was 4,000 manufactured units. The desired ending for Dec 31, 2018 is 8,000 manufactured units. a) 5% - Provide a production budget for the number of units that need to be produced. b) 6% - Assume for each unit manufactured, four pounds of raw materials are needed. Assume the desired ending inventory became 10,000 manufactured units. What effect...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500...
Cash Budget: Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 17,500 18,000 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $1,800 per year, using the straight-line method. He has supplied you with the following information (above) to...
You are purchasing a company that has projected cash flows after taxes of $15,000, $18,000, $22,000,...
You are purchasing a company that has projected cash flows after taxes of $15,000, $18,000, $22,000, $35,000, and $21,000 for Years 1 through 5. In Year 3, you will incur maintenance costs of $50,000. From Years 6 through 10, you expect cash flows to be steady at $25,000 per year. At Year 10, you can sell the firm for $500,000. You will pay dividends out at a growing rate of 2% each year and you will announce a $1.50/share dividend...
SmithSmith Foods produces specialty soup sold in jars. The projected sales in dollars and jars for...
SmithSmith Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as? follows: Total sales revenue Number of jars sold 1st quarter. . . . $181,000 153,000 2nd quarter. . . . $213,000 180,000 3rd quarter. . . . $257,000 212,500 4th quarter. . . . $194,000 163,500 SmithSmith anticipates selling 226 comma 000226,000 jars with total sales revenue of $ 266 comma 000$266,000 in the first quarter...
XYZ Company provides you with the following data projected for 2018: Projected sales are 30,000 units....
XYZ Company provides you with the following data projected for 2018: Projected sales are 30,000 units. Inventory at Dec 31,2017 was 4,000 manufactured units. The desired ending for Dec 31, 2018 is 8,000 manufactured units. a) - Provide a production budget for the number of units that need to be produced. b) - Assume for each unit manufactured, four pounds of raw materials are needed. Assume the desired ending inventory became 10,000 manufactured units. What effect would that have on...
ABC Company has projected Sales of $13181 in January. The sales are expected to grow by...
ABC Company has projected Sales of $13181 in January. The sales are expected to grow by 9% each month. ABC's collection schedule is as follows: ABC collects 55 percent of its sales in the month of sale and the remainder is collected in the following month. What is the amount of the March cash collections?
The following are budgeted data: Sales (units )Production (units) April 15,000 18,000 May 20,000 19,000 June...
The following are budgeted data: Sales (units )Production (units) April 15,000 18,000 May 20,000 19,000 June 18,000 16,000 Two pounds of material are required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for May should be: 36,800 pounds 39,200 pounds 52,000 pounds 38,000 pounds
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT