DATA SET: Netson Inc. makes milk sold in containers (1 gallon).

REQUIREMENTS:

1.) Excel... Prepare a sales budget, production budget, and direct labor budget for each month and for the total 4^th quarter in good form. Prepare columns for each month and one for the quarter. (Should be no direct inputs in the budget schedules. Each cell of the budget should be a reference to the data table or a calculation of other cells in the spreadsheet.)

2.) If Netson Inc. revised its November sales forecast from 43,000 gallons to 47,000 gallons, what would the total sales dollars and direct labor hours be for the quarter? What management decisions would be impacted by the increase in gallons sold?

1 Data Required for Budget Preparation October November December 4 Expected Sales in Gallons 40,000 43,000 50,000 6 Selling price 7 per gallon 8 Inventory balance requirement 9 Sept 30th inventory 10 December 30th inventory 10% of next month's sales units ,000 gallons 5,100 gallons 12 DLH per gallon 13 14 Wage 15 0.5 10 per DLH