Question

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 the labor contract in which bonuses are paid in February and April. The labor figures are:

January $19,000
February 22,000
March 19,000
April 24,000

Fixed overhead is $15,000 per month.

Prepare a schedule of cash payments for January through April. (Assume the $330,000 of sales occur equally over the four months of January through April, i.e. Monthly sales = $330,000 / 4.)

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Total materials purchases from January through April = Sales From January through April * 50% = 330000 * 50% = 165000
Monthly materials purchases from January through April = Total materials purchases from January through April / 4 = 165000 / 4 = 41250
Ultravision
Cash payment schedule
December January February March April
Monthly materials purchases 29000 41250 41250 41250 41250
    Payments to materials purchases 29000 41250 41250 41250
    Monthly labor cost 19000 22000 19000 24000
    Monthly fixed overhead 15000 15000 15000 15000
Total cash payments 104250 119500 116500 121500
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 $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...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:   March...
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:   March 20,000   April 22,000   May 19,500     June 18,000   Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March’s beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid...
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...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 7,000 March $    15,000 February $    12,000 April $    18,000 Monthly purchases of raw materials accounts for 50 % of sales forecast for the next month. Of total raw material purchases , payments are 50% in cash in the same month and 50% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750 February 2,050 June 2,900 March 2,000 July 2,600 April 2,500 Volt Battery always keeps an ending inventory equal to 120% of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 2,640 units, which is consistent with this policy. Materials cost $11 per unit and are paid for in the month after purchase. Labor cost is $4 per unit and...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 6,000 March $    15,000 February $ 11,000 April $    17,000 Monthly purchases of raw materials accounts for 60 % of sales forecast for the next month. Of total raw material purchases , payments are 60% in cash in the same month and 40% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
Selwyn, Inc. has budgeted the following for January: Unit sales 20,000 Direct materials cost $68,000 Fixed...
Selwyn, Inc. has budgeted the following for January: Unit sales 20,000 Direct materials cost $68,000 Fixed manufacturing overhead cost $35,000 Selwyn believes that unit sales will increase by 5% per month each month for the next year. Selwyn plans to continuously improve direct materials costs by 1% each month and fixed manufacturing overhead costs by 2% each month. Prepare a Kaizen budget for direct materials and fixed manufacturing overhead costs for January, February, March, and April. Instructions: Round your answers...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales (F)   1 January 18 2 February 23 3 March 20 4 April 16 5 May a. Use exponential smoothing with α = 0.2 to calculate smoothed averages and forecast sales for May from the above data. Assume the forecast for the initial period (January) is 18. b. Calculate MSE, and MAPE.
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000...
Month    Budgeted Cash Sales Budgeted Credit Sales Budgeted Cash Purchases Budgeted Credit Purchases December 8,000 21,000 January 9,000 23,000 February 11,000 25,000 March 77,800 12,000 12,000 22,000 March 68,500 12,500 12,500 23,500 May 72,000 12,300 12,300 24,500 Wages & other operating expenses are estimated as follows: Month Wages Other Expenses March 20,000 28,000 April 17,500 22,000 May 20,000 23,000  Newequipment purchased in February for $16,750 istobepaid forin April.  New furniture purchased in March for $15,000 isto be paid...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT