managerial accounting chapter 9 excel exercise 10-12

Office Update To keep up-to-date with security updates, fixes, and improvements, choose Chec B48 4 x fx Total direct labor cost BCDE F G H I X Berche 10 Lug expects the folowing sales of his famous tomato sauce. Luigkeeps 10% of the following month's sales as ending inventory. Determine required production. (Beginventory jan. 1 - 10% of January sales) Month Sales Cars January 770 February 8.40 March 910 April 90 Estimated sales in units Desired ending inventory (units) Beginning inventory units) Required production units) Bercise 11 It takes 5 lbs tomatoes to make a jar of Luigi's tomato sauce. Luig starts January with 100 lbs of tomatoes and wants to keep an ending inventory equal to 10% of tomatoes needed for next month's production. Tomatoes cost Luigi 20 cents a pound. Prepare a direct materials budget Month Jars Needed January 770 February 840 March April 910 770 ry Show subtractions as negative Required production (in units) Raw materials needed per unit (lb) Production needs lbs) Desired ending inventory lbs) Beginning inventory lbs Raw materials to be purchased (lbs) Cost per raw material perib) Cost of raw material purchases takes u s employee 15 minutes to make onejar of tomato sauce Olven the following production estimates d uring hourly wage of $9 an hour, prepare a direct labor budget Required production (injars) 770 February 8.40 March 770 tions as negatives Reguired production in units) Directibor hours per unit TOSOL hours required Directions or Total direct labor cost 1-6 10-12DQ QSEX Ready