- Breaded Oak, Inc. has a policy that requires 20 percent of the expected sales of its product to be on hand at the end of the prior month. Forecasted sales, in units, for the months of January through April are as follows:
Jan 36,000 Units Feb 42,000 units March 58,000 units April 52,000 units
a) Calculate the number of units planned for ending inventory for January, February, and March.
b) b) Calculate the number of units budgeted to be produced in January, February, and March.
2.Dominic's, Inc. had actual sales for January and February and forecasted sales for March, April, May and June as follows:
Actual: Jan $192,000 Feb $218,000
Forecasted: March $225,000 April $202,000 May $234,000 June $250,000
Based on company experience, it is estimated that 35 percent of a month's sales are collected in the month of sale, 48 percent in the month following the sale, and 16 percent in the second month following the sale. Calculate the estimated cash collections for March, April, and May.
3. The cost formula for the maintenance department of the Eifel Co. is $6,500 per month plus $3.50 per machine hour used by the production department.
(a.) Calculate the maintenance cost that would be budgeted for the month of May in which 5,700 machine hours are planned to be used.
(b.) Prepare an appropriate performance report for the maintenance department assuming that 5,860 machine hours were actually used in the month of May, and the total maintenance cost incurred was $28,010.
4. The standards for one carton of Wonder Wax are:
Direct Materials: 4lbs@$2.55
Direct Labor: 6 hours@$5.25
Variable Overhead (based on direct labor hours) hours@$3.40
During the week ended December 4, the following activity took place: • 4,600 lbs. of raw material were purchased for inventory at a cost of $2.63 per pound; • 1,050 cartons of finished product were produced; • 4,225 lbs. of raw material were used; • 6,140 labor hours were worked at a total cost of $33,463; • $20,569 actual variable overhead costs were incurred. Calculate each of the following variances:
(a.) Price variance for raw materials purchased.
(b.) Raw materials usage variance.
(c.) Direct labor rate variance.
(d.) Direct labor efficiency variance.
(e.) Variable overhead spending variance.
(f.) Variable overhead efficiency variance.