Question

Cool​ Water, Inc. sells bottled water. The firm keeps in inventory plastic bottles at10​% of the...

Cool​ Water, Inc. sells bottled water. The firm keeps in inventory plastic bottles at10​%

of the monthly projected sales. These plastic bottles cost

​$0.006

each. The monthly sales for the first four months of the coming year are as​ follows:

​January 2,200,000

​February:  2,200,000

​March: 2,700,000

​April: 3,200,000

Homework Answers

Answer #1

COGS = Monthly Sales × $0.006

Beginning Inventory Balance = Current Month’s Sales Projection x 10%

Ending Inventory Balance = Next Month’s Sales Projection x 10%

Increase in Working Capital Cash = [Ending Inventory - Beginning Inventory] x $0.006

Month Exp. Sales(Units) Ant. COGS Beg. Inv. Bal. End. Inv. Bal. W. Cap. Increase
January 2,200,000 $13,200 220,000 220,000 $0
February 2,200,000 $13,200 220,000 270,000 $300
March 2,700,000 $16,200 270,000 320,000 $300
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
Manson Inc. makes and sells handbags. In the first 4 months of the coming year, they...
Manson Inc. makes and sells handbags. In the first 4 months of the coming year, they expect the following unit sales: January 20,000 February 24,000 March 22,000 April 29,000 Manson Inc. is to have 30% of next month's sales in ending inventory. On January 1, the beginning inventory was 6,000 handbags. Prepare a budget for the first quarter of the year.
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...
Ultravision Inc. anticipates sales of $280,000 from January through April. Materials will represent 50 percent of...
Ultravision Inc. anticipates sales of $280,000 from January through April. Materials will represent 50 percent of sales, and because of level production, material purchases will be equal for each month during the four months of January, February, March, and April. Materials are paid for one month after the month purchased. Materials purchased in December of last year were $24,000 (half of $48,000 in sales). Labor costs for each of the four months are slightly different due to a provision in...
Ultravision Inc. anticipates sales of $330,000 from January through April. Materials will represent 50 percent of...
Ultravision Inc. anticipates sales of $330,000 from January through April. Materials will represent 50 percent of sales, and because of level production, material purchases will be equal for each month during the four months of January, February, March, and April. Materials are paid for one month after the month purchased. Materials purchased in December of last year were $29,000 (half of $58,000 in sales). Labor costs for each of the four months are slightly different due to a provision in...
Ultravision Inc. anticipates sales of $450,000 from January through April. Materials will represent 50 percent of...
Ultravision Inc. anticipates sales of $450,000 from January through April. Materials will represent 50 percent of sales, and because of level production, material purchases will be equal for each month during the four months of January, February, March, and April. Materials are paid for one month after the month purchased. Materials purchased in December of last year were $41,000 (half of $82,000 in sales). Labor costs for each of the four months are slightly different due to a provision in...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 21% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,350 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the...
Preparing a Production Budget Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 21% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,400 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should...
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2013:...
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2013:                                           Month                Sales                                           January             10,000                                           February           14,000                                           March               13,000                                           April                 16,000 Finished goods inventory at the end of December is 3,000 units. Target ending finished goods inventory is 30% of the next month's sales.How many mattresses need to be produced in the first quarter (January, February, March) of 2013? 37,000 mattresses 38,800 mattresses 41,800 mattresses 44,800 mattresses
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2020:...
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2020: Month Sales January 10,000 February 14,000 March 13,000 April 16,000 Finished goods inventory at the end of December is 3,000 units. Target ending finished goods inventory is 30% of the next month's sales. How many mattresses need to be produced in January 2020?
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality...
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT