Question

33. Yamaguchi Swimwear has deve,oped the following sales budget, in units: January February March April May...

33.

Yamaguchi Swimwear has deve,oped the following sales budget, in units:

January February March April May
155,000 185,000 225,000 240,000 205,000

Beginning Inventory in January is 35,000 units. The company policy is to have 40% of the next month's inventory on hand at the end of the month.

Required:

Prepare a purchasing budget for the months of January - April. Do not include May.

Homework Answers

Answer #1

Answer:

Particulars January February March April
Sale units 155,000.00 185,000.00 225,000.00 240,000.00
Add: Closing inventory     74,000.00     90,000.00     96,000.00     82,000.00
Total requirement 229,000.00 275,000.00 321,000.00 322,000.00
Less: Opening inventory     35,000.00     74,000.00     90,000.00     96,000.00
Purchase requirement 194,000.00 201,000.00 231,000.00 226,000.00

Note:

Ending inventory is calculated as 40% of next month sales.

Ending inventory of April = 205,000 * 40% = 82,000 units.

Opening inventory of the month = CLosing inventory of last month.

In case of any doubt, please comment.

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
Tyler Co. Production Budget April, May and June April May June Next month’s budgeted sales (units)...
Tyler Co. Production Budget April, May and June April May June Next month’s budgeted sales (units) % % % 0 0 0 Units to be produced 0 0 0 Tyler Co. predicts the following unit sales for the next four months: April, 3,600 units; May, 4,700 units; June, 6,700 units; and July, 3,000 units. The company’s policy is to maintain finished goods inventory equal to 20% of the next month’s sales. At the end of March, the company had 700...
A sales budget is given below for one of the products manufactured by the OMI Co.:...
A sales budget is given below for one of the products manufactured by the OMI Co.: January 25,000 units February 40,000 units March 65,000 units April 45,000 units May 35,000 units June 30,000 units The inventory of finished goods at the end of each month must equal 20% of the next month's sales. However, on December 31 the finished goods inventory totaled only 4,000 units. Each unit of product requires three pounds of specialized material. The requires an ending inventory...
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were...
Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were 700, 680, 752, 712, and 780 respectively. Required: 1. The company’s policy for ending finished goods is 25 percent of next month's sales. Prepare a production budget for the first quarter. 2. The drone toy includes 2 LED lights, which cost $15 each. The company requires ending direct materials to be 20 percent of next month's materials requirement. Prepare a direct materials purchases budget...
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...
A company budgeted unit sales of 204,000 units for January, 2017 and 240,000 units for February...
A company budgeted unit sales of 204,000 units for January, 2017 and 240,000 units for February 2017. The company has a policy of having an inventory of units on hand at the end of each month equal to 30% of next month's budgeted unit sales. If there were 61,200 units of inventory on hand on December 31, 2016, how many units should be produced in January, 2017 in order for the company to meet its goals?
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...
Webster Company has the following sales budget.       January            $200,000             February&nbsp
Webster Company has the following sales budget.       January            $200,000             February           $240,000             March               $300,000             April                  $360,000       Cost of sales is 70% of sales. Sales are collected 40% in the month of sale and 60% in the following month. Webster keeps inventory equal to double the coming month's budgeted sales requirements. It pays for purchases 80% in the month of purchase and 20% in the month after purchase. Inventory at the beginning of January is $190,000.   Webster...
Sander Enterprises prepared the following sales​ budget: Month Budgeted Sales March $5,000 April $10,000 May $15,000...
Sander Enterprises prepared the following sales​ budget: Month Budgeted Sales March $5,000 April $10,000 May $15,000 June $13,000 The expected gross profit rate is 10% and the inventory at the end of February was $11,000. Desired inventory levels at the end of the month are 20​% of the next​ month's cost of goods sold. What is the budgeted cost of goods sold for​ May?