Question

Spelling Company has the following sales projection (in units) for the next six months: Feb: 9500...

Spelling Company has the following sales projection (in units) for the next six months: Feb: 9500 Mar: 11000 Apr: 8500 May: 12000 Jun: 10000 Jul: 7500 Each unit sells for $30. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 8500 12000 10000 30500 Selling price per unit x $30 x $30 x $30 Sales revenue $255000 $360000 $300000 $915000 Spelling's cost of goods sold is 60% of its sales revenue. The company has a policy that it keeps 10% of next months budgeted cost of goods sold as ending inventory. The company had exactly the budgeted amount of inventory on hand at April 1. Prepare a purchases budget on paper or, PREFERABLY, in Excel for the quarter of April, May and June. (If you build your schedule using formulas in excel, multiple attempts will be much faster.) What is the cost of inventory at April 1 (Beginning inventory) What is the budgeted cost of purchases in June? What is the desired cost of inventory at the end of the quarter?

Homework Answers

Answer #1
MATERIAL PURCHASE BUDGET
APRIL MAY JUNE QUARTER JULY
Budgeted Sales units 8,500 12,000 10,000 30,500 7,500
Sales price per unit 30 30 30 30 30
Budgeted Sales in $ 255,000 360,000 300,000 915,000 225,000
Cost of goods sold ratio 60% 60% 60% 60% 60%
Budgeted cost of goods sold 153,000 216,000 180,000 549,000 135,000
Add: Desired Ending Inventory 21,600 18,000 13,500 13,500
Total needs 174,600 234,000 193,500 562,500
Less: Beginning Inventory 15,300 21,600 18,000 15,300
Budgeted Purchase in $ 159,300 212,400 175,500 547,200
Budgeted Cost of Sales for Quarter: $ 549,000
Ending inventory at the end of Quarter: $ 13500
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
Spelling Company has the following sales projection (in units) for the next six months: Feb: 19000...
Spelling Company has the following sales projection (in units) for the next six months: Feb: 19000 Mar: 21000 Apr: 17000 May: 24000 Jun: 20000 Jul: 15000 Each unit sells for $50. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 17000 24000 20000 61000 Selling price per unit x $50 x $50 x $50 Sales revenue $850000 $1200000 $1000000 $3050000 Spelling's cost of goods sold...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 27,000 units May 34,000 units June 10,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $21 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 28,000 units May 36,000 units June 12,000 units July 42,000 units August 69,000 units ABC Company sells its inventory to customers for $20 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 640 720 670 760 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 128 units. Prepare a production budget for the months of April, May, and June. RUIZ CO. Production Budget For April, May, and June April May June Next month's budgeted sales...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 12600 16800 14400 43800 Selling price per unit x $60 x $60 x $60 Sales revenue $756000 $1008000 $864000 $2628000 All of the sales are on credit. Quagmire collects from customers as follows: 45% of sales in the month of sale 25% in the month following the sale, and 30% in the second month following...
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...
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,430 May 3,840 June 4,550 July 4,105 August 3,950 Croy’s finished goods inventory policy is to have 50 percent of the next month’s sales on hand at the end of each month. Direct materials costs $3.20 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month’s production needs on hand at the...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June: Sales Budget April May June Total Sales in units 15600 19800 17400 52800 Selling price per unit x $30 x $30 x $30 Sales revenue $468000 $594000 $522000 $1584000 All of the sales are on credit. Quagmire collects from customers as follows: 40% of sales in the month of sale 25% in the month following the sale, and 35% in the second month following...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT